Excel Training Courses | Online Training Courses

MAIN PAGES

-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us

BLOG

- Our BLOG

SOFTWARE

-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security

NEW Videos

- IRR Calculator
- Count error checks
- Check import headers
- INDIRECT function
- IS number EVEN/ODD
- Is cell a number
- MATCH Function
- Identify missing categories
- Check that data within range
- TEXT Function
- Remove Spaces
- Use ADDRESS

Excel Basics

- Function Wizard
- Audit Toolbar
- Good Design
- Add In's

Tips and Tricks

- Identify missing categories
- Check that data within range
- Count error checks
- Check import headers
- CAGR
- Show all formula
- Fill in blanks
- Data Cleanup
- Multi sheet changes
- Automatic Sort

VLOOKUP tips

- VLOOKUP Use
- Large VLOOKUP's
- VLOOKUP Risk
- Automatic Sorting

Financial

- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table

Database

- Database

Lookups

- Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF

Dates

- DATE
- EOMONTH
- EDATE

Statistics

- Rank
- MAX/ MIN

Logical

- IF
- AND/ OR

Text

- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text

Information

- IS number EVEN/ODD
- Is cell a number
- ISERROR

Maths

- SUMIF/ COUNTIF

Other Tools

- Data Validation
- Group/Ungroup
- Autofilter
- Workbook protect
- External Links
- Goto Special
- Find/ Replace
- Conditional Format
- Pivot Tables
- Data Sort
- Data tables
- Multiple Windows
- Hyperlinks
- Protect cells
- Paste Special

How errors happen

- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing

What If's

- Goalseek
- Data Tables
- Scenarios
- Watch Window

Download All Videos

- Download All

Excel Training Courses

We provide a wide range of Excel training courses for every level of user. Individuals wanting to learn the basics of Excel or simply require assistance with specific functions of the program, will benefit from the free training pages where video based tutorials with scripts are available.

All areas of the program are covered from Vlookup to Math tools. Simply click on the broad categories and select the topic for which you need help. If you however, want to learn the program fast there is no better way than doing so than purchasing one of the Excel training courses. We offer the beginner’s course free and if you need more advanced training simply purchase one or more from the Excel 2007 training series which includes:

Audience – helping you to find your way around the program, using the formula and status bars, renaming worksheets, using the new Excel Ribbon, and getting to know all the functions. The getting started course is two hours long, just long enough to teach you the basics and short enough to ensure that you start using the program in the same day.

Worksheet – the three hours course deals with everything you need to know on how to create a worksheet from entering data as text to correcting spreadsheet errors and getting to know the AutoSUM and SUM functions.

Data Formatting – a one hour course on how to select cells, format and size cells, and how to format data within a cell.

Excel training courses