Category Archives: Excel 365

Distinct count using functions in #Excel 365 is so easy

Posted on February 19, 2023 by MF

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

The modern way to shortcut in #Excel 365

Posted on February 12, 2023 by MF

We all know that shortcut keys boost productivity in Excel as we can perform certain actions quickly with just a few keystrokes… if we can memorize the shortcut key combinations. Be frank, how many shortcut keys do you remember? Normally, … Continue reading →

Rate this:

Posted in Excel 365 | Tagged | Leave a comment

Copy values from Status Bar in #Excel 365

Posted on January 28, 2023 by MF

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

Workbook Statistics in #Excel 365

Posted on January 21, 2023 by MF

Whichever version of Excel you are using, you will see a lot of useful information about your worksheet/workbook in the Status Bar. Having said, many users are not aware of the presence of the status bar. Are you one of … Continue reading →

Rate this:

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

Unhide multiple sheets with #Excel 365

Posted on January 14, 2023 by MF

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

Posted on January 7, 2023 by MF

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