Using Excel As a Dashboard

Published

Introduction: Using Excel As a Dashboard

About: I work in industrial automation and spend any free time making.

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

- 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

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

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

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

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

Share

    Recommendations

    • Oil Contest

      Oil Contest
    • Make it Move Contest

      Make it Move Contest
    • Clocks Contest

      Clocks Contest
    user

    We have a be nice policy.
    Please be positive and constructive.

    Tips

    Questions

    Comments

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