Sat 21 Jan 2017

Downloads 11 - Printable & Pin-up Sheet for Excel Functions

By |Saturday, January 21st, 2017|Categories: Downloads|Tags: , , , , , , |0 Comments

You can download this one page pin-up sheet and take the printout and pin up to your desk for quick reference - Excel Functions Quick Reference

(more…)

Sat 24 Dec 2016

Downloads 10 - Printable & Pin-up Sheet for Excel Shortcuts

By |Saturday, December 24th, 2016|Categories: Downloads|Tags: , , , , , , , |0 Comments

You can download this one page pin-up sheet and take the printout and pin up to your desk for quick reference. - Excel Shortcuts Quick Reference

(more…)

Sat 04 Jul 2015

Article 17 - 3D Formulas - Hidden Wonder of Excel

By |Saturday, July 04th, 2015|Categories: Articles|Tags: , , , , , |0 Comments

3D formulas are one of the hidden wonders of Excel and not many of us know about the secret of this. The purpose of this article is to unravel the mystery of 3D formulas in Excel.

Suppose you have 4 worksheets called Quarter1, Quarter2, Quarter3, Quarter4 as below. And you want to find the total of Quarter1 to Quarter4 revenue. This is quite simple a task, just put the formula =Quarter1!B6+Quarter!B6+Quarter3!B6+Quarter4!B6 and you are through. But what happens when number of sheets are large say 12, 50 or 100. This becomes quite cumbersome to enter. And that is where the magic of 3D formulas comes into picture.

(more…)