All Other Courses

We offer many other courses that are usually not scheduled as public courses.

These can be provided as closed, corporate courses onsite in your training rooms, or offsite in ours. And, we can customise and tailor-make the content for you.

Courses can be delivered as face-to-face or as live, online sessions.

Have a look below at a summary of the wide range of courses we can provide.


To make an inquiry and receive a quotation/proposal, use our inquiry form here or phone us on (02) 6041 2711.

ALL OTHER COURSES

January 21st, 2025

  • MS Access
  • Digital Upskilling
  • Google Drive / Sheets
  • MYOB
  • PhotoShop
  • Zoom

MS Access


Basics Course

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Describe the Access screen layout.
  • Plan a database.
  • State meanings of database terms – primary key, fields, relational.
  • Add fields to create a database.
  • Create simple forms.
  • Enter data to create records.
  • Import data from other programs.
  • Find, sort and navigate data.
  • Create and format simple reports.
  • Create simple queries to extract data.
  • Create reports based on queries.
  • Link tables together.
  • Create queries to combine tables.

Intermediate Course

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Revise the basics and shortcuts in using an Access database.
  • Create more tables and link them.
  • Use queries to combine tables.
  • Create calculation queries.
  • Change the design of forms and reports.
  • Create forms and subforms.
  • Add calculations to forms and reports.
  • Format and validate data.
  • Add Windows features to forms (drop downs, check boxes).
  • Create a main menu system.
  • Implement simple security features.

Advanced Course

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Create mail merges with MS Word
  • Assign detailed controls to forms
  • Create automatic field population controls
  • Use report dialogue forms
  • Apply maintenance and security measures
  • Integrate databases with Web pages
  • Create and format macros
  • Use Visual Basic modules
  • Deploy databases to users without Access

Digital Upskilling


Full Course

This is a five (5) part live online course. Content as follows:

Session 1: Digital Technologies in the Workplace

  • Work better with a Windows PC using lots of great shortcuts, proper keyboarding, mouse shortcuts, etc.
  • Check the settings of a Windows PC – audio, screen, camera, Cortana settings, etc.
  • Create an electronic filing system for storing files, documents and folders.
  • Introduction to cloud computing and terminology, online learning, meeting and video conferencing tools (Zoom, etc).

Session 2: Working with MS Word Documents

  • Create and edit word processing documents.
  • Format word processing documents.
  • Output documents correctly: print and save to PDF.
  • Structure documents correctly: formal letter, CV, etc.
  • Handy shortcuts to save stacks of time.

Session 3: Working with MS Excel Spreadsheets

  • Create and edit spreadsheet documents.
  • Format spreadsheet documents.
  • Work with simple formulas and charts.
  • Output documents correctly: print and save to PDF.
  • Handy shortcuts to save stacks of time.

Session 4: Job Market, Facebook & LinkedIn, and Workplace Softskills

  • State aspects of the online job market and how to research jobs online.
  • State the differences and advantages of a Facebook profile and a Linked In profile.
  • State the important aspects of a great Linked In profile.
  • State and exhibit important job ‘soft skills’.
  • Understand the importance of interpersonal skills, phone and email etiquette, working in a team, meeting etiquette, etc.

Session 5: Bookkeeping & Email Skills, and Course Review

  • Work with a typical online accounting and bookkeeping app (Xero) .
  • Create and manage email communications, attachments, and more.
  • Review the DUIT Course, receive certificates, and where to next.

Google Drive / Sheets


Google Drive and Docs

This course can be delivered as a 1-day hands-on, face-to-face session or as 2 x 3-hour live online sessions, and participants will learn how to:

Google Drive:

  • Work with and manage your folders better.
  • Create folders, rename folders, set up a filing system.
  • Share folders with others — just view or editing access.
  • Set up and use desktop Windows File Explorer to manage files and folders instead of browser.
  • Your specific questions answered.

Google Docs:

  • Create, edit and format documents ‘from scratch’.
  • Upload and convert MS Word documents and view limitations.
  • Use time-saving shortcuts to navigate documents and select text.
  • Work with tables to create complex layouts.
  • Import and manipulate photos, images, etc, and mix text and graphics.
  • Add headers and footers, page numbers, etc.
  • Use best-practice suggestions to better present your documents — formatting guidelines, etc.
  • Your specific questions answered.

Sharing Google Docs:

  • Share documents and work with others on documents.
  • Add comments to documents and view all comments efficiently.
  • Check previous versions of files and track changes and revisions.
  • Convert/download files to different formats (MS Word, Excel, PDF, etc).
  • Your specific questions answered.

Google Sheets Essentials and Beyond

This course can be delivered as a 1-day hands-on, face-to-face session or as 2 x 3-hour live online sessions, and participants will learn how to:

  • Access Google Spreadsheet.
  • Create, edit and format a ‘cloud-based’ spreadsheet.
  • Work with important formulas — SUM, AVERAGE, etc.
  • Create and edit charts.
  • Use shortcuts to navigate and manipulate information.
  • Change displays and freeze parts of spreadsheets
  • Work with more detailed formulas  —  IF, LOOKUP, etc.
  • Use data analysis tools, such as sorting and filtering.
  • Use PivotTables to report the data you want.
  • Control the entry and formatting of data through data validation and conditional formatting.
  • Download spreadsheets in the format you want.
  • Share spreadsheets, view changes, add comments.
  • See different/previous versions and drafts of your spreadsheet documents.
  • Specific questions from attendees answered.

MYOB


Daily Processing Course

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Set up/check the ‘chart of accounts’, how it works, and how it relates to your business.
  • Create and manage items and how they relate to you.
  • Enter everyday transactions:
    • sales invoices, bills, cash transactions.
    • payments for invoices and bills.
    • bank transactions—lease payments, etc.
    • many more.
  • Pay bills electronically via a ‘batch’ process to save time.
  • Customise and design better invoices.
  • Manage and track the correct GST on transactions.
  • Reconcile bank accounts, manually and electronically.
  • Reverse and fix errors.
  • Use powerful ‘Recurring Transactions’ to save time.
  • Work with live bank feeds and bank rules to save time.
  • Print reports (P & L, balance sheet, BAS and others)
  • Check security and other important options.
  • Back up and maintain the file.

Payroll Course

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Describe payroll categories and what they mean.
  • Set up general payroll information.
  • Set up wages, salaries, superannuation, taxes, deductions, expenses and entitlements.
  • Set up ‘unusual’ payroll categories (allowances, tax-exempt and super-exempt categories).
  • Set up employee information.
  • Set up employees’ pay templates to save time.
  • Update any payroll opening balances for employees.
  • Describe Tax Tables and load them.
  • Create and process pay-runs and timesheets.
  • Pay employees electronically to save time.
  • Fix employee accrued entitlements with adjustments.
  • Design payslips to comply with ATO regulations.
  • Produce payroll reports and report PAYG and super.
  • Pay PAYG withholding tax and superannuation.
  • Describe and implement Single-Touch-Payroll.

Advanced Data Entry and Reporting Course

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Check your MYOB setup, accounts, GST, etc.
  • Use shortcuts and minimise errors for data entry.
  • Enter tricky transactions, for example:
    • Combined GST and GST-free transactions.
    • Combined business and private transactions.
    • Credit card purchases and payments.
    • Bank loans and entering repayments.
    • Jobs to track work and different departments.
  • Use live bank feeds and create powerful, ‘split’ bank rules for easier reconciling.
  • Use ‘Advanced Find’ features to search for data.
  • Reconcile receivables, payables, and others.
  • View out-of-balance reports and fix errors.
  • Make adjustments to your data correctly.
  • Customise, view and interpret important reports.
  • Use MYOB’s Data Auditor to find errors quickly.
  • Set up and complete the BAS correctly.
  • Lock accounting periods and prevent mistakes.
  • Set up users and restrict access to some functions.

PhotoShop


Essentials & Beyond Course

This is a 3-hour live, online session and participants will learn how to:

  • Enhance greyscale images and colour images.
  • Convert image types (colour to greyscale, etc).
  • Convert file types (TIF to JPG, PCX to GIF, etc).
  • Apply localised enhancement effects (dodge, burn, remove red eye etc).
  • Use clean-up techniques (cloning, erase-to-last-saved).
  • Add and work with text elements.
  • Work with different selection techniques.
  • Apply special effects to whole or parts of Images.
  • Montage and combine images.
  • Work with layers and masks.
  • Prepare images for commercial printing and exporting to the Internet.

Zoom


Essentials & Beyond Course

Want to run seamless Zoom meetings? Avoid high-pressure glitches – before they happen? Learn all this and more in this  2-part live, online session:


In the two sessions, participants will learn how to:

PART 1:

  • Schedule a Zoom meeting – timing, multiple sessions, options, settings, rooms, collaboration, add-ons, etc.
  • Before your Zoom meeting?
    • Invite attendees and use password protection and other security.
    • Control your video and audio content.
    • Adjust your lighting, looking your best and your Zoom Background.
    • Practise speaking to the camera and not the screen.
    • Prepare your slides and optimise Zoom!
  • During your Zoom meeting?
    • Admit your participants to the Zoom room!
    • Mute, unmute and manage your participants.
    • Use the group Chat function.
    • Share your screen to show PowerPoint presentations, files, etc!
    • Record your Zoom session.
  • After your Zoom meeting?
    • See who attended your Zoom meeting.
    • Access your Zoom recording and follow up with participants.
    • Post-meeting Zoom checklist.

PART 2:

  • Followup your homework – any issues with test meeting, queries, Q&As, etc.
  • Zoom advanced features – breakout rooms, Zoom Polls, Zoom security, Zoom annotation, recurring Zoom meetings, registration automation, Virtual consults, and Zoom shortcuts!
  • Zoom Review meeting – How did your homework go, your first Zoom meeting?


Ready to Work Smarter? [ Inquire Now ]
IT Training AND Courses
EDUCATE, ENHANCE & PERFORM
We are here to help you work smarter with your IT tools. Whether it's for business, work or fun, our services will increase your productivity and minimise your stress. Look around for info about our services and courses, dates, bookings, help desk, resources and more.
  • Analysis of your needs.
  • Face-to-face or live, online.
  • Our training rooms or yours.
  • Extensive training manuals.
  • Help desk support.
Our corporate video
Call (02) 6041 2711