Infero Training – Business and Technical Courses

Sometimes you may want to mark major event in a project, for example indicate the beginning and end of the project or display the end of a major phase. You can use milestones to do that. To create a milestone follow the steps:

1. In Gantt Chart View, in the Task Name column, type the name of a milestone
2. In the Duration column type 0 and press ENTER

In the Gantt Chart the task will be displayed as a black diamond symbol ¿.

Want more tips? Click on Microsoft Project Tips and Tricks

When money is a little tight, as it is for most businesses these days, a sure way to guarantee success is to invest in the little gems your company already holds, your employees.

Let us say you have 25 employees, what is the best way to maximise your revenue? By making cut backs? Definitely not. You already have a group of hard working people who know your business inside out, so all you need to do is get them working a little harder, faster and more efficiently and you will see the results from your hard work and loyalty paying off in no time at all.

Time management is something that we are generally quite poor at most of the time. We should start work at 9, but things get in our way, we’re on the phone, forget to buy breakfast, the stress is too much, I need another cigarette break. All these distractions are cutting away at the time we should be using to focus on our business and make more money.

It’s not just you that wants results; your employees want to be good at what they do too. Time Management training and IT courses can teach them it all, so that they possess the right skills to do the best job in the most efficient way. If you train your employees to be able to adapt in business, when you need to make changes, they are ready and fully prepared to take on any new challenges. You will probably be surprised to see leaders starting to develop and become more efficient in the workplace, making your job more relaxing.

Studies have shown that training has a very positive impact on productivity, with some showing an 80% rise. And not only will it improve the amount of work your people do, but the quality will be staggeringly higher.

IT courses are perfect for honing in those all so important business skills and making your work look more professional. From memos to producing complicated formula reach spreadsheets, we can show you how to look great, feel great, and be great. So join us for Effective Time Management seminar to find out how we can help you.

Let’s say you’ve just applied various formatting options to text, for example you might have selected bold, italic, underline; changed font and size of font; applied a different colour, added borders and shading, and even adjusted different line spacing. Now you would like to quickly reproduce this formatting in several places in your document.

You can save time by copying the format you’ve already applied to text using Format Painter. To do so follow these steps:

1. Select the text that has the formatting that you want to duplicate.
2. On the ribbon from Home tab, in Clipboard, click the Format Painter button. When you move from the Ribbon back to the document, the mouse pointer now appears as I-beam with a paint brush.
3. Select the text you want to reformat by dragging the mouse to highlight the text.
4. As soon as you release the mouse button, the text receives the format of the other text. The feature is turned off and the mouse pointer returns to the original default pointer.

If you have several pieces of the text throughout the document that you want to reformat, then follow steps 1 to 3, however in step 2, double click the Format Painter button and select text to format those pieces of text. When you’re finished, click the Format Painter button to turn it off.

Want more tips? Click on Microsoft Word Tips & Tricks

The long renowned Prince is back! No not the controversial, rock-and-roll hall of famer or Will Smith’s ‘Fresh’, upbeat character. Rather the project management tool assembled by the Central Computer and Telecommunication Agency in 1989 to plan an organised and controlled event.

Prince2 (PRojects IN Controlled Environment) not only allows companies to create a perfectly productive and efficient method in which to execute their plan, but also offers you an acquired sense of control over your project management and plans long term acquisitions of the business. But not any John can crack the method, as it takes a combination of 4 hours worth of examinations and weeks of revision to function. However once accredited you can comfortably implement your project planning system into your business and tie up all those loose ends.

The Prince2 training provides employees and organisations with the skills to successfully manage a project through the efficient use of their resources. Prince2 will benefit project managers by allowing them to economically manage all of their employees and resources towards their project goals through a structured method. In other words; a perfect tool for project managers.

Key Benefits of Prince2:

• The flexibility suits all projects needs
• Easy mornings for middle management, as all those tedious meetings can finally be reduced to only necessary meetings
• It’s Free! Well to use only, of course there are training costs.

Prince2 and project management are always good entities to be associated with as it gives you that extra edge with potential clients. Yes, you may have to put yourself through Prince2 training and exams, but reaping benefits from it are far more worthwhile than the short-term implications.

While entering data in Excel worksheet you may find yourself using the keyboard a lot. If you take your hands off the keyboard to use the mouse, it will slow you down. An alternative is to use keyboard shortcuts instead of a mouse. Below are my 10 most favoured key shortcuts in Excel 2007! To use them, simply press two keys shown in the brackets < > simultaneously.

<Ctrl> + <A> – Selects an entire worksheet

<Ctrl> + <C> – Copies the selected cells

<Ctrl> + <V> – Pastes the selected cells

<Ctrl> + <X> – Cuts the selected cells

<Ctrl> + <Z> – Undoes the previous command, if possible

<Ctrl> + <Y> (or <F4>) – Repeats the last command or action, if possible.

<Ctrl> + <S> – Saves the current work

<F2> – Enables editing within a cell

<F11> – Creates a chart from the selected data.

<Alt> + <=> Inserts the AutoSum function.

If you are working on a very important worksheet, use <Ctrl> + <S> regularly to prevent your data from being lost accidentally.

Want more tips? Click on Microsoft Excel Tips & Tricks

When I first time saw Microsoft Excel 2007 I thought I have a new annoying task to do – to learn excel. But after some playing with it I’ve realised how much I like this software. As time has gone by I prefer it. Here are 5 reasons why I prefer Excel 2007 to previous versions.

New level of limits

Microsoft Office Excel 2007 supports 1,048,576 rows and 16,384 columns. The number of rows has increased from roughly 65536 to 1.1 million; the number of columns has increased from 256 to over 16385! Columns now end at XFD instead of IV.

Office Excel 2007 also supports up to 16 million colours, which enhance visual appearance of graphic elements.

Improved sorting and filtering

Excel has always included sorting and filtering tools. With Excel 2007, the sorting and filtering options have been expanded. For example, you can now sort data by colour or by up to 64 levels (previously, you were limited to 3 levels).

Data can be filtered by colour or by dates. The AutoFilter dropdown list now displays more than 1000 items to choose from and multiple items to filter are available. Filtering capabilities can also be applied to data in PivotTables.

Powerful data visualisation tool

Do you need to highlight data when you are over or under budget or want to draw attention to the important data from a huge list?

With enhanced conditional formatting features you can highlight trends in your data, find the highest and lowest data, find exceptions and annotate data into categories. Using colour scales, data bars and performance indication icons will help you to achieve this.

Easy to use PivotTables and Pivot Charts

No need anymore to drag data into drop zones, just select the fields that you want to see in a new PivotTable field list.

And after you’ve created a PivotTables enjoy easy sorting and filtering data within PivotTable data or apply conditional formatting.

PivotCharts are also much easier to create than before. The chart formatting that you apply will be maintained when you make changes to the PivotChart, which is a significant improvement from previous versions of Excel.

New Functions are added

Microsoft Excel 2007 has 343 functions with 51 new functions. New functions mainly are within 2 new categories – Engineering (39 functions) and Cube (7 functions). The remaining five are IFRROR, AVERAGEIF, AVERAGEIFS, SUMIFS, COUNTIFS

So, really Excel 2007 is the must to upgrade for everyone using Excel. And you know that Excel training will help you to learn those tricks to make your business life easier.

Want to know more how Microsoft Excel can help you? Click on Microsoft Excel Articles.

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