Excel Charts, Formatting and Reporting Course Outline

Overview
Learn the essentials regarding visualizations in Excel. Create charts, use styles and templates, manage advanced worksheet formatting.

Target Student
This course is for individuals whose job responsibilities include publishing spreadsheet results and need to create visualizations and manage formatting and advanced reports.

Prerequisites
Excel Introduction or equivalent skills.
*** Excel Power User Class ***
Are you looking for a comprehensive intermediate or advanced Excel class that covers a wide range of topics? Our Excel Power User course provides the "best of" topics from 5 of our Excel classes. If you have a good foundation in Excel and want to be a Power User, this class is for you! This class will bring you up to speed on the latest features of Excel across all topics such as charting, database features, pivot tables, multiple worksheets, advanced functions and even an introduction to Macros.
COURSE OUTLINE

Creating Charts
Creating a Chart
Changing the Chart Location and Size
Changing the Chart Type
Modifying Charts
Working with Chart Elements
Using Chart Styles
Applying a Chart Filter
Formatting Chart Elements
Adding and Removing a Data Series
Printing Charts
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

Working with Specialty Charts
Understanding Specialty Charts
Creating a Map Chart
Creating a Treemap Chart
Creating a Sunburst Chart
Creating a Histogram
Creating a Pareto Chart
Creating a Box and Whisker Chart
Creating a Waterfall Chart
Creating a Funnel Chart
Creating a Combo Chart
View outline in Word

WEXC19

Attend hands-on, instructor-led Excel Charts, Formatting and Reporting training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Courses and select the one that's right for you.