Microsoft Excel Level 3: Business Analytics and Data Management
Monday, March 7, 1-4:30 p.m.
Online
In Microsoft Excel Level 3, participants will build confidence and mastery in their skills. Filled with practical instruction and ample practice, participants will learn to use logical, look-up and reference functions as well as skills to consolidate, validate, and forecast data. Participants will leave the course with the ability to use the software to drive greater efficiency, reduce errors and make confident decisions using data-driven insights.
Key Learning Outcomes
- Logical, Lookup, and Reference Functions
- Text Functions
- Date and Time Functions
- Nested Functions
- Named Ranges
- Using Multiple Worksheets and Workbooks
- Formula Auditing
- Data Validation
- What-If Analysis
- Workbook Collaboration
This course requires intermediate knowledge and experience with MS Excel. Participants should have an understanding of spreadsheet programs including the layout and composition of workbooks. Experience manipulating spreadsheets, formatting cells, entering formulas, functions (i.e.: SUM, AVERAGE, COUNT, MIN) and knowledge of mathematical operators in Excel.
Please use the Microsoft Excel Placement Self-Assessment to determine which level you should start at.
Delivered virtually on March 7 – 8, 2022 from 1:00 pm – 4:30 pm NST.
Presented by Gardiner Centre