Blog Stats
- 2,371,733 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
- Insert a text string into a specific position of another text string in #Excel
- Filter a list of items from a long long list
- Be cautious when using XLOOKUP
- Dropdown calendar in Excel
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Excel 365
What’s new in Excel 365?
Are you using Excel 365 but not sure what’s new? Have you heard about all the amazing new functions/features like Dynamic Arrays in Excel 365 but not sure what they are? Or you have no idea at all how Excel … Continue reading
Waterfall chart is just a few clicks away with #Excel 2016
Did you know, you can plot a Waterfall chart in #Excel in less than a minute…Provided that you are using Excel 2016 or later! 🙂 No Kidding! You may download a Sample File to follow along.
Dynamic Shrinking Dropdown with Dynamic Arrays in #Excel 365
The recent HOT topics about Excel should be the new Dynamic Arrays! After watching all the amazing demonstrations about the new Dynamic Arrays, I’ve decided to sign up to the Office Insider (Fast) programme (for Office 365 subscriber only). … Continue reading
Posted in Excel Tips
Tagged Data Validation, Dynamic Arrays, Dynamic Dropdown, Excel 365, MATCH
Leave a comment
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