Phone: 0456 CAREER (0456 227 337)

Microsoft Excel 2010


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



​

What is Excel?

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.


Some business and personal uses include:

  • 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.



Excel Introduction - Level 1


Prerequisite:

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.


At the completion of this course you should be able to:

  • 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. 




Excel Intermediate - Level 2


Prerequisite:

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.


At the completion of this course you should be able to:

  • use the fill operations available to fill a data series, and move the contents of cells and ranges within and between workbooks
  • work with logical functions in Excel
  • use a range of formula techniques
  • apply a range of number formatting techniques to data
  • apply conditional formatting to ranges in a worksheet
  • apply borders to cells and ranges
  • apply a variety of page setup techniques and work with various elements of a worksheet
  • use a range of find and replace techniques
  • sort and filter data in a list in a worksheet
  • use a range of techniques to enhance charts


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. 



​

Excel Advanced - Level 3


Prerequisite:

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.


At the completion of this course you should be able to:

  • use a range of lookup and reference functions
  • modify Excel options
  • customise the formatting of charts in Excel
  • create and use labels and names in a workbook
  • protect data in worksheets and workbooks
  • create summaries in your spreadsheets using subtotals
  • use data linking to create more efficient workbooks
  • use the Data Consolidation feature to combine data from several workbooks into one
  • understand and create simple PivotTable reports
  • construct and operate PivotTables using some of the more advanced techniques
  • create and edit a PivotChart
  • use goal seeking to determine the values required to reach a desired result
  • group cells and use outlines to manipulate the worksheet
  • use Solver to solve more complex and intricate problems
  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros


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.