Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » About practice example

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

About practice example

Resolved · High Priority · Version 2007

Reply Thu 20 May 2010, 16:20Delegate Fahim said...

Fahim has attended:
Excel Advanced course

About practice example

Hi when i came to the course i was told that i can find the examples that i did online.
im struggling with finding the the examples that i did.
I want a practice example on Look ups and the advanced list management

many thanks

Fahim

For upcoming training course dates see: Pricing & availability

Reply Tue 25 May 2010, 09:59Trainer Tristan said...

RE: About practice example

Good Morning Fahim,

You can access your reference material, including the examples, through your delegate account. Simply login to your delegate account via:

www.microsofttraining.net/delegate

Then select the "Your History/Courseware" tab and then you have access to download the reference material for each current version.

If you have any queries, please don't hesitate to contact us on 08455-194-797

Regards,
Tristan

Mon 31 May 2010: Automatically marked as resolved.

Excel articles

· How Small Businesses Profit from Outside Excel Training
· Improving Navigation Of Your Worksheets In Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Inviting Investment Into Your Business Can Be Easier With Excel
· Combining Logical Functions In Excel

Please browse our web site to find out more about
advanced excel class and other Microsoft training courses.

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips