Archive for Microsoft Office 2007

Using Styles in Microsoft Word

What are Styles ?

A style is a collection of formatting instructions that can be applied to text, avoiding the need for manual formatting using the Format menu or Formatting toolbar.

Styles are used in everything that you do in Word, without you even realising. There are several reasons why it is important to understand how they work:

  • Consistency – ensures that your document contains the same formatting throughout, providing a professional, clean-looking document.
  • Easier to Modify – using styles means that you only need to modify the style and not every single paragraph in your document in that style.
  • Efficiency – you only need to create the style once, then it can be applied anywhere else in that document (and other documents too)
  • Tables of Contents – a table of contents can be generated automatically using the styles in your document.
  • Faster Navigation – allows you to move to different sections, quickly, using the Document Map
  • Working in Outline – enables you to easily outline and organise your document.
  • Legal Outline Numbering – Numbering, when linked to styles, allows you to generate and update consistent outline numbering in legal documents, even ones with complicated numbering schemes like municipal law, tax law, and mergers and acquisitions documents.

 Style Types

  • Paragraph – These are the most common type of style. They apply formatting to the entire paragraph and include both font formatting and paragraph formatting.
  • Character – These styles apply only font formatting to selected text.
  • Table – These styles allow you to apply formatting to tables.
  • List – These styles allow you to specify the way lists are numbered depending on the level of the numbering e.g. the list style “1 / 1.1 / 1.1.1” will apply number formatting as follows:

1. Sarah

1.1. Fred

1.1.1.   John

How Styles Cascade

A style can be based on another style or on no style. Basing a style on another creates a hierarchy of styles that allow you to make changes to multiple styles in a single step.

For example, if you create a style called “Level 1 heading” which is Arial, 16pt and Bold, then a “Level 2 heading” which is based on the first, it will inherit level 1’s attributes. All you then need to do is to adjust that style, say to 14pt but leave the other formatting the same. If you then decide that you want all of your headings to be Verdana rather than Arial, you change the level 1 heading to Verdana and, because it is the ‘parent’ of the level 2 heading, it will change that to Verdana also.

You can create up to 9 levels of styles. Basing your headings on the built in ‘Heading 1” through to ‘Heading 9’ also allows you to use the Document Map feature:

View > Document Map

Styles & Templates

A new style can either be created and saved in that document only or added to the template that is currently in use. If you set up a new style but did not click on the ‘New Documents Based on this template’ check box, that style would only be available in that particular document, otherwise it would be added to the template which that document is attached to. Consequently, that style would then be available to all other documents using that template.

Do not use the ‘Automatically update’ feature unless you really know what you are doing! Any changes you make directly to your document will update anything else in that document with the same style, and you can end up overwriting your styles.

Modifying an existing Style

Changing a style will affect any text in that document that is linked to that particular style, and also any styles that may be dependent on that style. If you click on the ‘New Documents Based on this template’ check box, it will also modify that style within the template itself. For these reasons, it is important to decide whether you want to modify that style, create a new one or just apply manual formatting to some text.

  • From the Quick Styles, hover over the style to be modified
  • Right mouse click
  • Select Modify from the list
  • Change the formatting as necessary

Learn more about Microsoft Word >>

Create a stencil of your favourite shapes

Instead of searching various Visio stencils to create your drawings, why not put all of your favourite shapes and pictures on to a new customised stencil. You could even save your company logo or favourite Clip Art drawings on there too. Here’s how:

  • Go to File
  • Select Shapes
  • Select New Stencil
  • Drag shapes from drawing page to new stencil
  • Click on Save icon at the top of new stencil
  • Type in a name for your new stencil 

Learn more about Microsoft Visio >>

20 Must-know Shortcut Keys in Microsoft Excel

Microsoft ExcelWant to know how to navigate, select, format and perform other simple functions in Microsoft Excel quickly and efficiently? Here are some must-know shortcut keys to improve your productivity…

NAVIGATING IN EXCEL

1. Go to end of work area

Ctrl + End

This shortcut will move your active cell to the bottom right corner of your data.

2. Go to start of work area

Ctrl + Home

This shortcut will move your active cell to the top left corner of your data. This will usually be cell A1, unless you have turned on Freeze Panes, in which case this shortcut will take you to the top left cell of the unfrozen section of your data.

3. Go to previous screen above

Pg Up

This shortcut key will move your active cell up one screen at a time, remaining in the same column.

4. Go to next screen below

Pg Dn

This shortcut key will move your active cell down one screen at a time, remaining in the same column

SELECTING DATA

5. Select multiple individual cells (or ranges of cells)

Ctrl + Click

Holding down the Ctrl key whilst selecting cells (or ranges of cells) allows you to select multiple, non-adjacent cells at the same time.

6. Select a large range of cells

Click + Shift + Click

To select a large range (rectangular area of adjacent cells) click in the cell in the top left corner of the area to select, hold down the Shift key, then click in the cell in the bottom right corner of the area to select.

7. Select the whole spreadsheet

Ctrl + A

This shortcut key will select the entire spreadsheet. Alternatively click on the button to the left of column header A.

8. Select a range of cells

Ctrl + *

This shortcut key selects the current range of cells i.e. a rectangular area of cells with no adjacent data. Note: Use the * key on the number pad of your keyboard. If you do not have a number pad then you will need to use the shortcut Ctrl + Shift + 8. FORMATTING

9. Format data in active cell(s) as Bold

Ctrl + B

10. Format data in active cell(s) as Italic

Ctrl + I

11. Format data in active cell(s) as Underlined

Ctrl +U OTHER SHORTCUTS

12. Create a new line within a cell

Alt + Enter

Using Alt and Enter will create a new line in a cell, just like creating a new line in a document. If you are using Excel 2007 or later version, you will be able to expand the formula bar to view multiple lines in a cell.
13. Open a new workbook

Ctrl + N

14. Open an existing workbook

Ctrl + O

15. Save current workbook

Ctrl + S

16. Print worksheet

Ctrl + P

17. Undo last action

Ctrl + Z

18. Copy selected cells

Ctrl + C

This shortcut key selects cells for copying. The second step is to select where to copy this data to (Paste).

19. Move selected cells

Ctrl + X

This shortcut key selects cells for moving (Cut). The second step is to select where to move this data to (Paste).

20. Paste selected cells

Ctrl + V

Printer friendly version

Logical functions

There are several logical functions in Excel. This guide provides details of the 3 most common logical functions:

  • IF – used to return one value if the result of a test is true and another value if the result of a test is false.
  • AND – used in conjunction with the IF function to allow multiple tests to be performed, then returning one value if ALL the results of the tests are true and another value if the results of ALL the tests are false.
  • OR – used in conjunction with the IF function to allow multiple tests to be performed, then returning one value if ANY of the results of the tests are true and another value if the results of ANY of the tests are false.

IF function

The IF function uses 3 arguments as follows:

Operator Action
Greater than
Less than
= Equal to
<>  Not equal to
<= Less than or equal to
>= Greater than or equal to

 

  1. The test – comparing one value to another using the above operators
  2. The value to be displayed where the result of the test is true
  3. The value to be displayed where the result of the test is false

Example – performing a single test

A worksheet lists sales agent names and their annual sales. If the sales agents’ sales have exceeded a specific sales target, then text is to be displayed as “Exceeded”, otherwise text is to be displayed as “Not Exceeded”.

An IF function can be used to display either text result in column D, based on a test to compare each agents sales to the target of $34,000 in cell E2.

The function in cell D5 would be as follows:

Note that if text is to be displayed it must have the double quotation marks (“”) around the text in the function.

  1. The test comparing the agents’ sales to the target of $34,000
  2. The result to be displayed if the agents’ sales exceed the target
  3. The result to be displayed if the agents’ sales is less than the target

Example – performing more than one test

If you need to perform more than one test when constructing an IF function, you can use either an AND function or an OR function (see above for definitions).

AND function

In the example below we need to create a function that will calculate the agents’ commission, but only if they have a) exceeded the sales target AND b) have a Gold classification:

The formula in cell E3 would be as follows:

  1. Two tests (separate tests by a comma)
  2. The result to be displayed if both the 2 tests are true
  3. The result to be displayed if both the tests are not true

This example would only result in Janet Costas getting commission as she was the only agent to have Gold classification and exceeded the target.

OR function

In the example below we need to create a function that will calculate the agents’ commission if they have EITHER a) exceeded the sales target OR b) have a Gold classification:

The formula in cell E3 would be as follows:

  1. Two tests (separate 1 tests by a comma)
  2. The result to be displayed if either of the 2 tests are true
  3. The result to be displayed if neither of the tests are true

This example would result in Janet, Brian, Norris & Alex all getting commission as these agents have either Gold classification or have exceeded the target (or both).

Printable version