Excel VBA Beginner course

Resolved · Medium Priority · Version 2013

Thu 5 Apr 2018, 12:50 Delegate Matt said...

Matt has attended:
Excel Intermediate course
Excel VBA Introduction course
Excel VBA Intermediate course

Excel VBA Beginner course

Could you send me the Exercises and handouts from the session please, I have misplaced mine. I attended back in November 2017
Many thanks

For more information, check out our Excel data analysis course London.

Thu 5 Apr 2018, 14:04 Trainer Sarah said...

RE: Excel VBA Beginner course

Hi Matt

The handouts you can download right now from the 'Resources' area of our website - just click Resources in the top right hand corner of your screen.

What date did you attend the training (unfortunately we can't see this from your forum post)? And which course do you need the files from?

Let us know and we'll do our best to send you a copy of the exercises.

Regards,

Sarah
Excel Trainer

Thu 5 Apr 2018, 14:06 Delegate Matt said...

RE: Excel VBA Beginner course

Hi Sarah,

I attended the Excel VBA Introduction course on the 20/11/17 I think.

Many thanks

Matt

Thu 5 Apr 2018, 15:18 Trainer Sarah said...

RE: Excel VBA Beginner course

Hi Matt

I've double checked which trainer you had that day (I think it was perhaps actually the 22nd November) and sent them a message requesting to forward the files on to you.

Hopefully this will be in the next day or so, but I know he is training both today and tomorrow so might not get a chance.

Please let me know on here if you haven't received these by next week.

Sarah

Thu 12 Apr 2018: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips