audit excel spreadsheet auditing
audit excel spreadsheet auditing
Online Excel Training Links
 
-Home Page
-Company Profile
-Free Tutorial Page
-Training Schedule
-Contact Us
- Our BLOG
-Spreadsheet Auditing
-Spreadsheet Sensitivity
-Spreadsheet Security
- 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
- Function Wizard
- Audit Toolbar
- Good Design
- Add In's
- 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 Use
- Large VLOOKUP's
- VLOOKUP Risk
-
Automatic Sorting
- IRR Calculator
- Interest rate
- IRR
- NPV
- CAGR
- PMT
- Amortization table
- Database - Use ADDRESS
- MATCH Function
- INDIRECT function
- VLOOKUP
- Transpose
- CHOOSE
- OFFSET
- SUMIF/ COUNTIF
- DATE
- EOMONTH
- EDATE
- Rank
- MAX/ MIN
- IF
- AND/ OR
- TEXT Function
- Remove Spaces
- FIND
- Length
- Join characters
- Change Case
- Extract Text
- IS number EVEN/ODD
- Is cell a number
- ISERROR
- SUMIF/ COUNTIF - 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
- Copy/ Paste
- Delete Cells
- Insert rows
- Insert cells
- IF functions
- Linked Sheets
- Hidden Cells
- Lookup's
- MIN/MAX function
- Referencing
- Goalseek
- Data Tables
- Scenarios
- Watch Window
- Download All
Google
Web AuditExcel.co.za


















CompTIA

To get more details click here to mail us a query

CompTIA is the acronym for Computing Technology Industry Association.  The agents of five micro-computer dealerships created CompTIA as a non-profit trade association. It is today known for its role in the provision of highly sought after professional certification in the modern IT fields.
CompTIA provides various certifications including:

  • A+
  • Network+
  • Security+
  • Server+
  • CTT+
  • CDIA+
  • Linux+
  • Project+
  • RFID+
  • Convergence+
  • PDI+
  • DHTI+

We make it possible to study towards CompTIA certification for the following:

  • A+
  • Network+
  • Security+
  • Server+

A+
It is the certification that validates the computer technician’s skills and competency in specific fields. The first of the A+ certification exams was developed in 1993. Since then there have been two more versions that of 2003 and the 2006 objectives exams. Upon completion of the course and passing of the exams, the professional earns the designation of a Certified Computer Technician. Computer technicians who have extensive experience and worked hours (500) will do well to obtain the certification. Computer based examination with multiple choices is used for testing. Specific topics that are covered include for instance, installation of network cards, printers, hard drives, and more.
Network+
The certification serves the purpose to verify and validate the professional’s knowledge, experience and skills regarding communication security infrastructure and related fields of knowledge. It also includes measurement of the technician’s knowledge and skills in troubleshooting which forms a daily part of most of the computer technician’s work. The first exam in this category was launched as far back as 1993 after which several updates have followed including the 2002, 2005 and 2009 updates.
Security+
It is the certification aimed at validating the skills of professionals regarding infrastructure security cryptography operational security as well as related security concepts. It consists of four core courses and an elective course. It first came into being in 2002 as reaction to enormous security threats in the IT industry.
Server+
Aimed at the advanced technician with 18 to 24 months experience with Industry Standard Server Architecture known as ISSA, it tests the knowledge of the technician in topic areas such as multiple CPUs and RAID SCSI, and topics such as disaster recovery.
Contact us today for enrolment and completion of any of the above four CompTIA courses.

 

 


  • COMPTIA
  • COMPTIA Course
  • COMPTIA Help
  • COMPTIA Training
  • Excel Problems

  • Excel Audit & Financial Modeling Review

    Miricle Solutions provides review and auditing services on excel spreadsheets that are important to the organisation. Using the benefits of the internet these services can be provided to companies worldwide.

    More on excel audit and reviews

    Excel design and development

    Miricle Solutions designs and develops professional excel spreadsheets. Benefit from the combination of our business knowledge and modeling experience.


    More on design and development in excel

    Spreadsheet & Excel Risk Management in the Sarbanes Oxley world

    Excel has become a core tool in the business world. However few companies have managed to address the risks associated with these spreadsheets. Now Sarbanes Oxley is making it compulsory to address the issue in the States and it will reach the rest of the world soon. Visit our new SOX site , which covers spreadsheet controls relating to documenting ,access, input, testing, version control, audit trails, change control and backup/ archiving,

    More on reducing SOX risks due to excel use

    Decision Modeling

    The business world is all about making decisions. Miricle Solutions can provide the services to understand your problems, develop a Excel spreadsheet model to assess the decision, and ensure that the necessary level of quality is generated.




    More on decision modelling using excel and spreadsheets

    EXCEL TOOLS
    arrow Spreadsheet Professional Video Clip
    arrow
    Download Trial Copy
    arrow
    Quick start guide
    arrow
    Spreadsheet Professional
       Read our privacy policy if you are concerned about your information
     

    Home | Contact Us | Site Map | Training | Sarbanes Oxley | Articles | Links | Blog