Excel – Advanced (018741)

Product code: 018741

Upcoming sessions

To register, you will be prompted to sign in.


December 11, 2024

Virtual

8:30 am to 4:30 am (ET)


View more details

Overview

Delivery method

Delivery method

Virtual classroom

Duration

Duration

6 hours

Audience

Audience

Employees

 

Description

Microsoft Excel has many new features and tools that can be used to quickly analyze large amounts of financial information. This advanced workshop will combine, analyze and display data using Excel's powerful features, and learn the basics of how to use macros to further extend Excel's capabilities.

This course is for users who are familiar with Microsoft Excel and who wish to expand their knowledge and use of advanced data analysis and time-saving features.

Learning objectives:

Upon completing this learning activity, participants will be able to:

  • Perform a What-If analysis by creating scenarios and using data analysis;
  • Use Data Validation to restrict data entry and create drop-downs;
  • Use tools to group and subtotal your data;
  • Audit your formulas to help track down any errors;
  • Analyze data;
  • Record and delete macros;
  • Link and consolidate data across multiple workbooks and;
  • Import and export data and run web queries. 

Presented by: Priority Management in collaboration with the Centre of Expertise for Learning and Professional Developement (CoELPD).

Registration deadline : 5 working days prior to course date.

Cost: Free (subject to Training Cancellation Policy)

 

Participants are responsible for adding their training activities to their Outlook calendars.


Accreditation by Law Societies:

Please note that this activity is not eligible for accreditation of continuing professional development (CPD) with the law societies. 

If you have questions, please contact the accreditation team by email (Accreditations@justice.gc.ca).

Additional upcoming sessions

Date and Time Session code Location Language Available seats
December 11, 2024, 8:30 am to 4:30 am (ET) 018741-FR-2024-12-11 Virtual French 9
January 22, 2025, 8:30 am to 4:30 pm (ET) 018741-EN-2025-01-22 Virtual English Full
Date modified: 2023-04-04