Diploma in Microsoft Excel

It’s one of the most highly awarded courses that you could take. The Advanced Microsoft Excel Package for accountancy, bookkeeping and administration roles is loaded with specially rated achievements. These include certificates in Microsoft Excel, Intermediate Microsoft Excel, Advanced Certificate in Excel. If you want to be quickly acknowledged and highly rewarded, then this package is the one.

Course Modules​

Certificate in Microsoft Excel

1. Introducing Excel
2. Entering Data
3. File Operations
4. Performing Calculations
5. Modifying the Worksheet
6. Formatting
7. Printing
8. Sorting and Filtering

Intermediate Certificate in Excel

1. Working with Large Tables of Data
2. When Formulas Don't Calculate as Expected
3. Using Multiple Worksheets
4. Time Saving Functions
5. Conditional Formatting
6. Introduction to Recording Macros
7. Protecting
8. Microsoft 365 Functions

Advanced Certificate in Excel

1. Importing and Saving Plain Text Files
2. Lookup and Cross-Reference
3. Preparing Data for Reporting
4. Using Tables
5. Pivot Tables
6. Pivot Charts