Excel Training UK

From first time Excel users to advanced VBA experts, we offer Excel training courses to suit all abilities. Our popular Excel beginners courses are ideal for learning the basics of Microsoft's flagship spreadsheet application but we also offer advanced & tailored courses as well as a VBA for Excel course.

How to add a Website Link in Excel

Microsoft excel has a great Hyperlink function which allows you to link to websites, other worksheets and workbooks!
It’s very easy to do and all you need is this simple piece of code to do it –

=HYPERLINK(“add the link address here”,“and add the name of the link here”)

The link address is URL of a website that you want to link to and the link name is the text you want to appear on the spreadsheet.

e.g. =HYPERLINK(“http://www.exceltraining.org.uk/”,“Excel Training”)

On the spreadsheet only a hyper link containing the words ‘Excel Training’ will appear. Once clicked it will open up your internet browser and take you straight to the chosen site, in this case – http://www.exceltraining.org.uk/.

Don’t forget – both the URL and the link name MUST be between the “ ”

How to save information on a shared Excel Spreadsheet

Its all about Sharing

excel training sharing

by Ryan Roberts on Flickr

If you want to create an Excel Spreadsheet which you want to share between multiple computers then this is a very useful tool for a busy workplace that needs to be up to date.

First you need to open the document you want to share with other people. You will need to create your own individual user name so that others know who has changed what.

To do this you need to click on the –

  • Microsoft Office button
  • Click Excel Options
  • Click on Popular
  • and then type your name in the User Name field
  • Then click OK

Now that you have your username set up you now need to change the spreadsheets security settings. Click on the –

  • Review Tab
  • Click on Share Workbook
  • Tick the box that says ‘Allow changes by more than one user at the same time. This also allows workbook merging’
  • You can also click on the Advanced Tab if you want to change any of the Update Settings, its all a matter of preference.

You can now edit a spreadsheet by multiple people at the same time, when you do update; others will see it and a box will appear over it saying your name.

Page 13 of 13« First...910111213