[Share] – Excel Hash

Have you heard about the Excel Hash competition?

It is a contest initiated by Oz du Soleil at Excel On Fire.  Six well-known Excel MVPs, including Oz himself, show you what they can do with four designated Excel features/functions, and more importantly – how, on their YouTube channels.

The four Excel Features/Functions are:

  1. MAX Function – A basic function, well… you think it is?
  2. FREQUENCY Function – A not-so-well-known function for counting number of values to a specific bin.  Many people use COUNTIF(S) to do the same, because they don’t know about FREQUENCY
  3. Form Control – cool stuff to make your spreadsheet interactive (btw, I have many posts about it, check them out here)
  4. 3D Model – Something new in Excel 365

As you know, the true power of Excel never comes from a standalone function or feature. It comes from the ability of mixing function/feature together to do something great and impressive. Of course it requires out-of-the-box thinking from the people who use it. You will know what I am talking about after watching the six entries below.

The six contestants and their delicious dishes are:

Bill Jelen, aka Mr. Excel


Jon Acampora, Excel Campus


Leila Gharani


Mike Girvin, ExcelIsFun


Mynda Treacy, My Online Training Hub


Oz du Soleil


Believe me, you will learn something new and cool from watching these videos. You can also VOTE for your favorite entry here.

Enjoy! 🙂

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in General. Bookmark the permalink.

Comments, suggestions, corrections are welcome.

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

WordPress.com Logo

You are commenting using your WordPress.com 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.