EasyPC Training

Test 6

2010-07-28T14:59:00.001+10:00

test 6

Excel 2007 new features: 1 The Office Button

2010-05-25T16:46:00.000+10:00

Click here to view YouTube video.

MYOB End of Year Seminar

2010-05-25T16:20:00.003+10:00

MYOB are hosting their "End of Financial Year" seminars around Australia, and are offering a $50 discount during June and July.
If you are a user of MYOB, there is some important information in this seminar to assist with your end of year processes. Go to www.myob.com.au for more details

MYOB Course - Special Offer

2010-05-24T18:25:00.000+10:00

Book on EasyPC Training's 2 day MYOB course before 30 June 2010 and receive 20% off.
To book, please call 1300 63 10 40, or visit www.easypctraining.com.au

MS Visio 2003 Tip

2010-01-12T11:44:00.001+10:00

Create a stencil of your favourite shapes

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

MS PowerPoint 2003 Tip

2010-01-06T19:05:00.002+10:00

Insert slide from another presentation

Go to Insert
Slides from Files
From Find presentation tab, click on Browse
Select presentation
Click Open
Click on required slides
Click on Insert and Close

MS Excel 2007 Tip

2010-01-06T18:55:00.005+10:00

Enter data by picking from a list of text in current column.

Right click in cell
Select "Pick from drop-down list"
Select required text

MS Word 2003 Tip

2009-10-22T09:29:00.001+10:00

Insert today's date

Go to Insert menu
Select Date and Time
Tick Update Automatically if required

MYOB v18 Tip 3

2009-10-09T09:43:00.000+10:00

Find accounts easily. Search by account name

Go to Setup menu
Select Preferences
Go to the Windows Tab
Choose 'Select and Display account name, not account number'

MS Word 2003 Tip 5

2009-10-08T12:43:00.002+10:00

Navigate in Word

Use End and Home keys to go to start and finish of document.
Use Pg Up and Pg Dn to move one page.

MS Outlook 2007 Tip 5

2009-10-07T12:56:00.000+10:00

Schedule Emails

Open New Message screen
Go to Options tab
Click Delay Delivery button
Enter date & time

MS Word 2003 Tip 4

2009-09-30T09:33:00.000+10:00

View changes you make to document
Double click on TRK on status bar.

MS Office 2003 Tip 5

2009-09-23T10:44:00.006+10:00

Close all open files:

Hold down Shift key
Go to File
Select Close All

MS Excel 2003 Tip 3

2009-09-22T07:41:00.003+10:00

Join contents of 2 cells (Concatenation) - Use the '&' symbol:
Example: =A1&" "A2 joins contents of cells A1 and A2 with a space between.

MS Word 2003 Tip 3

2009-09-22T07:39:00.000+10:00

Use tabs to align text on page:

Click on the top ruler to set tab position
Use the Tab key to move cursor to set tab position

MS Excel 2003 Tip 2

2009-09-21T11:11:00.000+10:00

Start a new line:
To start a new line within the same cell use Alt + Enter.

Microsoft Shortcut Keys

2009-09-17T12:55:00.000+10:00

FREE Microsoft Shortcut Keys list

MS Office 2003 Tip 4

2009-09-17T12:39:00.002+10:00

Use the right mouse button to bring up a menu of common commands.

MS Office 2003 Tip 3

2009-09-16T08:47:00.000+10:00

Use shortcut keystrokes to speed things up.

Ctrl + X to Cut
Ctrl + C to Copy
Ctrl + V to Paste
Ctrl N for New

MS Office 2003 Tip 1

2009-09-15T10:31:00.000+10:00

Use Office Clipboard to copy between office applications.

Go to Edit
Select Office Clipboard
Copy data
Select data from clipboard to paste

MS Excel 2007 Tip 1

2009-09-15T10:28:00.002+10:00

Add shortcuts to Quick Access Toolbar.

Click arrow at end of toolbar
Select More Commands
Select command, Add

MYOB v18 Tip 2

2009-09-15T10:25:00.001+10:00

Save time entering bills. Set default expense a/c.

Go to Supplier card file
Go to Buying details tab
Select default expense a/c

MS Outlook 2007 Tip 4

2009-09-10T08:44:00.000+10:00

Use Email Template (see Tip 3)

Go to Tools
Select Forms
Choose Form
Select 'User Templates in File System'
Select required Template

MS Outlook 2007 Tip 3

2009-09-10T08:42:00.000+10:00

Create Email Template

Write Email
Save as Outlook template

Windows XP Tip 1

2009-09-09T15:32:00.003+10:00

Alphabetise your programs:

Go to Start menu
Select All Programs
Right Click
Select Sort by name.

MS Outlook 2007 Tip 2

2009-09-09T14:22:00.000+10:00

Organise your diary. Colour code appointments:

Go to New appointment window
Select colour from Categorize button.

MS Outlook 2007 Tip 1

2009-09-09T14:10:00.003+10:00

Organise emails into folders.

Right click on Inbox

Select New Folder

Type name

Drag email to folder.

Microsoft Office 2003 Tip 1

2009-03-17T22:46:00.002+10:00

Open the Office Clipboard before copying data. You can then paste the data multiple times and between office applications. To open the clipboard:

Go to Edit
Select Office Clipboard

Microsoft Excel 2007 Tip 1

2009-03-17T22:44:00.000+10:00

To add a shortcut to the Quick Access Toolbar:

Click on the drop down arrow to the right of the toolbar
Choose More Commands
Select required command from list on the left
Click on Add

MYOB v18 Tip 1

2009-03-17T22:27:00.004+10:00

Save time when entering supplier bills, add a default expense account to your supplier card files:

Go to Card File > Cards List
Open a supplier card file
Go to the Buying Details tab
Select the required default expense account

Microsoft Outlook 2007 Tip 1

2009-03-17T22:03:00.004+10:00

Colour code your appointments to make them easier to identify on your calendar:

Open an appointment
Click on Categorize
Select required colour category
Click on Save & Close