Excel Aptitude Test | 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

Excel Aptitude Test

Excel Aptitude Test for Targeted Training

We offer an Excel aptitude test to help you determine the level of expertise of an employee or employees .The Excel aptitude test will help you to save money by sending the right persons for relevant Excel training for the areas within which they will work. You will also be able to determine the skills levels of employees in your company and compare that with other companies in the same industry.

Our Excel aptitude will allow you test:

Basic knowledge of the fundamentals of Excel

Ability to use the various tools in Excel

Knowledge of the various functions in Excel

Problem solving skills

We provide you with a report indicating the level of expertise as expected from a beginner, intermediate, and advanced user respectively. We can also benchmark the user skills with other employees within your company and in comparison with employees on the same level in other companies through usage of our database.

By letting your employees take the test you will be able to identify key areas where training will be required. Research indicates that targeted, rather than general training improves the ability of users to apply their knowledge. Instead of learning modules that they have already mastered, and thus not only waste time and money, but also invest unnecessary resources in training will not benefit your company. Ensuring that the employees working with specific functions get the required training to ensure that they are up to industry standard, will be money well-spent. Contact us today for more information on the Excel aptitude test to help you plan training better.