Using Excel As A Dashboard
An often overlooked but very useful tool in Microsoft Excel is the ability to add hyperlinks to objects. By doing this you can create a visual shortcut page to all the files, websites and even applications you use the most. And you will not have to clutter your desktop with icons.

Step 1: Get Started

Using Excel As A Dashboard
- Open a new workbook in excel.- From the overhead insert tab select a shape and add it to the worksheet.- Right click and exit/add a name to the shape.

Step 2: Add The Hyperlink

Using Excel As A Dashboard
Using Excel As A Dashboard
Once to have your shape created and formatted to your liking - Right click on the shape and select add hyperlink from the menu.- Select the file or website you want to open with this button.

Step 3: Test It

Using Excel As A Dashboard
Now the shape you created is selectable.Use your new button and make sure it goes where you want it to.

Step 4: Get Fancy

Using Excel As A Dashboard
Take your buttons to another level by adding images inside the shapes.Visual buttons are always easier and faster to recognize.

Step 5: Get Real Fancy

Using Excel As A Dashboard
Now add the BAM!! and take it up another notch.Populate a whole sheet with buttons to create your very own command interface.Add macros to your buttons and they can open other applications for you, sign you into your email account, display the current time and date.... The inter-web is full of examples to make excel do pretty much whatever you want it to do...
 
 

Tag cloud

make build easy simple arduino making homemade solar laser printed portable cheap mini building custom cardboard wooden create super lego turn paracord chocolate your paper light intel