Sat 27 May 2017

## Excel Quiz 52

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

## Excel Quiz 52 - A Quiz on Formulas Tab in Excel

Sat 06 May 2017

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

Sat 21 Jan 2017

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

Sat 24 Dec 2016

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

Sat 18 Jun 2016

## Article 40 - Order of Operations in Formula

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

B – Brackets (Parentheses)
O – Orders (Powers/Exponents)
D – Division
M – Multiplication
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||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