Word and Excel Training

The Ultimate 1 Day Course
Get in Touch
onsite excel training sydney

Word and Excel Training 

Our 1 Day Excel and Word training course is designed for users who need to get up to speed fast with creating professionally presented Word documents and Excel spreadsheets. Learn how to effortlessly create spreadsheets in Excel including formulas and functions and Word documents that contain pictures, tables and more. Our trainers will provide you with the tools, tips and tricks that will get you ahead of the game fast.


Classroom Courses

Browse Classroom Course Dates

Group Training

Book an onsite group course at your office or at one of our training rooms

One on One Course

Learn more about one on one training

View our Prices page or Get a Quote

Word and Excel Essentials

Word and Excel Training

This training course is aimed at users who may be self taught with little or no knowledge of Word and Excel requiring a combined course that covers the essential tools required in every job role.


Course overview

This course is ideal for beginners who want to learn how to produce formatted spreadsheets and perform calculations in Excel and produce professional Word documents.

Course prerequisites

Participants will need to be familiar with Microsoft Windows and basic Windows techniques such as opening, closing and saving files. Users also need to be comfortable typing on a keyboard and using a mouse. Please note that our classroom courses use laptops.

What you will learn

  • Create, modify and format a spreadsheet including formulas
  • Create Word documents using a variety of different everyday tools

Course Topics

  • Excel
  •  Overview
    • Keyboard and mouse shortcuts
    • Entering data
  • Formatting the worksheet
    • Number and date formats
    • Fonts, colours, borders, sizes
    • Adjust column widths
    • Centre aligning
    • Merge and Centre
    • Text Wrap
  • Formulas
    • The Sum function
    • AutoSum
    • AutoFill a formula
    • Basic formulas to add, subtract, multiply, divide and calculate percentages
    • Editing formulae
  • Working with columns and rows
    • Inserting columns/rows
    • Deleting columns/rows
    • Hiding columns/rows
    • AutoFill 
  • Printing and page setup
    • Print preview
    • Margins, orientation, scaling
    • Page layout 
    • Page break preview
    • Headers and footers
    • Print
    • Save as PDF
  • Word
    •  Overview
    • Formatting a Document
      • Font Formatting (bold, colours, size)
      • Paragraph Formatting (spacing, indents, alignment, bullets and numbers)
    • Tables
    • Pictures
    • Headers and Footers
    • Page Breaks
    • Page Numbering
    • Printing and Page Layout

If you’re looking for other classroom short courses, view our Classroom Dates.

Microsoft Office short courses are available on site throughout NSW including Sydney CBD, Parramatta, Wetherill Park, Mascot, Hills District, North Sydney, Chatswood, St Leonards, Smithfield, Ryde, Pennant Hills, Sutherland Shire, Norwest, Macquarie Business Park, Bondi, Horsnby, Arndell Park, St Marys, Penrith, Fairfield and Northern Beaches. Check out our public course dates and competitive prices.

We cover all Microsoft applications including Excel, Word, PowerPoint, Access, OneNote, Publisher, Outlook, MS Project, Office 365




Level 3, Suite 2, 828 Pacific Hwy, Gordon NSW 2072

02 9454 7702