+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Log in
+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Excel

MS Excel Course Outline – Intermediate level

Course Description

This intermediate MS Excel course is designed for users who have attended an introductory level course or are already confident with the basic features.

By the end of this course you will be able to work with multiple worksheets and workbooks, work with ranges, format numbers, create subtotals and consolidate data. You will learn about how to name cells, filter data, work with graphics, create mini charts with Sparklines and create and manage templates.

Estimated course duration is 3-4 hours. Each lesson takes on average 3-5 minutes to complete.​
Download PDF

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
Sorting
Filtering
Totals
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

Outlining
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

Sparklines
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.

GET IN TOUCH

On-line courses

Face to face Workshops

Virtual On-line Classes

On-line Shop for 1 to 50 licences

Personalise your own course

Create your own branded learning site
bitsy

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!

Sign Up See our Tips