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]

OFFSET function and Dynamic Ranges [Video]

By |September 20th, 2018|Dashboards, Dynamic Ranges, Formulas, Youtube|

OFFSET function Basics + Dynamic Ranges ( 6 Examples) OFFSET function Basics + Dynamic Ranges ( 6 Examples) You can download the workbook here [...]

Comments Off on OFFSET function and Dynamic Ranges [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

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
Load More Posts

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Go to Top