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 How To

Excel’s AUTO FORMAT Option

how to use excel auto format option for quick formatting

Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone. But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]

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

How to Calculate Weighted Average With Sumproduct

how to calculate weighted average with sumproduct

The weighted mean is similar to an ordinary arithmetic mean (the most common type of average), except that instead of each of the data points contributing equally to the final average, some data points contribute more than others.

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
1 2 3 9