IN
Upload

Loading...

You're viewing YouTube in English (US).
Switch to another language: | | | | | | | | | | View all
You're viewing YouTube in English.
Switch to another language: | | | | | | | | | | View all

Excel Basics #20: Data Analysis Pivot Tables PivotTables

353,720

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Dec 16, 2008

Download file: http://people.highline.edu/mgirvin/Ex...

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#20 Video topics:
1)PivotTables Pivot Tables Basics
2)Most Powerful Excel feature for summarizing data
3)Summarize Data Quickly
4)Group By Date
5)Format Fields
6)Format Pivot Table
7)Pivot the table
8)See Pivot Tables in Excel 2003 and Excel 2007
9)Page Filter
10)Show Page Filter
11)Report Filter
12)Show Report Filter

Loading...

  1. 1

    PivotTables Are Easy! 30 Examples for Highline College Professional Development Day 2014

  2. 2

    Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples

  3. 3

    Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)

  4. 4

    Slaying Excel Dragons Book #39: Data Analysis Pivot Tables & Pivot Charts, PivotTables & PivotCharts

  5. 5

    Slaying Excel Dragons Book #40: Grouping Dates in PivotTables: Years, Months or Weeks, and more

  6. Excel Basics #20: Data Analysis Pivot Tables PivotTables

  7. 7

    Highline Excel Class 20: Pivot Tables 20 Examples

  8. 8

    You Tubers Love Excel#11: Pivot Table, SUMPRODUCT & SUMIFS

  9. 9

    YouTubers Love Excel 12: Pivot Table AVERAGEIF SUMIF/COUNTIF

  10. 10

    YouTubersLoveExcel#25: Dynamic Range for Pivot Table & Chart

  11. 11

    Excel Name Trick #5: Names for Pivot Tables & more...

  12. 12

    Excel Statistics 04: Frequency Pivot Table Chart Basics

  13. 13

    YTLE#53: Excel Pivot Table and COUNTIF function

  14. 14

    YTLE#59: Pivot Table for Age Account Receivable

  15. 15

    Excel Statistics 16: Categorical Cross Tabulation with Pivot Table

  16. 16

    Excel Statistics 19: Grouping Categories w Formula & Pivot Table

  17. 17

    Excel Statistics 15: Category Frequency Distribution w Pivot Table & Pie Chart

  18. 18

    YTLE#70 PivotTable & TRIM function & AVERAGES

  19. 19

    Excel Statistics 24: Quantitative Freq. Dist. w Pivot Table

  20. 20

    Excel Statistics 25: % Freq. Dist.& Histogram w Pivot Table

  21. 21

    Excel Statistics 26: Cumulative Freq. Dist w Pivot Table (Running Total)

  22. 22

    Excel Statistics 29: Quantitative Cross Tabulation W Pivot Table

  23. 23

    YTLE#86: Pivot Table Filtering & Functions

  24. 24

    YTLE#91: PivotTable: Average w MONTH criteria

  25. 25

    Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports

  26. 26

    YTLE#106: Alternatives To Pivot Tables - Excel

  27. 27

    YTL Excel #124: Pivot Table Bowling Average

  28. 28

    Excel Magic Trick #114: GetPivotData ISERROR and IF function

  29. 29

    Excel Magic Trick #172: Running Total Formula or Pivot Table

  30. 30

    Excel Magic Trick #168: Cross Tabulation For a Survey

  31. 31

    Excel Magic Trick 216 Pivot Table 4 Variable Cross Tabulation

  32. 32

    Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2

  33. 33

    Excel Magic Trick #218: Pivot Table Macro w Dynamic Range #1

  34. 34

    Excel Magic Trick 250 Pivot Table Unique List in Unique List

  35. 35

    Excel Magic Trick 257 Convert Dates as Text to Dates As No.

  36. 36

    Excel Magic Trick 401: Quarterly Comparative Report - Pivot Table (PivotTable)

  37. 37

    Excel Magic Trick 402: Monthly Comparative Report - Pivot Table

  38. 38

    Excel Magic Trick 403: March End Quarterly Comparative Report - Pivot Table

  39. 39

    Excel Magic Trick 482: 2 Pivot Tables with Different Date Groupings On Same Sheet

  40. 40

    Excel Magic Trick 498: 6 PivotTable Calculation Tricks (Pivot Table)

  41. 41

    Excel Magic Trick 542: PivotTable Count How Many Times A Word Occurs In Word Document

  42. 42

    Excel Magic Trick 556: Change PivotTable Source Data (Pivot Table)

  43. 43

    Excel Magic Trick 710: average with 3 Criteria Using PivotTable Pivot Table

  44. 44

    Mr Excel & excelisfun Trick 83: PowerPivot or Helper Column & PivotTable & Custom Number Format

  45. 45

    Excel Magic Trick 805: Unique List When Adjacent Cell Contains 1 of 4 Words SEARCH Function & More

  46. 46

    Excel 2010 Magic Trick 812: PivotTable Show Report Filter Pages For School District Reports

  47. 47

    Excel 2010 Statistics #15: Frequency Distributions, Histograms, Column Charts (11 Examples)

  48. 48

    Excel 2010 Statistics #17 Ogive Chart Formula PivotTable Data Analysis Toolpak Add-in & Pareto Chart

  49. 49

    Excel 2010 Statistics #21: Cross Tabulation With PivotTable Frequencies and % Column & % Row

  50. 50

    Excel 2010 Statistics #41: Joint Probability Table with PivotTable

  51. 51

    Learn Excel PowerPivot From Chandoo and Rob

  52. 52

    Excel Magic Trick 1034: Convert Summarized Table To Proper Data Set With PivotTable Trick

  53. 53

    Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable

  54. 54

    Excel Magic Trick 1112: Clean Transactional Data, Then Create PivotTable Monthly Cost Report

  55. 55

    Excel Magic Trick 1115: PivotTable to Count How Many of Each Item There Are In a Column

  56. 56

    Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable

  57. 57

    Excel 2013 PowerPivot Basics #11: Group By Date: Excel PivotTable vs. PowerPivot PivotTable

  58. 58

    Excel 2013 PowerPivot Basics #12: Show Report Filter Pages Not Available In PowerPivot Pivot Table

  59. 59

    Excel Magic Trick 1151: Get Two Tables Into Pivot Table Field List using Excel 2013

  60. 60

    Excel Magic Trick 1158: Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013

Advertisement
to add this to Watch Later

Add to