excel.advanced.course - Pivot tables

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

Resolved · Low Priority · Version Standard

Pivot tables

Morounke has attended:
Excel Advanced course

by - delegate Morounke [1 post] (2008 Jan 23 Wed, 16:39) Reply

If I have exported data from Sage (transaction listings) and want to creat pivot table with heading including months. How do I format date to read say April07 instead of 01/04/07 as this makes grouping transaction difficlut.

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	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	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: Format Dates

by - trainer Katie gold contributer [214 posts] (2008 Feb 6 Wed, 11:56) Reply

Hi Morounke,

Generally in Excel, if you want to select the entire column of dates & format, you can do the following:

See if that works.

Regards,

Katie Woo
Microsoft Certified Trainer

· Excel Macros for the Non-Programmer
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Microsoft Excel Training - Numerical excellence for all
· Advanced Excel Training - takes you to the next level
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

Rate this page: