Excel Level 2

Description du service

Cost: $360 + HST Federal Government Standing Offer Cost: $306+ 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.