## FUNCTIONS … top 100

### 22 12 2018

I just came across a couple of pages on hbr.org 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 https://excelwithbusiness.com/blog/definitive-100-most-useful-excel-tips/

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: https://hbr.org/2017/09/a-2×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 […]

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