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
Category: Tips and Tricks
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
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
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
Tips & Tricks 187 – Give Smilie Faces to Ratings in Dashboards / Reports
This video will help you to create Smilie Faces for values given in your reports / dashboards. They will be Green for Happy Face, Yellow for Neutral Face and Red for Unhappy Face. Excel file used in this video – https://1drv.ms/x/s!Akd5y6ruJhvhvS7bd4uLFLchcsHE?e=jBxt0d
Tips & Tricks 186 – Multi Column VLOOKUP XLOOKUP
DOWNLOADS 27 – CTRL+SHIFT – EXCEL SHORTCUT KEYS TO STAY AHEAD
CTRL + shortcut keys are the easiest and most often used shortcuts. Here are CTRL+ SHIFT shortcut keys listed to keep you ahead of the competition. DOWNLOAD for printing – Excel – CTRL_SHIFT_Shortcuts Pinup Reference Shortcut Action Ctrl+Shift Ctrl+Shift, then scroll your mouse wheel up to go left, down to go right Ctrl+Shift+A Insert argument…
Important – Content of this Website is 100% Copyright Free
I just want to convey that the content of this site is completely copyright free. You can use the content the way you want without seeking any permission. Whether you are using it commercially or non-commercially, personally or within your organization, it doesn't matter. There is no need to give any acknowledgement either that you…