Work in progress - will be adding the content of all our training DVDs - 2007 and our CDs - 2003 applications.

To find the content of each training DVD - scroll down the page. 

 
DVD  and Textbook – EXCEL 2007 Advanced - $99

More Functions and Formulas	multiply operators, insert and edit a function, auto-calculate and manual calculate, define names, use and manage names, tracing formulas, formula errors,
Working with Data Ranges	sorting, sorting multiple columns, custom lists, filtering data, custom autofilterr, advance filters.
Working with Tables	creating, total row, table data, summarising a table with a pivot table, data form, table styles, options, convert or delete a table.
Working with Pivot Tables	creating, specifying data, changing calculations, filtering and sorting, layout, grouping items, formatting, Pivot Chart.
Analysing and Organizing Data	create scenarios, data tables, goal seek, solver, data validation, text to columns, removing duplicates, grouping and outlining data, subtotals, Consolidating.
Working with the Web and External Data	Hyperlink, creating a web page from a workbook, importing data from access or text files, importing data from the web and other sources, existing data connections
Working with Macros	recording a macro playing and deleting a macro, adding a macro to the quick access toolbar, editing a Macro’s visual basic code, inserting code in a macro.
Working with Objects	clip art, pictures, graphics, shapes, grouping objects, layering, smartart, wordart, embedded object, symbols.
Advanced Topics	customise quick access toolbar, autocorrect, default options, recover documents, using diagnostics, saving a file as a PDF or XPS, adding a digital signature to a workbook, prepare for publishing and distribution.
Appendix of Common Functions	financial functions, date and time, Math and Trig, Statistical, Lookup and reference, database text, logical functions.

 DVD & Textbook – EXCEL Financial Accounting - $299

Working with Dates and Times	Functions, VLookup, If Statements, Date Ranges, Work days Calculations.
Investment Analysis and Time Value of Money	Terminology, Future Value, Present Value, Annuities, NPV, IRR, Effective Rates, Loan Amortisation Schedules.
What IF Analysis	Create and Scenario, summary report, create one and two input data tables, use goal seek, set up complex what-if analysis with solver, lease or buy.
Charting	Create a chart, move and resize a chart, forat objects in a chart, change a chart’s source data, change a chart type.
Data Analysis and Pivot Tables	Create a Pivot table, Pivot a Pivot Table, use Page field to filter data, group information, subtotals, database functions (DSUM), VLookup,
Depreciation Schedules	Depreciation functions, SLN, BD
Automating Tasks with Macros	Record a macro, play a macro, assign a shortcut to, Macro’s visual basic code, insert code into macro, declare variables using DIM statement, Prompt for user input, use IF...Then statements.

 DVD & Textbook – Word Introductory - $99

Starting Word	the screen, using the ribbons, using office buttons, keyboard commands, menus and mini toolbars, help, exit.
Documents Basics	Creating a new document, inserting text, saving, editing, undo, redo, viewing multiple documents and windows, preview, close.
Working with and Editing Text	spelling and grammar, find and replace, word count, thesaurus, symbols, special characters, cut, copy, past, clipboard, moving and copying text using the mouse.
Formatting Characters and Paragraphs	Font styling, lists, paragraph alignment, borders and shading, line spacing, format painter, mastering tabs and indents.
Formatting the page	adjusting margins, page orientation and size, using columns, page, section and column breaks, line numbers, hyphenations, background, cover page, headers and footers.
Working with Themes and Styles	Applying a style, style gallery, printing styles, document themes, colours and fonts, saving a theme.
Working with Shapes and Pictures	clip art, pictures and graphics, positioning pictures, shapes, move, copy, deleting object, aligning, distribution, and grouping, flipping & rotating, laying object.
Working with Tables	creating a table, resizing and moving, cell formatting, merge and splitting, sorting, formulas, borders and shading, table styles, deleting columns, rows, quick tables.

 DVD & Textbook – Word 2007 Advanced - $99

Mailing	mail merge, creating data source, rule fields, preview after merge, creating labels, creating envelopes.
Using Document Collaboration Tools	Tracking, comments, comparing and combining documents, password protect, publishing and distribution, workspace.
Working with Outlines, long Documents, and references	outline view, master documents, bookmarks, cross-references, creating a table of contents using heading styles, using TC entries, picture captions, creating an index, footnotes and endnotes, citations and bibliographies.
Working with WordArt, SmartArt and Charts	wordart, formatting wordart, smartart, elements, chart, working with labels, changing chart type.
Collaborating with other Programs	objects, collaborating with excel, collaborating with PowerPoint, modifying and object5, inserting text from another file, converting documents.
Working with templates	creating templates, styling, using a template, creating building blocks, using building blocks.
Working with forms	creating a new form, adding content controls, assigning help to form content controls, prepare for distribution, filling out a form.
Working with Web Pages	saving a document as a web page, modifying and viewing a web page, using hyperlinks, specifying web options, working with blog posts.
Advanced Topics	customising autocorrect, customizing quick access toolbar, change options, viewing properties, saving a document and a PDF or XPS, adding a digital default signature, recording a macro, playing and deleting a macro, editing a macro’s visual basic code.

 DVD & Textbook – PowerPoint 2007 - $99

The Fundamentals	Starting PP, screen elements, keyboard commands, contextual menus, using help
Presentation Basics	Creating a new presentation, inserting slides, layout, navigating, undo, redo, saving, print preview, printing
Inserting and editing text	Insert text, edit, cut, copy, paste, clipboard, moving, check spelling, find and replace, symbols
Formatting text	Font type, font size, colour, style, dialog box, format painter, wordart
Viewing a Presentation	Changing views, Zoom control, outline pane, presentation window, multiple presentations
Formatting a Presentation	Use document themes, change backgroung, rearrange slides, adding headers and footers, slide master, bullets and numbering, format paragraphs, tabs and indents, page setup
Working with objects	Clip art, pictures and graphics, shapes, resize, move, copy and delete objects, group objects together, special effects, flip and rotate, layering objects
Working with tables	Create a table, adjust column & rows, merge, split cells, borders and shading, table style
Working with charts and Smartart	Chart data, change chart type, labels, format a chart, smartart, converting slide text into smartart.
Applying transition and animation effects.	Transition effects, modify, apply animation effects, previewing a transition or animation effect.
Work with multimedia	Sounds, CD Track, movie clip, presentation, action buttons.
Finalize a presentation	Setting up a slide show, rehearsing timing, add comments, hide a slide, marking a presentation as final.
Delivering a presentation	Delivering a presentation on a computer, use pen and make annotations, creating a presentation that runs by itself, using presenter view, creating a custom show
Collaborating with others	Document inspector, compatibility checker, packing, saving as a PDF or XPS, save as a web page, add digital signature, password protect, publish to a document workspace
Working with other programs	Collaborating with Excel and Word, Embed or link content, create handouts in word, import or export an outline
Advance Tips	Autocorrect, default options, convert old presentation to PP 2007, Recovering your presentation, Office diagnostics, Properties.

DVD & Textbook – MYOB - $299 includes bonus Payroll DVD and textbooks

DVD & Textbook - MYOB Accounting Plus – Advanced - $149

1.       Budgets 2.        Advanced Inventory 3.       Job Costing and Tracking Profit Centres 4.       Categories 5.       Timesheets for Payroll and Time Billing 6.       Using time billing activity slips to enter payroll timesheet 7.       Manufacturing 8.       Advanced reporting 9.       Advanced Payroll

 DVD & Textbook MYOB Payroll for Accounting Plus - $99

Setting up and process Payroll in MYOB

loading tax tables, linked payroll accounts, adding employees, wage categories, overtime loading, allowances and re-imbursements, bonuses and commissions, deductions, superannuation, payroll tax, reporting for IAS, BAS and others, End of Year activities, customise payslips, restricting access to sensitive payroll information, creating electronic funds transfer files – EFT, check for errors, Pay ATO or Refund from ATO, save worksheet, tips on validating data / check for errors.