Have you been wondering how you can compare 2 ranges of data simultaneously in Microsoft Excel? Well in this tip, I will explain how you can do this using one of two solutions – first is by entering formula and the second is by using conditional formatting with the same formula.

The first method involves entering a simple formula in another identically sized and shaped range. You need to ensure that you select the range comparing to larger table.

Click on cell E1. In the Formula Bar type: =A1=Sheet1!A1 Ensure you do not have $ signs in reference links.

Now copy this formula to the right and then down for as many columns and rows you need to compare.

It will display TRUE for identical/duplicate cells and FALSE for new or changed cells.

The second method is about applying conditional formatting to one of tables. But in this case you will have to have both tables on one sheet.

Select the range A6:C10 stating from cell A6. This ensures that A1 is the active cell in the selection.

With this range selected, go to Home>Conditional Formatting>New Rule>Use a formula to determine which cells to format. Then type the formula =NOT(A1=A6) Click the Format button and choose the format to mark differences with.

I have used bold text.

Now simply click OK button.

If you would like to see more tips, visit our Microsoft Excel Tips page.

Want to learn more about Excel? Then you should book yourself on one of our Microsoft Excel Training Courses.

In our previous article: Mr Blair v Mr Branson – Who Do You Trust More? we explained how important trust is when dealing with any aspect of a business deal. Now that you have that client’s trust it is time to turn that client into a customer.

If you have done a good job in attracting new business leads to your company and gaining their trust, the next step to consider is how you intend to turn these leads into happy customers. Happy customers can lead to more customers enquiring about your services from word of mouth. Whatever you do, don’t use the technique displayed by our chicken friend here, it won’t end well.

To be sure your potential customer feels comfortable, you must listen to everything that they are after. Don’t jump too quickly to try and close the deal; you could frighten the customer away. To ensure they have full confidence in you, try following these 5 steps:

1. Engage & discuss any issues that the client considers key openly
2. Listen to what the customer sees as important and crucial for them, this will in turn help you prescribe the right solution to what they are looking for.
3. Frame the real true issue and don’t be afraid to take personal risks to get to the root of sensitive issues but refrain from using language which insinuates blame on the client.
4. Envision how things would be in the future, ensuring to include the situations in which both sides benefit as well as pointing out other possible outcomes & results.
5. Commit to and plan steps to help move the sides forward toward the ultimate goal.

Once these five steps have been achieved, both you and your new customer will be happy and you can start the whole process again with another potential future customer.

Would you like to view previous articles? Then indulge yourself on our Business Articles page.

Would you like to learn more about Business? Then come along to one of our Business Training Courses.

Welcome to another of Infero’s Microsoft Word tips. In this tip, I will explain to you how to easily move rows within a table up and down.

If you don’t use tables all that often then you can also use the same techniques for moving small paragraphs of text. If you are working with bigger passages of text however, it might be a better idea to use the normal cut and paste option.

Now to begin moving your table row, select which row you would like to move by clicking in it and then hold down the Alt and Shift keys and then depending where you would like to move the row to, press either the up or down button to move the row to your desired location.

If you like to view more tips, visit our Microsoft Word Tips page.

If you would like to learn more about Microsoft Word, book yourself on one of our Microsoft Word Training Courses.

Which would you trust more? Blair (left) or Branson (right)?

Putting your trust into the hands of somebody you don’t know can be a daunting prospect. So how can you gain the trust of your target audience so that they will take advantages of the services you are offering?

Well the answer to this isn’t always straight forward. With the current economic climate, the trust of a business can be almost impossible to get, especially if it involves a large sum of money. Small business can be as hard if not harder to convince. The profession you work in can also turn into a factor against you, forcing you to work even harder to gain this trust.

For example, a survey carried out by Sandler Training, a leader in providing Sales & Management Training tested the public view on how they rate various professions in terms of trust. Perhaps unsurprisingly, well over half of all the people surveyed agreed that Politicians were the most untrustworthy people followed by Sales-people.

This should be worrying for any business since most rely on their sales-people to drum up and acquire new leads for their services. If these sales-people give the impression that they are untrustworthy, then you might as well kiss goodbye to any chance of any company wanting to deal with them.

So readers, who would you rather do business with? A self made billionaire or a controversial ex Prime Minister?

Keep a look-out for our follow-up article in which we will give tips on how you can turn your newly found business leads into valued customers.

Welcome to another Microsoft Access Tip from us at Infero. In this tip, we will explain how you can make sure that your Microsoft Access databases are secure with the use of a password. This will ensure that only you can access the database.

To begin with, you must first open the database which you would like to add the password to in a mode known as Exclusive mode. To do this, select the Microsoft Office button and select Open. Then choose which database it is that you want to put the password on and click it once.

You then click the small arrow beside the open button to open the drop down menu and then select Open Exclusive. Once you have done this, go to the Database Tools tab and select the ‘Encrypt with password’ option (highlighted in orange in the image below).

Then enter your chosen password into both the Password and confirm password box and click ok. Whenever you open your database from now on, it will prompt you to input the password.

Want to know more? Then visit our Microsoft Access Tips page.

Want to learn more about Microsoft Access? Then book yourself on one of our Microsoft Access Training Courses.

At Infero, we understand that you wish to stay up-to-date with the latest versions of the software that you may use on an everyday basis such as the Microsoft Office suite. So when Microsoft released their new 2010 version of Office, we knew that it wouldn’t be long before we would have enquiries regarding courses to help better their knowledge.

Therefore we can now offer training on the 2010 versions of Microsoft Access, Excel, Outlook, Project, PowerPoint, Publisher and Word courses for you to choose from and still have the 3 levels of beginner, intermediate and advanced for you to choose from where applicable.

For those who are upgrading their versions of Office, we are also offering Transition Courses on each program to aid in making the upgrade as trouble-free as possible. For example, here is our Microsoft Excel 2010 Transition from 2003 Training Course.

Delegates taking these new courses will be getting all of Infero’s great benefits including our 100% money back guarantee if you are unsatisfied with the course. However if you are taking one of our transition courses, since these only run for half a day there will be no pub lunch included.

So, if you or indeed your company are upgrading, contact us and we’ll do everything we can to ensure that the transition training from one version to another goes as smoothly as possible.

For those who aren’t upgrading but would like some Training Courses in Access, Excel, Outlook, Project, PowerPoint, Publisher or Word, then feel free to take a look at our Public Schedule or Contact us to arrange a course for you. We are more than happy to help.

Here is the latest installation in Infero’s ever growing list of Hints and Tips. In this tip we will explain to you how to insert a new text column into Microsoft Project.

First of all, ensure that you are in sheet view, and then select the column field to the right of where you want to show the column. If you want to show the column as the last column, you need to insert it before the last column and then move it by dragging its heading.

On the Insert menu, click Column and specify the field name, title, title alignment, data alignment, and width of the column.

If you wish to wrap the column heading text to the next line, select the Header Text Wrapping check box.

If you want to set the column width to the longest item in the column, click Best Fit.

If you would like to see more Microsoft Project tips, then feel free to browse our Microsoft Project Tips page.

If you would like to learn more about Microsoft Project, then you should book yourself on one of our Microsoft Project Training Courses.

Stress can be a major block in a person’s working life and can attribute to poor health if it builds up too much. A recent survey carried out by the Insurance Group AXA shows that in the past 4 years, stress levels in the UK have doubled so there has never been a better time for you to start combating your stress.

National Stress Awareness Day is an annual event organised by the International Stress Management Association which seeks to promote awareness of just how damaging stress can be and to offer help to those affected by highlighting the many coping strategies and help sources available to them.

Stress can be brought on by different factors in the workplace such as tight deadlines, ineffective time management, problems with colleagues, and problems with equipment.

Here are a few tips from the International Stress Management Association UK website, organisers of the National Stress Awareness Day.

Learn to manage your time more effectively:

Learning to prioritise your daily tasks can help reduce stress in a big way. We at Infero can also help you here as we offer Time Management Courses in our wide range of Business & Technical Courses.

Learn to compromise rather than argue:

In most conflicts, there is usually a way in which both sides can achieve a positive outcome. Try to find this compromise rather than arguing and raising your stress levels even more.

Don’t take on too much work & know your limitations:

Taking on more work than you are capable of completing is just asking for trouble. Once you accept to complete something for a colleague, you don’t really want to be letting them down and if you have other tasks to complete at the same time it becomes stressful.

We at Infero would also like to help you overcome your stress barriers and therefore we have a course to help entitled Creating & Maintaining Life Balance. The course will help you learn ways to manage your stress effectively and ways to improve both your physical & mental well-being.

Contact us or give us a call and we’ll be more than happy to answer any questions you may have about our courses and how we can help you.

Welcome to another of our Microsoft Outlook Tips. This tip will hopefully help you organise your email categories via a selection of colours which will make the categories themselves more eye catching

To organise and add colour to all of your categories, first of all you need to select the ‘Categorize’ icon on the toolbar (highlighted in orange in the picture below)

Then if you select ‘All Categories’ you can rename existing categories or add additional ones if you wish. You can also assign a shortcut to the particular category, meaning that they can be accessed with just one click of the mouse. Here is where you choose which colour you want your category to be.

Are you interested in reading more tips? Then visit our Microsoft Outlook Tips page.

Would you like to learn more about Outlook? Then come along to one of our Microsoft Outlook Training Courses.