Excel Formulas | 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 Formulas

Master Excel Formulas through Online Training

Master the basic Excel formulas required through our easy to follow free online training on specific topics. Whether you need to learn how to use the SUM function, need assistance with DIVISION or want to learn how to do complex Excel formulas you will find our free video based online tutorials to be useful.

You don’t even have to install the program to learn it. Simply click on the relevant category and start the free course. Once you have mastered the Excel formulas in 2003 and 2007 you will be ready for more advanced skills in the powerful program.

Once at this level, you will appreciate the wide range of advanced courses which can also be completed online. The benefit is that you will be able to complete the courses online at your own pace and will be able to skip sections that you understand. With this method you will thus have targeted learning and save time in mastering the program. The courses can be studied from anywhere in the world where there is an internet connection.

Telephonic assistance is available and with the courses including questions, downloadable samples, audio and video instruction, as well as printable scripts you will master even complex Excel formulas in no time at all. Complete the assessments and get a certificate for completion of the course. This means responsible self-improvement is just a click of the mouse button away. View our training section for assistance with the basics of Excel or contact us to enrol in the more advanced courses.