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

microsoft excel training class - pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training class - Pivot Table

microsoft excel training class - Pivot Table

ResolvedVersion Standard

Amari has attended:
Project Intro Intermediate course
Excel Intermediate course
Excel Intermediate course

Pivot Table

What is a pivot table and what is it used for.

RE: Pivot Table

Hi Amari,

1. Enter the data you require for the Pivot table.
2. Select any cell within that data range
3. Then click Data > Pivot Table and Chart Reports
4. Follow all the steps of the wizard
5. Drag the fields you want to see onto the pivot table from the field list.


Pivot tables can be a more efficient way to view data

Hope that helps

Tracy

Excel tip:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.