Pivot tables

Resolved · Low Priority · Version 2010

Wed 23 Aug 2017, 16:45 Delegate Alison said...

Alison has attended:
Excel Introduction course
Excel Introduction course

Pivot tables

I need to lesrn how to put data into pivot tables

Wed 23 Aug 2017, 18:15 Trainer Richard said...

RE: Pivot tables

Hi Alison,

Glad you enjoyed the course today.

I believe we are looking to run another course for the team on using Pivot Tables. If you could let Lindsay know you are interested she'll make a note.

Kind regards

Richard Bailey
Microsoft Certified Trainer

Best 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.7 % recommend us
	More live stats...

Training information:

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips