Mastering Advanced Excel Functions (On-Demand - K2E)
Overview
With approximately 500 functions now available in Excel, it is easy to overlook some of the newer and more powerful tools available. But, if you do that, your productivity will suffer. In this session, you will learn how you can take advantage of many of Excel’s more advanced features – some of which are new, and some of which are legacy – to elevate your productivity to higher levels.
Access expires 180 days from purchase date |
Course Description
Applicable for
Content
- list examples of best practices for constructing formulas in Excel spreadsheets
- identify situations in which each of the following functions might be useful: SUMIFS, SWITCH, and STOCKHISTORY
- distinguish between the XLOOKUP function and legacy Excel functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH
- cite examples of when using Dynamic Arrays would be useful
- differentiate between Excel’s AGGREGATE and SUBTOTAL functions
- identify conditions in which the FORECAST.ETS function is preferable to the FORECAST function
Course Content Created: April 2024
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
- 4
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 5
- 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.
Mastering Advanced Excel Functions (On-Demand - K2E)
- 4
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
- 5
- Credits
Overview
With approximately 500 functions now available in Excel, it is easy to overlook some of the newer and more powerful tools available. But, if you do that, your productivity will suffer. In this session, you will learn how you can take advantage of many of Excel’s more advanced features – some of which are new, and some of which are legacy – to elevate your productivity to higher levels.
Access expires 180 days from purchase date |
Course Description
Applicable for
Content
- list examples of best practices for constructing formulas in Excel spreadsheets
- identify situations in which each of the following functions might be useful: SUMIFS, SWITCH, and STOCKHISTORY
- distinguish between the XLOOKUP function and legacy Excel functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH
- cite examples of when using Dynamic Arrays would be useful
- differentiate between Excel’s AGGREGATE and SUBTOTAL functions
- identify conditions in which the FORECAST.ETS function is preferable to the FORECAST function
Course Content Created: April 2024
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.