Discover Classes. Earn Rewards.

Excel 2016 Charts, Formatting and Reporting

at ONLC Training Centers - Schaumburg

(5)
Course Details
Price:
$295 1 seat left
Start Date:

Wed, Jul 10, 9:00am - 3:45pm

Next start dates (1)

Location:
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Purchase Options
Description
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

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.


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

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (2)
Start Date Time Teacher # Sessions Price
9:00am - 3:45pm ONLC Remote Instructor 1 $295
9:00am - 3:45pm ONLC Remote Instructor 1 $295

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

Similar Classes

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Loading...