[Affiliate]
Blog Stats
- 3,028,946 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
Tag Archives: Power Query
20% off Excel and Power BI Dashboard Courses
Mynda Treacy’s popular Excel and Power BI Dashboard courses are back Dashboard reports, are no longer a buzz word, they’re a standard reporting tool for all kinds of industries and they’re an in-demand skill for Excel users everywhere. In fact, IBM project … Continue reading
Are you ready to turn boring Excel reports to Business Intelligence?
Well, I know. You may have read similar topics before in my blog. You are now seeing it again because the awesome Excel Dashboard Course by Mynda Treacy is now open. What’s more exciting? Mynda puts her popular courses “Excel … Continue reading
[Guest Post] 5 things you should start doing with Power Query
This is a guest post by Puneet Gogia. Power Query is a revolution. It’s a (part of a) complete self-service BI tool which can help you in importing, connecting, shaping, cleaning and sharing your data with little efforts. It has … Continue reading
The powerful Power Query and the interesting TechNet Virtual Labs
As you may be aware of, I haven’t written a real blogpost recently. I was super busy at work in the past month. No surprise. There are moments Excel won’t help me much at work, especially when bosses like PowerPoint (and PDF) … Continue reading