Yawn-proof software training

Advanced Formula Tasks
Formulas are at the core of how Excel works. This module gives participants insight into using relative and absolute cell references, multiple cell references, 3D references, and array formulas.
  • Understanding Relative and Absolute Cell References
  • Using Multiple Cell References
  • Using 3D References
  • Using Array Formulas
Working with Named Ranges
This module is all about named ranges. Participants will learn what named ranges are as well as how to define, edit, and delete them. Participants are also shown how to use named ranges in formulas.
  • Understanding Named Ranges
  • Defining Named Ranges
  • Editing Named Ranges
  • Deleting Named Ranges
  • Using Named Ranges in Formulas
Using Advanced Functions
Applying the correct functions to data can save a lot of work and this module shows participants how to accomplish that. The functions covered in this module include PMT, FV, VLOOKUP, and HLOOKUP, as well as IF, AND, OR functions.
  • Using the PMT Function
  • Using the FV Function
  • Using VLOOKUP and HLOOKUP Functions
  • Using IF, AND, OR Functions

Resolving Formula Errors
Mistakes happen; it’s a fact of life! Luckily, Excel offers some tools to fix formula errors. This module covers how to trace formula precedents and dependents, show and evaluate formulas, set error checking options, use error option buttons, and run an error check.
  • Tracing Formula Precedents and Dependents
  • Showing Formulas
  • Evaluating Formulas
  • Setting Error Checking Options
  • Using Error Option Buttons
  • Running an Error Check
Managing Data
It’s of no use to have vast amounts of data if you cannot handle it efficiently. This module focuses on how to consolidate data, remove duplicate values, configure data validation, transpose data, and convert text to columns.
  • Consolidating Information
  • Removing Duplicates
  • Configuring Data Validation
  • Transposing Data
  • Converting Text to Columns
Outlining and Grouping Data
This module builds upon skills taught in the previous module with a continued look at data. Here, participants will learn how to outline data, show and hide details of outlined data, group data, create subtotals, and remove outlining and grouping.
  • Outlining Data
  • Showing and Hiding Outline Details
  • Grouping Data
  • Creating Subtotals
  • Removing Outlining and Grouping
Creating Scenarios
Scenarios are useful to simulate data results based upon certain circumstances. This module teaches how to create, load, merge, edit, and delete scenarios, and how to create a scenario summary report.
  • Creating Scenarios
  • Loading Scenarios
  • Merging Scenarios
  • Editing Scenarios
  • Creating a Scenario Summary Report
  • Deleting Scenarios
Using Solver
Solver is an Excel add-in that can do a lot of the heavy lifting when it comes to dealing with a data problem. In this module, participants are shown how to set up a worksheet for Solver, run Solver, generate reports and scenarios, modify Solver constraints, and set Solver options.
  • Setting up the Worksheet
  • Running Solver
  • Generating Reports and Scenarios with Solver
  • Modifying Constraints
  • Setting Solver Options
Analyzing Data
The Analysis ToolPak is another useful Excel add-in. This module shows participants how to enable and use the Analysis ToolPak, how to use Goal Seek, and how to use data tables.
  • Enabling the Analysis ToolPak
  • Using Data Analysis Tools
  • Using Goal Seek
  • Using Data Tables
Advanced PivotTable Features
With this module, participants get a look at using many features of PivotTables. The discussion covers how to create a basic PivotTable and PivotChart, use the PivotTable Fields pane, add calculated fields to a PivotTable, and sort and filter pivoted data.
  • Creating a Basic PivotTable
  • Creating a Basic PivotChart
  • Using the PivotTable Fields Pane
  • Adding Calculated Fields
  • Sorting Pivoted Data
  • Filtering Pivoted Data
Using PowerPivot
At the end of this module, participants will know how to enable PowerPivot, import Access and Excel data into PowerPivot, integrate data with relationships, and create a PivotTable with PowerPivot data.
  • Enabling PowerPivot
  • Importing Access Data
  • Importing Excel Data
  • Integrating Data with Relationships
  • Creating a PivotTable with PowerPivot Data
Using Macros
Macros are a wonderful timesaving device in Excel 2013. This concluding module teaches participants how to record a macro, write a macro using the Visual Basic Editor, edit a macro, and run a macro.
  • Recording a Macro
  • Writing a Macro using the Visual Basic Editor
  • Editing a Macro
  • Running a Macro

Download Full Course Details as a PDF

Share this printable PDF with others in the office.

Download Now

Corporate Training

Public Courses

There are no upcoming events.