[Affiliate]
Blog Stats
- 3,069,188 hits
-
Join 3,281 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- How to replace value with a value from another column in Power Query
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Open an embedded Excel file during a slide show in PowerPoint?
- Perform VLOOKUP with 2 lookup values
- Send a cell content to Google search
- How to put the Date Modified info on #Excel worksheet using #PowerQuery
- Rename column names in a dynamic way with #Excel #PowerQuery
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: General
My first #Excel video on YouTube
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
Posted in General
2 Comments
Learn something amazing from Mynda’s #Excel Dashboard webinars
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
The making of the bee…
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:
Prepare yourself to be an #Excel Dashboard Pro…
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
Trick or Treat 2018
♪♫♬ 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
Exciting Dynamic Array functions in #Excel 365
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
Excel Humor #7 just happened to me…
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. @_@
Three days in paradise…
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
Posted in General
Leave a comment
[Share] – Excel Hash
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
Posted in General
Leave a comment
5 years of blogging
Totally forgot I put my first post here 5 years ago. Time really flies! Thanks for flying with me. 🙂
Posted in General
Leave a comment
[Share] – Threaded Comments in Excel 365
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
(: Late summer break :)
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
Posted in General
Leave a comment
#Excel Humor #15 – Performance Review
Feel free to share this formula to your friend / colleague whom you think applicable… 🙂 He/She knows the answer. 😛
Top 40 Excel Blogs by Feedspot
What an honour and pleasant surprise to be selected as one of the Top 40! Recently I am quite busy (and moody) at work, I mean the real work at office. You must be thinking my works involved using Excel … Continue reading
Posted in General
Leave a comment
#Excel Humor #14 – Insert Table
I am having an incentive trip in Osaka… not sure if this is due to my Excel skills. 😛 So let’s have fun this week. 🙂 What would you say if you were the interviewer? Leave it in comments. … Continue reading
#Excel Dashboard Course and Free Webinars by Mynda Treacy is closing soon
Just a quick reminder that registration for the awesome Excel Dashboard and Power BI courses, by Mynda Treacy closes on Thursday February 15, 8pm in Los Angeles, to be exact. With demand for Data Visualization skills and Excel data analysis jobs … Continue reading
20% off Excel and Power BI Dashboard Courses
Mynda Treacy’s popular Excel and Power BI Dashboard courses are back Dashboard reports, are no longer a buzz word, they’re a standard reporting tool for all kinds of industries and they’re an in-demand skill for Excel users everywhere. In fact, IBM project … Continue reading
Season’s Greetings 2017
Ho…Ho…Ho… Merry Christmas! Wish you and your beloved ones a Merry Christmas and a Happy New Year of 2018! The above is made of #Excel of course… You may download a copy Seasons Greetings 2017 if you like it. 🙂
wmfexcel 