PostsCommentsPayoutsjerryhive (44)in #excel • 5 years agoRE: How to carry out a VLOOKUP within Text in ExcelLearn and Earn Activity 6: What text function is needed in this case? Mid function What is the full formula that you used? =VLOOKUP(MID(A2,4,2)+0,$E$2:$F$7,2,0)jerryhive (44)in #excel • 5 years agoRE: Learn Excel Pivot Tables in less than 20 MinutesLearn and Earn Activity 5: How often do you use pivot tables? Every time I have table in workbook and what feature of a pivot table is your favourite and why? Show Report…jerryhive (44)in #excel • 5 years agoRE: The CHOOSE function in ExcelEarn and Learn Activity 4: Tell me what formula did you use to return the selling price? B13=CHOOSE(B11,B2,B3,B4) What is the formula used to return the Units sold…jerryhive (44)in #excel • 5 years agoRE: Excel Power Tools - The Future of ExcelEarn and Learn : Did you share this post? Comment below and let us know Yes, Which Excel Power Tool do you use the most? Power Query Where would you put your Power Tools skills? Averagejerryhive (44)in #excel • 5 years agoRE: Funnel Charts In ExcelLearn and Earn Activity: In your organization where could you apply funnel charts instead of a table of data? Can be used to show the different levels of a sales process and…jerryhive (44)in #excel • 5 years agoRE: Excel 101 – Getting Started with Excel 365Learn Activity 7 :jerryhive (44)in #excel • 5 years agoRE: Excel 101 – Getting Started with Excel 365Learn Activity 1: Give a workbook a descriptive name Why? – It will be easy to find when opening it Learn Activity 2 : Page Layout Home Learn Activity 3 : F1 Why? It…jerryhive (44)in #excel • 5 years agoRE: Learn and Earn Activitiesare you excited about the opportunity to earn while you learn Excel? Yes, I am very grateful for this opportunity and excited as I've been looking forward to learn Excel…