pivot tables
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

resolvedResolved · Low Priority · Version 2010

replyReply Fri 16 Dec 2011, 15:02Delegate Sharon said...

Sharon has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Pivot Tables

When you have a whole list of dates across a year but you want to show the details in months - Can't remember how to do this.

For upcoming training course dates see: Pricing & availability

replyReply Wed 21 Dec 2011, 09:47Trainer Anthony said...

RE: Pivot Tables

Hi Sharon, thanks for your query. You'll need to use grouping to achieve that. Here's a good walkthrough:

http://www.bettersolutions.com/excel/EUA153/LI814111912.htm

Hope this helps,

Anthony

 

Please browse our web site to find out more about
excel+course+london and other Microsoft training courses.

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard