Fully Customizable Courseware For Trainers
Excel 2013: Advanced Essentials
DOWNLOAD A FREE SAMPLE
This advanced Microsoft Excel 2013 Advanced Essentials training course includes information on:
- Advanced formulas and functions
- Named ranges
- Resolving formula errors
- Consolidating data, removing duplicates, configuring data validation, and transposing data
- Using outlining, grouping, and subtotal tools
- Working with scenarios
- Using data analysis tools (such as Solver and Goal Seek)
- Creating and using PivotTables and PivotCharts
- Using PowerPivot to integrate data from several different sources
- Recording, editing, and using macros
Everything that you need to put on an interactive, engaging course is included. Instructor guide? Check! Exercise workbook? Check! PowerPoint slides?
Check! Lesson plan? Check! All of the materials are customizable, too, so that you can create a unique experience for each course you teach.
Module 1: Advanced Formula Tasks
Understanding Relative and Absolute Cell References
Using Multiple Cell References
Using 3D References
Using Array Formulas
Review Questions
Module 2: Working with Named Ranges
Understanding Named Ranges
Defining Named Ranges
Editing Named Ranges
Deleting Named Ranges
Using Named Ranges in Formulas
Review Questions
Module 3: Using Advanced Functions
Using the PMT Function
Using the FV Function
Using VLOOKUP and HLOOKUP Functions
Using IF, AND, OR Functions
Review Questions
Module 4: Resolving Formula Errors
Tracing Formula Precedents and Dependents
Showing Formulas
Evaluating Formulas
Setting Error Checking Options
Using Error Option Buttons
Running an Error Check
Review Questions
Module 5: Managing Data
Consolidating Information
Removing Duplicates
Configuring Data Validation
Transposing Data
Converting Text to Columns
Review Questions
Module 6: Outlining and Grouping Data
Outlining Data
Showing and Hiding Outline Details
Grouping Data
Creating Subtotals
Removing Outlining and Grouping
Review Questions
Module 7: Working with Scenarios
Creating Scenarios
Loading Scenarios
Merging Scenarios
Editing Scenarios
Creating a Scenario Summary Report
Deleting Scenarios
Review Questions
Module 8: Using Solver
Setting up the Worksheet
Running Solver
Generating Reports and Scenarios with Solver
Modifying Constraints
Setting Solver Options
Review Questions
Module 9: Analyzing Data
Enabling the Analysis ToolPak
Using Data Analysis Tools
Using Goal Seek
Using Data Tables
Review Questions
Module 10: Advanced PivotTable Features
Creating a Basic PivotTable
Creating a Basic PivotChart
Using the PivotTable Fields Pane
Adding Calculated Fields
Sorting Pivoted Data
Filtering Pivoted Data
Review Questions
Module 11: Using PowerPivot
Enabling PowerPivot
Importing Access Data
Importing Excel Data
Integrating Data with Relationships
Creating a PivotTable with PowerPivot Data
Review Questions
Module 12: Using Macros
Recording a Macro
Writing a Macro using the Visual Basic Editor
Editing a Macro
Running a Macro
Review Questions
This advanced Microsoft Excel 2013 Advanced Essentials training course includes information on:
- Advanced formulas and functions
- Named ranges
- Resolving formula errors
- Consolidating data, removing duplicates, configuring data validation, and transposing data
- Using outlining, grouping, and subtotal tools
- Working with scenarios
- Using data analysis tools (such as Solver and Goal Seek)
- Creating and using PivotTables and PivotCharts
- Using PowerPivot to integrate data from several different sources
- Recording, editing, and using macros
Everything that you need to put on an interactive, engaging course is included. Instructor guide? Check! Exercise workbook? Check! PowerPoint slides?
Check! Lesson plan? Check! All of the materials are customizable, too, so that you can create a unique experience for each course you teach.
Module 1: Advanced Formula Tasks
Understanding Relative and Absolute Cell References
Using Multiple Cell References
Using 3D References
Using Array Formulas
Review Questions
Module 2: Working with Named Ranges
Understanding Named Ranges
Defining Named Ranges
Editing Named Ranges
Deleting Named Ranges
Using Named Ranges in Formulas
Review Questions
Module 3: Using Advanced Functions
Using the PMT Function
Using the FV Function
Using VLOOKUP and HLOOKUP Functions
Using IF, AND, OR Functions
Review Questions
Module 4: Resolving Formula Errors
Tracing Formula Precedents and Dependents
Showing Formulas
Evaluating Formulas
Setting Error Checking Options
Using Error Option Buttons
Running an Error Check
Review Questions
Module 5: Managing Data
Consolidating Information
Removing Duplicates
Configuring Data Validation
Transposing Data
Converting Text to Columns
Review Questions
Module 6: Outlining and Grouping Data
Outlining Data
Showing and Hiding Outline Details
Grouping Data
Creating Subtotals
Removing Outlining and Grouping
Review Questions
Module 7: Working with Scenarios
Creating Scenarios
Loading Scenarios
Merging Scenarios
Editing Scenarios
Creating a Scenario Summary Report
Deleting Scenarios
Review Questions
Module 8: Using Solver
Setting up the Worksheet
Running Solver
Generating Reports and Scenarios with Solver
Modifying Constraints
Setting Solver Options
Review Questions
Module 9: Analyzing Data
Enabling the Analysis ToolPak
Using Data Analysis Tools
Using Goal Seek
Using Data Tables
Review Questions
Module 10: Advanced PivotTable Features
Creating a Basic PivotTable
Creating a Basic PivotChart
Using the PivotTable Fields Pane
Adding Calculated Fields
Sorting Pivoted Data
Filtering Pivoted Data
Review Questions
Module 11: Using PowerPivot
Enabling PowerPivot
Importing Access Data
Importing Excel Data
Integrating Data with Relationships
Creating a PivotTable with PowerPivot Data
Review Questions
Module 12: Using Macros
Recording a Macro
Writing a Macro using the Visual Basic Editor
Editing a Macro
Running a Macro
Review Questions
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
Instructor Guide
Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.
Student Manual
Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable manual gives each participant the student version of the course you will be teaching.
PowerPoint Deck
Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
