Course Outline
1 - WORKING WITH FUNCTIONS
- Topic A: Working with Ranges
- Topic B: Utilizing Specialized Functions
- Topic C: Applying Logical Functions
- Topic D: Managing 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 via 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: Generating Charts
- Topic B: Adjusting and Formatting Charts
- Topic C: Employing Advanced Chart Features
5 - USING PIVOTTABLES AND PIVOTCHARTS
- Topic A: Building a PivotTable
- Topic B: Analyzing PivotTable Data
- Topic C: Presenting Data via PivotCharts
- Topic D: Filtering Data Using Timelines and Slicers
Requirements
To ensure optimal results, participants should have completed the Microsoft® Office Excel® 2019: Basic course or possess equivalent proficiency 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
