pivot tables

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

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

Pivot Tables

resolvedResolved · Low Priority · Version 2007

Tara has attended:
Excel Intermediate course

Pivot Tables

HOw do they work?

RE: Pivot Tables

Hi Tara

Creating Pivot tables is very easy in Excel. Click in your data and choose Data > Pivot tables and Pivot Chart wizard (in 2003) or choose Insert > Pivot table (2007 or 2010)

We have some useful articles on Pivot tables in our forum which you may find helpful. Take a look at the following:

https://www.stl-training.co.uk/fg-3/what-are-pivot-tables-in-excel.html

https://www.stl-training.co.uk/article-240-access-training-unleashes-power-pivot-table.html

https://www.stl-training.co.uk/article-440-preparing-pivot-why-all-excel-users-should-know-about-pivot-tables.html

I hope these are helpful - do let me know if you have any further questions.

Kind regards,
Andrew

Thu 7 Jun 2012: Automatically marked as resolved.


 

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips


Server loaded in 0.08 secs.