microsoft excel course london - pivot table

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course london - Pivot table

microsoft excel course london - Pivot table

resolvedResolved · Low Priority · Version Standard

Hayley-jayne has attended:
Excel Intermediate course
Excel Intermediate course
Excel Advanced course

Pivot table

how does one link pivot tables within multiple work books

RE: pivot table

Go to Data on the menu bar then PivotTable and chart report and select Consolidation range


 

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


Server loaded in 0.09 secs.