These short 2 hour courses are aimed at those familiar with using Microsoft Office programs who want to improve their skills and find faster ways of working. We also run a beginners introduction customised for you, call for details. Many years of experience has enabled us to develop this special accelerated learning system. Using our system much is covered in just 2 hours, in an enjoyable way and with practical examples.
Create a table; define fields, choose data types and field properties, set default entries, validate data, delete, insert and rearrange fields and set the primary key. Add, save and edit records, change views from table to form, move and resize columns and rows and format the table. Find, sort and filter records. Create, save and modify a query. Choose columns to show. Calculate totals and averages. Design a report with Report Wizard.
Create a relationship between tables and set join properties. Create forms; add titles, fields and labels, edit and format labels, select, size, and move controls. Special query types; update, make table and interactive queries. Create, preview, print and save a report. Redesign the body of the report, headers and footers, group data, add subtotal and overall totals. Create standard letters and mailing labels. Import data from Excel.
Course covers creating formulas, linking cells and worksheets, rotate and wrap cells formatting and fast formatting with the format painter, how to centre across columns, hide, unhide columns build custom lists, freeze titles, split screens, customise headers and footers, create graphs and insert text boxes. There is also time to answer any problems you may have with Excel
Review of introduction/intermediate course and quick keys. Group columns and rows. Grouping worksheets for fastest formatting, custom date formats, protect cells, name ranges, absolute and relative referencing, using data sub-totals and outlines, multi-level sort, auto and advanced filters, transpose columns and rows, graphs including double Y graphs. With time to answer any problems you may have with Excel.
Understanding the slide sorter, outline, note and slide master views. Working in outline view. Create, align and group shapes. Insert pictures, crop, resize, recolour and compress pictures. Add comments and graphs. Draw freehand shapes add and adjust edit points, use fills. Insert text boxes and tables. Add bullets and numbering, tabs and indents, speaker’s notes, create diagrams and change object properties. Use slide show animations, transitions and record timings. Save as a template.
Enter tasks using task entry, task sheet and PERT chart view. Assign task relationships; add lead or lag time and set constraints. Enter start or end dates and milestones. Add and assign resources. Set base and resource calendars. Using outlining. Format tables, Gantt and PERT charts. Create and add sub-projects. Viewing project information and resource allocation and identifying critical tasks. Using filters and views to display specific groups of tasks and resources. Updating the project and tracking progress. Printing views and producing reports.
Page options, colour and font schemes. Add, format, align, distribute and group shapes. Enter, modify and format text. Add word art and tables. Set margins, columns and spacing. Flowing text into other text frames, place graphics, flow text around graphics. Insert pictures adjust colour, crop and rotate. Add headers and footers. Add, move and lock guidelines. Show guides and grid and turn grid snap off Create and assign master pages. Create and apply styles.
Add shapes and link with auto connect. Align, distribute, layer and group shapes. Create custom shapes and favourites stencil. Create, apply and work with themes. Create, assign and edit background pages. Import data from Excel. Link data to shapes and set automatic data refresh. Working with data fields and values. Create reusable data fields and add to a master shape. Colour shapes according to data, number and layout shapes automatically.
Are tabs, alignments, line spacing, bullets and indents difficult to work with? Do they seem to change without any reason when you move from paragraph to paragraph? Then this course is the one to attend. This course also covers tables, tabs in tables, fast formatting with the format painter, merging letters, creating auto text entries and shows the use of quick keys to improve ease and speed. There is also time to answer any problems you may have with Word.
Review of introduction/intermediate course and quick keys. Working with styles, using section breaks, creating automatic tables of contents, changing headers and footers in different sections and renumbering pages, create columns, change portrait to landscape within a document,. With time to answer any problems you may have with Word.
In easy 2 hour sessions
Class Fee is $50