Blog Stats
- 2,178,760 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
- Understanding Find and Replace in #Excel
- #Excel #PowerQuery Challenge – Add value to CSV data in cells
- Learn how to build effective #Excel Dashboard from Mynda Treacy
- Combine all visible worksheets from multiple #Excel files in a folder
- Quick Tip – Probably the quickest way to open txt file with #Excel
Top Posts & Pages
- How to sort bar chart in descending order?
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Filter a list of items from a long long list
- Sequential number for visible rows only
- Open an embedded Excel file during a slide show in PowerPoint?
- Copy data from strictly-protected sheet
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: November 2015
Excel Humor #1 – Home
I am now having fun somewhere in Tasmania; enjoying my vacation 🙂 So let’s have fun this week and the next.
Bug with copy and paste in Excel Table
Do check what you do! On top of human errors, there may be bug hidden. Continue reading
Nested IF vs. VLOOKUP – Which one to use?
A well-drawn flowchart or a well-organized table helps you write a successful formula effectively Continue reading
IF, it is too complicated…
Writing an IF function is quite straight forward, if there is only one logical test involved. For example, we want to comment on a shop’s performance by looking at its actual sales. If Actual hits Budget, then Good job, else … Continue reading
