CompTIA online training | 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

CompTIA online training

It is beneficial in more than one way to enrol for CompTIA online training at Audit Excel. Certification validates your knowledge and experience and it is a proven method for acquiring credibility in the IT world. The advantage is that upon passing the exams after having worked through the easy to use tutorials, you will attain professional status right away. It will also be advantageous for building your career as an advanced and professional qualification will be seen in a positive light by management. Proving that you are willing and eager to improve your skills will show commitment to a career in the IT industry.

We provide a CompTIA online training facility where you can subscribe for a period of 12 months and download the relevant tutorials either all at once or as you need them. Cost savings are implied through the online study method and since you can learn at your own pace and within the convenience of your home or office, you will be able to plan your learning schedule according to the time you have available.

You must write the exams that are required after you have finished the CompTIA online training. The exams are standardised around the world and commissioned through CompTIA. Once the minimum requirements for the exams are reached, you will obtain the vendor neutral and internationally recognised certification for A+, Server+, Network+ or Security+.

The A+ certification frequently is the first certification earned by IT professionals and goes well with the Network+ and the Server+ certifications. Not only does this provide you with a good base to work from, as well as the necessary background for other certifications, but it also enhances the necessary skills for hardware installation and basic networking.

The Network+ is recommended if you work in network infrastructure and if you on a regular basis handle troubleshooting, configuration, and maintenance. Server+ is suitable for technicians who work within the server environment. The Security+ is best for network and server professionals. Contact us today for a quote or for enrolment in the CompTIA online training program.