Bookkeeping Institute of Australia Pty Ltd.
5/1407 Logan Road
Phone: 1300 729 844
Fax: (07) 3343 1511
Mobile: 0418 211 108
Home » Microsoft Excel Training Courses
To view details of pricing and available course dates or to make a booking please scroll down to the bottom of this page.
In addition to Visa, Mastercard or AmEx, payment options include EFT or Cheque in advance.
An e-mail Tax Invoice showing our bank account details will be generated by your booking.
Please note that all courses start at 9:15am and finish at 4pm.
BI-812 Microsoft Excel - Intermediate
General Description:
This course is intended for current Excel users who wish to learn how to extend their use of the software.
Learning Outcomes:
At the completion of this courseware participants will be able to:
· use the fill technique to enter data into cells · edit data in a workbook · sort data in lists in a workbook · create a variety of charts (graphs) in Excel · summarise data using subtotals and relative range naming · group cells and use outlines to manipulate the worksheet · use linking to create more efficient workbooks · combine data in separate worksheets or workbooks using consolidation · use the various printing features to produce a variety of reports · use a variety of data validation techniques · protect data in worksheets and workbooks.
· use the fill technique to enter data into cells
· edit data in a workbook
· sort data in lists in a workbook
· create a variety of charts (graphs) in Excel
· summarise data using subtotals and relative range naming
· group cells and use outlines to manipulate the worksheet
· use linking to create more efficient workbooks
· combine data in separate worksheets or workbooks using consolidation
· use the various printing features to produce a variety of reports
· use a variety of data validation techniques
· protect data in worksheets and workbooks.
Target Audience:
Prerequisites:
This course is designed for for current Excel users and assumes the participant has a basic understanding of the Windows environment and file management.
Methodology:
A self-paced hands-on approach is taken during this course. A case study is used to produce real-life scenarios so that learners experience how to use the software to solve everyday problems and undertake routine tasks. A course manual is included in the cost of this course. Course files are provided with this courseware.
Certificate:
The Bookkeeping Institute of Australia will issue a Certificate of Achievement upon completion of this course.
Table of Contents
1. Filling Series 1. Filling A Series 2. Filling A Growth Series 3. Filling A Series Backwards 4. Filling Using Options 5. Creating A Custom Series 6. Modifying And Deleting Custom Series 7. Filling Series Quick Reference 2. Editing Data 1. Overwriting Cell Contents 2. Editing Long Cell Entries 3. Editing Formulas 4. Editing Functions 5. Editing Data Quick Reference 3. Sorting 1. Performing A Simple Sort 2. Sorting On More Than One Column 3. Sorting Numbers 4. Sorting By Rows 5. Sorting Quick Reference 4. Charting 1. Using The Chart Wizard 2. Choosing The Chart Type 3. Changing The Chart Type 4. Modifying A Chart 5. Printing A Chart 6. Creating A Pie Chart 7. Creating A Bar Chart 8. Moving A Chart 9. Deleting A Chart 10. Charting Quick Reference
5. Summarising Data 1. Creating Subtotals 2. Using A Subtotalled Worksheet 3. Creating Nested Subtotals 4. Copying Subtotals 5. Using Subtotals With AutoFilter 6. Installing The Conditional Sum Wizard 7. Using The Conditional Sum Wizard 8. Creating Relative Names For Subtotals 9. Using Relative Names For Subtotals 10. Summarising Data Quick Reference
6. Outlining 1. Creating An Automatic Outline 2. Working With An Outline 3. Creating A Manual Outline 4. Outlining Quick Reference 7. Linking Workbooks 1. Linking Data In Excel 2. Linking Within A Workbook 3. Linking Between Workbooks 4. Updating Links Between Workbooks 5. Linking Workbooks Quick Reference 8. Consolidation 1. Consolidating Data With Identical Layouts 2. Consolidating Data With Different Layouts 3. Consolidating Data Using A PivotTable 4. Consolidation Quick Reference
9. Printing Techniques 1. Printing A Selection 2. Setting The Print Area 3. Setting Page Margins By Dragging 4. Setting Margins With Page Setup 5. Centring Data On The Page 6. Printing Gridlines 7. Printing Techniques Quick Reference
10. Validations 1. Validation Techniques 2. Data Validation By Number Range 3. Testing Data Validation 4. Input Messages 5. Creating Error Alerts 6. Creating Drop-Down Lists 7. Using Formulas As Validation Criteria 8. Creating Custom Validation Criteria 9. Number Formats With Built-In Logic 10. Conditional Formatting 11. Copying Data Validation Settings 12. Validations Quick Reference 11. Protecting Data 1. Unlocking Cells 2. Protecting A Worksheet 3. Working With A Protected Worksheet 4. Disabling Worksheet Protection 5. Password Protecting A Worksheet 6. Protecting Data Quick Reference.
« Previous | Next »
BIA Courses
Self-paced Course Overview Our Mt. Gravatt Location Bookkeeping Course Overview How Distance Learning Works 30 Week Bookkeeping Distance Timetable Introduction to Bookkeeping & Accounting Certificate of Bookkeeping using MYOB FNS30107 Cert III in Financial Services FNS40207 Certificate IV in Bookkeeping FNSBKPG404A Carry out BAS & IAS tasks Start Your Own Bookkeeping Business Start Your Own BB Workshop Recognition of Prior Learning Bookkeeping Associations BAS Agents Act
Administration
About us FAQ's Our people Testimonials Student enrolment policies Cancellation & refund policy Privacy policy Student support policies Compliments, complaints and appeals BIA Members Code of Ethics & Standards Recognition of existing qualifications Request to access personal records Administration login NTIS links BIA partner bookings
Associations & Organisations
Find A Bookkeeper Australian Bookkeepers Network Institute of Certified Bookkeepers Association of Accounting Technicians Association of Professional Bookkeepers Institute of Chartered Accountants CPA Australia National Institute of Accountants Association of Management Accountants Taxation Institute of Australia Australian Tax Office National Training Information Service Fair Work Australia Rapid Companies ASIC National Names Index
Tax Practitioners Board
Tax Practitioners Board Home Page Conditions of Registration Registration as an individual BAS agent Exposure Drafts Message from the Chair BAS agents and the regime What is a ‘BAS Service’? Code of professional conduct Events affecting continued registration Recognised BAS Agent Associations Tax Practitioners Board Members Statement of relevant experience Schedule of personal details
BAS Agent Register
