K2's Excel - My Favourite Things

$49.00

(1 CPD Hour Course)

We all have our favourite features and functions of Excel. For many, the features and functions used have remained unchanged despite the significant improvements in Excel. In this session, I will review my favourite new and old features in Excel and how I use them daily to elevate my productivity.

A few of my favourite things covered in this session include Excel Tables, Excel Power Query, co-authoring and Show Changes. These features bring improved efficiencies to my Excel workbooks and how I work with the K2 team.

Learning Objectives

Upon completing this course, you should be able to:

Create Excel Tables and reference the table in formulas
Filter Excel Tables with slicers
Use Power Query to clean data and create an Excel table
Co-author and Show Changes
Customize the quick access toolbar

Course Information

CPE credit: Recommended for 1 hour Computer Software and Applications
Prerequisites: Fundamental knowledge of Excel 2016 or newer
Program level: Intermediate
Preparation: None
Who should attend: Existing Excel users looking to elevate their productivity

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt the final exam up to 10 times.