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

struggling pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Struggling with pivot table

Struggling with pivot table

ResolvedVersion 2016

Beth has attended:
Excel Intermediate course

Struggling with pivot table

Hi there,

I am using a spreadsheet created by a colleague who has left our organisation. I need to amend the field values in the pivot table as it is not capturing the information i need it to, and I am not experienced at all with pivot tables.

Could I please email it over with my questions for someone to take a look?

Many thanks!
Beth

RE: Struggling with pivot table

Hello Beth,

Thank you for your question. You can send the file to:

info@stl-training.co.uk

If you could tell us what the field values should be, as well as which items should go into Rows, Columns and Filters, that would be great.

Kind regards
Marius Barnard
STL

RE: Struggling with pivot table

Hello Beth,

Do you still require assistance with your Pivot Table issue?

Kind regards
Marius Barnard
STL

RE: Struggling with pivot table

Thank you - I managed to resolve it with the help of a colleague.
Best wishes
Beth

RE: Struggling with pivot table

Hi Beth,

Thanks. Please feel free to continue using our forum in future!

Kind regards
Marius

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

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