CompTIA Courses | Online 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

CompTIA Courses

Why take CompTIA Courses?

Audit Excel enables IT professionals to take CompTIA courses online and study at their own pace in the comfort of their own homes in a way that fits their lifestyles. Simply make your way to the training section and select one of the CompTIA courses. Subscribe and receive access to the course content for 12 months, providing you enough time to prepare for the CompTIA exams. The tutorials are hands-on with loads of challenges, answers and step by step instructions.

The CompTIA courses will prepare you for the four exams of which two must be passed if you want to qualify as an A+ Technician. Through the courses you will be able to prepare for exams that once passed will open new career paths. You will learn how to build, repair, troubleshoot, upgrade and maintain stand alone computers as well as computers on a network. For the latter you will have to pass the Network exam which will also give your career in IT a head start once passed.

The standardised courses and exams across the globe, ensure that the standard throughout, remains high. This means that an A+ or Network+ certification will be recognized worldwide and that employers immediately recognize the value of a person with such certification. Certification will also mean a higher salary and better chance to compete in an extremely competitive IT market. If you are serious about a career in IT, make your way to our training section or contact us for more information and pricing on the CompTIA courses today.