Blog Stats
- 2,427,436 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"
- Show number in thousand (k) or in million (M) by using custom format
- When unhide row doesn't work...
- Filter a list of items from a long long list
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- 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?
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: August 2016
Excel Humor #6 – Probably the shortest and the best Excel Proficiency Test
Definition of Advanced Excel user varies according to expectation. Someone thinks advanced users should know all the VBA, Pivot Tables and be able to write super long formula. Someone considers oneself “Advanced” for knowing the basic of VLOOKUP. On … Continue reading
Insert or move a field into Pivot table without drag and drop
If you do Pivot Table, the following won’t be a stranger to you as you must do a lot drag and drop to pivot. But did you know that you may insert a field name and / or swap the … Continue reading
Writing a long formula in steps
Writing a long formula is not easy, even for an advanced Excel user. What I mean long is a formula with many nested FUNCTIONS within a single formula. The difficulty I am talking about is not related to whether you understand the … 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
Excel Humor #5 – Are you relying on Excel too much?
Are you an Excel Dependency? Do you use Excel even for simple maths? Sometimes I do. 🙂