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.

5. ALL UR SPREADSHEET ARE BELONG TO US!

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.

Products for sale:

Products coming soon:

Link Manager

(Find and control external links in Excel Workbooks)

Due by Q3 2010.

XLAnalyst Pro

(Excel VBA based spreadsheet auditing tool)

Due before the end of 2010.

This page was last reviewed on March 14, 2010

Rapid Application Development / Advanced Excel Development