PIVOT TABLE - Excel Online Video Courses
[Pages:12]PIVOT TABLE
CHEAT SHEET
INSERTING A PIVOT TABLE
Click anywhere your data source or Table and choose Insert > PivotTable
Alt N V T
REFRESH A PIVOT TABLE
Right click anywhere in the pivot table and select Refresh
Alt
F5
DRILL DOWN TO AUDIT
Double click with your mouse in a Pivot Table value
PIVOT TABLE STYLES
Click anywhere in your Pivot Table, then choose Design > Pivot Table Styles
INSERT/REMOVE SUBTOTALS & GRAND TOTALS
Click anywhere in your Pivot Table, then choose Design > Subtotals/Grand Totals
NUMBER FORMATTING
Right click on any values within the Pivot Table and Select Number Format
PIVOT TABLE OPTIONS
Right click anywhere in the Pivot Table and select Pivot Table Options
SUMMARIZE VALUES BY / SHOW VALUES AS
Right click anywhere in the Pivot Table and select Summarize Values By or Show Values As
...Or in the Field List Values Area, choose the drop down arrow and select
Value Field Settings > Summarize Values By or Show Values As
GROUPING
Right click anywhere in the Pivot Table and select Group
SORTING
Right click anywhere in the Pivot Table and select Sort
FILTERING
Click on the Row/Column drop down arrow to access the Filter
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pivot table excel online video courses
- excel functions fx troyclic
- how to make a line graph with phase lines in excel 2007
- using the excel file
- 9780135112885 inp c01 ms11 pearson
- the report procedure and ods destination for microsoft
- exporting stata results to excel
- how to make a run chart in excel oahhs
- excel 2016 formulas and functions
- microsoft excel 2013 fundamentals manual
Related searches
- online english courses for beginners
- online writing courses middle school
- free online grammar courses for adults
- best online english courses free
- are online college courses good
- online college courses start anytime
- free online college courses accredited
- online college courses for high school students
- pivot table top 10
- pivot table relationships excel 2013
- basic pivot table cheat sheet
- pivot table in excel 365