Blog Stats
- 2,324,699 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?
- 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
- Filter a list of items from a long long list
- Open an embedded Excel file during a slide show in PowerPoint?
- Insert a text string into a specific position of another text string in #Excel
- Dropdown calendar in Excel
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: January 2017
Happy New Year of Rooster
Hi everyone, Today we celebrate the Chinese New Year🐔. No Excel tips but CNY greetings and blessings. Wish you a prosperous and rewarding new year ahead! Continue to excel. Cheers, MF
Posted in General
Leave a comment
Fill so good…
Answer to the 5 little Tips (tests) – Part 2/5 Fill a series (of sequential numbers) The task: Fill a big series of sequential number, say from 1 to 24567. Answer: You may find the answer to the question in this post: Fill … Continue reading
Transpose Data (Static and Linked)
Answer to the 5 little Tricks posted in the beginning of the year – Part 1/5 Transpose Data – Result is static This is actually a simple trick of using Copy and Paster (Special, Transpose). See? It can be done in a … Continue reading
Posted in Excel Tips, Formula
Tagged Array formula, Copy and Paste, Find and Replace, Paste Special, TRANSPOSE
2 Comments
5 Little Excel Tips (tests)
First of all, Happy New Year of 2017! Wish you all an Excellent year ahead! Let’s start the year with a simple “Game” which I developed for in-house Excel training in my previous company. All participants were expected to have basic Excel knowledge. … Continue reading
Posted in Excel Tips
Tagged Copy and Paste, Date, Fill, Find and Replace, Paste Special
Leave a comment