001 Essential-Excel-v27-upload-version.pdf
001 How to merge data from different sources
002 VLOOKUP Introduction
003 VLOOKUP with approximate match Introduction
004 What you can use the VLOOKUP for
005 Basic VLOOKUP usage
005 Basic-vlookup-Empty.xlsx
005 Basic-vlookup-Solution.xlsx
006 Some comments on basic VLOOKUP
006 Some-comments-on-vlookup-Empty.xlsx
006 Some-comments-on-vlookup-Solution.xlsx
007 How to assign categories using VLOOKUP
007 How-to-assign-categories-using-VLOOKUP-Empty.xlsx
007 How-to-assign-categories-using-VLOOKUP-Solution.xlsx
008 How to use HLOOKUP
008 How-to-use-HLOOKUP-Empty.xlsx
008 How-to-use-HLOOKUP-Solution.xlsx
009 The logic of MATCH function
010 Assigning categories based on 2 criteria using MATCH and VLOOKUP function
010 Startup-advisor-2-criteria-with-Match-Empty.xlsx
010 Startup-advisor-2-criteria-with-Match-Solution.xlsx
011 Assigning categories based on 2 criteria using HLOOKUP and VLOOKUP function
011 Startup-advisor-2-criteria-HLOOKUP-Empty.xlsx
011 Startup-advisor-2-criteria-HLOOKUP-Solution.xlsx
012 Assigning categories based on 2 criteria using VLOOKUP only
012 Startup-advisor-2-criteria-only-VLOOKUP-Empty.xlsx
012 Startup-advisor-2-criteria-only-VLOOKUP-Solution.xlsx
013 How to assign categories based on 3 and more criteria using VLOOKUP
013 Startup-advisor-many-criteria-Empty.xlsx
013 Startup-advisor-many-criteria-Solution.xlsx
014 How to assign categories using SUMIFS function Basic Usage
014 SUMIFS-for-many-criteria-Empty.xlsx
014 SUMIF-for-many-criteria-Solution.xlsx
015 Assigning customers to segments Case Introduction
016 Assigning customers to segments Data Available
016 Segmentation-using-Sumifs-Empty.xlsx
017 Assigning customers to segments Solution
017 Segmentation-using-Sumifs-Solution-v2.xlsx
018 The logic of INDEX function
019 INDEX & MATCH function Introduction
020 INDEX & MATCH function Exercise Case Introduction
020 Index-function-v2-Empty.xlsx
021 INDEX & MATCH function Exercise Case Solution
021 Index-function-v2.xlsx
