 |
| |
|
| |
 |
| |
|
| |
Level 12
379 Collins Street
Melbourne
VIC 3000
TEL: 1300 888 724
EMAIL: |
|
| |
|
|
|
|
Microsoft Office Specialist |
|
"I would definitely recommend Jenny Grimes as an instructor. She provided real world experience and kept the pace at a reasonable level." Angela Dickinson - Datacom Connect
"The course was well run and i will definately be interested in training here in the future." Chris Richardson - Medfin Australia |
| |
|
|
| |
|
|
|
| |
Microsoft Excel 2003 Level 2 |
| |
|
|
| |
This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.
Students should have already completed Excel Level 1 course or know how to create and save an excel workbook, enter simple formulas and print and chart data.
|
| |
This course shows you how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and to use the sorting and filtering features to manage and analyse data. |
| |
|
|
| |
Upon successful completion of this course, students will be able to:
* Work with one or more workbooks at once
* Use a range of techniques to work with worksheets
* Adjust the sizing of columns and rows in a workbook
* Use a variety of viewing techniques to view worksheets
* Format cells in a workbook
* Understand and use absolute referencing in a workbook
* Use the fill technique to enter data into cells
* Use names and labels
* Use a range of logical functions
* Use the various Lookup functions
* Sort data in lists in a workbook
* Use autofilter to display data in lists selectively. |
| |
|
|
| |
Each student will receive:
* Certificate of completion
* Training Manual
* 12 months FREE email support
* FREE class re-sit (if necessary) |
| |
|
| 1 Day |
| Max 8 Students |
| 9.00am to 5.00pm |
| $385 incl GST |
| |
|
|
| |
| |
Unit 1: Working With Workbooks
*
The Open Dialog Box
* Opening A Workbook
* Closing A Workbook
* Opening Multiple Workbooks
* Working With Multiple Workbooks
* Opening Recently Used Workbooks
Unit 2: Working With Worksheets
* Copying A Worksheet
* Renaming Worksheets
* Moving Worksheets
* Inserting And Deleting Worksheets
* Grouping Worksheets
Unit 3: Adjusting A Worksheet
*
Inserting Cells
* Deleting Cells
* Inserting Columns
* Inserting Rows
* Deleting Rows And Columns
* Resizing Columns
* Resizing Rows
* Hiding Grid Lines
Unit 4: Viewing Worksheets
* Freezing Columns And Rows
* Splitting Windows
* Using Zoom
* Hiding Rows And Columns
Unit 5: Absolute Referencing
* Absolute And Relative Referencing
* Problems With Relative Formulas
* Tracing Precedents
* Creating Absolute References
* Creating Mixed References
* Circular References
Unit 6: Filling Series
* Filling A Series
* Filling A Growth Series
* Filling A Series Backwards
* Filling Using Options
* Creating A Custom Series
* Modifying And Deleting Custom Series
Unit 7: Labels And Names
* Labels and Names Explained
* Accepting Labels In Formulas
* Using Text Labels
* Creating Labels
* Creating Names Using The Name Box
* Using Names To Select Cells
* Using Names In Formulas
* Creating Names Between Workbooks
* Creating Names For Constants
* Creating A List Of Names
* Changing The Range For Names
* Deleting Names
Unit 8: Logical Functions
* Logical Function Concepts
* Displaying Information Using IF
* Displaying Values Using IF
* Nesting An IF Function
* Using The AND Function
* Using The OR Function
* Using the NOT Function
Unit 9: Lookup Functions
* Requirements Of Lookup Functions
* The CHOOSE Function
* The ISERROR Function
* The VLOOKUP Function
* Testing Lookup Functions
* Using VLOOKUP For Exact Matches
* The INDEX Function
Unit 10: Sorting
* Performing A Simple Sort
* Sorting On More Than One Column
* Sorting Numbers
* Sorting By Rows
Unit 11: AutoFilter
* Applying & Using AutoFilter
* Creating Compound Filters
* Creating Custom Filters
* Multiple Value Criteria
* Using Wildcards In Custom Criteria.
|
| |
|
| |
|
| |
Or call us on 1300 888 724 |
|
|
|
