In Why to Use Microsoft Office Diagnostics we discussed the benefits and diagnostics options available. Here we are going to discuss how to use the diagnostics.

Before you start the diagnostics:

• Run the diagnostics when you do not need to use your computer
• Make sure you are connected to the Internet
• Close other programmes
• Make sure you have Microsoft Office installation disk in case there are problems and your program will need an access to the disk to repair

If Microsoft Word, Excel, PowerPoint or Access are still working then to start the Microsoft Office Diagnostics follow the steps:

1. Click the Microsoft Office Button , and then click Word Options (or Excel Options or PowerPoint Options or Access Options)
2. Click Resources
3. Click the Diagnose button
4. Click Continue, and then click Run Diagnostics.

If InfoPath, OneNote, Outlook, Publisher, Project, SharePoint Designer, or Visio are still working then to start the Microsoft Office Diagnostics follow the steps

1. On the Help menu, click Office Diagnostics.
2. Click Continue, and then click Start Diagnostics.

If any of the above programmes has crashed so badly that they not start, you can run Office Diagnostics from the Start menu.

1. In Windows, click the Start button
2. Point to All Programs, then to Microsoft Office and then to Microsoft Office Tools
3. Select Microsoft Office Diagnostics

To check which tests are available read Tips and Tricks: Microsoft Office 2007 – Why Use Microsoft Office Diagnostics?

Want more tips? Click on Microsoft Tips & Tricks

You probably get used to selecting text horizontally from left to right or right to left, for example, to format or copy it. For the left to right selection, click just before the beginning of a word, and while holding the mouse button down, drag to the end of the section that you want to highlight. For the right to left selection doing everything backwards achieves the same result. But what if you want to select a text vertically, for example, to apply some formatting to the first 2 words in the text of each line as on a picture? Here’s a handy tip.

You can select the text vertically. In order to do that, just hold down the <Alt> key on a keyboard whilst you are selecting the text as usually. You will get this result.

Now you can apply any formatting to it (here we selected Chicago font style).

Although in the example above we selected text at the beginning of the lines, you can make vertical selections anywhere on the page.

Want more tips? Click on Microsoft Word Tips & Tricks

You probably get very upset when your Microsoft Office application crashes down (closes down unexpectedly) while you are working on something important. It is not necessarily that the problem is within the Microsoft Office code. Computer viruses (read How to Protect Yourself from Viruses from Your Computer Health Part Two), disk failures, or laziness with respect to installing updates (read How to Stay up to Date Automatically from Your Computer Health Part One) are just a few issues causing this condition.

Microsoft Office Diagnostic is a tool included in Microsoft Office 2007 pack, allowing you to run a series of diagnostic tests that can help you discover why your computer is crashing. These tests will either solve problems directly or may help you with the ways to solve them.

These are the diagnostics that are run:

Setup Diagnostic – Files and registry are checked for errors occurring due to viruses or by hardware that is faulty or incorrectly configured. While running for about 15 minutes, the test may require the original installation source.

Disk Diagnostic – Hard disk is examined for errors logged by the Windows system and SMART (Self-Monitoring, Analysis and Reporting Technology) feature of your hard disk (if provided by disk drive manufacturers) to notice potential hard disk failure.

Memory Diagnostic – Random Access Memory (RAM) is verified for integrity.

Update Diagnostic – Your computer is tested as to whether it has the latest updates installed to make Microsoft Office more stable. You can install updates from Microsoft Office Online.

Compatibility Diagnostic – Different versions of Microsoft Office are checked for conflicts, as two different versions of Office installed on your computer can cause instability.

Check for Known Solutions – The crash report is tested and checked against the database of Microsoft’s crash cases for available solutions.

To find out how to run diagnostics, read How to Fix Errors Using Microsoft Office Diagnostics.

Every industry has its myths and misconceptions. And one of those is the problem that many IT professionals have with Access. Access is sometimes seen as one of the trickiest Microsoft Windows applications. Yet with the right know-how and training, it can be an asset for all kinds of organisations.

So why do IT professionals react against the idea of Access as a possible database solution?

Reason 1: It grows

Access is frequently used for everyday work activities – even when a larger, more powerful system is available. Sometimes a relatively small-scale Access database outgrows its original purpose to become central to an organisation. The challenge at this stage for IT professionals is to put a lot of work into revamping or upgrading the Access database. This is where some of them get grumpy. They want to know why the system wasn’t developed with a more sophisticated platform from the start. But unless you’re good at reading tea leaves, it’s not easy to look into the future and see how important an Access database is going to become for a company. The secret at this stage is to adapt the database to suit the changing needs of the business.

Reason 2: It needs support

The average Access database isn’t created by an IT professional. It’s set up by anyone from an office administrator to a sales manager. Any person who needs to store, manage and analyse information, basically. Which means it’s often not seen by an IT professional until there’s a problem. The glitch might be due to too much information, lack of training or the need for a new feature. The IT person might be called on, but not want to help because of the complexity of sorting it out. This is why in some companies, IT departments have banned the use of Access. But this is missing the point. The best approach is to assess how Access could work as an asset for an organisation.

Reason 3: It’s not professional

IT professionals can be tough critics. Some of them see Access as a toy instead of a real database and won’t use it. This could be something to do with the fact that a lot of Access developers are from a non-programming background. Unfairly, this prevents IT professionals from recognising the potential of Access. Perhaps they’re a little bit jealous. After all, Access is the most popular desktop database on the market.

Reason 4: It’s too easy

What’s wrong with something being easy to use? A lot, according to some people. Believe it or nor, there are IT professionals out there who won’t use Access precisely because it’s too simple to use. Daft, isn’t it? That’s exactly why clever people use it. It’s flexible, fast and it can help resolve a range of issues.

Reason 5: It’s not strategic

Access is so versatile it’s often the basis for a database used by just a few people. This type of database usually has one clear purpose and gets on with the job. In contrast, at enterprise level, an organisation will use highly complex, powerful and expensive to develop databases to drive its needs. Some IT professionals have a problem with organisations that don’t use these powerful databases at all levels. But why apply one answer to a whole range of different issues? After all, a flexible approach can help an organisation get the best out of IT, at every level.

Microsoft Word can’t do the hoovering – or make you a nice cup of tea. But it can put you in more control at home. Word checklists are ideal for helping you manage all kinds of activities in your very own castle. Who would have guessed that some simple Microsoft Word training could give you so much extra organisational oomph?

To do – stop using scraps of paper

Do you have scraps of paper with ‘to do’ tasks scribbled on them? Confusing isn’t it? And bits of paper have an uncanny knack of getting lost just when you need them. Keep it together with a Word activities checklist.

Keep track of the kids

Everyone knows that taking care of little ones requires extreme organisational resources. Even a trip to the local park can feel like an outing for an ‘A’ list celebrity. There are the bags, the toys, the clothes, the demanding dietary requirements….and that’s before you even get to the park! Why not create your own checklist to keep all those child-related chores on track?

Dream a little dream (and make it happen)

You know the saying – “What gets measured gets managed.” Create your very own dream checklist to state your goals and keep tabs on how close you are to them. Whether you’re working hard towards your ideal home or that perfect job, a checklist can help you clarify exactly what you want. And that should get you closer to your goal.

A gift for giving

Every year we know when those important birthdays are due, not to mention Christmas. But most of us still find ourselves rushing around the shops at the last minute to find the perfect present. How much would a present shopping checklist reduce your stress levels? You could even build in your time and budget for when the sales are on and grab the perfect present and a bargain at the same time!

Something for the book lovers

Still wondering where that favourite book went? Wish you could keep track of all the books you’d like to read in the future? Once you’ve got the knack by taking one of our Microsoft Word courses, you can create your very own Word checklist to keep track of your fiction, your non fiction and that new biography you’ve been wanting to read for ages….

There are so many other ways you can put Word checklists to good use. From preparing for big life changes like having a baby, to everyday essentials like keeping track of your bills. And all that gives you more time for a sit down and a nice cup of tea…

It can’t make a rabbit appear out of a hat or do crafty card tricks. But Microsoft Excel really can work wonders with your business inventory. Thanks to its (almost) magical powers, you’ll soon have all kinds of admin and management tasks covered. Yes, you know about Excel, you know it comes as standard with the Microsoft Office Suite and yes – you thought it was mostly for adding things up. But did you know that with Microsoft Excel training, you could be getting this supersmart software to boost the productivity and efficiency of your business?

Your magic wand

Work schedules, timesheets, stock levels, sales figures…have you ever wondered if there’s an easier way to keep tabs on them? On return from some targeted Microsoft Excel training you could be on your way to waving a magic wand over all of them! Excel lets you get truly inventive with your inventory. With MS Excel you can create and edit your very own spreadsheets for budget keeping, for inventory control and management, for creating customer contact lists, for staff attendance, and much more.

More power to you

Excel’s magic goes even further – putting you in charge of your inventory facts and figures. Its mathematical abilities can’t turn you into Carol Vorderman, but they will give you control over the most complex of calculations. Excel’s formulas are one of its most versatile features. Get the formula in place and it will allow you to keep control of everyday office figures right through to complex calculations for high-end business projections. The most magical thing, of course, is that once you’ve set up your formulas, Excel does all the work for you. The right kind of MS Excel training could put all this power at your fingertips.

Wizards on hand

Excel is packed full of clever little wizards to help you get all kinds of business tasks done. With just a short Microsoft Excel training course you could be on your way to managing many areas of your inventory – and your business – more efficiently. Excel allows you to create your very own database to suit your customer base, your stock and your schedules. One example is when a customer phones in and asks for a part number. You need to find out straight away if the product is available and in what quantity. With just a short MS Excel training course at intermediate level you‘d have the know how to use Hlookup and Vlookup functions and get the job done ASAP!

Excel makes your job easier to do and can even free up some of your time. Now that really is magic.

Bring some Excel magic to your business with an Infero training course at introductory, intermediate and advanced levels. As well as affordable IT and business training, we also offer helpful, no-obligation advice on your training options (and information about training grants of up to £1000)! Get in touch now.

In the “Putting the ‘Wow’ into PowerPoint Presentations – Part One – Readability” article we talked about how to make presentations readable. Here we learn how to make presentations more visually appealing.

PowerPoint – it’s one of the most commonly used presentation packages out there. That’s no surprise considering how easy it is to use. But you’d be surprised how many people aren’t making the most of this powerful software. Are you one of them?

Out of the 1 million PowerPoint presentations given every single day, many fail to make the most of images to create a great impression. A well-chosen image can grab our attention much more than lots of confusing words.

Here are some secrets for more attention grabbing PowerPoint presentations:

Picture this

You want your presentation to interest and inspire your audience. Using pictures or photos alongside your text will help people understand your message. And an unusual or amusing image could help keep your presentation in mind long after it’s over!

Aside from using images to make a point, don’t forget to use repeated background images to establish continuity between slides.

Get animated

Diagrams can be difficult to digest all at once. It’s often much more effective to present diagrams by revealing them one step at a time – rather than the whole thing in one go. For example, you could have a pyramid diagram revealing itself section by section from the bottom up.

There are lots of animation effects to choose from. They can help you control the flow of information, highlight key points and of course, keep your audience interested!

Double vision

So you’ve chosen the best images and pictures for your presentation, but how do you know they will win over your audience? It’s time to get someone you trust to take a look and see whether your images really do bring your talk to life.

Send your presentation over to a colleague or friend for review using Microsoft Outlook. Then your reviewer can view the presentation in the comfort of their own home or office and suggest changes to their copy of the presentation without having the chore of marking up hard copies. Once they’ve sent it back to you, you can add their comments using the PowerPoint reviewing tools.

Keep these simple rules in mind and you’ll soon be creating great looking presentations. A short PowerPoint training course could help you get even more out of PowerPoint and many other Microsoft packages.

Timing, teams and resources – a project is a complex mix of these aspects in any setting. That’s why it takes the right tools to manage projects effectively. Microsoft Office Project Standard 2007 is a powerful resource for more successful projects. It puts you in control of the workload, the finances and the people. And it’s designed to work seamlessly with other Microsoft programmes. Now it’s been updated, Microsoft Office Project is even more equipped for getting projects done – from the first task to the final outcome.

Advantages for your projects include:

See the impact of change

Now you can see every potential consequence of change – before you make it. Change Highlights automatically points out all the items that move as a result of the most recent change you make.

Add eyecatching highlights 

Make your information stand out even more by changing the background colour of a cell or row with Background Cell Highlighting.

Get right to the source of the issue

Now it takes less time to work out what’s affecting your task dates. Whether it’s schedule date or holiday time, Task Drivers help you understand what’s behind the start date of a task. Any delays and you can track back and work out exactly what’s holding things up!

Look ahead for your project

Ever wished you could see into the future? Well, you almost can with Multiple Level Undo. It allows you to view the implication of every possible change to your project. Just by undoing and redoing changes to views, data, and options.

Stay in control of your money

We all want more control over our finances right now. With the budget field, you can easily assign budgets to projects and programmes. The new “Cost” resource type gives you a strong grip on your cost estimation and tracking. Other advantages include more predefined fields that map to financial fields in project accounting systems!

Create customised charts and diagrams

Get your point across with impact. With the Visual Reports feature you can create customised PivotTable views, charts, graphs, and diagrams based on Project information. This smart feature uses Microsoft Office Excel and Microsoft Office Visio Professional to produce powerful visual information. You can also create your own customised report templates and share these with other Project users.

That’s a lot of advantages for better business or personal project management! And now you know the difference Microsoft Office Project Standard 2007 can make, why not boost the power of your projects with a short Microsoft Project 2007 training course?

We all know success in business can depend on completing projects on time and on budget. But how can you power up your projects using just one IT resource?

As a seriously powerful piece of software, Microsoft Project can be a little daunting for the first time user. But don’t let that put you off. A short Microsoft Project course  will give you the knowledge you need to manage all kinds of projects much more effectively.

It can be tempting to get launched into a new project without taking a good look at all the individual jobs it involves. It can also be far too easy to set down unrealistic timescales. So, before you begin – pause, take a deep breath and start planning.

Let’s go back to basics and talk about defining your tasks. Every project, from developing a new publication to moving offices, breaks down into individual tasks assigned to individual people. Do this clearly and you’ll ensure Microsoft Project works well for the lifetime of your project. Avoid the issue and you’ll find it difficult to stay in control.

Your new best friend – Work Breakdown Structure

If you’re new to project management, the Work Breakdown Structure (WBS) might look like just a handy project outline. But it’s actually a great deal more than that.

Wikipedia defines the WBS as “a tree-like structure that permits summing of subordinate costs for tasks, materials, etc., into their successively higher level “parent” tasks, materials, etc. For each element of the work breakdown structure, a description of the task to be performed is generated.”

WBS actually helps you to break down your project into manageable chunks. So you can think in hours – not weeks.

A common mistake for new project planners is set tasks that are much too broad, like “Write content – 3 months”. A vague and oversized goal like that is not likely to get done on time. Plus, with no thought given to the individual steps behind the task, it’s very likely that several steps will be forgotten. This is where WBS makes all the difference.

Large, generalised tasks are difficult to track. When the write content task runs late, the manager will likely have no idea what the problem is, what can be done to speed things up, or when the real finish date is going to be.

The alternative? With WBS you can break down each task into small steps measured in hours – no more than 16 hours or two business days each. This will get you thinking about what’s really involved in that particular project. Then you’ll create a much more realistic estimate of how long the project will really take.

For project managers, WBS is a vital tool for making sure that the project plan contains all the tasks that need to be done and ONLY the tasks that need to be done. Think of your WBS as your map and chapter-by-chapter guidebook to getting your project done on target and on budget!

The skills to stay ahead

You’ll see by now that MS Project is an invaluable resource for business and one worth getting to know and understand over time.

A great start to learning how it can help you is by taking a short course. With the right techniques and knowledge, you’ll power up all your projects!

You can find out more about  Microsoft Project courses here.

Did you know that around 1 million PowerPoint presentations are given every single day? Unfortunately, many of these feature classic readability errors such as using bullet points with white text on a dark background, text that’s far too small to read and other errors! What do we mean by readability? We’re talking about presentations which are attractive, simple to follow and easy on the eye. So how can you make sure your own audience is sitting on the edge of its seat – not falling asleep?

Keep colours simple

A dark background provides a much more relaxing background for your audience – and helps them focus on the content. If you do choose a lighter colour, don’t go for white. It’s far too bright and can even become painful to look at.

Go for a font colour that strongly contrasts with the background colour. Don’t rely on the way the text looks on your computer screen. Instead project the image to check your audience will be able to see it.

Another tip is not to use red text on a green background or vice versa as these combinations don’t work for people with colour blindness.

Audience-friendly fonts

Don’t get too fancy with your fonts. Keep them simple and straightforward. For starters, your font size should be big enough so that it can read by people at the back of the room. Are you giving your presentation in an office, a hall or lecture theatre?  Keep the presentation space in mind when planning your talk. In general you should use 38 to 48 point type for titles and 24 to 32 point type for bullet points.

Put formatting first

Make your slides consistent with the same size style and font, and with text positioned in the same place on all your slides. This means you’ll get more of a ‘wow’ factor when you do change the font type, size or position for a particular slide.

You’re not obliged to fill every inch of each slide! If you do have so much text on your slide that you need to use small text, try to use a serif font like Times New Roman. Those clever little serifs (the bits that stick out on each letter) will help your audience to read and understand small text.

Don’t let your text come into the slide from the left. It’s distracting for Western audiences who are used to reading from left to right. Bringing your text in from the right or fading in words from the left will make your presentation much easier to follow.

Keep it consistent

Be kind to your audience – use the same font style and size throughout your presentations. Try to avoid using italicized type and lines in all capital letters, as they’re difficult to read.

So now you know some of the secrets behind giving great PowerPoint presentations. Interested in learning more? Find out how a short PowerPoint or Effective Presentations training courses could help you get even more out of electronic presentations.