Ten “Must-Know” Features In Excel (On-Demand - K2E)
Overview
Microsoft Excel is perhaps the most commonly used business application today. Yet, many Excel users remain bogged down in yesterday’s spreadsheet practices. Attend this session to learn ten terrific features you should use to enhance your productivity with Excel.
Access expires 180 days from purchase date |
Course Description
Applicable for
Learning Objectives
- list at least three primary features associated with Power Query
- identify the steps necessary to utilize modern collaboration options in Excel
- cite examples of the benefits related to using dynamic arrays
- differentiate between Solver and Scenario Manager as optimization tools
- identify at least three benefits of protecting your data with Sensitivity Labels
Content
- best practices for working with large volumes of data
- how to securely and efficiently collaborate with others
- using Excel for optimization scenarios
- creating “audit trails” in Excel
- define “dynamic arrays” and list examples of their benefits
Course Content Created: 2023
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by K2E. For over three decades, the team of professionals at K2E has created and presented the finest in technology-focused education. Today, their focus remains unchanged – delivering outstanding value to customers with every interaction.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 3
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Ten “Must-Know” Features In Excel (On-Demand - K2E)
- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 3
- Credits
Overview
Microsoft Excel is perhaps the most commonly used business application today. Yet, many Excel users remain bogged down in yesterday’s spreadsheet practices. Attend this session to learn ten terrific features you should use to enhance your productivity with Excel.
Access expires 180 days from purchase date |
Course Description
Applicable for
Learning Objectives
- list at least three primary features associated with Power Query
- identify the steps necessary to utilize modern collaboration options in Excel
- cite examples of the benefits related to using dynamic arrays
- differentiate between Solver and Scenario Manager as optimization tools
- identify at least three benefits of protecting your data with Sensitivity Labels
Content
- best practices for working with large volumes of data
- how to securely and efficiently collaborate with others
- using Excel for optimization scenarios
- creating “audit trails” in Excel
- define “dynamic arrays” and list examples of their benefits
Course Content Created: 2023
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.About This Product
On-Demand Courses by K2E. For over three decades, the team of professionals at K2E has created and presented the finest in technology-focused education. Today, their focus remains unchanged – delivering outstanding value to customers with every interaction.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
Upon completion of purchase, go to mylms.bccpa.ca and log in using your CPABC Online Services credentials. Click “Go to your Courses and Materials” to go to your Learning Center, then find and click on your course title.
Course Dates & Registration
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.