Data Analysis Using Microsoft Excel
About Data Analysis Using Microsoft Excel
This Advanced Microsoft Excel training class is designed for participants to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, and collaborate with others.
Course Duration
Who Should Attend This Course?
Participants who have intermediate skills with Microsoft Excel.
What Will You Learn?
At the completion of the training, candidates will be able to:
- Create a Pivot Table
- Audit and Analyse Worksheet Data
- Utilize Data tools and Collaborate with others
Programme Outline
“MODULE 1: MANAGING DATA
- Consolidating Information
- Removing Duplicates
- Configuring Data Validation
- Converting Text to Columns
- Outlining Data
- Showing and Hiding Outline Details
- Grouping Data
- Creating Subtotals
- Removing Outlining and Grouping
- Understand Types of Charts
- Box & Whisker compare sets of data
- Creating a Treemap Chart
- Creating a Waterfall Chart
- Using Goal Seek
- Using Data Tables
- Setting up the Worksheet
- Running Solver
- Generating Reports and Scenarios with Solver
- Modifying Constraints
- Setting Solver Options
- Creating a Basic PivotTable
- Creating a Basic PivotChart
- Using the PivotTable Fields Pane
- Adding Calculated Fields
- Sorting Pivoted Data
- Filtering Pivoted Data
- Creating Calculated Items
- Creating Calculated Fields
Trainer
SENTHIVALU KRISHNASAMY
Certified Assessor for Skills Training under “Jabatan Pembangunan Kemahiran” (JPK), Ministry of Human Resources, Malaysia
About Us
Elev8 Asia Sdn Bhd is a HRDF Certified Training Provider in Malaysia which founded in year 2015.
Services
- Corporate Training
- Competency Assessment
- e-Learning
- Platform Development
Help
- Privacy Policy
- Contact Us
- News