This covered following topics;
Working with Charts
Introduction
Charts
Types of Charts
Identifying the Parts of
a Chart
To Create a Chart:
Chart Tools
To Change the Chart Type:
To Switch Row and Column
Data:
To Change the Chart
Layout:
To Change the Chart
Style:
To Move the Chart to a
Different Worksheet:
Challenge!
Analyzing Worksheet Data
Creating Complex Formulas
Complex Formulas
Order of Operations
To Create a Complex
Formula Using the Order of Operations:
Working with Cell References
Relative References
Absolute References
Challenge!
Working with Basic Functions
Basic Functions
Function Library
Insert Function Command
Challenge!
Sorting Data
Introduction
Basic Sorting
Custom Sorting
Sorting Multiple Levels
Challenge!
Outlining Data
Introduction
Outlining Data
Showing or Hiding Data
Removing Groups and Subtotaling
Creating Your Own Groups
Challenge!
Filtering Data
Introduction
Filtering Data
Advanced Filtering
Challenge!
Creating PivotTables
PivotTables
Using PivotTables to
Answer Questions
Pivoting Data
Report Filters
Slicers
PivotCharts
Challenge!
Using What-If Analysis
What-If Analysis
Goal Seek
Other Types of What-If Analysis
Download Note click Here
No comments:
Post a Comment