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
Objective
https://dwnk32xmy75f1.cloudfront.net/wp-content/uploads/20181228091415/lab04.mp4
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