Blog Stats
- 2,374,321 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?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Perform VLOOKUP with 2 lookup values
- 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)
- Open an embedded Excel file during a slide show in PowerPoint?
- Filter a list of items from a long long list
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: June 2017
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
The basic of Form Controls
Want to work like an Excel Pro? Learn more about Form Controls. Have you seen someone using Check box, Option Buttons, Scroll Bars on their worksheets and be impressed? You may wonder how they made it and think that is … Continue reading
Excel Humor #10 – WannaCry moments in Excel
There must been many others. Please share in comments. 🙂
The amazing SUMPRODUCT
Advanced use of SUMPRODUCT for multi-conditional SUM In the previous posts, we talked about the basic of SUMPRODUCT, the behaviors of logical values (i.e. TRUE/FALSE) when they are put into basic mathematics operations. These set the foundation to understand the … Continue reading