- 2,467,998 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- How to sort bar chart in descending order?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Show number in thousand (k) or in million (M) by using custom format
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Filter a list of items from a long long list
- Open an embedded Excel file during a slide show in PowerPoint?
- Dropdown calendar in Excel
- Insert a text string into a specific position of another text string in #Excel
- Be cautious when using XLOOKUP
My YouTube Channel
- My Tweets
Category Archives: General
Don’t make me wrong. I am not complaining Power Query at all. If you have followed me for a while, you should know that I am a big fan of Power Query indeed. It is simply powerful! With Power Query, … Continue reading
Are you using Excel 365 but not sure what’s new? Have you heard about all the amazing new functions/features like Dynamic Arrays in Excel 365 but not sure what they are? Or you have no idea at all how Excel … Continue reading
2020 comes to an end in just a few hours . I guess it’s the first time majority of people shares the same new year wish. It was a though year. Keep in faith! Tomorrow will be a better day! … Continue reading
Did you know… you can create such a beautiful dashboard using Excel? Did you also know… this visually appealing dashboard was built in just more than 30 minutes? No kidding! Check it out HERE and you will see. Want to … Continue reading
Well… I know I know, I haven’t written new posts for a while. I was lazy in previous weeks; enjoying summer breezes. You know what, if I were not doing Excel on weekends, I would probably have been enjoying hiking … Continue reading
Power Query – Full Outer Join Revisit Part 2 If you have been following my blog for a while, you should probably know that I’ve started my YouTube channel about one year ago. Up to this moment, I’ve uploaded 54 … Continue reading
To all Power Query Users: I need your vote! Well… we know that in Excel the language behind Power Query is called M; it takes at least three clicks to launch Power Query Editor; the shortcut CTRL+M is currently unassigned… Then why … Continue reading
Is learning Excel Dashboard one of your 2020 resolutions? If so, then you’re in for a treat because today I’m excited to tell you about Microsoft Excel MVP, Mynda Treacy’s highly acclaimed <Excel Dashboard Webinars> are open for limited time! … Continue reading
Just a quick reminder that registration for the awesome Excel Dashboard and Power BI courses by Microsoft Excel MVP, Mynda Treacy, closes on Thursday Nov 21, 8pm in Los Angeles, to be exact. With demand for Data Visualization skills and … Continue reading
that takes you long to prepare; and is hard for report consumers to get insight… 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 … Continue reading
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
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
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
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
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
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
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
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
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
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: