Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Excel Charts, Formatting and Reporting (365/2019/2016) Training Course

Excel Charts, Formatting and Reporting (365/2019/2016) Training Course


Course Description:The Excel 2019 Charts, Formatting and Reporting course covers the basics of building visuals in Excel: creating charts, using styles and templates, and creating advanced formatting.

Course Topics Include:

  • Creating a chart in Word or PowerPoint
  • Creating Custom Views
  • Managing Conditional Formatting Rules
  • Creating a Template
  • Modifying and Merging Cell Styles
  • Formatting Chart Elements
  • Changing the Chart Type

This class is perfect for those whose job responsibilities include creating visuals and managing formatting and have an Excel 2013 or 2016 Introduction or equivalent background.

Training Dates
(Click on the course name below to view course details and full list of class dates)

Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 1/31/20 - 1/31/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/3/20 - 2/3/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/5/20 - 2/5/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/11/20 - 2/11/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/13/20 - 2/13/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/19/20 - 2/19/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/21/20 - 2/21/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/24/20 - 2/24/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 2/27/20 - 2/27/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/3/20 - 3/3/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/6/20 - 3/6/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/9/20 - 3/9/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/11/20 - 3/11/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/17/20 - 3/17/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/19/20 - 3/19/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/25/20 - 3/25/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/27/20 - 3/27/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 3/30/20 - 3/30/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/2/20 - 4/2/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/7/20 - 4/7/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/10/20 - 4/10/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/13/20 - 4/13/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/15/20 - 4/15/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/21/20 - 4/21/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/23/20 - 4/23/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 4/29/20 - 4/29/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/1/20 - 5/1/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/4/20 - 5/4/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/7/20 - 5/7/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/12/20 - 5/12/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/15/20 - 5/15/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/18/20 - 5/18/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/20/20 - 5/20/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/26/20 - 5/26/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 5/28/20 - 5/28/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/3/20 - 6/3/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/5/20 - 6/5/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/8/20 - 6/8/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/11/20 - 6/11/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/16/20 - 6/16/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/19/20 - 6/19/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/22/20 - 6/22/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/24/20 - 6/24/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 6/30/20 - 6/30/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/2/20 - 7/2/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/8/20 - 7/8/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/10/20 - 7/10/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/13/20 - 7/13/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/16/20 - 7/16/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/21/20 - 7/21/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/24/20 - 7/24/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/27/20 - 7/27/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/29/20 - 7/29/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/4/20 - 8/4/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/6/20 - 8/6/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/12/20 - 8/12/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/14/20 - 8/14/20
Course Fee : $299


Excel Charts, Formatting and Reporting (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/17/20 - 8/17/20
Course Fee : $299


Course Syllabus

Course Outline

Working with Charts
Create a Chart
Change the Chart Location and Size
Change the Chart Type
Modify Chart Elements
Formatting Chart Elements
Adding and Removing Data Series
Applying a Chart Filter
Printing Charts

Working with Charts
Understanding Excel's Chart Types
Insert a Hierarchy Chart
Insert a Statistic Chart
Insert a Pareto Chart
Insert a Waterfall Chart
Create and Working with a Chart Template
Create a Sparkline

Working with Styles and Templates
Working with Cell Styles
Modify Styles
Merge Styles
Working with Themes
Working with Excel's Templates
Create a Template
Working with a Personal Template

Working with Formatting
Applying Conditional Formatting
Create a New Conditional Formatting Rule
Managing Conditional Formatting Rules
Create & Working with Custom Formats
Working with the Quick Analysis Tool

Printing
Create a Range Name for Printing
Selecting Print Areas
Create Custom Views
Printing Working with Custom Views
Working with Scaling Options
Printing Gridlines
Printing Row and Column Headings
Working with Headers and Footers
Working with Print Titles
Printing to a PDF

Working with Excel Data in Other Office Products
Pasting an Excel Range or Chart in a Word Document
Pasting an Excel Range or Chart in PowerPoint
Create a Chart in Word or PowerPoint
Modify the Chart

Onsite excel Training
Small Group Package (up to 6 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1800/day
  • Additional students can be added for $125/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1800/day (Flat Rate)

Medium Group Package (up to 12 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
  • Additional students can be added for $100/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2500/day (Flat Rate)

Large Group Package (up to 18 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
  • Additional students can be added for $75/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100/day (Flat Rate)




Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills BBB Profile