Introduction: Using Excel As a Dashboard

Picture of 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

Picture of Get Started

- 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

Picture of Add the Hyperlink

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

Picture of Test It

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

Picture of Get Fancy

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

Picture of Get Real Fancy

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

Comments

Fungineers (author)2016-12-04

I've been wanting to make something like this, since my life basically revolves around Excel. Thanks!

About This Instructable

2,924views

29favorites

License:

Bio: I work in industrial automation and spend any free time making.
More by syfrog:GONK Droid From JunkFile Creating With Python ProgrammingBAYMAX: My first Python Project
Add instructable to: