Full program description
Excel 3 includes four modules:
- Module 1 - Format as Table
- Module 2 - Aggregate Functions
- Module 3 - Sorting vs Filtering
- Module 4 - Lookup Functions
- Module 5 - Pivot Table
This course is designed to provide an overview of Excel, covering the essential features below:
- Changing raw data into a table
- Naming a cell
- SUMIF Function
- AVERAGEIF Function
- COUNTIF Function
- Sorting data
- Filtering data
- VLOOKUP Function
- XLOOKUP Function
- Create a Pivot Table
- Filtering in Pivot Table
By the end of the course, you will be able to:
- Practice conditional aggregation functions, like SUMIF, AVERAGEIF, and COUNTIF
- Convert standard data ranges into interactive Excel Tables
- Apply text-matching dropdown filters and advanced numeric condition rules
- Use VLOOKUP to reference data ranges or XLOOKUP as a flexible alternative
- Summarize datasets with Pivot Tables and Charts
*Note: If you do not have an existing Canvas account, request access to the course by completing this form: https://wkf.ms/3Q5WsiG