Microsoft Excel Power Skills

2 Day Course

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

Learn advanced power functions and modelling skills! In this course, you will gain an understanding of how to create sophisticated spreadsheets capable of not only displaying data but of producing refined analysis of the data. It is designed with real-world problem-solving needs in mind.

COURSE CONTENT

THE "POWER" FUNCTIONS – THE BASICS FOR BUILDING POWER SPREADSHEETS

• INDEX

• MATCH

• OFFSET

• INDIRECT

LINEAR PROGRAMMING WITH EXCEL - OPTIMIZING EVERYDAY BUSINESS SOLUTIONS

• Problem Types

• Setting up the Solution

HELPFUL TIPS, TRICKS, AND COMMANDS FOR EVERYDAY USE

• IFERROR

• Displaying cells with FORMAT

• VLOOKUP/ HLOOKUP

• Resolving Circular References

• Trace Dependencies

• Goal Seek

USING TEXT FUNCTIONS - FORMATTING TEXT TO GET IT JUST THE WAY YOU WANT IT

• LEN

• LEFT

• RIGHT

• MID

• TRIM

• And many others

MULTIPLE REGRESSION WITH EXCEL - DETERMINING RELATIONSHIPS BETWEEN VARIABLES

• Regressions

• Multiple Regressions

• Interpreting Results

• STEYX, LINEST

• Qualitative Variables

USING PIVOT TABLES - PIVOT TABLES FOR DISPLAYING AND ANALYZING DATA

• Creating the Pivot Table

• Creating the Pivot Chart

• Viewing data from multiple perspectives

UTILIZING CORRELATIONS - USING THE DATA ANALYSIS TOOL

• The meaning of correlations

• Calculating and interpreting correlations

ARRAY FUNCTIONS

• One dimensional arrays

• Two dimensional arrays

• Working with arrays

• Counting characters

• Summing random subsets of variables

USING FUNCTIONS FOR RANDOM VARIABLES - STATISTICS WITH EXCEL

• Random Variables

• Probability Distributions

• Common Business Examples

MONTE CARLO ANALYSIS

• The basis for Monte Carlo

• RAND

• Building a simple model

• Building an advanced Monte Carlo model

Register
Prix
Qté
Total
  • 4 or more Course Participants
    $598
    +$77.74 HST
    $598
    +$77.74 HST
    0
    $0
  • 2 - 3 Course Participants
    $798
    +$103.74 HST
    $798
    +$103.74 HST
    0
    $0
  • Course Calendar Date Pricing
    $598
    +$77.74 HST
    $598
    +$77.74 HST
    0
    $0
  • 1 on 1 Training
    $998
    +$129.74 HST
    $998
    +$129.74 HST
    0
    $0
Total$0

Share This Event