Blog Stats
- 2,319,187 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?
- Show number in thousand (k) or in million (M) by using custom format
- When unhide row doesn't work...
- 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
- Dropdown calendar in Excel
- Open an embedded Excel file during a slide show in PowerPoint?
- Filter a list of items from a long long list
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: October 2018
Trick or Treat 2018
♪♫♬ This is Halloween, this is Halloween ♪♫♬ ♪♫♬ Halloween! Halloween! Halloween! Halloween! ♪♫♬ Please join me to welcome our special guest – Jack Skellington, appears on wmfexcel’s Excel sheet. ♪♫♬Halloween! Halloween! Halloween! Halloween! In this town we call home Everyone … Continue reading
Exciting Dynamic Array functions in #Excel 365
Have you heard of the new Dynamic Array functions recently available in Excel 365 (currently for Insider Fast users only)? If you are an advanced Excel user, you will be impressed by these new functions. They are simply awesome, super … Continue reading
Learn something new from something that I think I knew well…
Today is a public holiday in Hong Kong. A perfect break in the middle of a busy week. What did I do on a public holiday? Excel, Excel and Excel. 🙂 I watched a few videos from my favourite YouTube … Continue reading
Calculating CAGR with Goal Seek in #Excel
when the starting point is a negative number… Calculating CAGR is not difficult, all we need is the starting value, ending value and the number of periods. Then we use the formula: CAGR = (Ending Value / Beginning Value ) … Continue reading
Excel Humor #7 just happened to me…
Two years ago… I posted this: which turned out a real case to me last week… I printed 99 pages of report out of one worksheet by selecting 99 items on a slicer one by one. @_@
Adding worksheet background in #Excel
How to add worksheet background in #Excel? If there is a secret recipe for an interesting Excel training, it would probably be starting with something interesting… 🙂 So in a recent in-house training, I’ve prepared a special Sheet1 in the … Continue reading
Posted in Excel Tips
4 Comments