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 OUTLINE 1 DAY

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

 

Useful Course Information

  • Our trainers contract for some of the largest providers in Sydney guaranteeing quality delivery at affordable prices
  • Training courses can be delivered on site at your offices or at one of our training venues in Sydney CBD or Northern Beaches
  • Full day courses run from 09:30 – 16:00 with a 45 minute lunch break but we also offer short courses too
  • Soft copy training manuals are included
  • Our trainers can use your examples
  • We offer classroom based training with small class sizes
  • Course outlines can be tailored to suit your needs
  • We are so certain you will be happy with our training that we offer a money back guarantee if you are not satisfied
  • All of our trainers are certified with many years of corporate training experience
  • Our pricing is competitive because our overheads are low
  • We offer free laptop hire to all Microsoft courses in Sydney
  • A free training needs analysis is included in our service
  • We offer lifetime membership of our online user support group for all IT courses

FIND US

 

Suite 3, 6/49 Frenchs Forest Rd E, NSW2097

02 9454 7702