Monthly Archives: January 2017

Happy New Year of Rooster

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…

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)

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)

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