[Affiliate]
Blog Stats
- 3,028,942 hits
-
Join 3,888 other subscribers
- 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
- How to replace value with a value from another column in Power Query
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Insert a text string into a specific position of another text string in #Excel
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Rename column names in a dynamic way with #Excel #PowerQuery
- Open an embedded Excel file during a slide show in PowerPoint?
- Send a cell content to Google search
- Perform VLOOKUP with 2 lookup values
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
A twist to turn Keep Duplicates into Keep Unique in #PowerQuery
In Power Query Editor, there is a button of “Keep Duplicates” in the ribbon. It’s located under Keep Rows in the section of Reduce Rows in the Home tab of the ribbon. With this, it is super easy … Continue reading
Keep the rows you need with #Excel Power Query
When we import data into Power Query editor, we should set the scope of data that we need. That means selecting only the rows and columns required for further processing. In the following video, I will show you different ways … Continue reading
Data Type is NOT formatting in #PowerQuery
Let’s think about this scenario. In the first encounter of Power Query, you were presented with demonstrations that show all the powerful transformations done by Power Query. You were surprised and amazed with the demos. Normally we did not pay … Continue reading
Close and Load… to table or to connection? That’s the question
Close and Load to is the last step in Power Query, but the first step in your reporting process. When I first learned Power Query, I preferred loading the result to Table as I could “see” the result on a … Continue reading
How to put the Date Modified info on #Excel worksheet using #PowerQuery
If we want to see when a workbook was last modified, we can see the information from File Explorer, or Excel Info Very handy indeed. However, if you want the information to be put on a worksheet, there is no … Continue reading
Getting Start with #PowerQuery in #Excel
As mentioned in the previous post, the awareness of Power Query is extremely low. In my experience, the hurdle for people who have learned Power Query but not feeling comfortable in using it is the fact that they are not … Continue reading
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
Fixing inconsistent data type in lookup table in #Excel
A common VLOOKUP problem with an easy fix The situation – VLOOKUP fails… Have you ever encountered something like this? This is quite common. We are sure that the VLOOKUP formula is correct. We are sure that the lookup values … 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 using #PowerQuery
This is an extension of the previous post. Here’s the task: If the data is coming from a CSV file, the solution is super easy. You may download the sample CSV file to follow along.
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
How to replace value with a value from another column in Power Query
It is a common task to replace a value with another value in Power Query. It can be easily done with “Replace Values”. However if you want to replace a value with the corresponding value in another column, it’s not … Continue reading
The Power BI Journey
Note: This is not a “how-to” post. In this article, I share my thoughts on how people start their Power BI journey, based on my observation and imagination. 😁 When you say you want to learn Power BI, what do … 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
wmfexcel 