• 6 months free course repeats
  • 6 months online access to eLearning course content
  • 60 day post course help-desk support
  • Complimentary pre-course assessments ensure students are enrolled in the correct level of training
 
 
  • New Horizons is a Registered Training Organisation (RTO)
  • New Horizons employs vendor certified and industry experienced trainers which ensures clients receive training from qualified instructors
  • Centrally located facilities in the heart of the CBD

    Click here for to view the complete list...
 
  New Horizons has extensive experience in helping organisations ensure a smooth Office upgrade by providing employees with the skills they require to maintain workplace productivity. Call 1300 794 006 to find out more.
 
> Download our Microsoft Office Upgrade and Rollouts Guide
 
  New Horizons offers complimentary pre-course assessments to help you determine the right course for your needs. Click here to contact an Account Manager for assistance. 
 
  New Horizons offers the following training delivery options for Microsoft Excel courses: 
 
  
  *Number of Excel users trained is based on all levels and all versions (Excel 1997-2010) of Excel courses delivered by New Horizons' from 1999 to present date.  
 
  
  • Excel 2010
  • Excel 2007
  • Excel 2003
Excel 2010 Level 1 1 day
   SKILLS COVERED:
  • Excel User interface
  • Work with cells
  • Basic formulas
  • Using functions
  • Manipulating data
  • Search for data
  • Modify fonts
  • Number formatting
  • Cell styles
  • Page layout options
  • Set page breaks
  • Printing
  • Using spreadsheets
  • Manage worksheets
Excel 2010 Level 2 1 day
   SKILLS COVERED:
  • Apply range names
  • Advanced formulas
  • Using functions
  • Create tables
  • Format tables
  • Sort and filter
  • Charts
  • PivotTable Reports
  • Analyse data with PivotTables
  • Draw & modify shapes
  • Customise Excel environment
  • Manage Themes
Excel 2010 Level 3 1 day
   SKILLS COVERED:
  • Creating Macros
  • Conditional formatting
  • Data validation
  • Share workbooks
  • Set revision tracking
  • Merge Workbooks
  • Restrict access
  • Formula errors
  • Create trendlines
  • "What-if" analysis
  • Consolidate data
  • Export excel data
  • Publish to the web
  • Develop XML data
Excel 2010 Level 4 1 day
   SKILLS COVERED:
  • Manipulating Data
  • Mining Data
  • Lookup Function
  • Reference Functions
  • Data Analysis Tools
  • Financial Functions
  • Investment Schedules
  • Math Functions
  • Text Functions
  • Information Functions
  • Advanced Templates
  • Advanced Charts
  • Managing Data in Workbooks
Excel 2010 PivotTables 1/2 day
   SKILLS COVERED:
  • Inserting a PivotTable
  • Categorise  Data
  • Customise a PivotTable
  • Analyse Data in PivotTables
  • Custom Calculations
  • Restructure a PivotTable
  • Presenting  Data
  • Formatting a PivotTable
  • Present a PivotChart
  • Print PivotTables & PivotCharts
Excel 2010 PowerPivot 1 day
   SKILLS COVERED:
  • Importing Data
  • Create Linked Tables
  • Organise & Format Tables
  • Calculated Columns
  • Sort & Filter PowerPivot Data
  • Table Relationships
  • PowerPivot Reports
  • Using DAX Functions
  • Time Dependant Data
  • Distributing Data
  • Save Reports in Various File Formats
Excel 2010 VBA 3 days
   SKILLS COVERED:
  • Setting macro security
  • Recording a macro
  • Cell references
  • Object collections
  • Property values
  • Command procedures
  • Comments
  • Creating variables
  • Declarations
  • Variable scopes
  • Data types & arrays
  • If statements
  • Custom forms
  • Creating error handlers
Excel 2010 Transition (From 2003) 1/2 day
   SKILLS COVERED:
  • User interface
  • The "ribbon"
  • Customise interface
  • Insert & format tables
  • Conditional formatting
  • Create PivotTables & PivotCharts
  • Sort & filter data
  • Create & format charts
  • Work with illustrations
  • Save data in compatable formats
  • Save spreadsheets to the web
Excel 2007 Level 1 1 day
   SKILLS COVERED:
  • Excel User interface
  • Enter and save data
  • Basic formulas
  • Using functions
  • Manipulating data
  • Search for data
  • Modify fonts
  • Number formatting
  • Cell styles
  • Page layout options
  • Set page breaks
  • Printing
  • Using spreadsheets
  • Manage worksheets
Excel 2007 Level 2 1 day
   SKILLS COVERED:
  • Apply range names
  • Advanced formulas
  • Specialised functions
  • Create tables
  • Format tables
  • Sort and filter
  • Charts
  • PivotTable Reports
  • Analyse data with PivotTables
  • Draw & modify shapes
  • Customise Excel environment
  • Manage Themes
Excel 2007 Level 3 1 day
   SKILLS COVERED:
  • Creating Macros
  • Conditional formatting
  • Data validation
  • Share workbooks
  • Set revision tracking
  • Merge Workbooks
  • Restrict access
  • Formula errors
  • Create trendlines
  • "What-if" analysis
  • Consolidate data
  • Export excel data
  • Publish to the web
  • Develop XML data
Excel 2007 Level 4 1 day
   SKILLS COVERED:
  • Statistical functions
  • Data mining
  • Reference functions
  • Financial functions
  • Manipulate data
  • Validate data
  • Advanced templates
  • Advanced charts
  • Retrieve & paste data
  • Determine the Conditional sum
  • Identify data with Lookup Wizard
  • Clean data
Excel 2007 VBA 3 days
   SKILLS COVERED:
  • Setting macro security
  • Recording a macro
  • Cell references
  • Object collections
  • Property values
  • Command procedures
  • Comments
  • Creating variables
  • Declarations
  • Variable scopes
  • Data types & arrays
  • If statements
  • Custom forms
  • Creating error handlers
Excel 2007 New Features (From 2003) 1 day
   SKILLS COVERED:
  • User interface
  • The "ribbon"
  • Customise interface
  • Insert & format tables
  • Conditional formatting
  • Create PivotTables & PivotCharts
  • Sort & filter data
  • Create & format charts
  • Create PivotTables
  • Save data in compatable formats
  • Save spreadsheets to the web
Excel 2003 Level 1 1 day
   SKILLS COVERED:
  • Navigate interface
  • Select & enter data
  • Basic formulas
  • Using functions
  • Manipulating data
  • Absolute references
  • Modify fonts
  • Number formatting
  • Cell styles
  • Page layout options
  • Set page breaks
  • Printing
  • Using spreadsheets
  • Manage worksheets
Excel 2003 Level 2 1 day
   SKILLS COVERED:
  • Custom Templates
  • Comments
  • Create hyperlinks
  • Create Charts
  • Create Diagrams
  • Insert Graphics
  • Apply range names
  • Date & time functions
  • Financial functions
  • Statistical functions
  • Logical functions
  • Advanced filters
  • Add subtotals
  • Publish to web
Excel 2003 Level 3 1 day
   SKILLS COVERED:
  • Creating Macros
  • Conditional formatting
  • Data validation
  • Share workbooks
  • Set revision tracking
  • Merge Workbooks
  • Restrict access
  • Formula errors
  • Create trendlines
  • "What-if" analysis
  • Consolidate data
  • Export excel data
  • Publish to the web
  • Develop XML data
Excel 2003 VBA 3 days
   SKILLS COVERED:
  • Setting macro security
  • Recording a macro
  • Cell references
  • Object collections
  • Property values
  • Command procedures
  • Comments
  • Creating variables
  • Declarations
  • Variable scopes
  • Data types & arrays
  • If statements
  • Custom forms
  • Creating error handlers
 
  
 
Name:
Company:
Phone:
Email:
Location:
How can we assist you?:

   

Home | Search | Site Map | Legal | Privacy Policy | Terms of Use | Contact | Links & Resources | Career Opportunities

Copyright © 2009 New Horizons Learning Centres Holdings Pty Ltd. All rights reserved. ABN: 86 168 459 086


Developed by Globe Web Services