- 1,987,006 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- When unhide row doesn't work...
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- Insert a text string into a specific position of another text string in #Excel
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Perform VLOOKUP with 2 lookup values
- Same day last year...
- Sequential number for visible rows only
- Open an embedded Excel file during a slide show in PowerPoint?
- Dropdown calendar in Excel
My YouTube Channel
- My Tweets
Author Archives: MF
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
Christmas has just passed while New Year is just around the corner. Party must go on! As a token of appreciation for you visiting my blog, I am going to present you a free gift – Party Expense Calculator, in … Continue reading
It’s not uncommon to insert a date stamp or time stamp on a spreadsheet. We may use the following functions to get the results easily: =TODAY() ‘to get the date of today =NOW() ‘to get both the date of today … Continue reading
🎵🎤Do you wanna build the Sparklines? Sparklines is not a new feature of Excel. It was introduced in Excel 2010. Yes, almost a decade ago. But I am quite sure it’s still something new to a lot of regular Excel … Continue reading
Can you spot the error in the above formula? It’s not about the new function of XLOOKUP. It’s about inevitable human error… If you are an Excel fan, you should be aware of the exciting XLOOKUP function in Office 365. … Continue reading
Have you ever seen an Excel sheet with in-cell bars to visualize the data like the ones below, and wonder how they are made? Believe it or not, you can do it in one less than a minute with Conditional … Continue reading
Just a quick reminder that registration for the awesome Excel Dashboard and Power BI courses by Microsoft Excel MVP, Mynda Treacy, closes on Thursday Nov 21, 8pm in Los Angeles, to be exact. With demand for Data Visualization skills and … Continue reading