Course Outline
Course name: Excel for Bookkeepers - Intermediate Excel 2007
Price: $299.00 (Includes GST)
Duration: 1 full day
Summary
The Wise Click Training Certificate III and IV Bookkeeping courses involve using Excel for Graphing and Spreadsheets. Excel is a great skill to have on your resume and a vital part of being a professional bookkeeper. This course has been especially designed for Bookkeeping students or those people who work with MYOB and import / export data into Excel for more detailed financial analysis.
Register for this course
| Course start date | Course end date | Location | Mode | Info/register |
|---|
| Tue, 10/08/2010 |
Tue, 10/08/2010 |
Balcatta (Rm 1) |
Day |
Info/register |
| Wed, 15/09/2010 |
Wed, 15/09/2010 |
Balcatta (Rm 1) |
Day |
Info/register |
| Wed, 20/10/2010 |
Wed, 20/10/2010 |
Balcatta (Rm 1) |
Day |
Info/register |
| Wed, 10/11/2010 |
Wed, 10/11/2010 |
Balcatta (Rm 1) |
Day |
Info/register |
| Mon, 13/12/2010 |
Mon, 13/12/2010 |
Balcatta (Rm 1) |
Day |
Info/register |
| | Volume discounts |
|---|
1 place only - no discount
2 places - 5% discount
3 places - 10% discount
Over 3 places - 20% discount
|
|
EXCEL 2007 INTERMEDIATE COURSE
Course Description
This course goes beyond the basics and focuses on more in-depth examples of formulas, formatting and charting.
How to work with larger spreadsheets more efficiently and how to analyse raw data are some of the important features covered. Many shortcuts and time-saving techniques used in creating multi-level spreadsheets are also covered.
Content
- Reviewing important Excel shortcuts
- Writing Formulas & Viewing Errors in Excel
- Creating Charts & Graphs
- Naming cell ranges to use formulas more easily and at a faster pace
- Use absolute references in formulas
- Working with multiple worksheets
- Sorting and subtotalling data
- Creating 'what if' formulas
- Adding Graphics to Charts
- Creating subtotals from raw data and creating & using pivot tables
- Grouping and outlining data to summarise information
|
Course: |
Excel 2007 Intermediate Course |
|
Course Code: |
EI |
|
Duration: |
1 day, 9:00 am - 4:30 pm |
|
Cost: |
$299 (inc GST) |
|
Class size: |
Maximum of 12 participants |
|
Who is this course for? |
People who want to increase their Excel knowledge and abilities. |
|
Prerequisites: |
Basic Excel knowledge |
|
What’s Included? |
An Excel 2007 Manual. Morning & Afternoon tea. Certificate of Attendance |
|
How to Book? |
Ring 9207 1088 or online via the sessions above. |
|
How to Pay? |
A deposit of $100 is required to secure your booking. The remaining balance is due 10 days prior to course commencement. Payments can be made by credit card, cheque or direct debit. Please also refer to the Terms & Conditions. |
|
Location: |
Wise Click Training. Unit 1/14 Halley Rd, BALCATTA WA 6021 |
|