Blog Stats
- 2,915,327 hits
-
Join 3,157 other followers
- 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
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Perform VLOOKUP with 2 lookup values
- 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)
- Send a cell content to Google search
- Insert a text string into a specific position of another text string in #Excel
- Open an embedded Excel file during a slide show in PowerPoint?
- Highlight weekends and holidays using Conditional Formatting in #Excel
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: Excel Tips
Will Power Query change your life?
Well, it depends! Depends on what? It depends on what you do and how you do it in Excel. 😉 True/False moments Excel is the core software I use for work I use Excel for data analysis I need to … Continue reading
Quick Tip – Edit #DAX formula in #PowerBI Desktop efficiently
Let me share a quick tip of Power BI today coz I work with Power BI Desktop a lot recently. 😎 What I am going to share in this post is my favorite shortcut key in Power BI Desktop. Honestly, … Continue reading
Highlight differences in two ranges with Conditional Formatting in #Excel
Happy New Year! Wish you all an Excellent Year of 2022! To kickstart the year, let’s share a trick to solve a common task – highlighting differences in two ranges, with conditional formatting. Common enough, right? The ingredients are simple, … Continue reading
Highlight different cells in two lists in #Excel
Finding and highlighting differences should be a common task in Excel. Most of the time, it’s solved by formula or conditional formatting. Either way, we need to construct a simple formula like the one below to compare the cell contents … Continue reading
Do Not input “-” for zero. Use proper formatting in #Excel
Do you input a hyphen to represent zero? If you do, please stop doing so in the future. The proper way of displaying “-” for zero is to apply relevant cell format to it. E.g. Using Accounting format with no … Continue reading
Posted in Excel Basic, Excel Tips, Format
Tagged Custom Format, Format, Power Query, Replace Values
Leave a comment
Convert numbers of different digits into text of fixed digits in #Excel
The situation We have an extensive list of numbers in different digits, say from 10 to 13 digits. The problem is, they are supposed to be numbers in thirteen digits stored as text. (Of course, in our example, we work … Continue reading
7 Copy and Paste Tricks I wish I knew sooner in #Excel
Regardless of what we do with Excel, Copy and Paste is something we do on daily basis… or even hourly basis. 😁 You may be thinking, every one knows Copy and Paste. Yes, probably. But is every one using Copy … Continue reading
Protect your cells in #Excel
Think about this… you have spent hours of work building your wonderful Excel template. Needless to say there are lots of formulas that took you hours of thorough thoughts and considerations, on top of the beautiful formats and layouts. You … Continue reading
[Video] – Swap cell contents with a simple mouse trick
It is super easy to move cells around by drag and drop. The standard drag and drop action however replaces contents in the destination cells. What if we want to preserve destination cells and just shift them up or right? … Continue reading
SUMIF vs. GETPIVOTDATA in terms of performance in #Excel
Did you experience a slow workbook? How slow? Let’s say it takes more than 2 minutes to just open the file. This is actually what a colleague asked me for help. When I opened the workbook, I saw LOTS of … Continue reading
The very hidden gem of AutoFilter in #Excel
Don’t get me wrong. I am not talking about the Filter button sitting on the Data Tab of ribbon, although they look almost exactly the same. I am pretty sure that most people who use Excel five days a week … Continue reading
The proper way to filter values not equal to zero in #Excel
I didn’t think of blogging about this topic before. I thought that it is so straight-forward. Nevertheless, there is another way of doing so which is even more straight-forward BUT may give you unexpected results later on. And to my … Continue reading
Reapply Filter in #Excel
Did you notice that there is a “Reapply” button next to Filter on the Data Tab of ribbon? And wondering what it does? 🤔 Indeed, the “Reapply” button is dim until you have applied filter to at least one column. … Continue reading
Data Cleansing is never easy, even with #Excel Power Query
Don’t make me wrong. I am not complaining Power Query at all. If you have followed me for a while, you should know that I am a big fan of Power Query indeed. It is simply powerful! With Power Query, … Continue reading
Filter: It’s easy and not easy
Applying filter in Excel is a very common task. We used to filter a dataset and focus on a subset of data that we are interested in. It is super easy to filter. The problem is, are you sure you … 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
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
wmfexcel 