Category Archives: General

Suggestion: Adding a button for number formats in thousand/million/billion in #Excel

Posted on September 3, 2019 by

Did you know what you may submit your ideas to improve Excel through UserVoice? The recent HOT news in the Excel community – the new XLOOKUP function is also resulted from an idea submitted in UserVoice. While everyone is super exciting … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Free Excel Dashboard Webinars you should not miss

Posted on August 7, 2019 by

Have you ever had an Excel moment like this? “My Excel reports take way too long to update each month/week” “I spend hours collating and cleaning data, updating formulas and charts and then no one reads my reports anyway, what’s … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

[Guest Post] DRAW – The New Tab in Office 2019/365 for INKING

Posted on August 4, 2019 by

This is a guest post by Aprajita of ExcelChamps. Let me ask you something. Suppose you are presenting data to the management and suddenly an important point strikes your mind. Will you look around for a piece of paper and … Continue reading →

Rate this:

Posted in General | Tagged , , | 1 Comment

Updates on Excel Magic in One Minute

Posted on July 27, 2019 by

Six weeks ago, I created my YouTube playlist – Excel Magic in One Minute. As of today, I’ve already published 17 videos to the playlist.  Meaning 2-3 videos per week.  Not too bad as a weekend YouTuber (newbie), I guess. … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Free Excel Dashboard Webinars by Mynda Treacy

Posted on May 11, 2019 by

If you’ve ever felt like: “My Excel reports take way too long to update each month/week” “I spend hours collating and cleaning data, updating formulas and charts and then no one reads my reports anyway, what’s the point?” “If I … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Birthday Treat Calculator

Posted on March 16, 2019 by

A powerful tool for a silly thing.  Why not?  🙂 Long time ago, I wrote a blog post How much do I need to pay? which was not really related to Excel but calculation of a random daily event.   … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

My second #Excel Video on YouTube

Posted on February 23, 2019 by

Glad to share with you my second video here.   This video is about how to plot a compelling to compare Actual vs. Budget, Target and Last Year data.  The written instruction is available in previous post – A compelling chart in three … Continue reading →

Rate this:

Posted in General | Tagged | 2 Comments

My first #Excel video on YouTube

Posted on February 9, 2019 by

Kung Hey Fat Choi!  This week is Chinese New Year.  I wish you a fruitful, healthy, and rewarding Year of Pig! I have almost one week off for CNY holiday.  I have cleaned my PC and spared 50G+ space in … Continue reading →

Rate this:

Posted in General | 2 Comments

Learn something amazing from Mynda’s #Excel Dashboard webinars

Posted on February 3, 2019 by

Free Excel Dashboard Webinars We don’t know what we don’t know.  The best way is to learn something new is to explore the web (or world), and/or learn from experts. Sometimes we just don’t know, or even don’t expect what … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

The making of the bee…

Posted on November 22, 2018 by

Did you know… the bee you see on top of this page is drawn with Excel using shapes? Yes… these are the shapes I used to draw the bee.  What I did was to put them together… Watch this:

Rate this:

Posted in General | Tagged | Leave a comment

Prepare yourself to be an #Excel Dashboard Pro…

Posted on November 3, 2018 by

Have you ever had an Excel moment like this? If you’ve ever felt like: “My Excel reports take way too long to update each month/week” “I spend hours collating and cleaning data, updating formulas and charts and then no one … Continue reading →

Rate this:

Posted in General | Tagged , | Leave a comment

Trick or Treat 2018

Posted on October 31, 2018 by

♪♫♬ This is Halloween, this is Halloween ♪♫♬ ♪♫♬ Halloween! Halloween! Halloween! Halloween! ♪♫♬ Please join me to welcome our special guest – Jack Skellington, appears on wmfexcel’s Excel sheet. ♪♫♬Halloween! Halloween! Halloween! Halloween! In this town we call home Everyone … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Exciting Dynamic Array functions in #Excel 365

Posted on October 27, 2018 by

Have you heard of the new Dynamic Array functions recently available in Excel 365 (currently for Insider Fast users only)? If you are an advanced Excel user, you will be impressed by these new functions.  They are simply awesome, super … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Excel Humor #7 just happened to me…

Posted on October 7, 2018 by

Two years ago… I posted this: which turned out a real case to me last week… I printed 99 pages of report out of one worksheet by selecting 99 items on a slicer one by one. @_@

Rate this:

Posted in General | Tagged | Leave a comment

Three days in paradise…

Posted on September 29, 2018 by

Note: This is not an Excel post. I am back from holiday, physically 🙂 I went to a very remote village called YuBeng in Yunnan, China.  It’s a village 3200M above sea level.  To get to there wasn’t easy.  Not … Continue reading →

Rate this:

Posted in General | Leave a comment

[Share] – Excel Hash

Posted on September 12, 2018 by

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

Rate this:

Posted in General | Leave a comment

5 years of blogging

Posted on September 7, 2018 by

Totally forgot I put my first post here 5 years ago.  Time really flies! Thanks for flying with me. 🙂

Rate this:

Posted in General | Leave a comment

[Share] – Threaded Comments in Excel 365

Posted on September 1, 2018 by

Last week, I told you that my Surface Pro 4 is out of service, and I am waiting for a new laptop for writing my Excel blog… until late September or early October.   That was the plan. Although I am … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

(: Late summer break :)

Posted on August 26, 2018 by

Today, I am not talking about Excel although I would like to.  Why?  Because my Surface Pro 4 is out of service… 😦 It has been out of order a few weeks ago… the moment when the warranty period was … Continue reading →

Rate this:

Posted in General | Leave a comment

#Excel Humor #15 – Performance Review

Posted on August 15, 2018 by

  Feel free to share this formula to your friend / colleague whom you think applicable… 🙂 He/She knows the answer.  😛

Rate this:

Posted in General | Tagged | Leave a comment