Course Description

You will create and edit basic Microsoft Office Excel 2013 worksheets and workbooks.

Target Student: 

 Delegates who are not familiar with Excel and would like to learn the basic functions of the package.

Prerequisites: 

Delegates will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should be comfortable in the Windows environment, and be able to use Windows  to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.

Performance-Based Objectives

         Get started with Excel 2013

         Create a basic worksheet

         Modify a workbook

         Use formulas and functions

         Format an Excel worksheet

         Manage worksheets and workbooks

         Set up printing options

Course Content

Module 1: Getting Started with Excel 2013

• Excel and the Excel Environment
• Navigate and Select in Worksheets
• Create a Basic Workbook
• Open, Save and Close Workbooks
• Use Microsoft Help

Module 2: Modifying a Workbook

• Cut, Copy and Paste Commands
• Flash Fill
• AutoFill Options
• Find and Replace
• Spelling
• Undo and Redo
• Insert and Delete Options
• Column Width and Row Height
• Hide and Unhide Options

Module 3: Using Formulas and Functions

• Create Relative Formulas
• Mixed Cell References
• AutoCalculate
• Insert Functions
• Use AutoSum
• Copy Formulas
• Create Absolute Formulas

Module 4: Formatting an Excel Worksheet

• Font Group
• Add Borders and Fill Colours
• Cell Alignment
• Number Formatting
• Cell Styles and Galleries

Module 5: Managing Worksheets and Workbooks

• Manage Worksheets
• View Worksheets and Workbooks

Module 6: Printing Options

• Print Pane
• Print Worksheets and Workbooks
• Page Setup
• Print Layout View