[Affiliate]
Blog Stats
- 3,287,205 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Copy data from strictly-protected sheet
- When unhide row doesn't work...
- Dropdown calendar in Excel
- Bug with copy and paste in Excel Table
- Convert an 8-digit number into Excel-recognizable Date
- Simple trick to look (hack) into hidden sheet
- Sequential number for visible rows only
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- How to lookup an image in #Excel
- Limitation (or bug?) with Filter by Color
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
Apply Conditional Format for alternate row color based on groups…
…that works even when filter is applied. The situation: We have a table that we would like to apply color banding based on groups. We can achieve this by inserting a helper column to identify the sequence of each group, … Continue reading
Unstack uneven data across columns with #Excel #PowerQuery
This is a continuation of the previous post, in which I showed you how to unstack two columns of data by using Pivot Table as a helper, and together with a couple of excel tricks. As mentioned, that approach is only … Continue reading
Unstack data across columns with #Excel Pivot Table
Another commonly seen problem in daily work. Many hours are spent on reshaping data, we all know that. Nevertheless, if you are good in Excel, doing this task is not difficult at all. Indeed, there are many ways to solve … Continue reading
Waterfall chart is just a few clicks away with #Excel 2016
Did you know, you can plot a Waterfall chart in #Excel in less than a minute…Provided that you are using Excel 2016 or later! 🙂 No Kidding! You may download a Sample File to follow along.
Split cell contents separated by line feed into rows with #Excel #PowerQuery – Part 2
Last week, I showed you how to split cell contents separated by line feed into rows with Power Query. That was easy when we are dealing with only one column. If you don’t know how, you may read the post … Continue reading
Free Excel Dashboard Webinars by Mynda Treacy
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
Split cell contents separated by line feed into rows with #Excel #PowerQuery
After an in-house training, a colleague came to me and asked if there is a way to do the following: The problem here is the contents in cells are separated by a line feed (line break). A cell may contain … Continue reading
Identify missing files in a folder with Power Query
It is a common task to compare two lists in Excel. This can be achieved with MATCH function. But what if you want to compare a list of filenames stored in your spreadsheet, with the files you’ve got in a … Continue reading
Quick Tip – #Excel AutoSum
While SUMMING data is probably the most common task in Excel, I am surprised that many people are not aware of this Excel feature – AutoSum. It is super handy especially when you know the shortcut of it, which is … Continue reading
#Excel Add current selection to filter. What it does?
Get multiple filter criteria with Excel Auto-Filter This post is in response to the following Mr.Excel video where Mr. Excel Bill Jelen solved the problem with Advanced Filter. Indeed I got a similar question from a colleague recently for filtering … Continue reading
#Excel Flash Fill in action with 16 examples
Flash Fill was introduced in Excel 2013. After 6 years, it is still a hidden gem of modern Excel that most regular Excel users do not even know its existence. Whenever I show to my colleagues what Flash Fill is … Continue reading
Birthday Treat Calculator
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
Extract FirstLast names in CamelCase with #Excel formula
In the previous blog post, we see how Flash Fill extracts First Name and Last Name from an email address in a format shown above. I’ve also recorded a video for that post. Flash Fill is so smart to detect … Continue reading
Turn CSV data into insight like a pro with Excel 2016
Many people are not aware of how easy-to-use and powerful modern Excel is. I mean Excel 2016 or later. In this post, I will show you how to turn CSV data into insight in a just a couple of minutes like a pro. Techniques used: Flash Fill, Quick Analysis and two new chart types (Histogram and Pareto). Continue reading
My second #Excel Video on YouTube
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
A compelling chart in three minutes…
In business world, we often compare actual sales to various benchmarks such as budget, target, and last year. In this post, I am going to show you step-by-step how to make a compelling chart for this purpose. This is basically a simplified version of bullet chart, and is super-easy to create. I hope you find it useful and relevant. Continue reading
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
Did you know… there are many nice Excel Templates readily available?
Did you know that there are many nice Excel Templates readily for usage? Next time when you start a New workbook, browse or even search for a template that suits your need. Or you may start from a template. Why re-invent a wheel? Continue reading
Posted in Excel Tips, Template
Leave a comment
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
Hard-coded range expands automatically with #Excel Table
The INDIRECT trick of using Structured Reference in Conditional Formatting Is it a feature or a bug? This is an extension of the previous post, in which we discussed the use of INDIRECT trick to deal with Excel Table in Conditional … Continue reading
wmfexcel 