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 Excel Time Saver

Excel 3D Reference – A Thing You Should Consider

    how to use 3D range in excel

    Using 3D Reference can save your a lot of time and help you to avoid writing lengthy formulas. It’s is like three-dimensional chart or image which has more than one phase. A normal range is all about a group of cells from a single worksheet. For Example, in =SUM(Sheet1!A1:A10), “A1:A10” is a group of cells which is referred from Sheet1. But, a 3D reference […]

    Check it out now

    How To Automatically Update a Pivot Table Range

      how to update pivot table range automatically

      If you use pivot tables in your work frequently, I am sure you face the problem to update it’s source data range manually. Every time when you add new data in the source sheet you need to update the source range for the pivot table before you refresh your pivot table. Now, just imagine if you add […]

      Check it out now

      An Advance Guide To Use Find and Replace In Excel

        how to use find and replace in excel advance option featured image

        Everyone know that we can find and replace a text with find and replace option. But very few people know that you can use this option to an advance level. Do you? If not, then after reading this post you’ll love this tool. In this post, you will learn some useful examples to use find […]

        Check it out now

        How To Copy Chart Formatting To Another Excel Chart [Trick]

          copy chart formatting to another excel chart using this charting tip

          Do you know how to Copy Chart Formatting To Another Excel Chart? Let’s say, with your extreme efforts, you have formatted a chart. And, you realize that you have more charts to format. It’s a pain. But, I have a super quick solution to your pain. All you need just a few clicks with your […]

          Check it out now

          10 Powerful Double Click Mouse Tricks For Excel Power Users

            10 Powerful Double Click Mouse Tricks I Want To Share With You

            Before I tell you all time favorite Double Click Mouse Tricks which I use. Let me show you that, why I am using them. If you are using Keyboard Shortcut Keys to save your time & increase your productivity, you are a smart guy. All Excel users are always eager to learn more excel keyboard shortcuts so they […]

            Check it out now