King Web Design And Computer Services Pty Ltd

Home

Web Design

Media

Training

Links

Contact

• Microsoft Products
• Word
• Excel
• PowerPoint
• Outlook
• Access
• Publisher
• Accounting Software
• MYOB, Quickbooks

• Services
• Weekly Tips

• More Information
• Contact Us
• Disclaimer

Computer Training Services

---

Training to suit your needs

Computers are a part of most people’s live.
Software is becoming more sophisticated and complex to use.
Training in computer software is a must if you wish to use it to its full advantage.

---

MS Word

Microsoft’s word processor enabling you to produce business documents in an efficient manner.

Download Microsoft Word Shortcut keys Tip Sheet

Top of Page

---

MS Excel

Microsoft’s spreadsheet program enabling you to create graphics and charts.

Download Microsoft Excel Shortcut Keys Tip Sheet

Top of Page

---

MS PowerPoint

Microsoft’s presentation program enabling you to create slide shows.
Top of Page

---

MS Outlook

Microsoft’s time management program enabling you to send and receive e-mails, store customer details, and organise your day with a calendar.

Download Microsoft Outlook Shortcut Keys Tip Sheet

Top of Page

---

MS Access

Microsoft’s database program.
Top of Page

---

MS Publisher

Create professional looking publications and marketing material.
Top of Page

---

MYOB, Quickbooks

Learn how to use accounting packages.
Top of Page

---

Tips on using Microsoft Products

Using Outlook:

• Using Colour Categories, you can easily personalise and add categories to any type of information.
• Colour your messages from a particular person by choosing the Organise feature from the Tools menu
• Quickly display several days side by side in Calendar. In the date picker, drag over the dates that you want to view.

Using Word:

• Create Word Templates to Save Time
• Use the Mail Merge feature when sending the same letter to many clients.
• To insert a page break, press CTRL+ENTER

Using Excel:

• Look at the grey bar at the bottom of the screen to quickly see the sum or average of a group of cells by selecting the appropriate cells.
• Make your data more useful by using the Sort and Filter feature.
• To change rows into to columns (and vice versa, select the row or column you want to change, by using the Transpose feature.

Using Access:

• To create a shortcut, drag a database object in an Access project or Access database to the desktop
• To stop a macro while it's running and then single step through it, press CTRL+BREAK
• To sort records on partial field values, use the Advanced Filter/Sort dialog box

Using PowerPoint:

• Change all your fonts at once by using the Replace Fonts command on the Format menu.
• When you're running an automatic slide show, to stop or restart it, press S or PLUS SIGN
• Go to the first or next hyperlink on a slide by pressing TAB.

Create a Newsletter Using Publisher

• Plan It
• Choose your Layout and Design
• Add Text and Pictures to your Newsletter