Top 100+ Excel Tips and Tricks which will Make You a PRO in 2018
Every Excel user do need a list of tips and tricks which he/she can use to learn to [...]
How to use INDEX and MATCH in Excel
INDEX MATCH, when combined, can change the approach you use to lookup values in Excel.Yes, you get it [...]
Top 100 Useful Excel Macro [VBA] Codes Examples
Macro codes can save you a ton of time.You can automate small as well as heavy tasks with [...]
How to use Formulas in Conditional Formatting in Excel
The best part of conditional formatting is you can use formulas in it.And, it has a very simple [...]
How to Perform VLOOKUP in Power Query in Excel
VLOOKUP is one of the most popular Excel functions and there’s no doubt about it.You know this from [...]
How to Convert Negative Number into Positive in Excel
Last week, I got an email from one of my subscribers with a question.Hey Puneet, how many methods [...]
How to Concatenate with a Line Break in Excel
In Excel, when we normally combine text from different cells using CONCATENATE.But sometimes while doing this we need [...]
How to Refresh All Pivot Tables at Once in Excel
By refreshing all the pivot tables at once you can save a lot of time.Yes, that’s right and [...]