Blog Stats
- 2,371,986 hits
- 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?
- 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
- Insert a text string into a specific position of another text string in #Excel
- Filter a list of items from a long long list
- Be cautious when using XLOOKUP
- Dropdown calendar in Excel
- Open an embedded Excel file during a slide show in PowerPoint?
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
What’s new in Excel 365?
Are you using Excel 365 but not sure what’s new? Have you heard about all the amazing new functions/features like Dynamic Arrays in Excel 365 but not sure what they are? Or you have no idea at all how Excel … Continue reading
Combine files of (slightly) different layouts in a folder with Power Query in #Excel
Part 2 β What if we have inconsistent table structures across files? Note: this is a long post. π This is the continuation of previous post. Suggest you read that post first if you are new to Power Query. Moreover … Continue reading
Combine files in a folder with Power Query in #Excel
Note: This is a long post… π Part 1 – What Power Query does for us in the process? If you know about Power Query, you should know that combining files in a folder is a powerful yet simple task … Continue reading
Add emoji to your numbers π in #Excel
Is it possible in #Excel? Of course, as you have just seen it! π Indeed, it’s easier than you may have thought about. We can do it by custom format. First of all, select the cells that you want to … Continue reading
Farewell 2020… Happy New Year!!
2020 comes to an end in just a few hours . I guess itβs the first time majority of people shares the same new year wish. It was a though year. Keep in faith! Tomorrow will be a better day! … Continue reading
Posted in General
Leave a comment
Quick Tip – Close all #Excel workbooks at once
Have you ever had more than 10 workbooks opened at the same time? Did you spend too much time to close them all one by one? If so, you will love this simple trick to close all workbooks simultaneously! The … Continue reading
Dense Ranking with Power Query – Unexpected Behavior and Workarounds
This post is inspired by the article – Dense Ranking in Power Query, written by PHILIP TREACY from myOnlineTraingHub. The first part of this post is a summary of what I read from Philip’s post. While the second part is … Continue reading
Replace values in filtered ranges using Copy and Paste trick in #Excel
Situation: In a filtered range of data, we made few changes on the side. Then we want to replace the original values with the updated values. What action appear on top of your mind? Copy and Paste of course. But… … Continue reading
Have you encountered any weird formula in #Excel?
Happy Halloween! π» Let’s do something fun. You are invited to leave your comments below. For what? For sharing with us any “weird” formula that you have ever seen in Excel. Real cases please. π Wait… what do I mean … Continue reading
Input data on one worksheet… Get summary on another worksheet in #Excel
It is a common task that we want to input and maintain all data on one worksheet, and display summary on different worksheets. A typical layout will be similar to the screenshot shown above. One “Input” sheet, and then one … Continue reading
SUM the last X non-blank values in a column in #Excel
Got this question from my brother. He is tracking scores for game he plays with friends. The game can be played with up to four players. He wants a formula to calculate the last 10 scores of a player. He … Continue reading
Understanding Find and Replace in #Excel
Find and Replace is a very handy tool in Excel. It helps you to find a value quickly. You may then replace the value found with another value, either one by one or replace all at one batch. To use … Continue reading
#Excel #PowerQuery Challenge – Add value to CSV data in cells
As always, a picture tells thousand words. The above image explains clearly what we want to achieve, with Power Query in Excel of course. This problem was bought to my attention when I watched the Dueling Excel Podcast #192 by … Continue reading
Learn how to build effective #Excel Dashboard from Mynda Treacy
Did you know… you can create such a beautiful dashboard using Excel? Did you also know… this visually appealing dashboard was built in just more than 30 minutes? No kidding! Check it out HERE and you will see. Want to … Continue reading
Combine all visible worksheets from multiple #Excel files in a folder
It is a common task for us to combine all worksheets in a workbook. It could be a time consuming task without Power Query. With Power Query, it’s piece of cake. π Wait? What about if you want to combine … Continue reading
Posted in Power Query
Tagged Combine Workbook, Invoke Custom Function, Remove Top Rows, Unpivot column
Leave a comment
Quick Tip – Probably the quickest way to open txt file with #Excel
Are you tired of seeing the (Text Import) Wizard π§ββοΈ every time you open txt file with Excel? In this super short video, you will see probably the quickest way to open a txt file with Excel.Β Enjoy! π
Posted in Excel Tips
Leave a comment
Lovely stickers in #Excel 365
Do you use stickers when you use communication apps like WhatsApp?Β I guess that’s almost a must-have features right now for communication apps. Would it be nice if you can use stickers in Excel too? Yes… you can, if you … Continue reading