Important – Copyright Free Information eforexcel.com/wp/important-c…

DOWNLOADS 24 – CTRL+F1 to F12 – EXCEL SHORTCUT KEYS TO STAY AHEAD eforexcel.com/wp/downloads-c…

DOWNLOADS 25 – CTRL+0 to 9 – EXCEL SHORTCUT KEYS TO STAY AHEAD eforexcel.com/wp/downloads-2…

Quiz 55 eforexcel.com/wp/quiz-55/

Downloads 26 – Excel Formulas Bible V2 eforexcel.com/wp/excel-formu…

SUM of Digits when cell Contains all Numbers If you have Dynamic Arrays =SUM(--MID(A1,SEQUENCE(LEN(A1)),1)) If you don't have Dynamic Arrays =SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)) If A1 is blank, then to handle error, enclose above formulas into an IFERROR block.

Extract First Name through Formula =LEFT(A1,FIND(" ",A1&" ")-1) If you are an Excel 365 Insider and are on beta channel, then you can use the power of TEXTBEFORE =TEXTBEFORE(A1&" "," ")

-- Extract Last Name through Formula --- =TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1))) If you are an Excel 365 Insider and are on beta channel, then you can use the power of TEXTAFTER =TEXTAFTER(" "&A1," ",-1) Practice File @ 1drv.ms/x/s!Akd5y6ruJh…

--- Excel Challenge --- Count the number of cells having only 2 words in range A2:A20. The answer should be 8 Name Paul Hughes Zachary Alan Murphy Ralph Gutierrez M. Challenge File @ lnkd.in/gcSHvCSG Post answers in comments.

Extract Middle Name through Excel Formula (only for 3 word names) =IFERROR(MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-(FIND(" ",A1)+1)),"") If you are on Beta Channel of Excel Insider =IFERROR(FILTER(TEXTSPLIT(A1," "),{0,1,0}),"") Practice File @ lnkd.in/dTx9QtpU

--- CAN YOU SOLVE THIS - EXCEL CHALLENGE --- Provide a formula to sum last 3 non-zeros values in range A2:A10. Last 3 non-zeros values are 20, 8 and 16, hence answer should be 44. (Post answers in Comment) Download Practice file from lnkd.in/dcvT9VrA #excelchallenge

--- CAN YOU SOLVE THIS - EXCEL CHALLENGE 3 --- Provide a formula to reverse a given number. Hence, if number is 7834, then answer would be 4387. (Post answers in Comment) Download Practice file from 1drv.ms/x/s!Akd5y6ruJh…

Shortcut to reset sheet's zoom to 100%

--- CAN YOU SOLVE THIS - EXCEL CHALLENGE 4 --- Provide a formula to Extract the Words which are all capitals (upper case). Hence if a word is "HAROLD Benison THOMAS" then answer would be "HAROLD THOMAS" (Post answers in Comment) Download Practice File - lnkd.in/d_nkmXHP

--- CAN YOU SOLVE THIS - EXCEL CHALLENGE 5 --- Provide a formula to know the name of the persons who have the highest Points on the basis of Round1+Round2+Round3. (Post answers in Comment) Download Practice File - 1drv.ms/x/s!Akd5y6ruJh…

--- Power Query Challenge 2 --- Practice File - 1drv.ms/x/s!Akd5y6ruJh… #powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks

--- CAN YOU SOLVE THIS - EXCEL CHALLENGE 6 --- Download Practice File - 1drv.ms/x/s!Akd5y6ruJh…

Number.Int and Number.ExcelInt in Power Query linkedin.com/pulse/numberin…

In Excel, CTRL+F3 is the shortcut for #excel, #excelquiz, #excelquestion, #exceltest, #excelproblem

--- CAN YOU SOLVE THIS - EXCEL CHALLENGE 9 --- Provide the Excel formula to get Revenue in cell E3 for a company given in cell E2. This would be case-sensitive LOOKUP, hence for MSFT, the answer would be 64280 not 46222. Download Practice File - lnkd.in/d27ksigq #excel,