MS Excel 365 - Introduction
This Course is CPD Certified
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, alter your worksheet display, work with additional formatting options such as custom number formats and paste special, use conditional formatting and find blank cells, work with ranges of cells using named ranges, work with objects ie text boxes and screenshots, work with Tables, sort and filter data, use outlining and consolidate and use subtotals, protect worksheets/books 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.
| Using Multiple Workbooks and Worksheets |
| Linking Workbooks |
| Linking Worksheets with 3D Formulas |
| Headers and Footers |
| Hide and Show |
| Arranging Workbooks |
| Freezing Panes |
| Create Custom Views |
| Grouping and Ungrouping Worksheets |
| Split Command |
| Advanced Printing Settings |
| Cell Borders |
| Custom Number Formats |
| Paste Special Options |
| Using Functions to format text |
| Working with Styles |
| Working with Themes |
| Creating Rules |
| Creating Rules using Formulas |
| Finding Blank Cells |
| Creating Named Ranges |
| Using Named Ranges in Formulas |
| Editing Named Ranges |
| Inserting Text Boxes |
| Inserting Pictures |
| Inserting Shapes and Icons |
| Inserting SmartArt |
| Screenshots |
| Creating Excel Tables |
| Formatting Excel Tables |
| Table Totals |
| Inserting/Deleting Table Rows and Columns |
| Sorting Data |
| Filtering Data |
| Data Validation Drop-Down Lists |
| Removing Duplicates |
| Using Slicers |
| Outlining |
| Consolidating Data |
| Creating Subtotals |
| Protecting Workbooks |
| Protecting Worksheets |
| Saving Workbooks as Web Pages |
| Creating and Managing Templates |
| Digitally Signing a Workbook |
