Wednesday, March 24, 2010

Customizing MS Word To Improve Productivity

The monitor flickers into life. There is just you, a keyboard and a mouse. You have a 1000 word essay to complete by Friday and you feel like a modern day Robinson Crusoe; alone, and cut adrift from civilized society. Where can you turn for help?

The full article appears here:
http://www.microsofttraining.net/article-485-customizing-ms-word-improve-productivity.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Baffled By Custom Number Formatting In Excel?

Whether you've used Excel to show lists containing numbers, or to perform calculations, sooner or later you may want to change the exact way the numbers are displayed in cells. By default Excel aligns numbers to the right, but this may not always suit you. Custom number formatting allows you to choose very precisely how the numbers are displayed.

The full article appears here:
http://www.microsofttraining.net/article-484-baffled-by-custom-number-formatting-in-excel.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

A Picture Is Worth A Thousand Words (Or Numbers)

Keeping an eye on your money isn't always as easy as you'd like it to be. Is there anything else where the need to understand your position is so frustratingly in inverse proportion to the ease of doing so? If your car is low on petrol, there's a dial on the dashboard that tells you so. If you want to keep an eye on the time, the clock can be relied on to keep ticking around in the same direction. But money tends to appear in a slew of rows and columns, and of dense figures piled up as far as the eye can see.

The full article appears here:
http://www.microsofttraining.net/article-483-a-picture-is-worth-thousand-words-or-numbers.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

When To Use Access, When To Use Excel

Tea or coffee? Shoes or trainers? Access or Excel? Life is full of different options but most of the time the decision comes down to practical requirements. If you need a shot of energy to get you through the day then you'll be better off with a big mug of coffee. Likewise if you have an important business meeting scheduled it is probably best to stick to more formal footwear.

The full article appears here:
http://www.microsofttraining.net/article-482-access-or-excel.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

How To Start Using Excel 2007 Functions

You may have used calculations in Excel 2007 for example to add two cell values by typing something like =D4+e4 into a cell, or to multiply two cells by typing this formula =D5*E5. You can build calculations like this using an "=" followed by a mixture of cell references and the symbols +, -, *, and / to add, subtract, multiply and divide values in different cells, with the answer showing in the cell containing the formula.

The full article appears here:
http://www.microsofttraining.net/article-481-how-start-using-excel-2007-functions.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Plug Into The Big Grid

Of all the sweeping changes that Microsoft have made to Excel 2007 the one that has got people most excited is the hugely increased capacity of the workbook. The Big Grid, as it is known, offers over a million rows per spreadsheet - as opposed to 65,536 in Excel 2003 - and increases the number of columns from 256 to a staggering 16,384. This incredible upgrade provides users with the ability to create almost limitless spreadsheets.

The full article appears here:
http://www.microsofttraining.net/article-480-plug-into-big-grid.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

Say It With Ribbon

When you come to a program for the first time you want the interface to be accessible. You want clear, unambiguous instructions and uncluttered, straightforward commands. What you don't want is to scramble blindly around on a computing wild good chase, clicking irrelevant tabs and searching through endless drop down menus.

The full article appears here:
http://www.microsofttraining.net/article-479-say-it-with-ribbon.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com