Course Outline
Microsoft Excel - Intermediate
Hands-on training in an instructor-led environment. One workstation per
delegate and exercises to consolidate learning.
Training Method:
Existing users of Microsoft Excel, or as a follow on from our Introduction
to Excel course.
One day
Upon successful completion of the course, delegates will have an understanding of and be
able to use Excel to create a simple database, and utilise essential features to enable
them to create more complex worksheets.
Existing users of Microsoft Excel.
Designed for:
Module 1: Managing Your Workbooks
Switching Between Sheets in a Workbook
Inserting and Deleting Worksheets
Renaming and Moving Worksheets
Working with Several Workbooks and Windows
Splitting and Freezing a Window
Referencing External Data
Creating Headers, Footers, and Page Numbers
Specifying a Print Area and Controlling Page Breaks
Adjusting Page Margins and Orientation
Adding Print Titles and Gridlines
Changing the Paper Size and Print Scale
Protecting a Worksheet
Hiding Columns, Rows and Sheets
Viewing a Worksheet and Comparing
Workbooks Side by Side
Saving a Custom View
Working with Templates
Consolidating Worksheets
Module 2: More Functions and Formulas
Formulas with Several Operators and Cell Ranges
Using the Insert Function Feature
Creating and Using Range Names
Selecting Nonadjacent Ranges and Using
Using the IF Function to Create
Conditional Formulas
Using the PMT Function
Displaying and Printing Formulas
Fixing Formula Errors
Module 3: Working with Lists
Creating a List
Working with Lists and Using the Total Row
Adding Records Using the Data Form
Dialog Box and Insert Row
Finding Records
Deleting Records
Sorting a List
Filtering a List with the AutoFilter
Creating a Custom AutoFilter
Filtering a List with an Advanced Filter
Copying Filtered Records
Using Data Validation
Module 4: Data Analysis
Creating Subtotals
Using Database Functions
Using Lookup Functions
Grouping and Outlining a Worksheet
* Public Courses
* Private Courses
* Customised Courses
* On site training available
Tel: 01625 549287