We train in almost every program that runs on a Macintosh.
Most progams (eg. Word and Photoshop) run the same on Macintosh or Windows computers.
We are specialists in graphic design programs - eg. Photoshop, Quark and Illustrator.
Macintosh to PC
Filemaker Pro Introduction
For details about costs and making an appointment, see Training description
Call us at Mac Advice on 03 9654 5800 for further information.
If you require training, and the course is not listed here, we can tailor a package to suit your needs.
We can also customise courses in: Troubleshooting, MYOB, Novell/Groupwise and Quicken
Used to store and sort images, especially from digital cameras.
Importing from digital camera.
Used to store and sort songs, voice recordings, and other sound files.
Importing music from CDs.
|Movie editing software, especially from digital video cameras.
iMovie comes on all Macintosh computers
Importing from a video camera.
Using the built in camera.
Arranging and editing video clips.
Importing music, building and editing a soundtrack.
Adding transitions and titles to movies.
Creating a slideshow (from iPhoto) with Ken Burns effect.
File sizes and disk space.
Preparing for DVD.
Used to create interactive DVDs, of movies and slideshows, which can be played on a DVD player. iDVD comes on all Macintosh computers
Many people are familiar with IBM-compatible PCs and need to switch - we can show you how the Macintosh is different.
1. Keyboard differences
Keynote is Apple's presentation program (used for slide shows, transparencies and screen presentations, etc.)
commonly used for budgets, financial planning and accounting systems, is
the most popular spreadsheet on the Macintosh.
Cells, columns and rows, Moving around the spreadsheet, Data entry of text and numbers, Simple formula, Sum function, Fill right and fill down, Cut, copy and paste
Changing column width and row height, Deleting and inserting columns and rows,
3. Presentation of the spreadsheet
Borders and shading, Formatting text and numbers, Cell protection
How to set up basic graphs and make changes, Graph types, Editing, Showing legend
Preview, Define print area, Headers and footers, fitting information on a single page.
6. Use of a master spreadsheet as a template
7. Headers and footers
should have a good knowledge of different types of spreadsheets, and have
created graphs. We can review any current Excel spreadsheets or look at
proposed spreadsheets that you may wish to create.
1. Revision of basics
Autofill, Shortcuts, Presentation and use of Colour, Print Options. Toolbar and menu options.
2. Linking Worksheets to keep worksheet sizes small.
Use of Macros to automate the spreadsheet, Creation of Macro buttons, editing the macro and combining macros with a database for rapid extraction of information..
4. Advanced formulas and functions.
5. Use of 'if' statements to improve analysis.
6. Use of the Drawing Tools.
How to draw flow charts using the drawing functions.
7. Cell/Spreadsheet Protection.
8. Use of Precedents.
9. Excel Database
Sorting and finding records, setting criteria and extracting records.
10. Using linked documents to reduce the size.
11. Advanced Graph and presentation options.
Preparing reports - Review of good presentation.
12. Common solutions to problems encountered when constructing spreadsheets
Pro is the most popular database program on the Macintosh. All businesses
will benefit from understanding more about databases, and how to create
and modify them.
1. What is a database?
Explanation of fields, field names, records. Examples of common databases. Comparison of elational with flat or manual databases.
2. Opening a new Filemaker Pro file
Entering field names, explanation of conventions in database structure.
3. Data entry
Moving around the layout, creating new records, moving back or forward through records.
4. Adding/deleting fields & changing field names.
Creating drop down lists and check boxes
5. Creating a new layout
Types of layout, adding and deleting fields, moving & resizing fields, adding graphics and colour to a layout, adjusting dimensions to print on labels.
6. Find, sort & preview
Explanation of finding records by different criteria. Sorting on one field or many.
7. Export & import data and mailmerge
Tab delimited and comma delimited, opening exported data in word processor. Form letters.
8. Introduction to summary parts
9. Introduction to scripts
10. Introduction to relationality
Most people who require intermediate training in FileMaker already have a database. The training can include assistance to extend or modify an existing FileMaker database.
of main features and shortcuts
Illustrator is the most popular computer drawing program. Although used primarily for creating posters, flowcharts and technical illustrations, it can be used for creative text effects, and web graphics design.
InDesign is a desktop publishing program, growing in popularity. It allows you to combine text and graphics into layouts for books, magazines and posters
1. Saving page
format and set up.
Photoshop is the most popular image editing program, especially useful for improving or altering photographs.
Colour & Brightness
is the most popular presentation program (used for slide shows, transparencies
and screen presentations, etc.)
is the preferred desktop publishing program in much of the graphic design industry.
1. Opening a new Quark file
Double sided, margin constraints, etc.
2. Simple text handling
Font style and size changes, alignment, item vs contents tool, moving, resizing & cutting text blocks, etc.
3. Working on long text
Explanation of linking text, linespacing, kerning, tracking, indents, checking spelling, find and charge, etc.
4. Graphic elements
Drawing lines and boxes, changing line and fill patterns, white on black text, etc.
5. Importing pictures
Picture boxes, resizing and cropping graphics, rotating picture & box, text wrap, scrapbook, adjusting contrast of TIFF images, etc.
6. Master pages
Document Layout Palette, creating multiple master pages.
7. Style sheets
8. Other features
Library, Colour, Styles, tips and shortcuts, etc.
Dreamweaver is the most popular program for creating webpages. We can assist you to set up your own site while learning Dreamweaver.
1. Setting up a basic webpage
Intermediate users of Quark are taught more shortcuts, as well as the finer points of typography (eg. tracking, kerning, leading).
of main features (and shortcuts).
Word is the most popular wordprocessing program on the Macintosh.
1. Formatting Text
Font size and family, bold, italic etc., Menu vs format character vs shortcuts
Open two documents, split screen, resize windows
Ruler vs document margins, indent, hanging indent
Left, right, centre, vertical line, selection of column calculation
5. Headers and Footers
Page numbers, formatting, text, first page special
Borders, margins, changing columns widths; merging, inserting and deleting cells
7. Print Preview
8. Spelling Checker
9. Page Breaks
Save as, file formats
session is for those who are conversant with the basic operations of Microsoft
Word, or who have completed the Intro session.
1. Revision of Basics
Setting margins and indents, tables, keyboard shortcuts, headers and footers
Importing and using graphics in Word.
3. Sections, multiple columns
Using section breaks to create columns within your document
Replacing, adding returns, tabs, spaces and formatting text to use in a database
Defining applying and editing styles
6. Print merge
Using the print merge facility to construct form letters
7. Footnotes (optional)
We provide customised courses in: Troubleshooting, MYOB, Novell/Groupwise and Quicken
If you want advanced training in any of the programs listed above, we will cover:
1. Revision of basic features of the particular program.