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
- 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
FOLLOW US