Use the Indirect Function to Create Excel Dashboards

[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).

[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