Lookup Functions, Advanced Charts and Pivot tables

Course Curriculum

Chapter 1: Lookup Functions

Lecture 1: Lookup Functions

Lecture 2: Lookup and Reference Functions

Chapter 2: Introduction to Advanced charts

Lecture 1: Introduction to Advanced charts

Chapter 3: Types of charts

Lecture 1: Objective

Lecture 2: Line chart

Lecture 3: Column chart

Lecture 4: Clustered column chart

Lecture 5: Stacked column chart

Lecture 6: Pie chart

Lecture 7: Bar chart

Lecture 8: Summary

Chapter 4: Sub-types of charts and its uses

Lecture 1: Objective

Lecture 2: Area Chart

Lecture 3: Converting area chart into line chart

Lecture 4: 3D Area chart

Lecture 5: Making areas transparent

Lecture 6: Stacked area chart

Lecture 7: Scatter chart

Lecture 8: Data plotting

Lecture 9: What is regression analysis ?

Lecture 10: Creating Scatter chart

Lecture 11: Using trendlines

Lecture 12: Line chart vs Scatter chart – part 1

Lecture 13: Line chart vs Scatter chart – part 2

Lecture 14: Scatter chart with lines and markers

Lecture 15: Types of scatter chart

Lecture 16: Bubble chart

Lecture 17: Creating bubble chart

Lecture 18: Coloring bubbles

Lecture 19: Displaying legends

Lecture 20: Stock charts

Lecture 21: Types of stock charts

Lecture 22: Organization of data

Lecture 23: Creating a high-low – close chart

Lecture 24: Formatting a stock chart

Lecture 25: Varying period

Lecture 26: Creating a open-high-low – close chart

Lecture 27: Stock charts with volumes

Lecture 28: Summary

Chapter 5: Modifying charts

Lecture 1: Objective

Lecture 2: Surface chart

Lecture 3: Types of surface charts

Lecture 4: Creating a surface chart

Lecture 5: Wireframe 3-D Surface chart

Lecture 6: Contour chart

Lecture 7: Wireframe contour chart

Lecture 8: Radar chart

Lecture 9: Creating a Radar chart

Lecture 10: Types of Radar chart

Lecture 11: Combination chart

Lecture 12: Creating a combination chart

Lecture 13: Changing chart type

Lecture 14: Adding titles to vertical axes

Lecture 15: Applying chart styles

Lecture 16: Summary

Chapter 6: Chart Templates

Lecture 1: Objective

Lecture 2: What are chart templates

Lecture 3: Customizing a chart

Lecture 4: Saving a chart template

Lecture 5: Using chart template – new chart

Lecture 6: Using chart template – An existing chart

Lecture 7: Moving or deleting chart template

Lecture 8: Summary

Chapter 7: Sparklines

Lecture 1: Objective

Lecture 2: What are sparklines

Lecture 3: Sparklines vs charts

Lecture 4: Types of sparklines

Lecture 5: Creating sparklines

Lecture 6: Altering the design of sparklines

Lecture 7: Sparkline group vs individual sparklines

Lecture 8: Removing sparklines

Lecture 9: Comparing sparklines with a group

Lecture 10: Modifying display range

Lecture 11: Dealing with empty cells

Lecture 12: Empty cells – option 2

Lecture 13: Empty cells – option 3

Lecture 14: Data in hidden rows and columns

Lecture 15: Summary

Chapter 8: Introduction to Pivot chart and tables

Lecture 1: Introduction

Chapter 9: Pivot charts

Lecture 1: Objective

Lecture 2: Creating pivot charts

Lecture 3: Manipulating options in pivot charts

Lecture 4: Using field buttons in pivot charts

Lecture 5: Effect of Slicers

Lecture 6: Creating pivot chart before pivot table

Lecture 7: Formatting pivot chart

Lecture 8: Summary

Chapter 10: Pivot table

Lecture 1: Objective

Lecture 2: Creating pivot table

Lecture 3: Multiple fields in row, column or data section