[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! 🙂

Advertisements
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