2012 - Page 2 of 2 - Glide Training

June 2012

How-To Guide: Create a key or legend in Visio

Thursday, June 14th, 2012

Written by Jane Hames

I have been training and working with a client to create Visio diagrams such as flowcharts, swimlane diagrams and organisation charts.

The organisation charts have proved tricky due a complex structure within the organisation, a common issue, I know. To make the chart clearer, my client decided to change the fill colour of the boxes for different responsibilities and then asked how we could create a key or legend for this. There would be a few approaches, but this one is very quick and easy to do (providing you know how!).

How-To Guide: Look like a pro when starting a PowerPoint presentation

Tuesday, June 12th, 2012

Written by Jane Hames

Do you use PowerPoint as a visual aid when presenting? How do you start running the Slide Show?

I sometimes see presenters opening PowerPoint and then fumbling around for the Slide Show button to start the full screen show (I don’t mind admitting that I have been guilty of this in the past!).

Software Secrets: My process for Word headers & footers in sections

Thursday, May 31st, 2012

Written by Jane Hames

In Microsoft Word, Headers and Footers are a great way of being able to set the same information to appear at the top and bottom of every page in the document. Common examples of this are the page number, date, company name, copyright, titles or file location.

Tip for working with tables in Word

Thursday, May 24th, 2012

Written by Jane Hames

I often get asked this question: “I’ve inserted a table at the top of my Word document but now I can’t seem to get above the table: how can I click above the table to type my heading?”

How-To Guide: Reduce document size by compressing pictures

Thursday, May 10th, 2012

Written by Jane Hames

Do you insert pictures into Word Documents, PowerPoint Presentations (or even Excel Workbooks)? Do you need to email those documents? If so, it is worth learning how to use the very simple Compress Pictures feature which will reduce the file size. It only takes a minute and works a treat!

Excel How-To Guide: Sorting (without messing up your data!)

Thursday, May 3rd, 2012

Written by Jane Hames

OK, hands up who thought they knew how to sort a list in Excel and then totally messed up their data? My hand is up! I ask my workshop participants that question and I can’t think of an occasion when no-one has admitted to making the same mistake. Many of Excel’s most useful features are not obvious. Below are some hints for sorting data in Excel:

Excel How-To Guide: PivotTable Slicers

Sunday, April 22nd, 2012

Written by Jane Hames

PivotTables are one of Excel’s most powerful tools, designed to make data analysis quick & easy. This How-To Guide is aimed at those who already use PivotTables and want to learn some new techniques.

Software Secrets – Microsoft Project

Monday, April 16th, 2012

Written by Jane Hames

Do you manage projects?

For me, anything that has a start date, an end date, milestones and deliverables can count as a project. For something short and simple it probably “just happens” with a small amount of organisation. For more complex projects, Microsoft Project can be a great help with the scheduling of work, people’s time, equipment, costs, dates, and above all; “how will we achieve this on time, within budget & to a high standard”.

Quick & easy tips to gain you more time & greater control

Tuesday, April 3rd, 2012

Written by Jane Hames

I am a great believer in being as efficient as possible when using Microsoft Office and Windows to maximise the time I have to spend doing other things. In case you missed Glide Training’s Microsoft Office tips on twitter, here they are again to help you to become quicker and more efficient.