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

excel training courses - excel data

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Excel Data

excel training courses - Excel Data

ResolvedVersion Standard

Daniel has attended:
Excel Intermediate course
Excel Advanced course

Excel Data

how do you do a pivot table?

RE: Excel Data

Hi Daniel,

1. Enter the data you require for the Pivot table generally in the format of a list.
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 if there is anything (more specific) let me know

Tracy



Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

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.