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

excel training course - how do i create

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - How do I create a pivot table?

excel training course - How do I create a pivot table?

ResolvedVersion Standard

Alessandro has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

How do I create a pivot table?

I would like to create a pivot table

RE: How do I create a pivot table?

Hi Alessandro,

I hope you gained a lot of knowledge from your Excel Advanced training course today.

To create a pivot table:
- Put your cursor into the data you want to go into your pivot table.
- Select DATA> Pivot table. Then follow the wizard
- Drag the relevant fields to the PIVOT TABLE.
- Adjust as necessary.

If this answers your question. Feel free to invite your colleagues and friend to this forum so they can get answers to their Microsoft Office problems too!

Kind regards,
Rich

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

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 1.12 secs.