Excel – Intermediate (018742)

Overview

Delivery method

Virtual classroom

Duration

7.5 hours

Audience

Employees

Description

Microsoft Excel is the standard spreadsheet application used extensively worldwide to managing your data. This workshop allows users to build and calculate formulas quickly, efficiently and accurately, as well as to find, extract, and analyze valuable data. This course will create formulas, utilize the maintain database records, utilized formulas and visualized the data in charts.

This course is for individuals who are familiar with the basics of Excel and who wish to learn additional functions and tools to organize and analyze their data more in depth.

Learning objectives:

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

• Enter, edit, and format data to create workbooks;
• Sort and filter data;  
• Work with ranges; 
• Organize worksheet data with tables and;   
• Visualize data with charts; 
• Display relationships between formulas and cells using formula auditing tools. 

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

Registration deadline : 3 working days prior to course date.

Cost: Free (subject to Training Cancellation Policy)

Accommodation measures:

The Department of Justice is committed to providing an inclusive and barrier-free learning environment. If you have any accessibility needs in order to fully participate in the training activity, please contact your manager to discuss your needs. You may also call upon the services of the Centre for Workplace Access-Ability, Health and Wellness to help identify what type of accommodation measures you require.

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. 

Si vous avez des questions, veuillez communiquer avec l'équipe d'accréditation par courriel (Accreditations@justice.gc.ca).