Duration
1 day
Learning Objective
Making strategic decisions, achieve major goals and solve complex problems, by collecting, analyzing and reporting the most useful information relevant to business needs. Mastering some powerful features Excel has to offer in analyze data to support quality decision making.
Delivery Method - VILT
Virtual instructor-led training (VILT) refers to training that is delivered in a virtual environment when instructor and learner are in separate locations. Virtual instruction environments are designed to simulate the traditional classroom or learning experience allowing professionals flexibility of learning at their convenient locations.
Content deliveries are break-down by sessions. Each session will take approximately 45min (with Q&A) follow with short breaks.
Content Outlines
Session 1
Managing Data
- Consolidating Information
- Configuring Data Validation
- Converting Text to Columns
- Using FlashFill
- Transposing Data
- Q & A
Session 2
Outlining and Grouping Data
- Outlining Data
- Creating Subtotals
- Q & A
Session 3
Analyzing Data
- Using Goal Seek
- Using Data Tables
- Q & A
Session 4
Using Solver - Optional
- Setting up the Worksheet
- Running Solver
- Generating Reports and Scenarios with Solver
- Modifying Constraints
- Setting Solver Options
- Q & A
Session 5
PivotTable Features
- Creating a Basic PivotTable
- Creating a Basic PivotChart
- Using the PivotTable Fields Pane
- Adding Calculated Fields
- Sorting Pivoted Data
- Filtering Pivoted Data
- Using Slicers
- Q & A
Final Q & A – 15-30min
Programme scope, delivery arrangements and suitability are confirmed during enquiry.