[Affiliate]
Blog Stats
- 3,070,579 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?
- Show number in thousand (k) or in million (M) by using custom format
- How to replace value with a value from another column in Power Query
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Insert a text string into a specific position of another text string in #Excel
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Open an embedded Excel file during a slide show in PowerPoint?
- Send a cell content to Google search
- How to put the Date Modified info on #Excel worksheet using #PowerQuery
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: General
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
Convert PDF to Excel without PDF converter
Does it sound familiar? There are many online-converters. I tried a few of them (freebies) but the result was not satisfactory sometimes. I don’t blame them as I had managed my expectation. 😛 Without PDF converter, what I tried to do … Continue reading
Excel 2016 is coming! Is your company ready for this?
If you Google “Excel 2016 preview”, you will find many previews and comments for Excel 2016 on the Internet. I have not tried Excel 2016. Indeed, I have not yet tried Excel 2013 either, although I keep an eye on … Continue reading
Posted in General
2 Comments
Interesting Magnifier in Windows 7
This is not an Excel tip… One day I intended to press Alt+= (which is the shortcut for Auto Sum), but I wrongly press Windows+=, and something interesting pop up… Instead of an auto sum formula I expected, I saw a … Continue reading
wmfexcel 