[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

https://youtu.be/ZuzNrKeI7r8

Jon Acampora, Excel Campus

https://youtu.be/0ZW-h4kPlBI

Leila Gharani

https://youtu.be/N0MesGk0VpI

Mike Girvin, ExcelIsFun

https://youtu.be/U1h2FrZFMqI

Mynda Treacy, My Online Training Hub

https://youtu.be/DEFsczAoCxQ

Oz du Soleil

https://www.youtube.com/watch?v=D9g-l6NjkIM

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 doesn’t work on Excel most of the time at current job...... 🤔 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 )

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.