pivot tables

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Pivot tables

resolvedResolved · Low Priority · Version 2003

Elize has attended:
Excel Advanced course

Pivot tables

How do I create a pivot table?

RE: Pivot tables

Hi Elize

Thank you for your question and welcome to the forum.

To create a pivot table:
1. Go to Data - PivotTable and PivotChart Report.
2. Follow through the three step wizard.
3. Once you have created the pivot table, you can drag and drop different fields into the table.

Amanda


 

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips


Server loaded in 0.07 secs.