Top Excel Tips and Tricks (101) – Basic + Advanced + Free PDF to Make You a PRO this Year
Learning Excel is like a fun game if you have a list of tips and tricks. Isn’t it TRUE? Every Excel user does need a list of tips and tricks which he/she
Top 100 Pivot Table Tips and Tricks You Need to Learn this Year
Top 100 Pivot Table Tips and Tricks You Need to Learn this Year I’m sure you love to use pivot tables.Right?No doubt, a pivot table is the single most important
Top 25 Options in Excel’s Mobile App (Android & iOS)
If you are reading this right now… …I’m sure you haven’t explored Excel’s Mobile App that much… …or, you haven’t heard about it. Am I right?Say “Yes” in the comment section if you
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 right. The combination of these two functions can match the gap of all
Top 25 Power Query Tips and Tricks You Need to Know Today
There’s one thing which we all want to do, and that’s, saving more and more time and working smartly. Well, in Excel, there are a lot of tips and tricks which
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 VBA codes.And do you know? With the help of macros……you can break all
Top 10 ADVANCED Excel Charts and Graphs (Free Templates Download)
Charts are one of the most important parts of Microsoft Excel. It helps us to present our data in an understandable manner. In Excel, we have different kind of charts and
How to Create a SPEEDOMETER Chart [Gauge] in Excel
When it comes to present data in an understandable way in Excel, charts standout there. And there are few charts which are specific and can be used to present a specific
How to Create Waffle Chart in Excel [Step by Step Guide]
There are a lot of people out there who don’t like to use a PIE chart and they have their valid reasons for this. And if you are one of those
How to Count Cells with Text in Excel
Last week one of my readers asked me for a simple formula which he can use to count cells with text. Actually, he was trying to figure out which is