Blog

The right training will increase productivety, but what is the right training? Flexibility Targeted Training topics that you can use and spending time on those that matter the most, our trainers find out about how the people on the course use the software then adjust...

Forms are great for when you want to email a spread sheet to other people and they will complete a form and send the spread sheet back to you. A dropdown will allow someone to select from a list of choices then the number of the item in the list is returned. So if...

Today I have come across a problem I can’t yet solve so thought to share it in case anyone knows a simple solution (not copy and paste) or has come across the same problem. When creating a word table you apply a style, it might be one of the ones that has a different...

When you have several pictures or objects on the slide it can look neater if they are the same size or similar, by that I mean that if you have a lot of objects across horizontally but some have more information in them then others it might look better to have them...

If you have 3 pictures and want them to be spaced evenly across the page you can do this easily. You will first need to select all the objects you want spaced. Select the first object, and then use the shift key to select the other objects. Once you have all the...

There are two main ways to create a dropdown in Microsoft Excel. One is not good for a list of data, the other is quick, easy and will allow you to have several in one spread sheet. An entire column can be converted to be a dropdown. This is called Data Validation....

There are a few choices to show and hide rows, but one way is easier for other people who are viewing your spread sheet. This is using the grouping feature. Select the rows that you want to group together then click on the Data tab and select group. The rows will be...

Your inbox can be hard to go through, too many emails in one day. By changing the colour of emails that are from specific people they can pop out so you don't miss ones from important people. You use Conditional Formatting. In 2010 this can be found in the View tab,...

When you insert a date within Microsoft Word you can change the date format. This is available when you are inserting dates that automatically update or using a date field. By date field I am talking about a field code, these are codes within Microsoft Word that when...

When you have multiple objects on a slide it can be hard to line them all up, this can be true for all objects whether they be flow chart items, pictures or text boxes. there is a simple tool that can do this for you. First you need to select multiple objects. To do...

This view is fairly new, some of you might not have heard or used it yet, but it allows you to see your spreadsheet as if it were on papers laid out on a desk or table. Why would you want to do this? You can see the spreadsheet as it would print out, and be able to...

Have you ever had a situation where you wanted to have an if statement test more than one condition in order have a true? I have seen people do this several ways, but there is an easy way. Nesting functions. You can use either the AND or the OR function where the...

I have used a master document for well over 10 years, in fact I was using them in 1996. So if you try and tell me that it must be a new feature, forget it. If you use very large documents then this is a feature that you must use. Have you had a document that is too...

Most of us know that we need to keep our document size down if we want a document that is manageable. A lot of companies and home email accounts have a limit to the size of the attachment, and there is only so much room on a memory stick. But what makes files large...

When you add text boxes and objects to slides within PowerPoint it can be difficult to get them into the centre. There is the long way, not so long way and the really quick way to do this, which do you think you do? The really Long way is to add the object to the...

You can calculate with percentages and to get percentages using excel. To find out a percentage value of a number it is a simple multiply. For example if you want to find out what 10% of 35 is the calculation would be: = 35 * 10% When you use the percent symbol Excel...

This has only been around for a few versions but is a great feature that can enhance presentations and documents. But what is it and what does it do? You can see from the picture that there are quite a few choices. From Organisational charts (hierarchy) to Cycle and...

When creating documents that you not not want others to be able to edit saving as a PDF is the best way. It depends on the version of Word how this is done. If you are using Word 2007 and 2010 then this should already be installed and you can save your document, then...

When you create letters in word it is a quick step to create either an envelope or a label for the address. This is one of the quickest, just highlight the address, if you want the name included in the label, highlight that too, then press envelopes and labels. Where...

Have you entered a time amount into a cell and not have Excel acknowledge it as time? You ask your colleagues and it works on their computers, or not but you can't see why it is not working. Anytime I have seen the time not working it has been because of the format....

Sometimes you do not want anyone to be able to make any changes to your spreadsheets, you may not want them to even view them in Excel. For these cases saving the spreadsheet as a PDF file could be the solution. In Excel 2007 and above you can save as a PDF file. This...

I hear a lot of people, especially the self employed who say they should start a blog. But months and years later they are still not blogging. Why? There are a few ways to start blogging, one is to add a blog to your website then add blogs on a regular basis. For most...

Depends. Are you making a lot of money from the website? Are you just starting out? If you have never made a dime from your site then you should not be Spending a lot on it .l Know several people who have started a business, paid over £1,000 for a website and did not...