3 d formulas

The UK's most regular instructor-led training courses.
Training information: excel course · Excel training london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

3 d formulas

Carol has attended:
Excel Intermediate course

by - delegate Carol [1 post] (2008 Mar 18 Tue, 16:35) Reply

HOw do you find a data reference

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
2007	2009 Jan 20 Tue	Bloomsbury	3	book now	£224	£224
2003	2009 Jan 20 Tue	Southwark	4	book now	£207	£215
Full Schedule: See all 134 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: 3 d formulas

by - trainer Mara silver contributer [73 posts] (2008 Mar 30 Sun, 20:00) Reply

Hello Carol,
I hope you enjoyed your Excel training session with us.

In response to your question, I'm not sure if I understand what you are looking to do. However, I have found another forum posting that relates to 3D formulas:
http://www.microsofttraining.net/post-4823-freeze-panesd-formulas.html

Please let me know if you have further questions on this that I can help answer.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

· How Excel Training Can Improve Your Company's Sales Process
· Excel and Inventory Management
· Microsoft Excel Training: Not Just for Newbies Anymore
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

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

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

Rate this page: