Course Details
Course Description:
The Excel 365 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.
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
Please check the course description to find prerequisite information.
We offer live-instructor group training classes for your team.
Upskill your team from the comfort of your office or online.
Benefits of Group Training Include:
- Experienced Professional Instructor Trains Your Team
- Content Focused On Your Team's Needs
- Convenient Scheduling and Class Setup
- Significant Per/Student Cost Savings
- Online, On-Site and Blended Options Available
Virtual Live Instructor
Financing Available
Free Repeat
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
We offer private Excel group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how Excel Private Group Training from Business Computer Skills can help your team.
