best training excel intermediate - formulas
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 Training and help » best training excel intermediate - Formulas

best training excel intermediate - Formulas

resolvedResolved · Low Priority · Version Standard

replyReply Wed 14 Nov 2007, 16:13Delegate Shane said...

Shane has attended:
Excel Introduction course

Formulas

what is Vlookup?

For upcoming training course dates see: Pricing & availability

replyReply Wed 14 Nov 2007, 16:46Delegate Paul said...

RE: formulas

Hi Shane,

Take a look at my post, here: http://www.microsofttraining.net/post-6842-v-look-ups.html#6849

 

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

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