Excel Level 2
November 27 & 28, 2023 - 1:00 pm to 4:30 pm
- $275 or $233.75$275 or $233.75
- Online via Microsoft Teams
Cost: $275 + HST Federal Government Standing Offer Cost: $233.75 + HST Excel LEVEL 2 Objectives: In this course, you will create advanced formulas. analyze data with functions and PivotTables, work with tables, visualize data with charts, use graphical objects and enhance workbooks. Unit 1 Getting Started: You will learn how to: • Use range names in formulas and functions • Use specialized functions. Unit 2 Analyzing Data with Logical and Lookup Functions: Priority Management will show you how to: • Analyze data by using text, logical, lookup, date, and financial functions. Unit 3 Organizing Worksheet Data with Tables: You will learn how to: • Create, format, and modify tables • Use structured references, as well as the subtotal and database functions. Unit 4 Visualizing Data with Charts: You will learn how to: • Create charts • Modify and format existing charts • Create a trendline and advanced charts. Unit 5 Analyzing Data with PivotTables, Slicers, and PivotCharts: You will learn how to: • Create a PivotTable • Filter data using slicers • Analyze data using PivotCharts Unit 6 Working with Graphical Objects: You will learn how to: • Insert, modify, layer, and group graphical objects • Incorporate SmartArt into workbooks. Unit 7 Enhancing Workbooks: • Customize workbooks • Manage themes • Protect files • Prepare a workbook for multiple audiences.
Terms & Conditions for Public Workshop Registrations Cancellations and reschedules are accepted up to (7) working days before the workshop. The full fee is payable for any cancellations or reschedules received less than (7) working days prior to the scheduled workshop and 50% of the course fee will be charged to reserve your subsequent seat. Substitutions are accepted at any time. Priority Management reserves the right to cancel or reschedule any seminar. In the event of a schedule change, registrants will be notified at least (7) working days prior to the start date.
11 Rosemount Avenue, Suite 301, Ottawa Ontario, K1Y 4R8 11 Rosemount Avenue, Ottawa, ON, Canada