Blog2020-06-27T19:00:55+00:00

# BLOG

## Calculate Quarters , Fiscal Quarters in Excel [Video]

By |September 27th, 2018|Date and Time, Formulas, Videos, Youtube|

Calculate Quarters, Fiscal Quarters, Fiscal Years in Excel Calculate Quarters, Fiscal Quarters, Fiscal Years in Excel You can download the workbook here to follow [...]

Comments Off on Calculate Quarters , Fiscal Quarters in Excel [Video]

## How to use the INDEX MATCH combo for Lookups – Basics of INDEX and MATCH

By |September 15th, 2018|Formulas, Lookup Formula|

Basics of Using INDEX MATCH Combo for Lookups INDEX  MATCH Basics You can download the workbook here to follow along with the Video! [...]

Comments Off on How to use the INDEX MATCH combo for Lookups – Basics of INDEX and MATCH

## Handling errors in Excel using IFERROR

By |November 2nd, 2017|Formulas|

Various functions in Excel result in an error in certain situations. It’s annoying to look at them when the errors are unavoidable. In this article, you will learn how to [...]

Comments Off on Handling errors in Excel using IFERROR

## Rounding using CEILING and FLOOR Functions in Excel

By |October 4th, 2017|Formulas|

Rounding numbers is a frequently occurring need. There are plenty of use cases where you would like to round off the given number to the nearest multiple of a certain number. [...]

Comments Off on Rounding using CEILING and FLOOR Functions in Excel

## Weighted Average in Excel-How to calculate!

By |August 4th, 2017|Formulas|

Calculating weighted average is a more advanced way of averaging numbers where different weights are given to different numbers unlike equal/uniform weights given in the case of the normal average. [...]

Comments Off on Weighted Average in Excel-How to calculate!