Amazing 3D Formulas in Excel & How to Use Them




About this tutorial:

Video duration: 11:57
Excel File:
Excel Forum:

How to use 3D formulas, which are an amazing thing in Excel that allows you to use functions across multiple worksheets at the same time – there are, however, a few limitations with these formulas and I’ll also show you how to get around these in this tutorial.

Here, I’ll show you how to use 3D formulas to easily summarize data into a single master worksheet, which could also be a dashboard or simple consolidation sheet.

In…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

6 thoughts on “Amazing 3D Formulas in Excel & How to Use Them

    MAJID SIDDIQUE

    (February 15, 2020 - 2:51 am)

    Very Cool Trick

    Warren Hall

    (February 15, 2020 - 2:51 am)

    Clever and sensible design techniques; thanks!

    Haider Ali

    (February 15, 2020 - 2:51 am)

    love it. thanks for parenthesis fun.

    Paul Taylor

    (February 15, 2020 - 2:51 am)

    Great tutorial but you can have the sheets not next to each other by using a wildcard. I have put the formula below
    =SUM('*Q*'!B4)
    .
    Do like the () so you can move sheets out and still calculate.

    Rodolfo Requena

    (February 15, 2020 - 2:51 am)

    Great! Many thanks 👏

    darryl morgan

    (February 15, 2020 - 2:51 am)

    Awesome Tutorial! Just Picked Up Some Neat Little Tricks Thank You Sir :):):)

Leave a Reply

Your email address will not be published. Required fields are marked *