Business Analyst Training Courses Icon
Microsoft Server Training Courses Icon

Excel Power Skills


2 Days
Classroom Session   |  
3 Days
Live Online

IIBA (CDU)

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.

NASBA (CPE)

NASBA continuing professional education credits (CPE) assist Certified Public Accountants in reaching their continuing education requirements.

PMI (PDU)

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.

NASBA
NASBA
16.00 CPEs

Expertise Level: Novice
Certification
Classroom Registration Fees
Individual:
$1495.00
Group Rate:
$1295.00
(per registrant, 2 or more)
GSA Individual:
$1091.35
Live Online Registration
Live Online:
$1495.00
Private Onsite Package

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

Request a Quote for Group Onsite Pricing

Overview

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.

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
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

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

  • INDEX
  • MATCH
  • OFFSET
  • INDIRECT

Lab: Applying the functions

2. Linear Programming with Excel - optimizing everyday business solutions

  • Problem Types
  • Setting up the Solution

Lab: Maximum/Minimum Solutions with Solver

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

  • IFERROR
  • Displaying cells with FORMAT
  • VLOOKUP/ HLOOKUP
  • Resolving Circular References
  • Trace Dependencies
  • Goal Seek

Lab: Practice Worksheet

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

  • LEN
  • LEFT
  • RIGHT
  • MID
  • TRIM
  • And many others

Lab: Cleaning up database entries

5. Multiple Regression with Excel - determining relationships between variables

  • Regressions
  • Multiple Regressions
  • Interpreting Results
  • STEYX, LINEST
  • Qualitative Variables

Lab: Trend analysis of business data

6. Using Pivot Tables - Pivot tables for displaying and analyzing data

  • Creating the Pivot Table
  • Creating the Pivot Chart
  • Viewing data from multiple perspectives

Lab: Evaluating Sales Data

7. Utilizing Correlations - using the Data Analysis Tool

  • The meaning of correlations
  • Calculating and interpreting correlations

Lab: Calculate correlations for a predictive model

8. Array Functions

  • One dimensional arryas
  • Two dimensional arrays
  • Working with arrays
  • Counting characters
  • Summing random subsets of variables

Lab: Building one and two dimensional arrays

 

9. Using Functions for Random Variables - statistics with Excel

 

  • Random Variables
  • Probability Distributions
  • Common Business Examples

Lab: Statistical Analysis using Excel

 

10. Monte Carlo Analysis

  • The basis for Monte Carlo
  • RAND
  • Building a simple model
  • 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
Pre-Requisites

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.

Yes, this course looks perfect for my needs!