Tag Archives: Excel 365

Distinct count using functions in #Excel 365 is so easy

Have your ever wanted to count how many distinct items in a range? Though a common task, there was not build-in functional for it. Perhaps we can make a distinct list using advanced filter first then we count the outcome. … Continue reading

Rate this:

Posted in Excel 365, Excel Tips, Formula | Tagged , , | Leave a comment

Copy values from Status Bar in #Excel 365

You probably knew it… In Excel, when multiple cells are selected, we will see basic statistics of the selected cells in status bar: This is a very handy feature. But did you know… this handy feature has a nice touch … Continue reading

Rate this:

Posted in Excel 365, Excel Tips | Tagged , | Leave a comment

Unhide multiple sheets with #Excel 365

Photo Hunt time – What are the differences between the two screenshots? Three, Two, One… Answer: Did you see it? The long-awaited feature is finally here in Excel 365. The next question is how?

Rate this:

Posted in Excel 365, Excel Tips | Tagged , | Leave a comment

Unselect selected cells with #Excel 365

First of all, I wish you a happy, healthy, and Excellent new year of 2023! Unselect selected cells Maybe you knew this already … we can select multiple cells/ranges by holding CTRL key. However, there was no way to unselect … Continue reading

Rate this:

Posted in Excel 365, Excel Tips | Tagged , , | Leave a comment

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

Rate this:

Posted in General | Tagged , , , | Leave a comment

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.

Rate this:

Posted in Chart | Tagged , , | 1 Comment

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

Rate this:

Posted in Excel Tips | Tagged , , , , | 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

Rate this:

Posted in General | Tagged | Leave a comment