Excel VBA training course self assessment


Advanced Excel Development, Training and Support

Resources

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 viscous 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 pleasecontact 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 YOUR 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.

This page was last reviewed on July 31, 2007

Advanced Excel Development, Training and Support