Back to Search
AI, Technology & Innovation

Excel 365: Advanced Data Analysis (Live Webinar)

DELIVERY FORMAT
Online Virtual
SEMINAR TYPE
PD Seminar
REQUIRED
Excel 365

Overview

Excel 365 recently introduced new features which are the biggest changes to Excel's core functionality in decades.  This hands-on course is an intensive session that will teach participants to use new features in Excel 365 to complete analytical work more efficiently and accurately. Participants will also learn how this new functionality can replace or supplement older methods of analysis in Excel.

Applicable for

Anyone who uses Excel regularly.

Content

Understand the Changes to Excel

  • understand new "spilling" behaviors (Dynamic Arrays) and how they can be used in analysis
  • learn about the limitations of "spilling" and potential errors it may create (#SPILL errors, etc.)
  • see the pitfalls of using these new functions across different versions of Excel
  • learn how to use the Spilled Range Operator (#) and Intersect Operator(@) to change how Excel handles "spilled" ranges

New Data Analysis Functions

  • use newly introduced Excel functions to leverage Dynamic Arrays to interpret and manipulate data
  • employ Excel's UNIQUE, FILTER. SORT and SORTBY functions to create dynamic, customizable subsets from a database
  • create Dynamic Arrays of data using Excel's SEQUENCE and RANDARRAY functions
  • learn about new applications for legacy functions including OFFSET and TRANSPOSE

New Lookup Functions

  • use Excel's new lookup functions (XLOOKUP and XMATCH) to extract specific information from large datasets
  • learn about the pros and cons of XLOOKUP vs. legacy lookup functions

Integrating Old Tools with New Functionality

  • learn about how to integrate Dynamic Arrays with some legacy analysis tools including Tables (previously known as Lists) and Pivot Tables
  • integrate Dynamic Arrays into charts to create powerful visuals that can update automatically

Course Dates & Registration

Jul 8, 2026
9:00AM - 12:30PM
Online Virtual
Training the Street
TRAINING THE STREET has offered targeted training courses to academic, corporate, and public enrollment clients since 1999. Training the Street provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals. By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, they teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Available
Register Now
Course Code: C62151A_OL
Dec 4, 2025
9:00AM - 12:30PM
Online Virtual
Training the Street
TRAINING THE STREET has offered targeted training courses to academic, corporate, and public enrollment clients since 1999. Training the Street provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals. By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, they teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Past
Course Code: C52151A_OL
Dec 4, 2024
9:00AM - 12:30PM
Online Virtual
Training the Street
TRAINING THE STREET has offered targeted training courses to academic, corporate, and public enrollment clients since 1999. Training the Street provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals. By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, they teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Past
Course Code: C42151B_OL
Jun 11, 2024
9:00AM - 12:30PM
Online Virtual
Training the Street
TRAINING THE STREET has offered targeted training courses to academic, corporate, and public enrollment clients since 1999. Training the Street provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals. By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, they teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Past
Course Code: C42151A_OL

Improving Your Virtual Learning Experience

Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns. 

In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.

Live Webinar FAQs can be found here.  

 

Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department. 

Course Details
Cost
$210
Members
$235
Non-Members
Eligible Hours
3.5
CPD Hours
0
Ethics Hours
0
AML Hours
Passport
5
Credits
Prerequisites
Prerequisites
Participants should have a good working knowledge of Excel prior to taking this course.
Special Notes
This hands-on seminar will utilize assignments and handouts throughout the day. You will need access to Excel 365.
Interested in similar content?
Credit Card Fee

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.

AI, Technology & Innovation

Excel 365: Advanced Data Analysis (Live Webinar)

DELIVERY FORMAT
Online Virtual
SEMINAR TYPE
PD Seminar
REQUIRED
Excel 365
Course Details
Cost
$210
Members
$235
Non-Members
Eligible Hours
3.5
CPD Hours
0
Ethics Hours
0
AML Hours
Passport
5
Credits
Prerequisites
Prerequisites
Participants should have a good working knowledge of Excel prior to taking this course.

Overview

Excel 365 recently introduced new features which are the biggest changes to Excel's core functionality in decades.  This hands-on course is an intensive session that will teach participants to use new features in Excel 365 to complete analytical work more efficiently and accurately. Participants will also learn how this new functionality can replace or supplement older methods of analysis in Excel.

Applicable for

Anyone who uses Excel regularly.

Content

Understand the Changes to Excel

  • understand new "spilling" behaviors (Dynamic Arrays) and how they can be used in analysis
  • learn about the limitations of "spilling" and potential errors it may create (#SPILL errors, etc.)
  • see the pitfalls of using these new functions across different versions of Excel
  • learn how to use the Spilled Range Operator (#) and Intersect Operator(@) to change how Excel handles "spilled" ranges

New Data Analysis Functions

  • use newly introduced Excel functions to leverage Dynamic Arrays to interpret and manipulate data
  • employ Excel's UNIQUE, FILTER. SORT and SORTBY functions to create dynamic, customizable subsets from a database
  • create Dynamic Arrays of data using Excel's SEQUENCE and RANDARRAY functions
  • learn about new applications for legacy functions including OFFSET and TRANSPOSE

New Lookup Functions

  • use Excel's new lookup functions (XLOOKUP and XMATCH) to extract specific information from large datasets
  • learn about the pros and cons of XLOOKUP vs. legacy lookup functions

Integrating Old Tools with New Functionality

  • learn about how to integrate Dynamic Arrays with some legacy analysis tools including Tables (previously known as Lists) and Pivot Tables
  • integrate Dynamic Arrays into charts to create powerful visuals that can update automatically

Course Dates & Registration

Jul 8, 2026
9:00AM - 12:30PM
Online Virtual
Training the Street
TRAINING THE STREET has offered targeted training courses to academic, corporate, and public enrollment clients since 1999. Training the Street provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals. By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, they teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Available
Register Now
Course Code: C62151A_OL
Dec 4, 2025
9:00AM - 12:30PM
Online Virtual
Training the Street
TRAINING THE STREET has offered targeted training courses to academic, corporate, and public enrollment clients since 1999. Training the Street provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals. By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, they teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Past
Course Code: C52151A_OL
Dec 4, 2024
9:00AM - 12:30PM
Online Virtual
Training the Street
TRAINING THE STREET has offered targeted training courses to academic, corporate, and public enrollment clients since 1999. Training the Street provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals. By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, they teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Past
Course Code: C42151B_OL
Jun 11, 2024
9:00AM - 12:30PM
Online Virtual
Training the Street
TRAINING THE STREET has offered targeted training courses to academic, corporate, and public enrollment clients since 1999. Training the Street provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals. By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, they teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Past
Course Code: C42151A_OL

Improving Your Virtual Learning Experience

Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns. 

In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.

Live Webinar FAQs can be found here.  

 

Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department. 

Special Notes
This hands-on seminar will utilize assignments and handouts throughout the day. You will need access to Excel 365.
Interested in similar content?
Credit Card Fee

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.