Sat 27 May 2017

Excel Quiz 52

By |Saturday, May 27th, 2017|Categories: Quizzes|Tags: , , , , , , , , , , |0 Comments

Excel Quiz 52 - A Quiz on Formulas Tab in Excel

This quiz checks your knowledge about Formulas tab.

Sat 06 May 2017

Downloads 15 - Excel Formulas Bible

By |Saturday, May 06th, 2017|Categories: Downloads|Tags: , , , , , , , , , , , , |0 Comments

This is one single document which contains close to 100 formulas dealing with various situations. Useful for Intermediate and Advanced users.

Download it from Excel - Formulas Bible

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 18 Jun 2016

Article 40 - Order of Operations in Formula

By |Saturday, June 18th, 2016|Categories: Articles|Tags: , , , , , , , , , , , , , , |0 Comments

Follow the BODMAS rule

B – Brackets (Parentheses)
O – Orders (Powers/Exponents)
D – Division
M – Multiplication
A – Addition
S – Subtraction (more…)

Sat 16 Apr 2016

Article 38 - 10 Features I would like to see in Excel

By |Saturday, April 16th, 2016|Categories: Articles|Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , |0 Comments

Like all of you, I am dependent upon day to day work in Excel. Excel is a software which is like ocean, unlimited in bounds. It has almost all features but it doesn't have few which everybody cherishes. All of us want something or the other. Below is a list of features which I would like Excel to have.

1. Making Volatile Functions Non-volatile on the basis of a Parameter

We all like TODAY(), NOW(), RAND() and RANDBETWEEN() (there are other volatile functions also). They are very useful but suffer a fatal flaw, if something gets recalculated, they always get recalculated also. Hence, if I am using TODAY() to derive today's day and if I open the sheet tomorrow, TODAY() will change tomorrow's date. I wish that all volatile functions should carry a parameter so that they should not recalculated when the sheet is recalculated. For example, we should have something like TODAY(N), NOW(N),RAND(N) and RANDBETWEEN(N) where N
(more…)

Sat 03 Jan 2015

Excel Quiz 5 - Crossword - I

By |Saturday, January 03rd, 2015|Categories: Quizzes|Tags: , , , |3 Comments

This time, I decided to put a Crossword on Excel Functions. This crossword is interactive and you can use browser to play with this. Click in the Grid to start.

Click on Check Puzzle just above Questions to check your score.

If you want to print the Crossword on a paper to play with, download from here Excel Functions Crossword 1

The answer key can be downloaded from here Excel Functions Crossword 1 Answers

If the below Crossword is not properly visible because of WordPress plugin limitation, you can play it properly here Excel Functions Crossword 1

(more…)