Excel

                 

Excel Introduction
(1 day or 2 evenings)

General Outline

This course concentrates on the simple basics of using a spreadsheet application. You will be taken through what’s meant by a ‘spreadsheet’, and will see how it works and how to create one. Then, the basic aspects of adding text and numbers, as well as simple formulas, to the spreadsheet will be covered in the hands-on exercises.

Editing and formatting data will be covered, allowing you to see how easy it is to change and manipulate the information on your spreadsheet. Then you will learn how to create charts that will graphically display your data and information. All through the hands-on exercises, you will practise the keyboard shortcuts and mouse shortcuts that will save time and money.

Main Skills Acquired

Describing the Excel screen

Using the Online Help features

Entering basic spreadsheet formulas

Setting up the page, page size, margins

Creating a full spreadsheet

Navigating with mouse and keys

Zooming in/out and arranging windows

Cutting, pasting and copying formulas

Editing text, data and formulas

Formatting a spreadsheet

Creating a chart

Editing a chart

Excel Intermediate
(1 day or 2 evenings)

Main Skills Acquired

Revising the important shortcuts

Apply more advanced charting features

Drawing and importing graphics

Name cell ranges to use formulas more easily and more quickly

Use absolute references in formulas

Grouping and Outlining data to summarise information

Creating 3-dimensional spreadsheets and copying sheets

Creating SubTotals from Raw Data

Creating and Using Pivot Tables

Creating ‘What If’ formulas (Goal Seek)

Excel Advanced
(1 day or 2 evenings)

General Outline
This course is for the power-users of Excel. It takes you through the main aspects of creating macros, how to edit them, and how to create shortcuts for them. More powerful Excel functions, such as IF statements and lookup tables, and when to use them are covered in the exercises. Excel’s statistical functions, accessed through its data analysis pack, are covered in the training manual and will allow you to apply the techniques to your own projects.

Other aspects covered in this course include how to transfer data between Excel and other Office applications using DDE and OLE. The meanings of these are also covered. You are also taken through an introduction to Visual Basic for Excel and protection and locking of spreadsheets.

Main Skills Acquired

Apply more advanced formulas (SUMIF, COUNTIF, text manipulation formulas)

Importing other types of files

Using Excel's database features

Using Lookup functions

Creating and working with macros

Customising the toolbars and menus

Using Excel Visual Basic for programming

Applying protection to spreadsheets

Integrating Excel with other programs

Using Data Validation and Conditional Formatting features

Excel General Information
(1 day or 2 evenings)

Previous Experience Recommended
Introductory Course: Experience with a mouse and Windows is recommended.
Intermediate Course: CLASS Training Introductory Course or proven experience with Excel.
Advanced Course: CLASS Training Intermediate Course or proven experience with Excel.

Class Size
The number of trainees is restricted to a maximum of 10, or as required by your organisation. Each trainee is trained on a Pentium 4 PC with 17" flat-screen monitor and access to broadband Internet, printing and demonstration facilities.

• Training manual: Our training manual contains hands-on exercises that are easy-to-follow, and are practical and relevant. The training manual will also serve as an excellent reference tool back at the office or home long after the course. Our training manuals are developed and produced in-house by our experienced tutors, who have used the software in real-world situations. All exercises follow a logical sequence and show you how to tackle your typical projects. A list of keyboard shortcuts and other important information is included.
  
  
• Refreshments: For full-day courses, you will receive a comprehensive lunch and refreshments.
  
  
• Customisation of courses: We can redesign our courses to cover other or additional outcomes and so make our courses even more relevant for you. Please inquire about this if you have any specific needs.
  
  
• Support: Free unlimited phone support on the material covered is provided for all courses. The support means that you can phone us during business hours or e-mail us anytime to get answers about any specific problems you might have. If we can't solve your problem immediately we will do some research and get back to you.
  
  Please note: This free support only covers your specific questions that relate back to the material covered in the course you attended. We can provide you with consultancy for additional help you might need beyond that.
  
  
• Complimentary Follow-up: When the course is running again later and there is a seat available, you'll be invited back for a free refresher. This can be used for fine-tuning your skills or for asking any specific questions you might have. You can come for the whole course or just part of it, and it's a great way to ensure that you maintain your momentum in using the program.
  
  
• Certificate: You'll receive a certificate of achievement which details the outcomes you achieved for the particular course attended.

Booking Your Place
If relevant, check with your training coordinator for availability of places and dates. Alternatively, you can check our course calendar, then book online to secure your place on one or more of these courses. You can also fax us on (02) 6041 4811 or e-mail at office@classtraining.com.au. If you have any specific queries, or would like to discuss your needs, please phone Mark or Jenny on (02) 6041 2711.