5 Little Excel Tips (tests)

First of all, Happy New Year of 2017!  Wish you all an Excellent year ahead!

Let’s start the year with a simple “Game” which I developed for in-house Excel training in my previous company.  All participants were expected to have basic Excel knowledge.  Many of them worked with Excel on daily basis.  I had delivered the training to over 100 colleagues with this “Game” as warm up exercise.

The “Game” covers five Excel tricks.   To me, and probably to most of you, they are quite basic and simple.  However, to my big surprise, there was NO participant (out of the >100 participants) who could complete the “Game” successfully in 5 minutes.

You may see the short description of the five tasks below:

Trick 1 – Transposing Data

The task: To transpose (turning columns into rows) a table, as illustrated below.

Excel Tips - Trick #1.png

This is really to my surprise… many people are not aware of this simple but time-saving trick about Copy and Paste.

Trick 2 – Fill a series

The task: Fill a big series of sequential number, say from 1 to 24567

Are you one of them… using drag and drop?  Remember, you have only 5 minutes to complete 5 tasks.

Trick 3 – Doing simple calculation (add, subtract, multiply, divide) without formula

The task: Convert a set of number from USD to HKD

Excel Tips - Trick #3.png

Hey, no formula please!

Trick 4 – Replace a value with a symbol

The task was actually a question from an ex-colleague.  It is to convert “1” to “Tick” in a table like the following one:

Excel Tips - Trick #4.png

Well, the first thing you need to know is how to insert a “Tick” in Excel

Trick 5 – Sort dates

The task: To sort the following dates in descending order.  Sound silly but…

Excel Tips - Trick #5.png

Note: Please double check to ensure you have sorted them correctly.  Hint: Are they real dates?

Without time limit, any one could finish all of them.  Nevertheless, we learn Excel to become more productive, right?  Believe it or not, it is often a simple and basic trick that could boost productivity of your daily work.

Are you ready to try this “Game”?  Click HERE to download the file.

Remember, you have only 5 minutes to complete it.  Have fun! 🙂


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 Excel Tips and tagged , , , , . 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 )

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.