excel vba exercises
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA exercises

Excel VBA exercises

resolvedResolved · Low Priority · Version 2007

replyReply Mon 21 Mar 2011, 15:14Delegate Judith said...

Judith has attended:
Excel VBA Intro Intermediate course

Excel VBA exercises

Hi I recently attended the VBA course at the Bloomsbury Sq location. Whilst I enjoyed the course and found it useful I felt it could have benefited from more exercises in class rather than copying coding put up by the trainer. Our trainer said we would be able to find exercises in the support forum. Could you tell me where these are located?
Thanks

Judith

For upcoming training course dates see: Pricing & availability

replyReply Thu 21 Apr 2011, 12:14Trainer Simon said...

RE: Excel VBA exercises

Hi Judith,

Sorry for the delay in responding.

I have emailed one of my colleagues to see whether there are any practice exercises on the forum.

However, I have attached four practice tasks and a VBA solutions spreadsheet so you can have a go yourself.

I hope this helps.

Regards

Simon

Attached files...

VBA Basic Concepts Practice Exercises 2003.doc
VBA Practice code solutions.xls

Wed 27 Apr 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
visual+basic+excel and other Microsoft training courses.

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard