Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Excel Power Skills Overview



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

    • INDEX

    • MATCH

    • OFFSET

    • INDIRECT

    • Practice Session: Applying the functions



  • 2. Linear Programming with Excel — optimizing everyday business solutions

    • Problem Types

    • Setting up the Solution

    • Practice Session: 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

    • Practice Session: 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

    • Practice Session: Cleaning up database entries



  • 5. Multiple Regression with Excel — determining relationships between variables

    • Regressions

    • Multiple Regressions

    • Interpreting Results

    • STEYX, LINEST

    • Qualitative Variables

    • Practice Session: 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

    • Practice Session: Evaluating Sales Data



  • 7. Utilizing Correlations — using the Data Analysis Tool

    • The meaning of correlations

    • Calculating and interpreting correlations

    • Practice Session: 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

    • Practice Session: Building one and two dimensional arrays



  • 9. Using Functions for Random Variables — statistics with Excel

    • Random Variables

    • Probability Distributions

    • Common Business Examples

    • Practice Session: Statistical Analysis using Excel



  • 10. Monte Carlo Analysis

    • The basis for Monte Carlo

    • RAND

    • Building a simple model

    • Building an advanced Monte Carlo model

    • Practice Session: Calculating Risk for uncertain events




 

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.