UpcomingExcel 2010 Level 3

admin

Price Qty*
October 31, 2017 show details + $267.75 (CAD)   Sold Out
November 27, 2017 show details + $267.75 (CAD)  

  • October 31, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • November 27, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)

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

Course Objective: In this level you will learn to use advanced formula’s 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, Visual Basic, and Excel Programming
Lesson 5.1: Creating a Basic Macro
Lesson 5.2: Visual Basic and Macros
Lesson 5.3: More Macro Tasks
Lesson 5.4: Advanced Visual Basic Tasks
adminUpcomingExcel 2010 Level 3