Home » Microsoft Excel Essential Skills – Beginner – Stage 1

This is an invaluable course for anyone new to Excel

read more testimonials

Microsoft Excel Essential Skills – Stage 1

Half-day course (3.5 hours)

Microsoft Excel Beginner course   About this course

This introductory course is offered as a 3.5 hour onsite short-course focusing on getting you started in Excel. It covers the skills that are essential to creating professional worksheets.

BOOK NOW

  Is this course suitable for you or your team?

This course is aimed at people who will be creating or updating Excel worksheets in a business environment. This course is definitely for you if…

  • You are new to Excel and would like a beginner course
  • You currently make minor updates to existing files and would now like to learn how to create worksheets from scratch
  • You haven’t used Excel for a while and would like a refresher course

   Prerequisite

As this is a beginner level course the only prerequisite is that the learner is proficient in using the Microsoft® Windows environment, a mouse and keyboard

   Learning objectives

This hands-on course takes learners through creating an expenses workbook. You will learn how to layout the expense sheet, add calculations, insert additional data, quickly apply formatting to give the worksheet a professional look, preview and print the worksheet.

Additional exercises and practice files are supplied for use during the training and for use post-training, allowing you the opportunity to repeat the exercises again in your own time.

By the end of this course you should be able to confidently:

  • Move around the Excel screen
  • Insert and edit data in a workbook
  • Create basic calculations using formulas and the SUM function
  • Apply formatting to data
  • Apply borders and colour to enhance the presentation of the data
  • Set the page options to ensure the worksheet prints correctly
  • Preview and print the worksheet

   Attendance Certificate

Need proof of your Continuing Professional Development (CPD)? On completion of the session, by request, we will send you a “Certificate of Attendance” confirming your participation and the duration of the training session.

   Course Duration

Workshop delivery consists of 3.5 hours hands-on tuition. Please note the duration is set for a maximum of 12 people.

   Price and Booking details

We bring the training to you. That’s right! We don’t run scheduled courses. We come onsite to your place of work on a day and time that works for you. Avoid traffic and parking hassles and learn at work. And if you don’t have a laptop, we can lend you one. We have 6 to share. Pricing is adjusted depending on the number of attendees. Minimum of 3, maximum of 12.

3 to 4 people – $285+GST per person
5 to 7 people – $265+GST per person
8 to 12 people – $245+GST per person

 Book now! Save the date for this onsite Excel course

Dates and preferred times go quickly so book yours today!

Use our online booking system to reserve and manage your session.
Our Booking Terms and Conditions

BOOK NOW

COURSE CONTENT

Getting Started

  • Starting Excel and opening a workbook
  • Working with the Excel Ribbon and tabs
  • Working with sheet tabs – inserting and renaming
  • Selecting cells and cell ranges

Entering data

  • Entering and deleting data
  • Adjusting column width and row height
  • Quick keys to move quickly around the worksheet and workbook

File operations

  • Saving a workbook – Save vs Save As
  • Creating a new workbook
  • Closing a workbook

Creating calculations

  • Creating calculations – formulas
  • Understanding why and when to include brackets
  • Editing calculations
  • Using the SUM function
  • Calculating percentages and GST

Modifying the worksheet

  • Making changes to the data
  • Inserting, deleting and hiding rows and columns
  • Moving and copying data
  • Moving and copying data
  • Copying calculations using absolute $

Formatting the worksheet

  • Adding colour and borders
  • Applying currency, percentage and comma formats
  • Changing the alignment of data
  • How to remove formatting from cells

Selecting suitable Page Setup options

  • Using scaling options to control how your worksheet prints
  • Changing the page from portrait to landscape
  • Selecting suitable margins
  • Setting Print Titles so that column headings print at the top of every page

Printing in Excel

  • Previewing the worksheet before printing
  • Setting a print area and print titles
  • Printing the worksheet(s)

Already applying their knowledge

Just want to say a big thank you for the day, the delivery and the content. The referral forms all speak for themselves and the team are already applying their knowledge.
Penny Smith, Village Manager Hillsborough Heights – Metlifecare

read more testimonials

Invaluable Course

This is an invaluable course for anyone new to Excel and I highly recommend Sharyn.
Candice Murphy, Home Direct

read more testimonials

Great Session

Awesome teacher. I knew the basics of Excel but learnt a lot more today. Well worth doing. Manual is great. Glad we can keep this to go back to.
Trudy Piercy, after attending an Essential Skills session

read more testimonials