Course Outline
1 - WORKING WITH FUNCTIONS
- Topic A: Working with Ranges
- Topic B: Using Specialized Functions
- Topic C: Applying Logical Functions
- Topic D: Working with Date and Time Functions
- Topic E: Using Text Functions
2 - WORKING WITH LISTS
- Topic A: Sorting Data
- Topic B: Filtering Data
- Topic C: Querying Data with Database Functions
- Topic D: Outlining and Subtotaling Data
3 - ANALYZING DATA
- Topic A: Creating and Modifying Tables
- Topic B: Applying Intermediate Conditional Formatting
- Topic C: Implementing Advanced Conditional Formatting
4 - VISUALIZING DATA WITH CHARTS
- Topic A: Creating Charts
- Topic B: Modifying and Formatting Charts
- Topic C: Utilizing Advanced Chart Features
5 - USING PIVOTTABLES AND PIVOTCHARTS
- Topic A: Creating a PivotTable
- Topic B: Analyzing PivotTable Data
- Topic C: Presenting Data with PivotCharts
- Topic D: Filtering Data Using Timelines and Slicers
Requirements
To ensure optimal learning outcomes, students should have completed Microsoft® Office Excel® 2019: Basic or possess equivalent knowledge and experience.
Testimonials (7)
Every step of the way, I was learning something.
GEORGE BRUSSE - martinrea.com
Course - Excel - Intermediate
Learning new ways of improving my work
Stan Doku - martinrea.com
Course - Excel - Intermediate
It's taught me that excel it more than just a spreadsheet that we input data. It's helps us create data that not just us, but everyone could understand.
Tonya Huong - martinrea.com
Course - Excel - Intermediate
The practical application of excel
Rolan Garin - martinrea.com
Course - Excel - Intermediate
Some of the exercises are fun and can be applied on everyday work.
Preciosa Cabildo - martinrea.com
Course - Excel - Intermediate
Learned some short cuts I can use when working on Excel.
Rafal Trzeciakowski - martinrea.com
Course - Excel - Intermediate
i learned understanding the ribbon ,row, columns and cells. And how do inputting data entry and perform basic calculations
