EXCEL

Data entry/import, drop down lists and validation, data type concepts and common difficulties and errors, formatting issues, cell referencing (relative, absolute and named), "databases" with Tables and Pivot Tables and key benefits, slices, Formulas and intro to Functions, graphs (Charts), worksheet design for productivity and accuracy, tricks for exporting to Word and Powerpoint. I do NOT cover Macros or Visual Basic.

PREMIERE PRO

My own requirement to produce increasingly more video for clients has forced me through the steep learning curve and I am now able to guide others through this complex program. Your workshop will cover the preparation of resources, understanding the confusing range of formats (and relevant qualities) for video, audio and still images, using these resources inside Premiere, the timeline layers, layer interactions, applying effects, applying transitions, options for generating output. Bring existing video (or record it during the workshop) and use it for your project.

INDESIGN

I have discontinued this offering due to the rarity of requests and also that my own use has declined in line with the reduction in clients requiring high quality multi-page layouts. The great majority of their remaining multi-page requirements can be easily and better accommodated using Word (for a number of good reasons, technical and business).

Common to each workshop:

Simple overview

The primary work area and the 20% of available tools and features used for 80% of everyday tasks.

Strengths and weaknesses

Informed opinion on which features you should (or should not) use.

Tips and shortcuts

I always show you the best and quickest way to achieve the major tasks.

Creating and editing work

Printing and exporting what you've created

Relevant file types and their uses, how best to share your work, common print problems and efficiency tips, using external print companies. Real print examples used.

Self-help resources

Besides the "showbag" of useful freebies, you will be shown how you can get help and improve your skills in future at no additional cost.

Short Practical "ProjectS"

To cement your new skills, and to recreate the workplace,
you will be given the opportunity tackle some everyday tasks from scratch (help being
given if requested). Or you can bring a project from work/home so that you leave the workshop with a real 'solution'.

.

TOTAL FLEXIBILITY

You pay for my TIME. Therefore it is up to YOU to make the most of it. I can go as slow as you want, repeating the basics until you are totally comfortable. Or I can steer you quickly though the features I know will make you a valuable asset in any environment. Create a list of specific issues or workfiles to discuss or to workshop how to improve.

Some people may simply be brushing up their skills after some time out of the workforce, or perhaps have languished on an older software version. Others have a list of their own topics that they want to explore.

Many people want to use the time to improve or try out two or more programs. The most common combo requested is Word and Excel.

We can even switch topics/programs without any notice. Remember, I use these programs on a regular basis so I'm comfortable dipping in and out of things to suit your requirements.

TRAVEL TO YOU

I'm happy to discuss bringing the workshops to you, anywhere in Australia and New Zealand. This requires substantial discussion of requirements and dates. It is better value for you to amortise travel costs by either training a lot of people in one or many sessions, and/or to cover several different programs while I'm there.