Call on 1300 794 006 Advanced Search

Home > Desktop Applications > Microsoft Excel > Microsoft Excel 2007

Excel 2007 - Level 4 Book a course:   Location: Sydney Melbourne Brisbane Date: Choose a date... 21 Feb 12 - 21 Feb 12 12 Apr 12 - 12 Apr 12 07 Jun 12 - 07 Jun 12 {None} 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM   Duration: 1 Day Time: 9:00 AM - 5:00 PM   Price: $375.00 inc. GST Print Preview | Send to a friend    Learning Method: Instructor Led Duration: 1 Day Overview: In this course, students will use the advanced features of Microsoft® Office Excel® 2007 to attain a high degree of proficiency as an Excel power user. Target Audience: This course is designed for advanced Microsoft Office Excel professionals who may work or be interested in the domain of finance, statistics, project analysis, and market analysis who wish to improve their skills in using Excel formulas and functions. Pre-requisites: Before attending this course, students must have: Excel 2007 - Level 1 Excel 2007 - Level 2 At Course Completion: Upon successful completion of this course, students will be able to: Forecast data using functions. Analyze data using the data analysis tools in Microsoft Office Excel 2007. Make investment decisions using the financial functions in Microsoft Office Excel 2007. Examine data using math functions in Microsoft Office Excel 2007. Manipulate data using text and information functions in Microsoft Office Excel 2007. Create templates and work with the advanced chart options. Manage data in Excel workbooks. Outline: Expand All Module 1: Manipulating Data Using Statistical and Lookup Functions Evaluate Sales Data Using Statistical Functions Analyze Stock Data Using Statistical Functions Mine Data Using the Lookup and Reference Functions Module 2: Working with Data Using Financial Functions Develop an Investment Schedule Using Financial Functions Make Investment Decisions Using Financial Functions Module 3: Manipulating Data Using Text and Information Functions Manipulate Data Using Text Functions Validate Data Using Information Functions Module 4: Working with Templates and Charts Create Advanced Templates Create Advanced Charts Module 5: Managing Data in Workbooks Retrieve and Paste Data Determine the Conditional Sum Identify Specific Data Using the Lookup Wizard Clean Data in Workbooks

Course Ratings Averaged from 529 responses. Instructor's Knowledge Training Quality Training Objectives Training Overall Courseware Quality What do these ratings mean? Extraordinary Great Good Average Poor Previous Course Excel 2007 - Level 3 Next Course VBA EXCEL 2007 Related Courses Business Problem Solving Excel 2007 - Level 1 Excel 2007 - Level 2 Excel 2007 New Features Financial Management for Non-Finance Managers Name: Company: Phone: Email: Location: BrisbaneCanberraCrn-CairnsMelbournePerthSydney How can we assist you?: Bookmark & Share

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