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.
| Using Multiple Workbooks |
| Linking Workbooks |
| Linking Worksheets with 3D Formulas |
| Managing Workbooks |
| Headers and Footers |
| Creating Named Ranges |
| Using Named Ranges in Formulae |
| Editing Named Ranges |
| Inserting Text Boxes |
| Inserting Pictures |
| Inserting Online Pictures |
| Inserting Shapes |
| Inserting SmartArt |
| 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 |
| Freezing Panes |
| Transpose Columns and Rows |
| Create a Custom View |
| Group and Ungroup Worksheets |
| Using Special Number Formats |
| Using Functions to Format Text |
| Working with Styles |
| Working With Themes |
| Outlining |
| Consolidating Data |
| Creating Subtotals |
| Saving Workbooks as Web Pages |
| Web Sharing Features |
| Saving as Templates |
| Creating and Managing Templates |
| Digitally Signing a Workbook |
| Sparklines |
| Chart Formatting Options |
| Combo Charts |
