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

microsoft excel training in london - pivot tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training in london - Pivot Tables

microsoft excel training in london - Pivot Tables

ResolvedVersion Standard

Michelle has attended:
Excel Advanced course

Pivot Tables

Can you please advise the best way to run pivot tables

RE: Pivot Tables

Hi Michelle,

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.

What do you mean by the best way of running a pivot table, what do you want it to do specifically?

Tracy

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

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.