Business Analyst Training Icon
Microsoft Server Training Icon

Excel Power Skills

2 Days Classroom Session   |  
3 Days Live Online
Classroom Registration
Group Rate:
(per registrant, 2 or more)
GSA Individual:
Live Online Registration
Live Online:
Private Onsite Package

This course can be tailored to your needs for private, onsite delivery at your location.

Request a Private Onsite Price Quote

Professional Credits


ASPE is an IIBA Endorsed Education Provider of business analysis training. Select Project Delivery courses offer IIBA continuing development units (CDU) in accordance with IIBA standards.


Select courses offer Leadership (PDU-L), Strategic (PDU-S) and Technical PMI professional development units that vary according to certification. Technical PDUs are available in the following types: ACP, PBA, PfMP, PMP/PgMP, RMP, and SP.


Just about everyone knows how to construct a simple spreadsheet. Most business users can add IF statements and SUM function to do heavy-duty number crunching. But if you really want to set your Excel skills apart from the rest of the pack, you have to move on to the advanced functions. Knowing how to create sophisticated spreadsheets capable of not only displaying data but of producing refined analysis of the data.

The Excel training class was designed with your real-world problem solving needs in mind. In each of its subject modules it first provides you with a quick overview of the concept followed by a step-by-step introduction as to how Excel implements the concept. Once these essentials have been mastered, you will move on to more sophisticated models that provide real-value to solving real-world situations. You will leave the course proficient in power functions and techniques that others do not even know exist. You will be set to immediately begin implementing what you have learned to the benefit of your job and your career.

*Please note, if you are taking this class as part of the St. Louis University Certificate requirements, there is a $500 fee to claim your certificate once you have completed ALL requirements.

Learn how to find optimal solutions to any number of business problems using Solver
Master the use of Monte Carlo analysis for a wide range of estimating situations
Develop predictive models that can incorporate both quantitative and qualitative factors
Quickly standardize databases of information by applying text functions
Discover information buried in your data that you did not know existed
Be able to display data in a manner that enhances understanding
Develop sophisticated risk models for your project, product, or operation
Find relationships between data using correlations and statistical analysis
Master the functions that will serve as the building blocks of your future databases
Learn how to combine any number of functions and tools for one-of-a-kind Excel analysis
Upcoming Dates and Locations
All Live Online times are listed in Eastern Time Guaranteed To Run

There aren’t any public sessions currently scheduled for this course, but if you fill out the form below, we can tell you about how we can bring this course to you!

Course Outline

Part 1: The "Power" Functions – the basics for building power spreadsheets

  1. INDEX
  2. MATCH

Lab: Applying the functions

Part 2: Linear Programming with Excel - optimizing everyday business solutions

  1. Problem Types
  2. Setting up the Solution

Lab: Maximum/Minimum Solutions with Solver

Part 3: Odds and Ends - a helpful collection of various tips, tricks, and commands for everyday use

  2. Displaying cells with FORMAT
  4. Resolving Circular References
  5. Trace Dependencies
  6. Goal Seek

Lab: Practice Worksheet

Part 4: Using Text Functions - formatting text to get it just the way you want it

  1. LEN
  2. LEFT
  3. RIGHT
  4. MID
  5. TRIM
  6. And many others

Lab: Cleaning up database entries

Part 5: Multiple Regression with Excel - determining relationships between variables

  1. Regressions
  2. Multiple Regressions
  3. Interpreting Results
  5. Qualitative Variables

Lab: Trend analysis of business data

Part 6: Using Pivot Tables - Pivot tables for displaying and analyzing data

  1. Creating the Pivot Table
  2. Creating the Pivot Chart
  3. Viewing data from multiple perspectives

Lab: Evaluating Sales Data

Part 7: Utilizing Correlations - using the Data Analysis Tool

  1. The meaning of correlations
  2. Calculating and interpreting correlations

Lab: Calculate correlations for a predictive model

Part 8: Array Functions

  1. One dimensional arrays
  2. Two dimensional arrays
  3. Working with arrays
  4. Counting characters
  5. Summing random subsets of variables

Lab: Building one and two dimensional arrays

Part 9: Using Functions for Random Variables - statistics with Excel

  1. Random Variables
  2. Probability Distributions
  3. Common Business Examples

Lab: Statistical Analysis using Excel

Part 10: Monte Carlo Analysis

  1. The basis for Monte Carlo
  2. RAND
  3. Building a simple model
  4. Building an advanced Monte Carlo model

Lab: Calculating Risk for uncertain events

Who should attend

Anyone who wants to take their Excel skills to the next level can benefit from this class, but it will be especially useful for: 

  • Product owners
  • Project managers
  • Product analysts
  • Functional managers
  • Small business owners
  • Non-profit managers
  • Professionals seeking deeper insights into their data

Prospective students should know how to create, save, and load spreadsheets; how to copy and paste, format data and use Format Painter; and how to navigate using the Excel ribbon.