Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

10000+ Copies Already Downloaded

Category Archives for Advance Excel

Dynamic Drop Down List

quickly create a dynamic drop down list in excel featured image

Drop down list is a powerful tool. It can help you to make your data entry simple and quick. You can use a drop down list with your dashboards, charts or even with normal data. While using it, one thing always gave me nuts that you need to update it’s data source whenever you add a […]

Check it out now

How To Add Ranks in a Pivot Table in Excel

how to add ranks in a pivot table in excel featured image

By using a pivot table, you can summarize your data in an understandable manner. And, that summary can help you to analyze data on category wise, product wise, month wise, etc. One of the common practices for analyzing data is by ranking them. Ranking categories and products can help you to compare them with each […]

Check it out now

7+1 Amazing Things You Can Do with Excel Filters

amazing things you can do with excel filters

Using a filter in excel is not a #rocketscience. Everyone out there knows that they can do a lot of things with filter option. But, the bad news is they are not actually using it to the best or maybe they forget to make a habit to use it. And, the good news is you […]

Check it out now

8 Examples for Using Formulas in Conditional Formatting

how to use formulas in conditional formatting featured image

The best part of conditional formatting is you can use formulas in it. It has a very simple sense to work with formulas. Your formula should be a logical formula and result should be in TRUE or FALSE. If that formula returns TRUE, conditional formatting will apply. And, if it returns FALSE, conditional formatting will not […]

Check it out now

Consolidate Data From Multiple Worksheets In A Single Worksheet

consolidate data from multiple worksheets in a single worksheet featured images

In my starting days with excel, I was really bad in capturing data. If you asked me to capture sales data for four different zones, I will create four different worksheets for that. Yes, I was really bad. But, you always learn with your mistakes. Am I right? And, if you are doing the same […]

Check it out now
1 2 3 5