Learning CompTIA | Online Training

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

Learning CompTIA

Audit Excel provides an economical, hassle free solution for learning CompTIA content for the relevant exams.

All you have to do to start learning CompTIA content is to subscribe for a period of one year. We will provide you with the login details for the specific course where you will find all the course material to study. Learning CompTIA course material for the exams has never been easier. Upon completion of the course you will also receive the Miricle Solutions Certificate. It does not however mean that you have passed the exams. Your next step is to register for the CompTIA exams in the specific field, write and pass the exams.

You will require about 38 hours of study to work through the A+ courseware and if you select the whole bundle it will take around 148 hours. The CompTIA bundles include the four areas of study which are the A+, Network+. Server+, and the Security+ fields.

We provide you with 24 hour access to the courseware. If you only want to study for the A+ certification you will have to pass the core exam and the elective exam which can be selected from the Remote Support Technician, IT or Depot series. For the CompTIA bundle which includes the A+ you must pass four core exams and the one elective. The courseware consists of material from all four study areas.

learning CompTIA