Excel Introduction

Excel is one of the most commonly used software applications especially in the workplace. You can use Excel to enter all sorts of data and perform financial, mathematical or statistical calculations. This comprehensive course covers the essentials of working with Excel 2019. This course covers creating simple spreadsheets and charts using MS Excel. You will learn how to create, edit and save spreadsheets, format data and worksheets, perform calculations using formulae and simple functions and produce simple charts.

Please Bring:

• Notepad/Pen
• Please bring a USB stick to class (around 4GB storage is sufficient)
• A manual will be provided

• A telephone or personal meeting may be required with our Training Coordinator who will provide course information and answer your questions to ensure this is the right course for you before you enrol.
• Unique Student Identifier (see information below).
• Enrolling students may be required to complete a Language, Literacy and Numeracy (LLN) Quiz and/or Digital Skills Questionnaire to confirm suitability for the course and identify any support needs. If you have not previously completed an AQF Certificate III or higher in Australia, an NBMC LLN Quiz may be required. For short courses involving electronic resources or digital participation, you may also need to complete the Digital Skills Questionnaire.
• Confident keyboarding
• Basic Windows PC & file management skills

Create Spreadsheets

• Open spreadsheet application and create/open spreadsheet file and enter numbers, text and symbols into cells according to information requirements
• Enter simple formulas using cell referencing where required
• Correct formulas when error messages occur
• Use a range of common tools during spreadsheet development
• Edit columns and rows within the spreadsheet
• Use the autofill function to increment data where required
• Save spreadsheet to correct directory or folder Customise basic settings
• Adjust page layout to meet user requirements or special needs
• Open and view different toolbars
• Change font settings so they are appropriate for the purpose of the document
• Change alignment options and line spacing according to spreadsheet formatting features
• Format cell to display different styles as required
• Modify margin sizes to suit the purpose of the spreadsheets
• View multiple spreadsheets concurrently

Format Spreadsheet

• Use formatting features as required
• Copy selected formatting features from another cell in the spreadsheet or from another active spreadsheet
• Use formatting tools as required within the spreadsheet
• Align information in a selected cell as required
• Insert headers and footers using formatting features
• Save spreadsheet in another format
• Save and close spreadsheet to disk
• Incorporate object and chart in spreadsheet
• Import an object into an active spreadsheet
• Manipulate imported object by using formatting features
• Create a chart using selected data in the spreadsheet
• Display selected data in a different chart
• Modify chart using formatting features
• Print spreadsheet
• Preview spreadsheet in print preview mode

As part of this course you will be completing the accredited unit:

• Design and produce spreadsheets (BSBTEC302)

On successful completion of the assessment tasks associated with this unit, a Statement of Attainment will be issued.

This course may be fully funded for many Australian citizens; permanent residents; New Zealand citizens and Humanitarian Visa Holders under the NSW Government’s Adult & Community Education or Targeted Skills for Small Business funding. See ACE* Funding page or TSB* Funding page for details.  To see if you are eligible check the Funding Eligibility Calculator below, or contact Jo Mellor on 9970 1052 or email outreach@nbmc.nsw.edu.au for further information.  Subject to funding availability.

An application form for any of the courses that may be funded under ACE or TSB must be completed.  To see if you are eligible, and to apply online, go to the Funding Eligibility Calculator below.   Alternatively, you can contact Jo to arrange an appointment to meet and complete a form at the College. We can then assess your eligibility and your training needs to work out an individual training plan (which may include more than one course) to provide a pathway to further training and/or improved employment opportunities.

If not eligible for the funding, a fee for service enrolment is possible below.

*This training is funded by the NSW Government.

From 1 January 2015 it is a requirement of the Federal Government that all students undertaking nationally recognised training will need to obtain a Unique Student Identifier (USI). This involves an easy online application. See USI Fact Sheet for information on how to apply for a USI go to the Unique Student Identifier (USI).

If you are applying for funded training a USI is a requirement.

Website for additional information: https://www.usi.gov.au/students/get-a-usi.

Please ensure when completing your enrolment information, that the details relating to your name are identical to those on the identification evidence (eg passport or driver’s licence) used when creating your USI, eg no abbreviations or nicknames should be used. Once created, it is important that you keep a record of your USI and access to your accredited training records in a safe place. You will need this information for any future enrolments into accredited training in Australia.

Please contact the College on 9970 1000 if you require assistance.

This is a means of measuring skills acquired through work or life experiences, or through qualifications obtained from formal studies or training.

There are two options for recognising prior learning:

Recognition of Prior Learning (RPL)

This is an assessment process to evaluate skills and knowledge gained through work experience, life experience or non-accredited training.

Credit Transfer (CT)

This is recognition of current qualifications/units of competency previously gained through a Registered Training Organisation (RTO).

For more information please head to our Recognition of Prior Learning page.