Struggling with pivot table

Resolved · Medium Priority · Version 2016

Wed 4 Aug 2021, 17:50 Delegate Beth said...

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

Thu 5 Aug 2021, 09:18 Trainer Marius said...

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

Tue 10 Aug 2021, 19:47 Trainer Marius said...

RE: Struggling with pivot table

Hello Beth,

Do you still require assistance with your Pivot Table issue?

Kind regards
Marius Barnard
STL

Wed 11 Aug 2021, 09:12 Delegate Beth said...

RE: Struggling with pivot table

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

Wed 11 Aug 2021, 09:14 Trainer Marius said...

RE: Struggling with pivot table

Hi Beth,

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

Kind regards
Marius

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips