Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn INDEX, MATCH, OFFSET & WHAT IF ANALYSIS in MS Excel
Rating: 4.4 out of 5(486 ratings)
9,269 students

Learn INDEX, MATCH, OFFSET & WHAT IF ANALYSIS in MS Excel

Index, Match, Offset and What IF Analysis (Goal Seek, Data Table & Scenario Manager) with Examples
Last updated 6/2020
English
English [Auto],

What you'll learn

  • Index, Match, Offset and What IF Analysis (Goal Seek, Data Table & Scenario Manager) with Examples

Course content

5 sections5 lectures1h 57m total length
  • Learn GOAL SEEK in an easy way! - Microsoft Excel10:16

    Learn what-if analysis in Excel using goal seek to reach a target by adjusting inputs like loan amount or selling price, and discover how scenario manager helps model outcomes.

Requirements

  • Basic Excel

Description

Index, Match, Offset, and What IF Analysis (Goal Seek, Data Table & Scenario Manager) with Examples. This course will enhance the knowledge of Excel users to understand the Advanced function with examples in an easy way.  Microsoft Excel is one of the most important because of the key role it plays in many sectors. It is the most used spreadsheet program in many business activities, classwork, and even personal data organization.

Who this course is for:

  • Analysts, Officers, Managers