Level Up Your Excel Skills

“Learning Unit 1 – Gather Data

Import data into spreadsheets.
Consolidate data from multiple sources.
Link cells and ranges between applications and break links as needed.

Learning Unit 2 – Format & Manage Worksheets

Apply custom number formats.
Implement data validation techniques.
Group multiple worksheets.
Explore paste special options.

Learning Unit 3 – Advanced Data Handling

Create and manage range names.
Utilize the ‘Go To Special’ feature for advanced data handling.

Learning Unit 4 – Data Analysis

Use Quick Analysis tools.
Apply conditional formatting to enhance data visualization.
Perform advanced sorting and filtering.
Create and manipulate PivotTables and PivotCharts.

Learning Unit 5 – Advanced Excel Functions

Understand and use various types of cell referencing.
Employ logical functions like IF, AND, OR.
Utilize nested functions to build complex formulas.
Apply mathematical functions for calculations.
Use date functions to manage and manipulate dates.
Manipulate text with text functions.
Find data with lookup and reference functions.
Handle data sets with database functions.
Conduct formula auditing to check and debug formulas.

Learning Unit 6 – Collaborative Editing

Track changes made by multiple users.
Share workbooks for collaborative work.
Compare and merge workbook changes.”