Course Content
Lesson 1: Creating Charts
- Understanding Chart Types
- Creating a Chart
- Changing the Chart Type
- Modifying Chart Elements & Formatting Chart Elements
- Adding and Removing a Data Series
- Applying a Chart Filter
Lesson 2: Working with Charts
- Creating a Hierarchy Chart
- Creating a Histogram, Pareto Chart & Box and Whisker Chart
- Creating a Waterfall Chart, Combo Chart & Sparkline
- Creating and Using a Chart Template & Dashboard
Lesson 3: Using Styles, Themes, and Templates
- Working with Cell Styles, Merging Styles Using Themes
- Working with Cell Styles, Merging Styles Using Templates
- Creating a Template
Lesson 4: Working with Formatting
- Creating and Using Custom Formats
- Applying Conditional Formatting
- Creating a New Conditional Formatting Rule
- Working with Conditional Formatting Rules
- Using the Quick Analysis Tool
Lesson 5: Using Print Options
- Using Print Areas
- Creating and Using a Range Name for Printing
- Working with Print Settings
- Using Page Setup Tools, Page Break Preview, Print Titles & Headers and Footers
- Printing Gridlines and Row and Column Headings
- Using Custom Worksheet Views
Lesson 6: Using Excel Data in Other Office Applications
- Understanding Pasting, Linking and Embedding
- Pasting an Excel Range into a Word Document
- Pasting an Excel Chart into a Word Document
- Pasting an Excel Range into PowerPoint
- Pasting an Excel Chart into PowerPoint
- Creating a Chart in Word or PowerPoint