Lessons
Share Exit Fullscreen Back to course
Professional Excel Skills for Business Analysts and Consultants
  • Introduction
  • How to Combine Data from Different Sources
    • 2-1_How to merge data from different sources
    • 2-2_Vlookup
    • 2-3_VLOOKUP with approximate match – Introduction
    • 2-4_What can you use the VLOOKUP for
    • Data Files for Practice
    • 2-5_Basic VLOOKUP usage
    • 2-6_Best Practice with basic VLOOKUP
    • 2-7_How to assign categories using VLOOKUP
    • 2-8_Hlookup Basic and Error Handling
    • 2-9_MATCH Function Introduction
    • 2-10_Assigning categories based on 2 criteria using MATCH and VLOOKUP function
    • 2-11_Startup advisor 2 criteria HLOOKUP
    • 2-12_Startup advisor 2 criteria only VLOOKUP
    • 2-13_How to assign categories based on 3 and more criteria using VLOOKUP
    • 2-14_How to assign categories using SUMIFS function – Basic Usage in Project
    • 2-15_Assigning customers to segments – Case Introduction
    • 2-16_Assigning customers to segments – Data Available
    • 2-17_Assigning customers to segments – Solution
    • 2-18_The logic of INDEX function