Course Details
Course Description:
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
- Using Formatting Options
- Working with Formulas
- Working with Data
- Using Tables and Pivot Tables
- Configuring Charts and Graphics
Working with Workbooks and Files
Keyboard Shortcuts
Customize Excel
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
Format Painter
Show Text and a Value in a Cell
Working with Formulas
AutoSum Tricks
When to Use Absolute and Mixed References
How To Avoid Error Displays in Formulas
Create Worksheet-Level Names
Use Named Constants
Perform Lookups
Rounding Numbers
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
Understanding 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
Customize 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:
- 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.
