excel training courses - 1593

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

Resolved · Low Priority · Version Standard

1593

Vela has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Vela [3 posts] (2007 Feb 15 Thu, 16:25) Reply

I am trying to create 3-D formulate to link work sheets.I am not getting the right answer.
(1) On total sales for 1999-200,on report sheet,on the first cell, I HAVE GOT $5372210.26 but
I don't follow the command-Select-math& Trig to complete the full work sheet.
Can you please explain step by step. Thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: 1593

by - trainer Garry gold contributer [188 posts] (2007 Feb 21 Wed, 09:43) Reply

Note when you link to workbooks outside of Excel this makes them Absolute that is with dollar symbols $$ which you do not want try removing the dollar symbols and this may work

· How to Create Better Excel Spreadsheets: Part Four
· Microsoft Excel Courses Teach Advanced Macro Techniques
· How to Create Better Excel Spreadsheets: Part One
· Features of Microsoft Excel that assist in Analysis of Financial Data
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips