Excel Introduction

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