About This Training Course

Objectives of this Excel Intermediate 2010 Training Course are to enable experienced users of Microsoft Excel to consolidate their knowledge of formulae and functions and unlock the graphics and database features contained within this powerful spreadsheet application.

Subjects Covered

This Excel Intermediate 2010 Training Course will cover the following subjects:

REVIEW OF INTRODUCTORY CONCEPTS
• Overview of topics covered during Introductory Excel course
CELL REFERENCING
• Absolute and relative cell referencing
• Partial Cell referencing
• Tracing precedents
• Naming Ranges
• Working with labels and Names

LOGICAL FUNCTIONS
• Using the IF, AND and OR functions
• Combining and embedding logical functions

LOOK UP FUNCTIONS
• Using LOOK UP and LOOK UP functions
EXCEL DATABASE CONCEPTS
• Using the sort tool
• Using the database form tool
• Searching for records
• Using Autofilter and advanced filter tool

WORKING WITH EXCEL FILES
• Linking workbooks
• Creating templates
• Importing and exporting data
• Protecting data

WORKING WITH DATA
• Using the fill handle
• Data validation
• Conditional formatting
• Summarising data
• Creating pivot tables
• Working with goal seeking and scenarios

Training Course Outcomes

At the end of the Excel Intermediate 2010 Training Course, participants will have a good understanding of functions and formula and be able to sort data, filter database and analysis data using pivot tables and what-if tools .

Prerequisites

Completion of Microsoft Excel Introduction course, 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 Startnextweek.com.au on 1300 728 102