Monthly Archives: January 2017

Happy New Year of Rooster

Posted on January 28, 2017 by MF

Hi everyone, Today we celebrate the Chinese New Year🐔. No Excel tips but CNY greetings and blessings.  Wish you a prosperous and rewarding new year ahead! Continue to excel. Cheers, MF

Rate this:

Posted in General | Leave a comment

Fill so good…

Posted on January 21, 2017 by MF

Answer to the 5 little Tips (tests) – Part 2/5 Fill a series (of sequential numbers) The task: Fill a big series of sequential number, say from 1 to 24567. Answer:  You may find the answer to the question in this post:  Fill … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Transpose Data (Static and Linked)

Posted on January 14, 2017 by MF

Answer to the 5 little Tricks posted in the beginning of the year – Part 1/5 Transpose Data – Result is static This is actually a simple trick of using Copy and Paster (Special, Transpose).  See? It can be done in a … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , , , | 2 Comments

5 Little Excel Tips (tests)

Posted on January 7, 2017 by MF

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. … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment