Author Archives: MF

Copy and Paste can do so much…

Answer to the 5 little Tips (tests) – Part 5/5 The task: To sort the following dates in descending order.  Sound silly but… The first thing you would probably do is to go to Data tab and then click the Sort Z to A icon? … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 16 Comments

Go to Special + Copy and Paste do the magic

Answer to the 5 little Tips (tests) – Part 4/5 The task: To convert “1” to “Tick” in a table like the following one: Answer:  Copy and Paste with a simple trick … What? Not Find and Replace?  Yes, you may do it by using … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 2 Comments

Free webinar on Power BI by Mynda Treacy is coming soon

Have you heard about Power BI from Microsoft? Probably yes.  However I guess most people are not yet aware of this amazing BI tool from Microsoft that enables you to build stunning interactive dashboards and share them on any device. If you want … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

The 5-minute Excel Dashboard Challenge @ Bacon Bits

Have you ever thought of building an Excel Dashboard in 5 minutes?  Yes, only 5 minutes. That’s why it is a Challenge!   You may find the details of The 5-minute Excel Challenge at Bacon Bits. Honestly, I haven’t thought … Continue reading

Rate this:

Posted in General | Tagged | 4 Comments

Paste special with simple mathematic operation + – * /

Answer to the 5 little Tips (tests) – Part 3/5 The task: Doing simple calculation (add, subtract, multiply, divide) without formula Answer:  Copy and Paste Special…

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

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 , , , , | Leave a comment

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

Merry Christmas

Dear readers, Merry Christmas!!! Wishing you and your family a healthy, fruitful, rewarding and Happy New Year of 2017! See you next year! p.s.  Should you want to play around the Excel Card above,  here’s the christmas-tree! Tip: Hold F9 for … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

A tip of using AutoCorret to input names quickly

This is a simple tip that most secretaries and executive assistants love. 🙂 Did you ever look up someone’s full name in Outlook or email directory?  It happens especially if you are working in a multi-national company and you are … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Are we aligned?

A simple trick to align objects neatly. 🙂 Did you move the objects one by one and then realized that it took you forever to have them perfectly aligned? Why not using the “Align” under Drawing Tools?

Rate this:

Posted in Excel Tips | Leave a comment

Turn boring Excel reports into Business Intelligence – Excel Dashboard

Last week I told you about the awesome Excel Dashboard Webinar  was back.  I hope you had a chance to watch it and get something already.  If not, it’s not too late.  But hurry seats and sessions are limited with … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Free Excel Dashboard Webinars by MYNDA TREACY is back

If you have been following my blog for more than three months, you should have read this before.  If you wonder why I am reposting it again and again (Yes, this is the 3rd time I write about Mynda’s Excel … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Be cautious when using SUMIF(s)

SUMIF is a handy but helpful function.  The syntax is simple: =SUMIF(range,criteria,[sum range] What it does is quite straight forward indeed.  In the example above, it instructs Excel to look into the range (A2:A7), look for the matching criteria, which … Continue reading

Rate this:

Posted in Excel Tips, Formula | 2 Comments

Move a chart object with arrow keys

If you do chart in Excel, you may have encountered this: You clicked on a chart object, tried to move it just a little bit to the right by pressing Right Arrow key a few times… Instead of the chart being moved … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

The powerful Power Query and the interesting TechNet Virtual Labs

As you may be aware of, I haven’t written a real blogpost recently.  I was super busy at work in the past month.  No surprise.  There are moments Excel won’t help me much at work, especially when bosses like PowerPoint (and PDF) … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Excel Humor #8 – iLOOKUP, the ultimate function in using Excel

Have you ever used “i”LOOKUP?  I do it almost every day…   🙂  

Rate this:

Posted in General | Tagged | Leave a comment

Excel Humor #7 – Interactive Report

I hope you will never run into a situation like this… 🙂

Rate this:

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

What is a “Container Chart”?

First of all, I would like to thank Chandoo for suggesting this name for the chart I submitted to him for a charting contest a few months ago.  What’s more surprising to me is I was one of the winners of … Continue reading

Rate this:

Posted in Chart | Tagged , | Leave a comment