Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

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

            How To Highlight Blank Cells With Conditional Formatting

              how to highlight blank cells with conditional formatting featured image

              It’s hard to recognize blank cells from a large data table. Because a blank cell is just a white cell without any value. In most of the cases, blank cells represent some sort of gap or missing data. It’s recommended to highlight these cells with a color so that we can recognize them. And, I found that […]

              Check it out now

              How To Highlight Top-Bottom N Values In Excel

                how to highlight top bottom n values in excel featured chart

                The best way to highlight top bottom values is by using conditional formatting. It’s quick, simple and all you need a few clicks. But, the best part is, you don’t even have to write a formula for this. I have been using this since I have got my first job. Whenever my boss called me with […]

                Check it out now

                How To Create Interactive Charts In Excel

                  how to create an interactive chart in excel featured image

                  A chart is a perfect tool to present data in an understandable way. But sometimes it sucks because we overload it with data. I believe that when it comes to charting it should be neat & clean. The best solution to this problem is using interactive charts in excel. By using interactive charts in excel […]

                  Check it out now

                  How To Use Wildcard Characters in Excel [Ultimate Guide]

                    how to use wildcard character in excel featured image

                    Do you use wildcard characters in excel? They are life savers. Wildcard characters are all about searching a text with a partial match. Let’s say you have a list of names & you want to search for the names who are starting with “T” and ending with “I”. You can use a question mark (?) to […]

                    Check it out now

                    How To Use R1C1 Reference Style In Excel [Proper Guide]

                      Do you know R1C1 Reference Style in excel is one of the unused features? Most of the excel users don’t even know about the existence of R1C1 reference style. But, some super users love to use it. They found it more convenient than a1 reference style. This post will help you to master R1C1 reference style. And, also […]

                      Check it out now