UpcomingExcel 2010 Level 3


Price Qty*
September 7, 2018 show details + $267.75 (CAD)  
October 26, 2018 show details + $267.75 (CAD)  

  • September 7, 2018
    8:30 am - 4:00 pm
  • October 26, 2018
    8:30 am - 4:00 pm

Course Length: 1 day (8:30 a.m. – 4:00 p.m.)                        Instructor Led Training

Course Objective: In this Excel 2010 level 3 course, you will learn to use advanced formulas and features such as Scenarios, Goal Seek, PivotCharts, PivotTables, VLOOKUP, HLOOKUP, PMT and other logical functions. This level will also instruct on linking, consolidating and combining worksheets and workbooks.

Prerequisites: This course presumes that the user has a basic knowledge of Windows, including concepts such as using the mouse and keyboard. With respect to Excel, we also presume that the user has completed the Intermediate level of this course (or has equivalent knowledge) and is familiar with concepts such as copying, pasting, organizing worksheets, basic cell formatting, understands & can select ranges, can create and manipulate Excel data tables, use Excel functions, work with external data sources and can create Excel Charts.

Course Content

Section 1: Getting the Most From Your Data
Lesson 1.1: Outlining and Grouping Data
Lesson 1.2: Exploring Scenarios
Lesson 1.3: Using Data Analysis Tools
Lesson 1.4: Using Solver
Lesson 1.5: Excel and Hyperlinks
Section 2: Pivoting Data
Lesson 2.1: Getting Started with PivotTables
Lesson 2.2: Working with PivotTable Data
Lesson 2.3: Formatting a PivotTable
Lesson 2.4: Using the Classic PivotTable Layout
Lesson 2.5: Advanced PivotTable Tasks
Lesson 2.6: Using PowerPivot
Section 3: Charting Pivoted Data
Lesson 3.1: Getting Started with PivotCharts
Lesson 3.2: Using the PivotChart Tools Tabs
Lesson 3.3: Formatting a PivotChart
Lesson 3.4: Advanced PivotChart Tasks
Section 4: Advanced Excel Tasks
Lesson 4.1: Using Advanced Functions
Lesson 4.2: Using the VLOOKUP Function
Lesson 4.3: Using Custom AutoFill Lists
Lesson 4.4: Linking, Consolidating, and Combining Data
Section 5: Macros
Lesson 5.1: Creating a Basic Macro
adminUpcomingExcel 2010 Level 3