Please note that this page is for Non-accredited training. You will receive a Certificate of Participation upon completion of the day.
Duration: 6-8 hours*
Day times: 9.00 am - 5.00 pm (approx.) Monday to Friday
Fee: $240
Please note prices do not include GST
Class size: 12 students - Max, 4 students - Min, please contact us if you require a quote for a smaller class size or 1 on 1 training
Call now to enrol - 0456 CAREER (0456 227 337) or email - training@myhbc.com.au
Read below for course outlines for Level 1, Level 2 and Level 3
This type of software is called spreadsheet software. It is used for organising, storing and manipulating data and allows you to keep track of data that automatically calculate the totals of numerical values you input, you can also:
create charts based from data
perform complex calculations
design a database
use pivot tables
create macro programming language called Visual Basic for Applications (VBA)
and so much more….
Each workbook consists of one or more worksheets. Each worksheet is made up of rows and columns. The types of data that a spreadsheet cell can hold include text, numbers or formulas. A cell is the fundamental unit for data storing in the spreadsheet.
manage budgets
business planning
maintain customers' records and data
analysis of sales data
enrolment records
inventories
financial and accounting applications
planners
time sheets
schedules….and the list goes on
* Number of hours should be used as a guide only. Actual duration will vary depending upon the skills, knowledge and aptitude of the participants. Hunter Business College are not responsible if the student enrols for a course higher than their level so if you are not sure which course/level to book into please contact us for advice. This duration also includes 1/2 hour lunch and 15 min morning and afternoon tea break.
There will be a maximum of 12 students per course and all courses require a minimum 4 students. Please contact us for a quote if you would like a class of less than 4 students at a reduced number of hours.
Hunter Business College will supply text books and working files. Students are to supply their own pens, notebooks and highlighters.
This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2010. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
navigate your way around Microsoft Excel 2010
create a new workbook
open and navigate within workbooks and worksheets
understand and work with ranges in a worksheet
understand, create and work with formulas and functions used to perform calculations
copy and paste data in Excel
understand and use formula cell referencing to create more complex formulas
use font formatting techniques to greatly enhance the look of a worksheet
align the contents of cells in a number of ways
format rows and columns in a worksheet
understand and use the number formatting features in Excel
print your workbook data
create effective charts in Microsoft Excel
If you don't know even some of these topics you should consider starting here. The tips and tricks you will learn will enhance your preparation for moving to Level 2 - Intermediate.
It is highly recommended that you complete the Introduction course before contemplating the Intermediate course.
Please contact us if you have any questions regarding which level is right for you.
You must have completed Microsoft Excel 2010 Level 1 Introduction to enrol in this course and be competent in the Windows operating system environment. If you feel that you have the necessary skills please follow the "Read more about this course" link below to the course outline and if there are any topics you don't know you should either begin at the previous level or contact our office to discuss your queries.
If you don't know even some of these topics, and have completed the Level 1 - Introduction course, you should consider this course.
It is highly recommended that you complete the Level 2 - Intermediate course before contemplating the Level 3 - Advanced course.
Please contact us if you have any questions regarding which level is right for you.
You must have completed Microsoft Excel 2010 Level 2 - Intermediate course to enrol in this course and be competent in the Windows operating system environment. If you feel that you have the necessary skills please follow the "Read more about this course" link below to the course outline and if there are any topics you don't know you should either begin at the previous level or contact our office to discuss your queries.
If you don't know even some of these topics, and have completed the Level 2 - Introduction course, you should consider this course.
Please contact us if you have any questions regarding which level is right for you.