Excel Level 2 | Free Workplace Education 2025 - Monday Evening
Start Date: Monday, January 20, 2025
Time: Mondays 5:30pm – 9:30pm
Length: 10 Weeks
Location: Virtual Via Zoom
Cost: Free
Requirements: Must be currently employed or self-employed in Nova Scotia.
Course Description
Building on the concepts presented in Microsoft Excel (level I), this next level focuses on data analysis and reporting as well as integration, dataflow, and modifying databases using advance charting and customized formulas. You will also learn how to create pivot tables and charts.
Mandatory Core Concepts
- Formulas – Vlookups, absolute cells, and custom formulas such MMMM/DD/YYYY
- Macros – record a macro, assign a macro to keystroke, and assign a macro to a button on the toolbar
Learning Outcomes & Standard Topics
- Create with advance charting
- Demonstrate various customizing functions (Fx)
- Apply If statements – basic and complex
- Sort, filter, and manipulate data
- Create and modify databases
- Create pivot-tables and charts
- Creating macros
- Advance charting
- Data analysis and reporting
- Linking and embedding for reporting
- Integration and dataflow
- Modifying databases
- Pivot-tables
- Charts
To register fill out the form below. All fields are mandatory (the exception is immigration year).
Excel Level 2 - Monday 5:30pm - 9:30pm
Please fill out the form below to register"*" indicates required fields