[Affiliate]
Blog Stats
- 3,288,028 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Perform VLOOKUP with 2 lookup values
- Show number in thousand (k) or in million (M) by using custom format
- Dropdown calendar in Excel
- Sequential number for visible rows only
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Dense Ranking with Power Query - Unexpected Behavior and Workarounds
- Copy data from strictly-protected sheet
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- How to replace value with a value from another column in Power Query
- #Excel Add current selection to filter. What it does?
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Training
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
Transform boring Excel reports into Business Intelligence
Dashboard Course by MYNDA TREACY is now open Last week, I shared the news about the free Excel Dashboard Webinars by Mynda. I hope you did find a time to join the webinars. If you haven’t watched the Webinars and … Continue reading
Boost Excel Skill with Pivot Table
I think I must have missed the email from Mynda Treacy regarding the Xtreme PivotTables Course on her site: myOnlineTrainingHub, otherwise you should have read this post earlier. I use Pivot Table a lot and consider it a must-have skill … Continue reading
Don’t Miss Out on the Early Bird Registration for Allen Wyatt’s Excel Macros for Beginners course
About a week ago I let you know about Allen Wyatt’s Excel Macros for Beginners course. At the time, I invited you to visit Allen’s overview for the course, and I told you that you could register for this excellent … Continue reading
Want to learn Macro? Here’s the chance.
If you have been following my blog, you should know that I focus on tricks and tips of “preset” ways in Excel. For some people, using those preset ways is enough, but for others, Excel may be a bit restrictive … Continue reading



