- Follow wmfexcel on WordPress.com
Top Posts & Pages
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Advanced vlookup - wildcard characters "?" and "*"
- Advanced vlookup - Text vs. Number
- Copy data from strictly-protected sheet
- 2D SUMIF with two variables – one on column and one on row
- Show number in thousand (k) or in million (M) by using custom format
- Convert an 8-digit number into Excel-recognizable Date
Category Archives: General
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
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
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
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
Have you ever used “i”LOOKUP? I do it almost every day… 🙂
I hope you will never run into a situation like this… 🙂
Note: This is not an Excel post… I totally forgot that today is the 3rd Anniversary of my Excel blog. Time really flies. Thanks WordPress for sending this 3rd Anniversary notification to me. What’s a pleasant surprise! 🙂 Did you … Continue reading
Definition of Advanced Excel user varies according to expectation. Someone thinks advanced users should know all the VBA, Pivot Tables and be able to write super long formula. Someone considers oneself “Advanced” for knowing the basic of VLOOKUP. On … Continue reading
Dashboard Course by MYNDA TREACY is now open Last week, I shared the news about the free Excel Dashboard Webinars by Mynda. I hope you did find a time to join the webinars. If you haven’t watched the Webinars and … Continue reading
Are you an Excel Dependency? Do you use Excel even for simple maths? Sometimes I do. 🙂
Like and/or share this post if you agree it. 🙂
I think I must have missed the email from Mynda Treacy regarding the Xtreme PivotTables Course on her site: myOnlineTrainingHub, otherwise you should have read this post earlier. I use Pivot Table a lot and consider it a must-have skill … Continue reading
Which one of the following charts use better colors? It is not surprising if you prefer the one on the left as the colors used are of high contrast. However, will you change your mind after you read the same … Continue reading
Earlier this month I let you know about Allen Wyatt’s Excel Macros for Beginners course. He only opens the doors to the course a few times each year, and he’s already busy helping those who have signed up for the … Continue reading
About a week ago I let you know about Allen Wyatt’s Excel Macros for Beginners course. At the time, I invited you to visit Allen’s overview for the course, and I told you that you could register for this excellent … Continue reading
This post is intended to give you an example of using Solver in Excel to solve a causal problem in daily life – buying postal stamps. Don’t consider it a tutorial. 😛 Have you ever heard of Solver in Excel? I think … Continue reading
If you have been following my blog, you should know that I focus on tricks and tips of “preset” ways in Excel. For some people, using those preset ways is enough, but for others, Excel may be a bit restrictive … Continue reading
Happy New Year!!! Wish you a happy, healthy and prosperous year of 2016. In a word, wish you EXCEL in 2016! 🙂 Let’s start the year with FUN!
I am now having fun somewhere in Tasmania; enjoying my vacation 🙂 So let’s have fun this week and the next.