Microsoft Excel Intermediate (1 day recommended)

This course is designed for existing users of Excel. It show delegates how to work with multiple worksheets, create and format charts, work with complex formulas and use advanced formatting techniques.

The course is suitable for those who are comfortable working with Excel spreadsheet and who know how to enter and edit data and create formulas.

Course outline

Multiple Worksheets and Workbooks

Using Multiple Worksheets
Inserting New Worksheets
Renaming Worksheets
Deleting Worksheets
Creating Multiple Views
Freezing Panes
Viewing and Arranging Multiple Worksheet Windows
Navigating in Multiple Workbooks
Selecting and Viewing Multiple Workbooks
Creating and Opening a Workspace
Managing Multiple Worksheets and Workbooks
Selecting Multiple Worksheets
Moving and Copying Data between Worksheets
Linking Data Between Worksheets
Creating a 3-D Formula

Charting

Using Charts
Creating a Chart
Changing Chart Type, Style and Chart Sub-Type
Changes to the Chart Source Data
Add data to an existing chart
Change the data in an existing chart
Remove data from a chart
Managing Chart Objects
Moving and Resizing Chart Objects
Deleting Chart Objects
Adding Data Series and Objects to a Chart
Changing the Chart Type
Formatting Chart Objects
Printing Charts

Advanced Functions

Creating and Using Functions
Using Built-in Functions
Working with Arguments: The PMT Function
Using Dates and Times
Using Dates in Calculations
Using Nested Functions
Auditing Worksheets
Identifying the Auditing Commands
The Watch Window
The Formula Evaluator
Tracing and Correcting Worksheet Errors
Assignment

Advanced Formatting

Using Comments in a Worksheet
Reviewing, Showing, and Hiding Comments
Deleting a Comment
Working with Styles
Applying a Style
Modifying Existing Styles
Using Format Painter
Creating Custom Number Formats
Applying an AutoFormat (Table Format)
Conditional Formats
Clear conditional formats

Back to top