OverviewStep 1 creating a seriesStep 2 adjust row heightsStep 3 add column totalsStep 4 add a names columnStep 5 add column headersStep 6 add currency formattingStep 7 freeze the column headingsStep 8 add a Salary columnStep 9 add a conditional formulaStep 10 add a COUNTIF formulaStep 11 utilising binary cellsStep 12 applying Conditional FormattingStep 13 adding text cellsStep 14 adding an AVERAGEStep 15 adding calculationsStep 16 adding a FilterStep 17 add a Pie Chart graphicStep 18 using the IF and CONCAT functionsADDITIONAL Work with timesADDITIONAL PrintingAdvanced Topics Pivot TablesAdvanced Topics MacrosAdvanced Topics VLOOKUPsFinal Steps
Excel training
First written: Feb-2024
last changed Jan-2026

Pivot Tables

A pivot table is an Excel tool that allows you to summarize, analyze and explore data.

This is one in my many years of using Excel at advanced levels, I have never used. That said, if you want to know more about then go to Google/ChatGPT and start learning.

For more information, you should refer to those who feel more confident you need it - such as goskills.com

square

Also see

articles/Excel101square

Comments

New Comment

NOTE: (Put code blocks in [[[ and ]]] markup to be formatted.)

(Posted comments will be checked by the administrator before being published)



PrivacyCookies