Pivot tables

Resolved · Medium Priority · Version 365

Fri 12 Feb 2021, 16:53 Delegate Femi said...

Femi has attended:
Excel Advanced course

Pivot tables

getting the top 5 value filters using the alternative/ quicker method

Mon 15 Feb 2021, 10:49 Trainer Jens said...

RE: Pivot tables

Hi Femi,

I hope that you are fine.

Thank you for the forum question.

I am not sure what you mean by "getting the top 5 value filters using the alternative/ quicker method"

The only method is the one we did on the course.

What I did after you did the Pivot Table "Bottom Five". I just copied the Pivot Table "Top Five" and changed the filter to "Bottom Five"

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips