GSTIN Offline Check – AdarshGSTINCheck
A simple and easy to use Excel Utility to identify whether GSTIN is correct Amidst all the buzz...
Read MoreCategory: Excel
Excel Learning Resources
Whenever I take seminars on Excel. I always get a question – What is the best place to learn...
Read More
Complete List of MS Excel Shortcut Key
Ctrl+A – Select All Ctrl+B – Bold Ctrl+C – Copy Ctrl+D – Fill Down Ctrl+F...
Read More
Thousand Separator in Excel
Sometimes we come accross a situation, where we want to change thousand seperator for a particular...
Read More7 Excel tricks to impress your boss
This blog is owned by CA Adarsh Madrecha. All rights reserved.
Read MoreEveryting about VLOOKUP
When you want to pull information from a table, the Excel VLOOKUP function is a typical solution. Its ability to dynamically lookup and retrieve information from a table is a game-changer for many users, so you’ll...
Read MoreExcel Shortcuts – Ctrl combination
Excel shortcut with Control Key. You will be surprised there are so many shortcuts with just Ctrl key.The below table lists down every possible shortcut key using Just Ctrl key. Will be soon posting Excel shortcuts using Shift,...
Read MoreFrench Number format to Indian Number format
Convert data in the format 99.999.999,88 to 99,999,999.88 i.e French system to British System Background We in India (and most of the world) follow number format where we use comma [,] for separator and Full stop [.] for decimal...
Read More
Convert Text to Date when Importing Data to Excel
Many a times, we have to import data which is given by client. When data is imported in excel,...
Read MoreConvert date to Text for filling CST / VAT form
When filling up CST / VAT form, you need date in text format. Here is the formula to convert the date into text format as required in CST / VAT form. There are 3 ways you can achive this. Custom Format Formual User Defined...
Read More
