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

All posts by Puneet

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

How To Create a Sales Chart Template In Excel

how create a sales funnel template in excel

In this real world, everything has a process. From Marketing to Production, Sales To Purchase everything has a stage. To make the process successful we need to track each and every stage. And, to track a sales process, sales funnel chart is one the best tool you can use. Just think this way. You are a […]

Check it out now

How To Use Condition in SUMPRODUCT

how to use conditional sumproduct in excel

SUMPRODUCT is one of the powerful excel functions. And, today, I will show you one of its amazing powers. You will learn how can you write a conditional sumproduct function. Well, as you know you can use sumproduct to multiply and sum specified ranges or arrays. But, while using a conditional sumproduct you can you can […]

Check it out now

How To Create a Milestone Chart in Excel

how to create a milestone chart in excel

Tracking all the steps of a project is an important task. It’s as important as the execution of the each step. In fact, tracking makes execution easy. And, a milestone chart is a perfect way to track a project in a simple way. The basic idea in milestone chart is to track each step of your project on a […]

Check it out now
1 6 7 8 9 10 25