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.

Worth $20, Absolutely Free

Category Archives for Formulas

Weighted Average in Excel

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.

➲ Continue Reading

Excel 3D Reference for Cells

We all want to save our time.And, by using 3D Reference in Excel you can save your a lot of time.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 […]

➲ Continue Reading

SUMPRODUCT IF to Create a Conditional Formula in Excel

SUMPRODUCT is one of the most important Excel functions. The best part about it is, you can modify it in several ways.And, one of its powers which I have discovered recently is using it as “SUMPRODUCT IF”.In short, a Conditional SUMPRODUCT.As you know, you can use sumproduct to multiply and sum specified ranges or arrays.While […]

➲ Continue Reading

How To Perform Two Way Lookup In Excel

It happens sometimes when we need to lookup for a value from a table according to the row heading and column heading.Let say, if you need to get the values from above table for a particular month and zone. Here in this situation you can use a two way lookup.Performing a two-way lookup is all about […]

➲ Continue Reading

MAX IF Formula

Ever tried to look up for the maximum value from a range using a specific condition? Which formula do you think you can use?You might be wondering:Well, in excel, we can’t simply use default max function in excel with a condition (unless you are using office 365).But, you can combine MAX and IF to create a […]

➲ Continue Reading