FUNCTIONS … top 100

22 12 2018

I just came across a couple of pages on that you need to know about and forgive me if these are behind a paywall: I subscribe to the HBR so I went straight to every page.

Firstly, 10 Excel Functions Everyone Should Know by Adam Lacey and Deborah Ashby. I prefer DGET to their INDEX-MATCH function but otherwise, this is a good start to learning the top 10. Top 10 Excel Functions

Then there is a REALLY useful PDF file The Definitive 100 Most Useful Excel Tips at

Finally and following on from the 100 must useful Excel tips, Marc Zao-Zanders gives us this, A 2×2 Matrix to Help You to Prioritise the Skills to Learn Right Now, here:×2-matrix-to-help-you-prioritize-the-skills-to-learn-right-now This 2×2 matrix puts the 100 tips on a grid/graph to illustrate four quadrants:

  • Decide whether you need to learn it
  • Learn it as the chance arises
  • Schedule a block of time for learning it
  • Learn it right away

Marc says this, “You’ll find the quickest wins in the bottom-right quadrant, which we’ve labeled “Learn it right away.” In here we have time-saving shortcuts that can be applied frequently, like Ctrl-Y (redo) and F2 (edit cell) and a nice combination formula that cleanses your spreadsheet of errors (IF(ISERROR)).” Of course, IF(ISERROR) is way out of date and should be replced by IFERROR()

Duncan Williamson

22nd December 2018

One Response to “FUNCTIONS … top 100”

  1. […] a brief article on THIS PAGE, click the following link or scroll down from here to read it, called, FUNCTIONS ,,, top 100. It comes from the Harvard Business Review and is well worth reading and following up on. They […]

Leave a Reply to Welcome to this Blog: Excel with ExcelMaster | Excel with Excel Master Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: