Excel Worksheet Tips: Creating Navigation Buttons

Excel Worksheet Tips: Creating Navigation Buttons In a previous excel post, I explained how to create hyperlinks. Extending from this, you can link this ability with some simple VBA to create navigation buttons, similar to ones that you would find on websites. 1. Firstly, click on the developer tab. 2. Click on the “Insert” icon.…

Read More

Excel VBA Tips: Introduction

Excel VBA Tips: Introduction Within excel, there are two sides to the program. The “front end” is the worksheet area where data is entered and the “back end” is the visual basic editor side. There are many different things that excel can do to help save time and allow you to become more productive. Why…

Read More

Excel Worksheet Tips: Hyperlinks

Excel Worksheet Tips: Hyperlinks When you have multiple sources of data and you wish to reference them all in one worksheet, it can get a bit messy to put all the data on one worksheet. Maybe you want to link to a web page? No problem! Creating hyperlinks in excel 1. Create some text which…

Read More

Mac Tips – Ctrl + Alt + Del on Mac

Mac Tips – Ctrl + Alt + Del on Mac There are times when you are using a program and all of a sudden it hangs and stops responding! After pressing: the left mouse button, the right mouse button, the spacebar, the enter key, the escape key and the backspace key, you realise that the…

Read More

Powerpoint help: Two instances of powerpoint

Powerpoint help: Two instances of powerpoint I discovered this problem today. With most of microsoft products, you can open more than one instance at the same time. However, in powerpoint, you cannot do this! Why? Who knows why Microsoft decided to not let you do this. But there are two ways to work around. Work-a-round…

Read More