UpcomingExcel 2010 Level 3

admin

Price Qty*
May 30, 2018 show details + $267.75 (CAD)  
June 7, 2018 show details + $267.75 (CAD)   Sold Out
June 22, 2018 show details + $267.75 (CAD)   Sold Out
July 17, 2018 show details + $267.75 (CAD)  
July 24, 2018 show details + $267.75 (CAD)  
August 14, 2018 show details + $267.75 (CAD)  
September 7, 2018 show details + $267.75 (CAD)  
October 4, 2018 show details + $267.75 (CAD)  
October 26, 2018 show details + $267.75 (CAD)  
November 2, 2018 show details + $267.75 (CAD)  
November 30, 2018 show details + $267.75 (CAD)  

  • May 30, 2018
    8:30 am - 4:00 pm
  • June 7, 2018
    8:30 am - 4:00 pm
  • June 22, 2018
    8:30 am - 4:00 pm
  • July 17, 2018
    8:30 am - 4:00 pm
  • July 24, 2018
    8:30 am - 4:00 pm
  • August 14, 2018
    8:30 am - 4:00 pm
  • September 7, 2018
    8:30 am - 4:00 pm
  • October 4, 2018
    8:30 am - 4:00 pm
  • October 26, 2018
    8:30 am - 4:00 pm
  • November 2, 2018
    8:30 am - 4:00 pm
  • November 30, 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