Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
1 - WORKING WITH FUNCTIONS
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
2 - WORKING WITH LISTS
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
3 - ANALYZING DATA
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
4 - VISUALIZING DATA WITH CHARTS
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
5 - USING PIVOTTABLES AND PIVOTCHARTS
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
Requirements
To ensure success, students should have completed Microsoft® Office Excel® 2019: Basic or have the equivalent knowledge and experience.
7 Hours
Testimonials (2)
I learned new skills and information
fatma AlKetbi - Dubai Government Human Resources
Course - Excel 2019 - Intermediate
The trainer was informative and has a smooth and easy way of teaching