MS Excel Course Outline – Intermediate level

Topics Covered

Multiple Workbooks and Worksheets

Using Multiple Workbooks
Linking Workbooks
Linking Worksheets with 3-D Formulas
Managing Workbooks
Headers and Footers

Working with Ranges

Creating Named Ranges
Using Named Ranges in formulae
Editing Named Ranges

Creating Graphics

Inserting Text Boxes
Inserting Pictures
Inserting Online Pictures
Inserting Shapes
Inserting SmartArt

Excel Tables

Creating an Excel Table
Editing an Excel Table
Inserting/deleting rows & columns in tables
Creating a dropdown list for table entry
Removing duplicate rows
Advanced Filtering

Worksheet Display

Freezing Panes
Transpose Columns and Rows
Create a Custom View
Group/Ungroup Worksheets

Advanced Formatting

Using Special Number Formats
Using Functions to Format Text
Working with Styles
Working with Themes

Outlining and Subtotals

Consolidating Data
Creating Subtotals

Additional Saving Options

Saving Workbooks as Web Pages
Web and Sharing Features
Using Office Templates
Creating/Managing Templates
Digitally Signing a Workbook

Advanced Charts

Chart Formatting Options
Combo Charts

Can't see what you need?

All Microsoft Office Online Courses are based on a typical one day training course at a specific skill level and are included in our full online library. If you require a more tailored course to meet a particular learning need, get in touch.

All Personal Development Online Courses are 15 minute modules that complement our Bite Size methodology and work well together to create a great training plan.

Great deals for Corporate licences – give us a call.


Sign up for our free weekly tip

Receive a free nugget of IT Learning every week! It will give you a good feel for how we write and design our lessons and you could learn something new every week too!