25% discount on all courses  /  Enter BITE2020 at checkout  /  Limited Offer

MS Excel 2016 - Intermediate

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, 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 take on average 3-5 minutes to complete.



Course Content

Multiple Workbooks and Worksheets

Using Multiple Workbooks
Linking Workbooks
Linking Worksheets with 3D 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
Formatting an Excel Table
Inserting and Deleting Rows and Columns in Tables
Sorting Data
Filtering Data
Totals 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 and 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 Sharing Features
Saving as Templates
Creating and Managing Templates
Digitally Signing a Workbook

Advanced Charts

Sparklines
Chart Formatting Options
Combo Charts