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.
You can also access our Quick Tip Videos, that only last a few minutes, under Tips and Tricks.
Course Content
string(3) "596"
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
Use the X inside a lesson to save your progress.Continue
