advanced excel courses - Two or more work sheets

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

Resolved · Low Priority · Version Standard

Two or more work sheets

Darren has attended:
Excel Intermediate course

by - delegate Darren [1 post] (2008 Jan 31 Thu, 12:57) Reply

Please could you supply more information on split work sheets and the formulas for totalling years of account etc.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
2003	2009 Jan 23 Fri	Bayswater	4	book now	£195	£205
Full Schedule: See all 113 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Two or more work sheets

by - trainer Stephen gold contributer [396 posts] (2008 Feb 10 Sun, 11:09) Reply

Hi Darren

Thank you for your question

When you say split worksheets do you mean split panes?

If so then a split pane simply allows you to break the window into up to 4 different views, each showing a different section of a worksheet. To do this click on Window-Split, and then go to the required ranges in each window.

As to the second part of your question could you please clarify your requirements, so I can be more specific in my answer

Regards

Stephen

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· How Excel Training Can Improve Your Company's Sales Process
· Compare Different MS Excel Training Methods
· Improve Performance Of Your Excel Macros
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips