Lookup Functions
- Lookup Functions
- Lookup and Reference Functions
Introduction to Advanced charts
- Introduction to Advanced charts
Types of charts
- Objective
- Line chart
- Column chart
- Clustered column chart
- Stacked column chart
- Pie chart
- Bar chart
- Summary
Sub-types of charts and its uses
- Objective
- Area Chart
- Converting area chart into line chart
- 3D Area chart
- Making areas transparent
- Stacked area chart
- Scatter chart
- Data plotting
- What is regression analysis ?
- Creating Scatter chart
- Using trendlines
- Line chart vs Scatter chart - part 1
- Line chart vs Scatter chart - part 2
- Scatter chart with lines and markers
- Types of scatter chart
- Bubble chart
- Creating bubble chart
- Coloring bubbles
- Displaying legends
- Stock charts
- Types of stock charts
- Organization of data
- Creating a high-low - close chart
- Formatting a stock chart
- Varying period
- Creating a open-high-low - close chart
- Stock charts with volumes
- Summary
Modifying charts
- Objective
- Surface chart
- Types of surface charts
- Creating a surface chart
- Wireframe 3-D Surface chart
- Contour chart
- Wireframe contour chart
- Radar chart
- Creating a Radar chart
- Types of Radar chart
- Combination chart
- Creating a combination chart
- Changing chart type
- Adding titles to vertical axes
- Applying chart styles
- Summary
Chart Templates
- Objective
- What are chart templates
- Customizing a chart
- Saving a chart template
- Using chart template - new chart
- Using chart template - An existing chart
- Moving or deleting chart template
- Summary
Sparklines
- Objective
- What are sparklines
- Sparklines vs charts
- Types of sparklines
- Creating sparklines
- Altering the design of sparklines
- Sparkline group vs individual sparklines
- Removing sparklines
- Comparing sparklines with a group
- Modifying display range
- Dealing with empty cells
- Empty cells - option 2
- Empty cells - option 3
- Data in hidden rows and columns
- Summary
Introduction to Pivot chart and tables
- Introduction
Pivot charts
- Objective
- Creating pivot charts
- Manipulating options in pivot charts
- Using field buttons in pivot charts
- Effect of Slicers
- Creating pivot chart before pivot table
- Formatting pivot chart
- Summary
Pivot table
- Objective
- Creating pivot table
- Multiple fields in row, column or data section
