Tag Archives: Excel 365

#Excel IMAGE function is great, but…

Posted on December 7, 2024 by MF

If you are using #Excel365, you have the privilege of many powerful functions. IMAGE is one of them! This function works like a charm with just one argument required. Think about a simple formula like this: =IMAGE(A1) It returns the … Continue reading →

Rate this:

Posted in Excel 365, Formula | Tagged , | 2 Comments

VLOOKUP across tables is so easy in #Excel365

Posted on January 14, 2024 by MF

Again, a picture tells a thousand words. The following GIF shows what we want to achieve: Seriously? A simple VLOOKUP formula stated below would do. What’s the challenge? =VLOOKUP(G3,B:E,4,FALSE) Yes, you are right if all these tables reside on the same worksheet. What if … Continue reading →

Rate this:

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

(Kind of) Paginated report in #Excel

Posted on October 14, 2023 by MF

A picture tells a thousand words. This is what we want to achieve. It is only “kind of” a paginated report because it works only on the application (Excel) but not for printing. 😅 With dynamic array and new functions … Continue reading →

Rate this:

Posted in Excel in Action | Tagged , , , | Leave a comment

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

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

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

What’s new in Excel 365?

Posted on February 6, 2021 by MF

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

Posted on May 18, 2019 by MF

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

Posted on November 14, 2018 by MF

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

Posted on October 27, 2018 by MF

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