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

Excel

ResolvedVersion 2003

Wed 1 Oct 2008, 16:46 Delegate Emma said...

Emma has attended:
Excel Intermediate course

Excel

What are pivot tables?

Fri 3 Oct 2008, 16:57 Trainer Amanda said...

RE: Excel

Hi Emma

Thank you for your question and welcome to the forum.

A PivotTable report is an interactive table that quickly combines and compares large amounts of data. You can rotate its rows and columns to see different summaries of data.

There is a good tutorial on the Microsoft web site that introduces the concept of PivotTable reports:
http://office.microsoft.com/en-us/excel/HA010346321033.aspx

Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Convert Text into Number