| Online Excel
Training Links |
|
|
| Downloads /
Products |
|
Spreadsheet Prof.
The world's No.1
spreadsheet testing tool. Try it out below |
|
|
Excel for beginners (Excel 2003, Excel 2007, Excel 2010 & Excel 2011
for Apple Mac)
This course is aimed at
beginners.
If you are not sure what you or your organisations skill level is,
download this file
 ,
complete the Instructions and Questions sheets and email back to us for
a free skill assessment (South Africa and African countries only)
- Click here to go
back to the
Live Training
Home Page
- For details on
timing refer to the schedule on the right
- For information on
pricing and venue please mail
adrian@AuditExcel.co.za or
Get
Price and Venue details |
|
Search the site
Advanced Excel Training Courses
Contact us for more
information on 011 563 3805/ 083 272 2552 or
info@AuditExcel.co.za
Excel Course in Rivonia
and Sandton, Johannesburg
Download Price and venue and see dates below
11-15
June 2012
18-20
July 2012 (less 5%)
13- 17
Aug 2012 (less 10%)
17- 21
Sep 2012
15-19
Oct 2012
12- 16
Nov 2012
Get
Price and Venue details
Watch a video clip of what you will learn
Featured Product
Online Excel training based
on the Excel for dummies series.
For a sample register by
clicking on this
link for a trial
Contact Details
Mail:
info@AuditExcel.co.za
Call Adrian + 27 83 272 2552
Miricle Solutions cc PO Box
2683 Rivonia
2128 |
Who should attend
|
|
Contents
|
INTRODUCTION
This application driven full day programme leads delegates through
Excel's basic functions, explaining the each function and their uses. This is a very
hands-on, non-intimidating, course – delegates work through
various exercises under the supervision, and with the help, of
the facilitator to get to grips with the nuances of Excel’s
advanced functions
WHO SHOULD ATTEND
o All persons using Excel spreadsheets
(either Excel 2003 or Excel 2007)
o All persons involved in using Excel
to process large datasets, especially those received from other
systems, and converting them into reports to be utilised in the
business.
PRE REQUISITE(S)
Able to switch on a computer and use a
mouse :)
Pricing
Download the following pdf document
with the registration documents and pricing for the various
course. For inhouse courses please contact us at
info@AuditExcel.co.za
Get
Price and Venue details
Please email us at
info@AuditExcel.co.za
with any questions.
|
|
OUTCOMES
By the end of the course
delegates will recognize areas where they could improve their own
spreadsheeting. They will be in a position to immediately apply the
lessons learnt to their own models in their own environment. They will
immediately be able to save time on their everyday Excel tasks
What the delegates will learn (from an Excel 2003, Excel 2007
and Excel 2010 viewpoint):
- What is a Spreadsheet?
- Excel Layout Create-, Save- and Open existing Excel files
- Navigation and Data entry
- Insert, Delete, Hide as well as Adjust width and height of
columns and rows
- Formatting of cells
- Format Painter
- Drawing borders/ lines
- Alignment
- Conditional Formatting
- Basic maths (Formulas)
- Absolute /(Relative) referencing
- Linking cells in different sheets and workbooks
- Function Wizard
- The basic “IF” function
- Auditing Toolbar
- Formulas and the coloured boxes
- How to Print
- Data sorting
- Data Filtering
- Graphs in Excel
|
| |
|
|
|
|
.gif)
.gif)
