Curriculum
8 Sections
93 Lessons
52 Weeks
Expand all sections
Collapse all sections
Introduction to Pivot chart and tables
1
1.1
Introduction to Pivot chart and tables
1 Minute
Types of charts
8
2.1
Objective
1 Minute
2.1
Line chart
1 Minute
2.1
Column Chart
1 Minute
2.1
Clustered column chart
1 Minute
2.1
Stacked column chart
1 Minute
2.1
Pie chart
1 Minute
2.1
Bar chart
1 Minute
2.1
Summary
1 Minute
Sub-types of charts and its uses
28
3.1
Objective
1 Minute
3.1
Bubble chart
1 Minute
3.1
Stock charts with volumes
1 Minute
3.1
Creating a open-high-low – close chart
1 Minute
3.1
Varying period
1 Minute
3.1
Formatting a stock chart
1 Minute
3.1
Creating a high-low – close chart
1 Minute
3.1
Organization of data
1 Minute
3.1
Types of stock charts
1 Minute
3.1
Stock charts
1 Minute
3.1
Displaying legends
1 Minute
3.1
Coloring bubbles
1 Minute
3.1
Creating bubble chart
1 Minute
3.1
Types of scatter chart
1 Minute
3.1
Area Chart
1 Minute
3.1
Scatter chart with lines and markers
1 Minute
3.1
Line chart vs Scatter chart – part 2
1 Minute
3.1
Line chart vs Scatter chart – part 1
1 Minute
3.1
Using trendlines
1 Minute
3.1
Creating Scatter chart
1 Minute
3.1
What is regression analysis ?
1 Minute
3.1
Data plotting
1 Minute
3.1
Scatter chart
1 Minute
3.1
Stacked area chart
1 Minute
3.1
Making areas transparent
1 Minute
3.1
3D Area chart
1 Minute
3.1
Converting area chart into line chart
1 Minute
3.1
Summary
1 Minute
Modifying charts
16
4.1
Objective
1 Minute
4.1
Surface chart
1 Minute
4.1
Types of surface charts
1 Minute
4.1
Creating a surface chart
1 Minute
4.1
Wireframe 3-D Surface chart
1 Minute
4.1
Contour chart
1 Minute
4.1
Wireframe contour chart
1 Minute
4.1
Radar chart
1 Minute
4.1
Creating a Radar chart
1 Minute
4.1
Types of Radar chart
1 Minute
4.1
Combination chart
1 Minute
4.1
Creating a combination chart
1 Minute
4.1
Changing chart type
1 Minute
4.1
Adding titles to vertical axes
1 Minute
4.1
Applying chart styles
1 Minute
4.1
Summary
1 Minute
Chart Templates
8
5.1
Objective
1 Minute
5.1
What are chart templates
1 Minute
5.1
Customizing a chart
1 Minute
5.1
Saving a chart template
1 Minute
5.1
Using chart template – new chart
1 Minute
5.1
Using chart template – An existing chart
1 Minute
5.1
Moving or deleting chart template
1 Minute
5.1
Summary
1 Minute
Sparklines
15
6.1
Objective
1 Minute
6.1
What are sparklines?
1 Minute
6.1
Sparklines vs charts
1 Minute
6.1
Types of sparklines
1 Minute
6.1
Creating sparklines
1 Minute
6.1
Altering the design of sparklines
1 Minute
6.1
Sparkline group vs individual sparklines
2 Minutes
6.1
Removing sparklines
1 Minute
6.1
Comparing sparklines with a group
1 Minute
6.1
Modifying display range
2 Minutes
6.1
Dealing with empty cells
1 Minute
6.1
Empty cells – option 2
30 Minutes
6.1
Empty cells – option 3
1 Minute
6.1
Data in hidden rows and columns
1 Minute
6.1
Summary
1 Minute
Pivot charts
8
7.1
Objective
1 Minute
7.1
Creating pivot charts
1 Minute
7.1
Manipulating options in pivot charts
1 Minute
7.1
Using field buttons in pivot charts
1 Minute
7.1
Effect of Slicers
1 Minute
7.1
Creating pivot chart before pivot table
1 Minute
7.1
Formatting pivot chart
1 Minute
7.1
Summary
1 Minute
Pivot table
9
8.1
Objective
1 Minute
8.1
Creating pivot table
1 Minute
8.1
Multiple fields in row, column or data section
2 Minutes
8.1
Creating pivot charts
1 Minute
8.1
Creating and using calculated fields
2 Minutes
8.1
Adding and using data slicer
1 Minute
8.1
Using the new timeline filter option
1 Minute
8.1
Pivot table styles
1 Minute
8.1
Summary
1 Minute
MS Excel – Create Advanced Charts and Pivot tables
Search
This content is protected, please
login
and enroll in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content