Microsoft Excel (Intermediate)
Course Objective
Microsoft Excel Intermediate course will equip you with hands-on knowledge to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.
You will: -
- Work with functions.
- Work with lists.
- Analyze data.
- Visualize data with charts.
Target Audience
This course is designed for students who already have foundational knowledge and skills in Microsoft Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Microsoft Excel to analyze and present data.
Training Methodologies
- Training is hands-on using easy-to-follow step-by-stepinstructions.
- Instructor-Led Training (ILT) on live exercises of each topic.
Trainer
Training will be conducted by our experienced local trainer who has more than 10 years of experience with relevant certification.
Course Content
Lesson 1: Working with Lists
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Outline and Subtotal Data
- Topic D: Consolidate Data
Lesson 2: Advanced Functions
- Topic A: Work with Logical Functions
- Topic B: Work with Date & Time Functions
Lesson 3: Analyzing Data
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
Lesson 4: Visualizing Data with Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts