Welcome to ONLC Training Centers


Excel Charts, Formatting and Reporting Course Outline

 (1 day)
Version 365/2019/2016
Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

SPECIAL AFTER-HOURS CLASS
This class is part of our special after-hours series of events that meet after the regular workday, typically on Monday through Thursday evenings. Below is some additional background information on our after-hours classes.

When does the class meet?
To see the class meeting times for your time zone, hover the mouse over the date listed on this outline page and the class times will pop up. Classes typically start at 8 pm Eastern, 7 pm Central, 6 pm Mountain, and 5 pm Pacific. Classes meet from 2 to 3 hours each night, depending on the particular class.

Where does the class meet?
All After-Hours classes must be taken from your home or office. If you want to attend a class from one of our physical training locations, you will need to take the version of this class that meets during the regular weekday. Follow this link to see our weekday class schedule and review the list of over 300 locations available when you enroll.
Excel Charts, Formatting and Reporting Weekday Class

Is this the same content as the daytime class?
The instructor will review the most important topics during the live instructor-led session. However, the duration of the evening class is slightly less than the daytime class. To compensate for the reduced hours, we include our ONLC On-Demand content. These are self-study materials that will not only fill in the gaps in your learning, but you will also give you the opportunity to review concepts for 6 months after the class. In addition, should you not be able to attend one of the evening sessions, you will have the On-Demand content to bring you back up to speed. We've got you covered!

What software and hardware is needed?
- You need just a basic computer with an internet connection. The software will be loaded on our servers and you will connect to that computer. (So no software is needed on your computer). Here's a more detailed list:
- At least 1 monitor (Dual monitors or 2 devices would be helpful, but not required.)
- Audio Connection. You can use audio from your computer with a microphone (a standalone microphone, headset, or even a camera that has a microphone.) Most laptops will have a built-in microphone and speaker.Or use your cell phone.

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.

*** NEW: 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 class provides the "best of" topics from 5 of our Excel classes. 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. If you have a good foundation in Excel and want to be a Power User, this class is for you! For details on this class, go to
Excel Power User

Course Outline

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
View outline in Word

EEXC19

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.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $295

Savings options:

 CEA Apps Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com