Use the Indirect Function to Create Excel Dashboards

The Indirect Function in Excel refers to a Text String in a cell. This is a handy tool to use - in conjunction with drop-down list created with Data Validation - for adding interactivity to an Excel Dashboard Report.

I use two different examples of the Indirect Function in this lesson. For the 2nd example I show you how to quickly lookup the value in any cell using the SPACE BAR as the "union" operator.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of the resources and tips that I offer.

Danny Rocks
The Company Rocks

Category:

Education

Tags:

• Excel
• Lookup
• Functions
• Indirect
• Function
• Named
• Cell
• Ranges
• Data
• Validation
• Keyboard
• Shortcuts
• Drop-down
• lists
• Dashboards
• software
• technology
• management
• Training
• Software Tutorial
• Microsoft Excel
• Educational
• Office
• Microsoft Office
• Business
• Information

[kfong6932]

Hi all, this is another great tutorial. Thanks......

[DannyRocksExcels]

@kfong6932

Thank you. I am so pleased that you enjoyed my tutorial.

Thank you for sharing your comment.

Danny Rocks

The Company Rocks

[RAVISHTEJSINGH]

excellent ,thank u it help me lot..

[DannyRocksExcels]

@RAVISHTEJSINGH

Thank you. I am pleased that you enjoyed my video tutorial.

Danny Rocks

The Company Rocks

[Exlslearn]

Hi Danny, this such a great video. I'm trying out the INDIRECT function to populate lists based on a list in a preceeding column (Excel2010). My challenge is Excel gives an error if the name of the primary list is more than one word & has a spacebar in it. I've tried to use underscores to remove spacebars, but would prefer not to use _. I'm using =INDIRECT(SUBSTITUTE(B5, "", " ")) but it still doesn't like spacebars. Any tips to make Excel primary list names work with spacebars?

[DannyRocksExcels]

@Exlslearn

Thank you! I am pleased that you enjoyed this video so much.

Let me try to help you:

1) As you saw in the video, I was using the INDIRECT() Function to refer to a "Text Strign" - but not just ANY "Text String."

2) This "Special" Text String was the Name for a "Named Range" of values.

3) In Excel, All "Named Ranges" MUST begin with a Letter and they CANNOT contain any SPACES.

4) So there, you are facing the main challenge - Named Ranges CANNOT containg any Spaces.

Danny

[justjustinme]

Hello. My employer told me to learn how to create / use Excel Dashboards... but I don't know what they are, or how and where to start! Never even heard of Dashboards before. Any idea on where I should go to learn about them and how to create them?

I use Excel, but use basic functions such as sum, multiply, add, and a few basic if functions. I also use the PMT function (I am in accounting class).