2007Ó  Integrity Computer Solutions.
Home

Training

Courses

About Us

Contacts

Not Sure? Call us in person

    QUICK LINKS    

       COURSES

       
       
       SCHEDULE Jan ~ June 2008
       SCHEDULE July ~ Dec 2008

       BOOK ONLINE

Welcome to the NEW Learning Laboratory Web Site.

Scroll down to click on the links below to see the latest information on courses available, and schedules, as well as book online.

There are many new changes happening at The Learning Laboratory. We are pleased to announce new PC's in all classrooms, which will increase the flexibility of our room configurations.

We are also Vista ready to train you and your team in all aspects of the new Vista operating system, and Microsoft's new Office 2007.

Please note as of January 2008, course durations and content will be slightly adjusted to further suit our clients needs. Our schedules and outlines will soon be updated  to reflect these changes.
The


Learning Laboratory
innovate       results       trust
ABN: 94 081 457 454
11th Floor
Adelaide Bank Building
90 King William Street
ADELAIDE SA 5000
Tel. 1300 731 451
Fax. (08) 8231 2427
www.learnlab.com.au
labinfo@learnlab.com.au
Integrity
Training Solutions
innovate       results       trust
ABN: 58 309 252 680
Suite 2, Level 1
902 Mt Alexander Road
Essendon VIC 3040
Tel. 1300 731 451
Fax. (03) 9372 9382
www.integritytrainingsolutions.com
info@integritytrainingsolutions.com
A division of...
Microsoft Excel Introduction Day 1 - Course Outline


Duration
1 day Course

Course Aims
This course will provide the user with the skills necessary to complete a basic spreadsheet.

Please Note:     The Excel Introduction course is composed of two days (Introduction Day 1 and Introduction Day 2) you can choose to complete the two days consecutively or separately or choose to attend only one of the days.

Learning Outcomes
Upon completion of this course the participant will be able to:

• enter, edit, delete, clear and select data  • build a basic formula
• manage worksheets  • understand functions
• work with cells, rows and columns  • format existing data

Training Method
Training is conducted by professional trainers, using hands on exercises and user practise to consolidate concepts.

Prerequisite
Windows XP Getting Started or equivalent. Participants must have basic mouse skills.

Course Content
Getting Started
• Starting and Closing Excel   • The Workbook Window
• Moving around the Worksheet   • Using the Edit, Go To Command
• Ending the Current Excel Session

Survival Skills
• Choosing a Command using the Keyboard   • Choosing a Command using the Mouse
• Cancelling a Command Selection   • Using Short Cut Menus
• Moving between Worksheets   • Opening and Closing Workbooks
• Creating and Saving a Workbook   • Opening a Recently Used Workbook
• Opening Several Workbooks at One Time

Worksheet Skills
• Identifying Data Types   • Entering Data
• Abandoning Data Entry   • Using Undo and Redo
• Using AutoComplete   • Editing Existing Data
• Deleting Data Only   • Deleting Data and Formatting
• Using AutoFill   • Fill Sequences

Selecting
• Moving through Selected Cells   • Moving and Copying
• Changing Column Widths   • Changing Row Heights
• Inserting Cells, Rows and Columns   • Deleting Cells, Rows and Columns
• Working with Sheets   • Renaming Sheets
• Inserting and Deleting Sheets   • Hiding and Unhiding Sheets

Formulas
• Types of Formulas   • Building a Basic Formula
• The Order of Precedence   • Using the SUM Function
• Using AutoSum   • Relative and Absolute Cell References
• Formatting Cells   • The Formatting Toolbar
• The Format, Cells Menu   • Copying Cell Formatting
• AutoFormats

Printing
• Overview   • Printing using Excel’s Defaults
• Changing Page Setup   • Page Options
• Margins Options   • Header and Footer Options
• Sheet Options   • Print Preview
• Changing Margins via Print Preview   • Page Breaks

Training Needs Analysis                Schedule