CompTIA help | Online Help | Miricle Solutions

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 help

CompTIA help online

Online CompTIA help is available for your studies towards certification whether for A+, Network+, Server+ or any of the CompTIA certifications. Studying online provides you with several benefits over that of the traditional paper and posting method:

More flexibility in terms of study time

Improved interactivity

24 Hour online access to courseware

Instant access to CompTIA help 24 hours a day

No paper trail and thus environmentally friendly

No postage costs

Minimization of travelling costs

It is also a better option than attending class where you will have to wait for students that fall behind or may get lost in the work yourself because you cannot set the pace of learning. When attending the traditional class instruction you have to travel, take off time from work and also schedule in travelling time. It contains a rigid time schedule which means that you have to schedule your life around class rather that scheduling your studies according to available time as would be the case if you study online. It is also more difficult to monitor progress and track marks.

With the online study method as available from Audit Excel you will have 12 months subscription to the courseware, can print out whenever you need, and can set your own pace. You have a secure online login system and a track record of your progress. Glossary of terms, immediate online CompTIA help and well structured tutorials make it the preferred option for studying towards certification. In addition is cheaper than the paper and pen or the classroom instruction methods as well as more cost effective in terms of time and travelling.

Get all the online CompTIA help you need to pass your certification exams. Contact us today at Audit Excel for free information about our various courses including pricing, materials, procedures, and exams.