UpcomingExcel 2013 Level 2

admin Leave a Comment

Price Qty*
November 9, 2017 show details + $267.75 (CAD)  
December 18, 2017 show details + $267.75 (CAD)  

  • November 9, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • December 18, 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 Overview
Microsoft Excel 2013 has lots of time-saving tools. Do you know how to make the most of them? The modules in the course will show you how! This advanced course covers a wide range of topics, including advanced formula tasks, working with named ranges, using advanced functions, resolving formula errors, managing data, outlining and grouping data, working with scenarios, using Solver, the Analysis ToolPak, PivotTable features, using PowerPivot, and developing macros.

Course Content

Module 1: Advanced Formula Tasks
Understanding Relative and Absolute Cell References
Using Multiple Cell References
Using 3D References
Using Array Formula
Module 2: Working with Named Ranges
Understanding Named Ranges
Defining Named Ranges
Editing Named Ranges
Deleting Named Ranges
Using Named Ranges in Formulas
Module 3: Using Advanced Functions
Using the PMT Function
Using the FV Function
Using VLOOKUP and HLOOKUP Functions
Using IF, AND, OR Functions
Module 4: Resolving Formula Errors
Tracing Formula Precedents and Dependents
Showing Formulas
Evaluating Formulas
Setting Error Checking Options
Using Error Option Buttons
Running a Error Check
Module 5: Managing Data
Consolidating Information
Removing Duplicates
Consolidating Information
Transposing Data
Converting Text to Columns
Module 6: Outlining and Grouping Data
Outlining Data
Showing and Hiding Outline Details
Grouping Data
Creating Subtotals
Removing Outlining and Grouping
Module 7: Working with Scenarios
Creating Scenarios
Loading Scenarios
Merging Scenarios
Editing Scenarios
Creating a Scenario Summary Report
Deleting Scenarios
Module 8: Using Solver
Setting up the Worksheet
Running Solver
Generating Reports and Scenarios with Solver
Modifying Constraints
Setting Solver Options
Module 9: Analyzing Data
Enabling the Analysis ToolPak
Using Data Analysis Tools
Using Goal Seek
Using Data Tables
Module 10: Advanced PivotTable Feature
Creating a Basic PivotTable
Creating a Basic PivotChart
Using the PivotTable Fields Pane
Adding Calculated Fields
Sorting Pivoted Data
Filtering Pivoted Data
Module 11: Using PowerPivot
Enabling PowerPivot
Importing Access Data
Importing Excel Data
Integrating Data with Relationships
Creating a PivotTable with PowerPivot Data
Module 12: Using Macros
Running a Macro
Writing a Macro using the Visual Basic Editor
Editing a Macro
Recording a Macro
adminUpcomingExcel 2013 Level 2

Leave a Reply