Advanced Excel
Course (Excel 2003, Excel 2007 , Excel 2010 & Excel 2011 for
Apple Mac)
This course is aimed at
intermediate to advanced users.
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)
Watch this brief
video clip on what you will learn
Video Clip
- 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
13- 17
Feb 2012 (less 10%)
12- 16
Mar 2012 (less 20%)
16-20
April 2012
14-18
May 2012
11-15
June 2012
18-20
July 2012
13- 17
Aug 2012
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 3 day programme leads delegates through advanced Excel 2003,
2007 and 2010 data analysis
functions, explaining the function and its 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 Excels
advanced functions. It is putting your Excel on steroids.
WHO SHOULD ATTEND
o All persons using Excel spreadsheets
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.
o All persons wanting to see Excel on
steroids
PRE REQUISITE'S
Delegates should be familiar with
Microsoft Excel (though not necessarily expert in the use
thereof, as any relevant Excel function pertinent to an exercise
will be discussed prior to tackling the exercise).
Excel knowledge required:
1. Basic Excel skills
a. Opening &
closing files
b. Moving around
the spreadsheet
c. Inserting &
deleting rows and columns
d. Inserting text &
formulas
e. Deleting cells
f. Copying formulas
g. Printing
2. Basic formulas (+-*/) e.g.
=C5+C7+sum(C9:C12), and =D5*D6/12
3. Formatting
If any of these are a problem please visit
www.AuditExcel.com
where you can get affordable online training to address these
areas.
Pricing
Download the following pdf document
with the registration documents and pricing
Get
Price and Venue details
Please email us at
info@AuditExcel.co.za
with any questions.
|
|
OUTCOMES
Amongst other things,
delegates will be able to easily perform the following in Excel:
-
Reconcile different
accounts either based on unique identifiers or the actual amounts
-
Compare lists of data to
each other
-
Join databases together
-
Find errors in spreadsheets
-
Identify duplicates or
missing data
We will also answer any
questions within the course!
What the delegates will learn (from an Excel 2003, Excel
2007 and Excel 2010 viewpoint):
How errors happen in
excel and how to avoid them
High level spreadsheet
design principals
Essential Knowledge
o Auditing Toolbar
o Function wizard
o Various shortcuts and
useful tools
Importing data into a
spreadsheet
o Using excels import
wizard to import text and databases
o Using the text to column
tool
o Common pitfalls/ problems
at this stage- addressing them
Correcting the format of
the date
o Data Cleanup using the
Data Autofilter and the Advanced Filter
o GOTO Special tool for
working with cells
o Handling Dates in Excel
EOMONTH, DATE, DATEVALUE,
DAY, EDATE, MONTH, NETWORKING DAYS, WEEKDAY, WORKDAY, YEAR
o Working with imported
text data
CLEAN, CONCATENATE,
DOLLAR, EXACT, FIND/ SEARCH, LEFT/ RIGHT/ MID, LEN, LOWER/ UPPER/
PROPER, REPLACE, T, TEXT, TRIM, VALUE
Manipulating the data
o Filling in blanks (GOTO
Special)
o Identifying duplicates (SUMIF,
COUNTIF, VLOOKUP)
o Data Sorting (DATA SORT,
RANK)
o Error checks
o Joining tables together (VLOOKUP)
o Converting columns to
rows and rows to columns (TRANSPOSE)
o Other Functions (PASTE
SPECIAL, EDIT LINKS, CHOOSE, HYPERLINK, AND/ OR/IF, ISERROR)
Analysing Data
o Data Filter
o Speech to Text
o Database Functions
Reporting
o Conditional Formatting
o Pivot Tables
o COUNTIF/ SUMIF
o Cell formatting
o Data Protection
o Group and Outline
|
.gif)
.gif)
