Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

d formulas

ResolvedVersion 2007

Leigh-anne has attended:
Excel Intermediate course

3D Formulas

What type of situation can I use this in?

RE: 3D Formulas

Hi Leigh-anne

hope you are ok, and v.sorry i haven't got back to you sooner

the reason for using 3D formulas is if you want to calculate an answer on a sheet where some or all of the figures you need are on other sheets or even in other files

I hope this has helped

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

RE: 3D Formulas

Hi Mark,

Im all ok, hope you are too.. Thanks much appreciated!

RE: 3D Formulas

Hi Liegh-anne

How are you getting on with excel hope things are going good there

Im grand keeping busy of course when are you coming back for another course like advanced let me know

Speak to you soon

Many Thanks

Mark East
MOUS Master Instructor
mark@stl-training.co.uk

RE: 3D Formulas

Its good, I've been on at my boss to upgrade to 2007... hasnt happened yet but Ill get there.

Same here... Im swamped! Ok will do

Take care

RE: 3D Formulas

Well keep at it it been manic here i love being busy

email me if you need help on things

Many Thanks

Mark East
MOUS Master Instructor
mark@stl-training.co.uk

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.