| Fee | £115 |
|---|---|
| Days | 1 |
| Code | EX1 |
There are currently no dates scheduled for this course.
However it can still be provided on a closed-company basis – or we may schedule it on demand. Please contact us for further information.
e-mail us
or call us on
0845 650 6500
Excel Introduction
The Excel Introduction training course is available at our Cardiff training centre in Wales, which is also within easy reach of Newport, Bristol and South Wales
Overview
This course introduces the skills necessary for productive development of workbooks. It includes tasks to explore Excel, create simple formulas, copy and move data, and print worksheets. The student will also learn how to work with ranges and use the Office Assistant, basic workbook skills and page set up.
Examination information
- This course helps prepare delegates for the ECDL Module 4 - Spreadsheets examination and the Microsoft Office Specialist Excel Proficient examination
Prerequisites
Before attending this course, students must have:
- Knowledge and experience in using a Windows environment
Course outline
Module 1 - Exploring Excel
- Using the Interface
- Working with Worksheets
- Using the Task pane
- Changing Toolbar and Menu Options
Module 2 - Using Basic Workbook Skills
- Selecting a Cell
- Scrolling
- Entering Text and Numbers
- Data Shortcuts
Module 3 - Working with Ranges
- Using Ranges
- Selecting Ranges
- Using AutoFill Features
Module 4 - Creating simple Formulas
- Entering Formulas
- Using Functions
- AutoSum
- Checking Errors
Module 5 - Copying and Moving Data
- Copying/ Cutting and Pasting
- Using the Clipboard Task Pane
- Creating an Absolute Reference
Module 6 - Printing
- Previewing a Worksheet
- Printing a range
Module 7 - Using Page Set Up
- Setting Margins
- Creating Headers and Footers
Module 8 - Formatting Numbers
- Using Number Formats
Module 9 - Formatting Text
- Formatting Cell Text
- Wrapping Text
- Aligning Text
Module 10 - Working with Columns and Rows
- Changing Width and Height
- Adjusting Automatically
- Inserting and Deleting Rows and columns
Module 11 - Formatting Cells
- Formatting Borders and Colours
- Clearing Formats
- Using the Format Painter
Module 12 - Using Automatic Formatting and Styles
- Using the Automatic Formatting Features
- Creating a Style
- Merging Styles
Module 13 - Using Large Worksheets
- Increasing Magnification
- Splitting the Window
- Freezing Panes
Module 14 - Using Paste Special
- Working with Paste Special
- Performing mathematical Operations
Quick link to this course: www.e-academy.ltd.uk/ex1
