CompTIA Tutorials | Online Help

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 Tutorials

CompTIA Tutorials Available Online

Better known for the A+ certification, CompTIA also offers numerous other certifications. You can find all the CompTIA tutorials you will need whether for Server+, Security+, A+ or Network+ certification all at one convenient online place.

We provide the CompTIA tutorials with your 12 months subscription allowing you to view and use any of the course guides at our site. We have a variety of CompTIA tutorials for various courses – in total more than 1900 courses.

Examples of the courseware available include that of various A+ guides for preparation such as the A+ Essentials Exam. This guide includes free questions, examples, and challenges ensuring full preparation for the exam. Learn about pc components, operating systems, laptops, printers, networks, communication, security, scanners and more in this tutorial. Another A+ tutorial is one that that looks at the system architecture which covers the various hardware components and peripherals. Many more guides are available for each of the A+ exams helping you to become fully prepared for the examination.

The same applies for the Network+ certification. We for instance, offer you full access to all the information required to pass this exam. The information such as network topologies, technologies, media, and devices is provided in an easy to understand format and includes tips, glossaries of terms, and more.

CompTIA tutorials