Course Description
With the Excel Charts, Formatting and Reporting Training, you will learn the essentials regarding visualizations in Excel. You will create charts, use styles and templates and manage advanced worksheet formatting. The Excel Charts, Formatting and Reporting Training course is for individuals whose job responsibilities include publishing spreadsheet results, creating visualizations and managing formatting and advanced reports.
Objectives
Upon successful completion of the Excel Charts, Formatting and Reporting Training course, you will be able to: · Format a Worksheet
· Apply Number Formats
· Align Cell Contents
· Apply Styles and Themes
· Apply Basic Conditional Formatting
· Create and Use Templates
· Visualize data by using basic charts
· Modify and Format Charts
· Use Advanced Chart Features
Agenda
Creating Charts
Understanding Chart Types
Creating a Chart
Changing the Chart Location and Size
Changing the Chart Type
Modifying Chart Elements
Formatting Chart Elements
Adding and Removing a Data Series
Applying a Chart Filter
Printing Charts
Working with Charts
Creating a Hierarchy Chart
Creating a Histogram
Creating a Pareto Chart
Creating a Box and Whisker Chart
Creating a Waterfall Chart
Creating a Combo Chart
Creating a Sparkline
Creating and Using a Chart Template
Creating a Dashboard
Using Styles, Themes, and Templates
Working with Cell Styles
Merging Styles
Using Themes
Using Templates
Creating a Template
Using a Personal Template
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
Using Print Options
Using Print Areas
Creating and Using a Range Name for Printing
Working with Print Settings
Using Page Setup Tools
Using Page Break Preview
Using Print Titles
Using Headers and Footers
Printing Gridlines and Row and Column Headings
Using Custom Worksheet Views
Saving a Worksheet as a PDF File
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
Modifying a Chart in Word or PowerPoint