Virtual Live Instructor
Free Training Manual
The Excel Power User course will train experienced Excel students in a two-day crash course on core topics form the Excel 2016 class catalog. The class will cover topics from the following courses: Excel 2016 Introduction, Excel Charts and formatting, database features and pivot tables, Excel Workbooks, Formulas and Functions and Excel Macros.
Please note: this is a fast-paced class for experienced Excel users. Students that are new to Excel should consider the Excel introduction class or the Excel Tips, Tricks & Timesavers class.
Upon completion of the course, users will be able to:
Selected Topics from “Excel Introduction”
Getting Started with Excel
Working with the Ribbon
Exploring the File Tab
Working with the Quick Access Toolbar
Use Excel Help – Tell Me
Selecting a Range of Cells
Use Auto Fill to Enter Data
Use Auto Fill with Formulas
Use Page Setup Tools
Working in Page Layout View
Use Page Break Preview
Select Topics from “Excel Charts, Formatting & Reporting”
Create a Chart
Change the Chart Location and Size
Change the Chart Type
Modify Chart Elements
Formatting Chart Elements
Adding and Removing a Data Series
Applying a Chart Filter
Working with Charts
Create a Hierarchy Chart
Create a Histogram
Create a Pareto Chart
Create a Box and Whisker Chart
Create a Waterfall Chart
Create a Combo Chart
Create a Sparkline
Create and Use a Chart Template
Create a Dashboard
Use Styles, Themes, and Templates
Working with Cell Styles
Create a Template
Working with Formatting
Create and Use Custom Formats
Applying Conditional Formatting
Create a New Conditional Formatting Rule
Use the Quick Analysis Tool
Use 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
Create a Chart in Word or PowerPoint
Select Topics from “Excel Workbooks, Formulas & Functions”
Working with Workbooks
Editing a Group
Working with Multiple Worksheets and Workbooks
Create Linked Formulas
Viewing Multiple Worksheets
Use Absolute Cell References
Create Linked Formulas between Workbooks
Working with Financial and Date Functions
Use Financial Functions
Use Date Functions
Working with Logical Functions
Use the IF Function
Use Multiple Conditions with the IF Function
Nesting IF Functions
Working with Lookup and Reference Functions
Use HLOOKUP and VLOOKUP Functions
Use the MATCH Function
Use the INDEX Function
Nesting the INDEX and MATCH Functions
Use INDEX MATCH MATCH
Use INDEX MATCH & MATCH
Select Topics from “Excel Database Features and Pivot Tables”
Create and Use Absolute Named Ranges
Freeze and Unfreeze Panes
Use Functions with Lists
Use Table Features
Create a Table
Filter a Table
Create a Slicer
Working with the Total Row
Create a Calculated Column
Working with Data
Import Data from a Text File
Use Flash Fill
Connect to Data in an Access Database
Create and Working with PivotTables
Create a PivotTable Use Worksheet Data
Create a PivotTable Use an External Data Connection
Use a Report Filter
Use VLOOKUP to Add a Column to a List
Working with Summary Functions
Create a Slicer
Create a Calculated Field
Create a PivotChart
Use Automatic Outlining
Create an Advanced Filter
Use the Quick Analysis Tool
Select Topics from "Excel Macros"
Working with Macros
Record a Macro
Create a Macro Button
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.