Codematic Excel developers logo
Codematic spreadsheet-excel development image

Rapid Application Development / Advanced Excel Development

Products for Excel
Commercial Products:
  - Classic Ribbon
  - Alt-FileSearch
  - Password Remover
Spreadsheet Quality Products
Free Products
Excel Development
Excel Development Index
Excel VBA
- VBA IDE (editor)
- VBA Training
- VBA Best Practice
- VBA Performance
- COM Performance
- VBA Security
Excel and Databases
Excel and Pivot Tables
Excel Add-ins
Worksheet Functions
Excel and xlls
Excel (in)security
Excel testing
Excel and .net
Excel External Links
Excel Developer Types
Professional Excel Development
Excel 2007
Excel 2010
Excel Development Archive
Spreadsheet Services
Spreadsheet Development
Spreadsheet Migration
Spreadsheet Maintenance
Spreadsheet Review
Spreadsheet Management
Excel User Confs
Consultant Profile
Book Reviews
Site Map

Excel VBA Training Course Self Assessment

Codematic can provide in-house training for any number of delegates up to 6. We specialise in advanced user and developer training, our trainers are commercial developers with training experience. Our courses are based on commercial solutions to real world commercial issues.

We recognise the vicious circle of being too busy working ineffectively to take the time to learn a better way. That's why we offer our training on a flexible basis. Train in a way that suits you, from 5 days full time, to 1 day per week over several weeks, or even weekends. We can be flexible to fit in with your needs. You can even combine a half day on-site consultancy with a half day training on issues raised by the consulting. We can help you decide which areas would benefit from training or you can tell us what you want to learn.

Clients have used this in the past to manage handovers of complex models when the original developer has already left. We can review it, document it and then train the in-house maintainer to look after it.

This assessment may help you work out whether our training may be of use to you. For more details or to book a course please contact us.

To have this test scored automatically you must have JavaScript enabled which you don't. If you do not want to enable Javascript you can still work through the test, a mid range score is the target for the course.

1. Rate your knowledge of Pivot tables:

1. I have seen the menu item - they never seem to work
5. I Regularly build pivot tables from Excel and External data sources, including OLAP cubes with multiple hierarchies. I know the difference between calculated items and calculated fields and regularly use both.

2. Rate your knowledge of Software design

1. I don't have time to design, I have deadlines.
5. I have good knowledge of data normalisation, object oriented design and structured programming, and implement best practice as a matter of course.

3. Rate your knowledge of security

1. I can password protect a workbook, not sure what a 'strong' password is though.

4. Rate your experience of databases

1. I have opened Access a few time, no idea how it works.
5. I'm comfortable with all aspects of logical design and the physical database design, and the different SQL dialects, of most of the main database server vendors.

5. Rate your VBA knowledge

1. I can run the macro recorder, but don't understand the code.
5. I have in depth knowledge of the Excel object model, and good program design skills, using OO, and structured design. Totally comfortable writing UDFs and clear on when to use Application.Volatile.

6. Rate your .net knowledge

1. I have never used it.
5. I have developed and deployed many large scale, n-tier .net apps in VB and C#.

7. Rate your COM/Activex knowledge

1. I have never used it.
5. I have developed and deployed many significant COM components in both VB6 and C++.

8. Rate your knowledge Excel worksheet functions

1. I am comfortable with basic formulas and functions.
5. I have used almost all worksheet functions and complex array formulas in commercial applications.

9. Rate your database connectivity knowledge

1. I have never connected Excel to an external data source.
5. I have written commercial apps using ADO, ADO MX, ADO DDL, and DAO against a variety of data sources and am aware of the strengths and weakness of the various approaches.

10. Rate your knowledge on the freeware and commercial tools available for Excel users and developers

1. I have never reviewed them.
5. I have reviewed most of them and have my own range available.


Upcoming Events:

25 January 2012 - UK Excel Developer Conference - London

Products for sale:


Office 2007 FileSearch replacement logo

New information about the missing FileSearch feature in Office 2007 and details of our pragmatic solution (Current price GBP 30.00)


worksheet password remover logo

Instant Excel worksheet protection remover and password recovery (Current price GBP 15.00)

Classic Ribbon Tab

classic ribbon for office 2007 logo

Add Excel 97/2000/2002/2003 compatible menu structure to Excel 2007
(Current Price GBP 10.00)


Products coming soon:

Link Manager

(Find and control external links in Excel Workbooks)

Due by Q1 2111.

XLAnalyst Pro

(Excel VBA based spreadsheet auditing tool)

Due before the end of 2111.

This page was last reviewed on December 21, 2011

©Codematic Ltd 1999-2011