- 2,324,662 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- How to sort bar chart in descending order?
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- 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?
- Insert a text string into a specific position of another text string in #Excel
- Dropdown calendar in Excel
- Be cautious when using XLOOKUP
My YouTube Channel
- My Tweets
Author Archives: MF
In Excel, it is a common (but not necessarily a good) practice for people to add a thin blank column in a table to give a visual effect of divider. Like the screenshot below: To insert a blank column in … 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
Take a look at the challenge presented above. Is it possible to do it in Excel? Be honest, without Power Query, I have no idea how to do it but manual work. 😁🤦♂️ Believe it or not, with Power Query, … Continue reading
Following the techniques used in the previous post , we can perform many Excel magics for different scenarios. On top of my mind is to replace blank cells with zero. The first task is to select all blank cells in … Continue reading
Guess what? We are going to do it with a sequence of keyboard shortcuts only. Believe it or not, it requires only 8 key strokes: Ctrl+A => Ctrl+G => Alt+S => k => Enter => Ctrl+- (minus sign) => r … Continue reading
Power Query is magically powerful, yet it is not well known to majority of Excel users. I think most Excel users are not even aware of its existence… So, let’s talk about how Power Query could solve a real-life problem … 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
Append Queries + Group By = Another alternative for a better Full Join In the previous post, we explored an alternative way to perform FULL OUTER JOIN with Left Outer Join + Right Anti Join, followed by Append Queries in … Continue reading
Left Outer + Right Anti = A better Full Join A sample file is available below. If you prefer reading to watching, please continue to read this post. The situation: I have two tables. One is Sales Table; One is … 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
Today is a special day. Today is February 29th, which happens only once every four years. And today is Saturday, when I usually post a new blog. So let’s talk about how to determine if a year is leap year using … Continue reading
Last week, I posted a video and blogpost in response to a challenge from Mr. Excel . And this week, Mr. Excel has collected viewers’ solutions and post a video to summarize different techniques used for solving the same question. … Continue reading
I really like Power Query (in both Excel and Power BI). Honestly I do not know much about the M behind the scene (still learning it piece by piece). Nevertheless, I’ve got the POWER simply through the User Interface of … Continue reading
In about 5 years ago when I was still using Excel 2010, I wrote a post Compare two documents for changes – Word and maybe Excel. Lukas left a comment: In the Inquire Add-In you have the option to compare … Continue reading
Basic of Two way Data Table This is an extension of the post What-If analysis in #Excel. If you do not know about Goal Seek or One-Way Data Table, you may read Start the new decade with Goal Seek in #Excel and What-If … 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
Basic of One way Data Table This is an extension of the post Start the new decade with Goal Seek in #Excel. In that post, we talked about using Goal Seek to find the initiate savings required to obtain a … Continue reading
Interesting application of Power Query for real life problem – See how to transform table into different layout using Power Query I came across this Power Query Challenge from Computergaga and I found it really interesting as it seems that … Continue reading
Happy New Year of 2020! Wish you all an Excellent year decade ahead! 😉 Have you made your new year resolutions? Or you are relying on Excel to set your goals of the year? Did you know that Excel has … Continue reading