[Affiliate]
Blog Stats
- 3,290,407 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Show number in thousand (k) or in million (M) by using custom format
- Open an embedded Excel file during a slide show in PowerPoint?
- Dropdown calendar in Excel
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Sequential number for visible rows only
- Perform VLOOKUP with 2 lookup values
- Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
- Advanced vlookup - wildcard characters "?" and "*"
- Insert blank columns to table in #PowerBI Desktop
- How to sort bar chart in descending order?
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: General
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
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
Excel Humor #8 – iLOOKUP, the ultimate function in using Excel
Have you ever used “i”LOOKUP? I do it almost every day… 🙂
Excel Humor #7 – Interactive Report
I hope you will never run into a situation like this… 🙂
Three years of Excel Blogging – A quick review
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
Posted in General
4 Comments
Excel Humor #6 – Probably the shortest and the best Excel Proficiency Test
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
Transform boring Excel reports into Business Intelligence
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
Excel Humor #5 – Are you relying on Excel too much?
Are you an Excel Dependency? Do you use Excel even for simple maths? Sometimes I do. 🙂
Excel Humor #4 – Excel is the perfect tool for…
Like and/or share this post if you agree it. 🙂
Boost Excel Skill with Pivot Table
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
Lost in colors
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
Posted in Excel Tips, General
Leave a comment
Don’t Miss Out on the Early Bird Registration for Allen Wyatt’s Excel Macros for Beginners course
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
An example of using Solver for a causal problem in daily life
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
Want to learn Macro? Here’s the chance.
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
Excel Humor #3 – Advanced User
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!
Excel Humor #1 – Home
I am now having fun somewhere in Tasmania; enjoying my vacation 🙂 So let’s have fun this week and the next.
Bug with copy and paste in Excel Table
Do check what you do! On top of human errors, there may be bug hidden. Continue reading
No Pain No Gain
Learning is a process, in which I believe the easier we take, the less we get. I am glad that I’ve learnt Excel starting with Excel 2000. Yes it is more than a decade ago. Throughout the decade, I have … Continue reading
wmfexcel 