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.
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
“MODULE 1: MANAGING DATA
Configuring Data Validation
Converting Text to Columns
MODULE 2: OUTLINING AND GROUPING DATA
Showing and Hiding Outline Details
Removing Outlining and Grouping
MODULE 3: DATA VISUALIZATION
Understand Types of Charts
Box & Whisker compare sets of data
Creating a Treemap Chart
Creating a Waterfall Chart
MODULE 4: ANALYZING DATA
Using Goal Seek
Using Data Tables
MODULE 5: USING SOLVER
Setting up the Worksheet
Generating Reports and Scenarios with Solver
Setting Solver Options
MODULE 6: PIVOT TABLE
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
Certified Assessor for Skills Training under “Jabatan Pembangunan Kemahiran” (JPK), Ministry of Human Resources, Malaysia
Elev8 Asia Sdn Bhd is a HRDF Certified Training Provider in Malaysia which founded in year 2015.