Quick Steps is a new feature in Microsoft Outlook 2010 that applies multiple actions at the same time to email messages. This helps you quickly manage your mailbox. For example, if you frequently move messages to a specific folder, you can use a Quick Step to move the message in one click. Or, if you forward messages to your manager or peers, a one-click Quick Step can simplify the task.
The Quick Steps included with Outlook 2010 can be customized. You can also create your own to make a Quick Steps gallery of mail actions that you take most often.

Default Quick Steps. You can customize any of the default Quick Steps. When you use some Quick Steps for the first time, you are prompted to configure them. For example, if you want a Quick Step to move messages to a certain folder, you must specify the folder before you can use the Quick Step.

Some exciting signature features are now available in Adobe Acrobat Reader
 - Fill and Sign!

This allows you three options to insert a signature into a PDF document. 
1.  Type your name and select from 4 fonts to format signature
2. Draw your signature using your mouse or touchpad
3. Write your actual signature on a blank page, scan and save as an image file.  Then upload to sign any document. 

Once you choose your preferred option, Acrobat Adobe Reader will save this signature for signing all future documents. 

But remember, fill in all your details on the form before signing.  Once your document is signed, you (or anyone else for that matter) cannot edit the information.

Make sure you have the latest FREE Adobe Acrobat Reader by clicking on the link below.

https://acrobat.adobe.com/au/en/acrobat/pdf-reader.html

Then follow these instructions to insert your signature.

Open Acrobat Adobe Reader
Open a PDF or scan a document to upload
In the tools menu, select Fill and Sign
Click on the Sign icon In the Fill and Sign ribbon
Select Add Signature or Add Initial
Select preferred signature option - Type, draw or image?
Once happy with signature, click Apply
Your signature is attached to the cursor, so once you are happy with position of your signature in the document, single mouse click to stick it to the page.

Happy electronic signing!

Ever had trouble with varying headers and footers in a document?

Try using section breaks after each header / footer if you wish for the text to be different for each page.

Place curser in the document.  Go to Page Layout tab.  Select dropdown arrow next to Breaks, or click on dialog box launcher arrow.

Select Continuous - inserts a section break and starts a new section on the same page.

You may also need to break the link from previous header / footer.

Whilst curser is located within the header or footer, click on Header and Footer Tools, Design tab.
Click on Link to previous and follow prompts to break this link.

Now you should be able to include a different header or footer on every page.
​

Did you know that there is a default order in which calculations occur in Excel? 
And that you can change this order by using brackets? 

​Calculate 4 + 3 x 6.
What is your answer?
The correct answer is 22.
 
There are two basic Excel rules to remember.

1. Excel calculates from left to right.
2. Multiplication and Division is calculated before addition and subtraction.

 
Do you remember the acronym BODMAS?
Brackets
Over
Division
Multiplication
Addition
Subtraction
 
Therefore if you wanted to calculate 4+3 THEN multiply the answer by 6 you would need to write the formula like this.
(4+3)*6
Answer is 42. 
 
Here is one to practice.
Solve 9 – 5 / (8 – 3) x 2 + 6
Answer 8.375 or 13?
 
Step 1
9 – 5 / (8 – 3) x 2 + 6
=
9 – 5 / 5 x 2 + 6
Brackets

Step 2
9 – 5 / 5 x 2 + 6
=
9 – 1 x 2 + 6
Division

Step 3
9 – 1 x 2 + 6
=
9 – 2 + 6
Multiplication

Step 4
9 – 2 + 6
=
7 + 6
Subtraction

Step 5
7 + 6
=
13
Addition

 
Noticed we did subtraction before addition?  This is because we are calculating from left to right.  The multiplication and division are in the same order, and subtraction and addition are in the same order.
Therefore if we have a division and multiplication in the sum, we calculate left to right. Neither have precedence.
Happy Excelling!

The Windows 8 Start Screen provides a central location where you can access information and email, browse the web, stream videos, view photos, and access your social media websites.

To view apps (application), use the scroll bar at the bottom of screen.

To open an app - Click or tap a Start screen app.  To quickly return to the Start screen, press the Windows logo key on your keyboard.

Charms are used to access commonly used tools. They are hidden until required.  When summoned, the Charms menu displays at the right side of screen.  To display the charms - point mouse pointer to the upper-right or lower-right corner of the screen.   Alternatively, hold down the windows logo key on keyboard and press C.

Find a list of all apps from the Start screen - Right-click on the Start screen, then click All apps.  You can also pin apps to the Start screen and unpin apps from the Start screen.  Or uninstall apps from this screen.  Right mouse click on app to display these options.

Switch between open apps - The open apps area of the screen allows you to switch between open apps.   Point mouse pointer to upper-left corner of screen and click.  Or drag mouse pointer down to show a list of open apps.

Happy navigating Windows!

Quick and easy shortcut to insert today's date in an Excel Worksheet.  

CTRL + : colon

Happy excelling!

Instead of entering data manually on a worksheet, you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells.  You can also copy formulas from adjacent cells to save reentering the same formula into several cells.

To do this, position mouse cursor on bottom right corner of cell you wish to copy or begin a pattern.  Once you have the bold plus symbol, left mouse click and drag down to the cells you wish data or formula to be inputted in.  You can also double click rather than drag down - data entry will stop once an empty cell is located.

In the above example drag the fill handle down from each cell reference to create a series as shown below.

See how column A simply copied the numeral 1 down.  To count 1 2 3 4 etc. Input 2 in cell A2 then select both A1 and A2, then move the mouse cursor to corner of cell A2 to get the fill handle, then drag down.  Excel will then input 3 into A3, 4 into A4 etc. 

Alternatively,  you can fill the active cell with the contents of an adjacent cell by selecting an empty cell that is below, to the right, above, or to the left of the cell that contains the data that you want to use to fill the empty cell. Then on the Home tab, in the Editing group, click Fill, and then click Down, Right, Up, or Left.