Free Excel Video Tutorials
Below is a listing of our
free online Excel Tutorial video clips.
You can either click on a
category below to find the correct video, use the navigation on the
left to quickly move between videos, or use the search
facility on the right to find what you are looking for.
To find out more about
our live training visit the Live
Training Page
or watch this brief video clip on what you
will learn
Video Clip
Next
Course- Rivonia
9th & 10th February 2010-
Two Day
Advanced Excel
Recent Testimonials:
“Data accuracy and consistency has improved dramatically across
Absa Capital, so much so that it has become
compulsory within certain areas for all staff to complete
Adrian’s Data Analyses Spreadsheet Techniques course.”
Anton Faber, Head of Learning and Development, ABSA Capital
I found your site by accident.
I am so glad I did.
Your videos are easy to understand
and saved the day here at work today!
Debra L. Barnes
| Tutorials |
Description |
|
NEW- Online Excel
Training |
If you’re looking for online Excel
training that’s dead easy, cost-effective and that you can do in
your own time, try out our free Excel beginner course by
clicking here.
Other courses available from our e
commerce site at
www.AuditExcel.com include
|
The Basics
(Free Excel Video Tutorials) |
Learn the basics of using Microsoft Excel.
Whether you consider yourself an expert or an absolute beginner, make
sure you know about the Auditing Toolbar, the Function Wizard, how to
design good spreadsheets and how to load your add ins.
|
Training
by Excel's categories
(Free Excel Video Tutorials) |
The functions available in Excel
split into the categories as per the Excel Function Wizard. If you are
interested in Lookup and Reference functions then follow this link.
|
Other Tool and Features in
Excel
(Free Excel Video Tutorials) |
Excel has a number of time saving
tools that are useful to its users. Learn about handling external
links, the GoTo Special command, Find and Replace and Conditional
Formatting.
|
VLOOKUP
Page
(Free Excel Video Tutorials) |
Learn all you need to know about the
VLOOKUP function in Microsoft Excel. |
Tips and Tricks in
Excel
(Free Excel Video Tutorials) |
Some tips and tricks in using excel.
Learn how to show all the underlying formula in cells, fill in blanks
in some easy steps, cleanup data in a convenient way etc.
|
What If
Tools
(Free Excel Training video clips) |
Learn how to use Excels tools to run
what ifs, sensitivities, and scenarios. Find out how to goalseek and
to watch what happens to key cells when inputs are changed (no matter
where they are!)
|
|
Power Courses
(Free Excel Video Tutorials) |
Short courses where we have used our
experience to show various users what they need to know based on the
type of work they do, or the industry they are in. Have a look, its
free.
|
How errors happen in Excel
(Free Excel Video Tutorials) |
Learn how easy it is to make errors
in excel and how to avoid them. From simple functions like Copy/ Paste
to more complex ones like VLOOKUP.
|
Vital Tips
(Free Excel Tutorials- Documentation) |
Over the years it has become
apparent that spreadsheets contain errors. This is clearly
acknowledged by the addition of many audit functions to the more
recent versions of Excel. These are very useful features which are
seldom known about, understood or used.
|
|
Addressing Sarbanes Oxley with Excel
Only
|
Ideas on how to address spreadsheet
risks in terms of Sarbanes Oxley legislation.
|
|
Downloadable Training
|
Training that can be downloaded for
a variety of functions and features in Excel. Quickly learn about
VLOOKUP, RANK, Conditional formatting etc.
|
| Fun and Useful Stuff
World Cup Soccer
Spreadsheet
Retirement
Planning
Su Doku Spreadsheet |
Some fun and useful spreadsheet
related topics. If you are looking forward to the world cup, see how
to build automatic sorting league tables. If Su Doku is you pleasure,
then get a spreadsheet to make getting started easier. On a more
serious note, see how your retirement planning is coming. Will you
have enough?? |
|
|
Search the site
Advanced Excel Training Courses
Contact us for more
information on
info@AuditExcel.co.za
9th &
10th Feb 2010 -
Two Day Advanced Excel Course
 CLICK HERE
to download the Registration Document for the above course which
includes the pricing and map
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
Other Services
Visit the
Home Page to find out more
Our
YouTube Channel Do you know
we also have a YouTube Channel. The video quality is best on this site
but if you prefer you can see our channel by clicking on the logo
below
|
.gif)
.gif)
