excel computer training

excel computer training - Pivot tables

Resolved · Low Priority · Version Standard

Pivot tables

Hasan has attended:
Excel Advanced course

by - delegate Hasan [1 post] (2007 Mar 28 Wed, 09:49) Reply

What are pivot tables and how do they work?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: pivot tables

by - trainer Amanda diamond contributer [1241 posts] (2007 Mar 28 Wed, 15:32) Reply

Hi Hasan

Thanks for your question.

Pivot tables allow you to display data stored in a list format in a more 3 dimensional way. You can also change the display of a pivot table by moving around fields within the pivot table area.

Amanda

· A Beginners Guide To Formulas In Excel
· Database Tips from an Excel Training Course
· Customized Financial Excel Courses in London
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· MS Excel: Excel At Making The Most Of Your Christmas

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.