About This Training Course

Objectives of this Perth <b>Excel Intermediate 2007 & 2010 Training Course</b> are to enable experienced users of Microsoft Excel to consolidate their knowledge of formula and functions and unlock the graphics and database features contained within this powerful spreadsheet application.

Subjects Covered

This <b>Excel Intermediate 2007 & 2010 Training Course</b> will cover the following subjects:

• Review Introductory concepts
• Absolute and relative cell references
• Using the logical functions (IF, AND,NOT)
• Using LOOKUP functions
• Excel Database concepts
• Sorting data using single and multiple fields
• Using a database form to insert, edit and delete data
• Specifying criteria in order to find records
• Using the filter and autofilter commands
• Creating custom autofilters
• Excel Charting Concepts
• Creating line charts, bar charts and pie charts using the Chart Wizard
• Modifying data ranges and setting chart options
• Formatting charts
• Printing charts
• Linking charts to other applications

Training Course Outcomes

At the end of this <b>Excel Intermediate 2007 & 2010 Training Course</b>, participants will have a good understanding of functions and formula and be able to sort data and filter database tables and create customised charts .

Prerequisites

Completion of <b>Microsoft Excel Introduction course</b>, or equivalent knowledge, is necessary

Other Information

Put MICROSOFT on your resume!
ATI-Mirage is an Authorised Testing Centre for Microsoft Office Applications - enabling YOU to gain Microsoft Office Specialist certification, a globally recognised credential which PROVES the skills you have gained in desktop computing and helps you to achieve higher productivity and efficiency than your peers!

If you need further information contact <b>Startnextweek.com.au on 1300 728 102</b>