Excel BI

Excel BI skills include Advanced Excel, Power BI, VBA and Dashboards. Believing in helping others.

[Excel BI @eforexcel]

--- 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 - https://t.co/3OoW8mhi3g
#excel,

[Excel BI @eforexcel]

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

[Excel BI @eforexcel]

https://t.co/01tbFsnnfP and Number.ExcelInt in Power Query
https://t.co/t7onMaG6jS

[Excel BI @eforexcel]

--- CAN YOU SOLVE THIS - EXCEL CHALLENGE 6 ---
Download Practice File - https://t.co/yIF3kAtwCE

[Excel BI @eforexcel]

--- Power Query Challenge 2 ---
Practice File - https://t.co/xrXeaVXZNc
#powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks

[Excel BI @eforexcel]

--- 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 - https://t.co/1FIprpCkg8

[Excel BI @eforexcel]

--- 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 - https://t.co/iYNePrVO37

[Excel BI @eforexcel]

Shortcut to reset sheet's zoom to 100%

[Excel BI @eforexcel]

--- 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 https://t.co/dNDImjWeuF

[Excel BI @eforexcel]

--- 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 https://t.co/eUN4VnQAx4
#excelchallenge

[Excel BI @eforexcel]

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 @ https://t.co/XYGcbez0Ae

[Excel BI @eforexcel]

--- 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 @ https://t.co/b9d5acSuBR
Post answers in comments.

[Excel BI @eforexcel]

-- 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 @ https://t.co/5GkzW4vhrs

[Excel BI @eforexcel]

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&" "," ")

[Excel BI @eforexcel]

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.

[Excel BI @eforexcel]

Downloads 26 – Excel Formulas Bible V2 https://t.co/J436eBE2VZ

[Excel BI @eforexcel]

Quiz 55 https://t.co/oGVWk4gczr

[Excel BI @eforexcel]

DOWNLOADS 25 – CTRL+0 to 9 – EXCEL SHORTCUT KEYS TO STAY AHEAD https://t.co/VldHH79mLc

[Excel BI @eforexcel]

DOWNLOADS 24 – CTRL+F1 to F12 – EXCEL SHORTCUT KEYS TO STAY AHEAD https://t.co/3rrMqADooY

[Excel BI @eforexcel]

Important – Copyright Free Information https://t.co/JTeSpSrzzj