This course can be tailored to your needs for private, onsite delivery at your location.
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 continuing professional education credits (CPE) assist Certified Public Accountants in reaching their continuing education requirements.
This course offers 16.00 NASBA CPEs.
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.
- Upcoming Dates and Locations
All Live Online times are listed in Eastern Time Guaranteed To Run
- Course Outline
Part 1: The "Power" Functions – the basics for building power spreadsheets
Lab: Applying the functions
Part 2: Linear Programming with Excel - optimizing everyday business solutions
- Problem Types
- 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
- Displaying cells with FORMAT
- VLOOKUP/ HLOOKUP
- Resolving Circular References
- Trace Dependencies
- Goal Seek
Lab: Practice Worksheet
Part 4: Using Text Functions - formatting text to get it just the way you want it
- And many others
Lab: Cleaning up database entries
Part 5: Multiple Regression with Excel - determining relationships between variables
- Multiple Regressions
- Interpreting Results
- STEYX, LINEST
- Qualitative Variables
Lab: Trend analysis of business data
Part 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
Part 7: Utilizing Correlations - using the Data Analysis Tool
- The meaning of correlations
- Calculating and interpreting correlations
Lab: Calculate correlations for a predictive model
Part 8: Array Functions
- One dimensional arrays
- Two dimensional arrays
- Working with arrays
- Counting characters
- Summing random subsets of variables
Lab: Building one and two dimensional arrays
Part 9: Using Functions for Random Variables - statistics with Excel
- Random Variables
- Probability Distributions
- Common Business Examples
Lab: Statistical Analysis using Excel
Part 10: Monte Carlo Analysis
- The basis for Monte Carlo
- 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
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.