Excel is a powerful tool for managing data, creating reports, and performing calculations. It automates tasks, analyses large datasets, and presents findings clearly.
Structured into 16 detailed modules, the course includes hands-on practical exercises. You'll cover data entry, formatting, essential and advanced formulas, data analysis tools, date and time management, data validation, lookup functions, data import/export, macros, VBA, and collaboration tools.
During this online course, you will gain valuable, practical experience delivering mock training sessions.
- Introduction
- Quick Wins
- Format and Align Numbers and Cells
- Introduction to Excel Formulas
- Use Named Ranges
- Excel Tables
- Excel Lists: Sort, Filter and Subtotals
- Move and Link to Data
- Introduction to Intermediate Formulas
- Analyse Data
- Conditional Formatting
- Insert Pictures and Annotations
- Work with Views
- Prepare for Printing
- Finalizing the Spreadsheet
- Excel 365 Online
- Course Close
Please Note: This course offers over 8+ hours of expert content, and you'll receive a certificate upon completion.