Pivot Tables

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

Resolved · Low Priority · Version Standard

Pivot Tables

Samantha has attended:
No courses

by - delegate Samantha [1 post] (2008 Feb 20 Wed, 13:18) Reply

We have two different excel spreadsheets - one which gives a list of all projects supported through our funding programme, Grants for the arts (data already supplied for our tailored training programme with Stephen on 19th Feb 08), and another which lists all of the Arts Council's Regularly Funded Organisations (RFOs). What we are currently unable to do is report on RFOs which have also been funded through Gfta (i.e. our reporting systems are unable to report across different funding programmes). What we would like to be able to do is somehow cross reference these two sets of data so that we can just note on our Gfta report, those applicants (identified via contact URN) which are also RFOs.

Hope this makes sense.

I am going to email Stephen with the list of RFOs so he can hopefully answer this questions.

Thanks,
Sam

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

RE: Pivot Tables

by - trainer Rich platinum contributer [754 posts] (2008 Mar 1 Sat, 11:00) Reply

You might be able to use the vlookup formula in excel to see if one value on a data sheet appears anywhere on the other data sheet. Are there any common fields between the two sheets? Like a name or an ID or something?

· Tips for Transitioning to Excel 2007
· Reasons Why VBA for Excel Training Fails
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· How to check for and reduce errors in Microsoft Excel
· Microsoft Excel Training Course

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

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

Rate this page: