Virtual Live Instructor
Free Training Manual
The Excel Tips, Tricks and Timesaver course teaches experienced Excel students a variety of ways to become more efficient when working with Excel. This course is suitable for users of Excel 2016 and Excel 2013.
This course is not intended for novice Excel users. Students should have completed the Excel introduction course or have equivalent experience.
Topics covered in the course include:
Working with Workbooks and Files
Understand Protected View and AutoRecover
Save to a Read-Only Format
Use Document Themes
Adjust Printer Settings
Using Formatting Options
Work with Merged Cells
Work with Styles
Custom Number Formats
Shade Alternate Rows Using Conditional Formatting
Show Text and a Value in a Cell
Working with Formulas
When to Use Absolute and Mixed References
How To Avoid Error Displays in Formulas
Create Worksheet-Level Names
Use Named Constants
Working with Data
Selecting Cells Efficiently
Auto Filling a Range with a Series
Transform Data with and Without Using Formulas
Create a Drop-Down List in a Cell
Use Conditional Formatting
Identify Excess Spaces
Transpose a Range
Use Flash Fill
Fill the Gaps in a Report
Get Data from a PDF File
Using Tables and Pivot Tables
Use Formulas with a Table
Identify Data Appropriate for a Pivot Table
Use a Pivot Table Instead of Formulas
Control References to Cells Within a Pivot Table
Group Items by Date in a Pivot Table
Create Pivot Tables with Multiple Groupings
Use Pivot Table Slicers and Timelines
Configure Charts and Graphics
Understand Recommended Charts
Create a Chart Template
Link Chart Text to Cells
Apply Chart Data Labels from a Range
Group Charts and Other Objects
Take Pictures of Ranges
Work with Images
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:
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).
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Instructor led training is a cost effective and convenient learning platform for busy professionals. Most courses are available at over 300 locations nationwide and Online.
The classes are taught via the RCI method by professionally certified instructors, and are usually limited to 12 or less students. Each student receives a training manual and practice problems, along with a free course retake. Click here to learn more about Instructor Led Training
Below is a list of upcoming Excel Instructor Led Class Dates:
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.