Outshine others by creating Target line in your charts which would clearly show when you hit the target The file used in this video – https://1drv.ms/x/s!Akd5y6ruJhvhvT3-uVo6EaAd_vBF?e=4CLXk2
Author: Vijay A. Verma
Tips & Tricks 191 – Be Super Smart at Work, use SMART LOOKUP
Smart Lookup is often an ignored feature of Excel though present through Excel 2016. Very powerful and can increase your productivity to next level if used properly. File used in this tutorial – https://1drv.ms/x/s!Akd5y6ruJhvhvTlGQ9t04W4Pj1LC?e=RU7tQ9
SQL Quiz 2
Tips & Tricks 190 – Blazing fast way to convert text numbers into numeric numbers
No need to write formulas to convert text numbers into numeric numbers. Here is a blazing fast way. File used in this tutorial – https://1drv.ms/x/s!Akd5y6ruJhvhvTY9-xarJTpl0fKs?e=jeMABJ
Tips & Tricks 189 – Extract First and Last Name in a Super Fast Way – No Formula Required
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…