November 2020

One-to-one Training and Consultancy

Monday, November 2nd, 2020

Individual one-to-one training sessions can go into greater depth than is viable in a group scenario, which can be extremely beneficial for power users.

Another popular application for one-to-one sessions is where a train-the-trainer approach is sought, in order to facilitate future in-house learning.

On Site Q&A Workshops

Monday, November 2nd, 2020

Q&A Workshops take more of a relaxed conversational approach to training. They can take place either in the form of a group forum, or with the instructor walking the floor of the office to speak to users in their day-to-day environment.

On Site IT Classroom Training

Monday, November 2nd, 2020

on-site IT classroom training – the classic setup. A room of people on laptops, and one instructor up the front.

Traditional yet interactive sessions for up to eight people. A lively modern approach combining presentation, live demonstrations, hands-on practical sessions and full course notes for attendees to take away.

Online Google Workspace Training

Thursday, October 22nd, 2020

online Google Workspace Training

Many organisations are making the change from Microsoft Office to Google Workspace (formerly known as G Suite). Google Workspace has some great tools for collaborative working and we help organisations to maximise the opportunities that it offers.

On Site Google Workspace Training

Thursday, October 22nd, 2020

on-site Google Workspace Training

Online Microsoft Office Training

Thursday, October 22nd, 2020

Online Microsoft Office Training

We design and deliver bespoke Microsoft Office training courses tailored to your requirements. We can cover any version from Office 2010 to the latest 2019 release (including Office 365), depending on which is used in your organisation.

On Site Microsoft Office Training

Thursday, October 22nd, 2020

on-site Microsoft Office Training

On-Site IT Training for Business

Wednesday, October 21st, 2020

Even today with increased home working, on-site IT training for business and public sector organisations alike remains an important activity.

We design bespoke IT training programmes for you and your team, and deliver training sessions on-site at your premises. Whether you’re using software from 2010 or 2020, or plan to switch platforms entirely, we can help.

Go to linked cells in an Excel formula (Quickly!)

Monday, July 4th, 2016

Written by Jane Hames

If you have set up a formula in one workbook that uses cells from a different workbook, the two workbooks become linked. It is useful to be able to go to linked cells in an Excel formula, and it would be great to be able to do that both quickly and easily!

Here’s the slow way: If you are on the cell that contains the formula, you can use Trace Precendents, double click on the dotted line and then use Go To to go to the cells used in that formula. go to linked cells in an excel formula

There is quicker way! It takes several clicks to get there using the method described above, but there is a very quick keyboard shortcut that does the same thing.

If you have tried to use Google to find this shortcut key, you might have trouble. I found it very tricky to find a search phrase that explained what I wanted to do. Asking amoungst a group of Excel users it seemed that this shortcut was a mystery until one of the group had a sudden recollection of what the shortcut is. Now, those of you who know me and/or follow my posts, I certainly don’t believe in keeping these kind of software secrets as secret, so here’s what you need to know:

Click on the cell that contains the formula.
On the keyboard, press, CTRL [
You will taken to the first cells used in the formula. (Regardless of whether or not the linked workbook was open already.)