microsoft excel courses - Charts

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

Resolved · Low Priority · Version Standard

Charts

Sarah has attended:
Excel Advanced course

by - delegate Sarah [3 posts] (2007 Jul 3 Tue, 12:51) Reply

how do I overlap results from different markets to compare them over a 12 month period?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	6	book now	£214	£230
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: charts

by - trainer Anthony gold contributer [113 posts] (2007 Jul 10 Tue, 13:18) Reply

Hi Sarah. Create a composite worksheet comprised of references to the results of the different markets (say, in individual columns/rows) and use a new row/column to perform comparison equations. For multiple column/row comparisons across a 12-month period consider using Pivot Tables created across workbooks.

· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Prepare for your MOS Certification with MS Excel Courses
· Microsoft Excel Training: Essential for Today's Employees
· Microsoft Excel Features and Functions for Accountants
· Tips to Facilitate Printing of Excel worksheets

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips