Course Overview
This 3-day intensive boot camp for beginners is designed to take you from the absolute basics of Microsoft Excel navigation and data entry all the way to mastering advanced, real-world applications.
course outline
Day 1: Microsoft Excel Fundamentals
-
- Getting Started with Microsoft Excel
- Performing Calculations
- Modifying a Worksheet
- Formatting a Worksheet
- Printing Workbook Contents
- Managing Large Workbooks
Day 2: Microsoft Excel Intermediate
-
- Working with Functions
- Working with Lists
- Analysing Data
- Visualising Data with Charts
- Using PivotTables and PivotCharts
Day 3: Microsoft Excel Advanced
-
- Working with Multiple Worksheets and Workbooks
- Using Lookup Functions and Formula Auditing
- Sharing and Protecting Workbooks
- Automating Workbook Functionality
- Creating Sparklines and Mapping Data
- Forecasting Data