No need to write formulas to extract first name and last name. Here is a super fast way by using CTRL+H. The same trick can be used to extract user name and domain name from a mail ID. File used in this tutorial – https://1drv.ms/x/s!Akd5y6ruJhvhvTPIrUd2QVh1ro7x?e=SyaAMr
Power BI Quiz 4
Tips & Tricks 188 – Running Total and Percentage Total without Formulas
Are you still writing formulas to calculate Running Total and % Total? There is a super fast way to calculate Running Total and % Total. Use this to work at a blazing speed in Excel while calculating Running Total and %Total. No more formula writing. File used in this tutorial – https://1drv.ms/x/s!Akd5y6ruJhvhvTGzqZqO-VkYFWID?e=IUzfQx
Excel Quiz 56
Power BI – New DAX functions launched in 2022
This is a mini guide to recap those 9 functions which were launched in year 2022. PDF file corresponding to this video – https://1drv.ms/b/s!Akd5y6ruJhvhvwCdltcqWqFlen0f?e=cAzGyg
Power Query – Generate Fiscal Year – Tips & Tricks 14
Suppose you need to generate fiscal year like 2021/22, then use this formula in a custom column where 3 means FY finishes in March month. Similarly say your financial year finishes in Jun month, replace 3 with 6..If it finishes in Jul, replace 3 with 7. You will need to replace [Year] and [Month] fields…
Power Query – Sum only Numbers in a List – Tips & Tricks 13
Suppose you are given a list {"x", "100","200", "x300", 500} and you need to sum only the numbers 100, 200 and 500 in it. Then you can use following code
SQL Quiz 1
Power BI Quiz 3
Excel & Power Query Challenges Week 1
Here are 7 Excel & Power Query challenges posted on Linkedin during Week 1. You can create your own solution and also can refer to solutions posted by others to learn from others. EXCEL CHALLENGE 1 2. EXCEL CHALLENGE 2 3. EXCEL CHALLENGE 3 4. POWER QUERY CHALLENGE 1 5. EXCEL CHALLENGE 4 6. EXCEL…