Go to page content

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.

Register Now!

 

 

Presented by Gardiner Centre

Event Listing 2022-03-07 13:00:00 2022-03-07 16:30:00 America/St_Johns Microsoft Excel Level 3: Business Analytics and Data Management 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. Register Now!     Online Gardiner Centre