Call on 1300 794 006 Advanced Search

Home > Desktop Applications > Microsoft Excel > Microsoft Excel 2003

Excel 2003 - Level 2 Book a course:   Location: Sydney Melbourne Brisbane Perth Date: Choose a date... 20 Mar 12 - 20 Mar 12 14 May 12 - 14 May 12 18 Jul 12 - 18 Jul 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: $440.00 inc. GST Print Preview | Send to a friend    Learning Method: Instructor Led Duration: 1 Day Overview: In this course, you will use Microsoft Office Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Target Audience: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets. Pre-requisites: Excel 2003 - Level 1 At Course Completion: You will apply visual elements and advanced formulas to a worksheet to display data in various formats. Outline: Expand All Module 1: Creating and Applying Templates Create a Workbook from a Template Create a Custom Template Working with Comments Create a Hyperlink Use Web-based Research Tools Module 2: Creating and Modifying Charts Create a Chart Format Chart Items Change the Chart Type Create a Diagram Module 3: Working with Graphic Objects Insert Graphics Create AutoShapes Format Graphic Objects Change the Order of Graphic Objects Group Graphic Objects Move, Copy, and Resize Graphic Objects Module 4: Calculating with Advanced Formulas Create and Apply a Name for a Range of Cells Calculate Across Worksheets Calculate with Date and Time Functions Calculate with Financial Functions Calculate with Statistical Functions Calculate with Lookup and Reference Functions Calculate with Logical Functions Module 5: Sorting and Filtering Data Sort Data Lists Filter Data Lists Create and Apply Advanced Filters Calculate with Database Functions Add Subtotals to a Worksheet Module 6: Using Excel with the Web Export Excel Data Publish a Worksheet to the Web Import Data from the Web Create a Web Query

Course Ratings Averaged from 20,443 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 2003 - Level 1 Next Course Excel 2003 - Level 3 Related Courses Business Problem Solving Financial Management for Non-Finance Managers VBA EXCEL 2003 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