Excel Level 2

Service Description

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: • Use range names in formulas and functions • Use specialized functions. Unit 2 Analyzing Data with Logical and Lookup Functions: • Analyze data by using text, logical, lookup, date, and financial functions. Unit 3 Organizing Worksheet Data with Tables: • Create, format, and modify tables • Use structured references, as well as the subtotal and database functions. Unit 4 Visualizing Data with Charts: • Create charts • Modify and format existing charts • Create a trendline and advanced charts. Unit 5 Analyzing Data with PivotTables, Slicers, and PivotCharts: • Create a PivotTable • Filter data using slicers • Analyze data using PivotCharts Unit 6 Working with Graphical Objects: • 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. Format: · One-day or two half-days, instructor-led online training session(s) Tools Provided: · Comprehensive Learning Guide · Subscription to our monthlyLearningLink e-newsletter