Training in the Tropics
  • Home
  • About
  • Courses
  • Testimonials
  • Contact
  • Gallery
  • Resume Writing Service
  • Computer Tips
  • Subscribe

Computer Tips

Automate common or repetitive tasks in Outlook using Quick Steps

8/13/2018

0 Comments

 
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.
Picture
To configure or change existing Quick Steps, do the following:
  1. In Mail, on the Home tab, in the Quick Steps group, click the More  arrow at the side of the Quick Steps box, and then click Manage Quick Steps.
  2. In the Quick Step box, click the Quick Step that you want to change, and then click Modify.
  3. Under Actions, change or add the actions that you want this Quick Step to do.
  4. If you want, in the Shortcut key box, click a keyboard shortcut that you want to assign to that Quick Step.
  5. If you want to change the icon for a Quick Step, click an icon next to the Name box, click an icon, and then click OK.


    To create a Quick Step:
  6. In Mail, on the Home tab, in the Quick Steps group, in the Quick Steps gallery, click the Create NewQuick Step.
  7. Click an action type from the list or click Custom.
  8. In the Name box, type a name for the new Quick Step.
  9. Click the icon button next to the Name box, click an icon, and then click OK.
  10. Under Actions, choose an action that you want the Quick Step to do. Click Add Action for any additional actions.
  11. To create a keyboard shortcut, in the Shortcut key box, click the keyboard shortcut that you want to assign.
0 Comments

Signing PDF documents in Adobe Acrobat Reader

3/20/2017

0 Comments

 
Picture
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!





0 Comments

Continuous Section Breaks - MS Word

5/23/2016

0 Comments

 
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.
Picture
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.
​
0 Comments

Excel - Calculation order of precedence

2/15/2016

0 Comments

 
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!
0 Comments

Navigating the Start Screen - Windows 8

11/10/2015

0 Comments

 
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!

Picture
0 Comments

Microsoft Excel Insert Date Shortcut

10/20/2015

0 Comments

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

CTRL + : colon

Happy excelling!
0 Comments

Microsoft EXCEL - Fill Handle

8/7/2015

0 Comments

 
Picture
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.
Picture
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.



0 Comments

How to add captions to pictures

5/22/2015

0 Comments

 
Picture
In most Microsoft programs you can add a caption to a picture, photograph or graphic. 

To do this, right mouse click on the picture or photo, and select Insert caption from the shortcut menu.  This will open the Caption dialog box where you can make various selections and type the caption or your choice. 

Note: By ticking the Exclude label from caption box, Figure 1 will be excluded from the text.

Once you add a caption, you can edit or format the text
by clicking on the text.

Once selected you can also use the paragraph group or dialog box to centre or left align caption under photograph or picture.

Happy captioning!


0 Comments

    Author

    Julie Goleby is the Director of Training in the Tropics

    Archives

    August 2018
    March 2017
    May 2016
    February 2016
    November 2015
    October 2015
    August 2015
    May 2015

    Categories

    All
    Captions
    Graphics
    Images
    Microsoft
    Photographs
    Pictures

    RSS Feed

We are passionate about helping you improve your skills and knowledge!  


Hours

M-F: 9am - 5pm

Telephone

0428 411 050

Email

office@traininginthetropics.com
POSTAL

PO Box 1702, ATHERTON QLD 4883
  • Home
  • About
  • Courses
  • Testimonials
  • Contact
  • Gallery
  • Resume Writing Service
  • Computer Tips
  • Subscribe