PivotTable New Features (Spill Error & Auto Refresh) and PivotTable Basics Revealed. EMT 1914
From excelisfun · · 7 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Download Excel File: https://excelisfun.net/files/EMT1914-1915.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn about two new features in a PivotTable: Helpful #SPILL! Error and Auto Refresh. Also learn the powerful basics of how PivotTables work and how they are created. In specific, I take a BMX bike racing data set from all the races I have participated in this year and create a report that counts how many races for each track, % of races for each track, total points for each track and the % of point total for each track. In the process we the important basics of PivotTables. Topics: 1. (00:00) Introduction. 2. (00:29) Table with BMX Race Data that needs to be analyzed. 3. (00:46) Reporting goal of video. 4. (01:02) Create PivotTable report using Ribbon or Keyboard. 5. (01:29) #SPILL! Error: New in a PivotTable. 6. (02:06) PivotTable Brilliance: Drag Field to Row area and you get a Unique List. 7. (02:17) Drag Text Field to Values area and you get the default COUNT aggregate calculation. 8. (02:28) Summarize Values By calculation option. 9. (02:46) Show Values As option to calculate the % of Column Total for the COUNT aggregate calculation. 10. (03:00) Create informative labels for report. 11. (03:06) Number Formatting for a PivotTable. 12. (03:59) Drag Number Field to Values area and you get the default SUM aggregate calculation. 13. (04:19) Show Values As option to calculate the % of Column Total for SUM aggregate calculation. 14. (04:44) One reason PivotTables are the easiest option when creating reports. 15. (05:00) Sort report by aggregate total column. 16. (05:43) Auto Refresh (when new data is added to source table): New in a PivotTable. 17. (06:25) Set default on your computer so that ALL PivotTables will Auto Refresh when new data is added to the Source Data Table. 18. (06:57) Bonus Tip! 19. (07:40) Summary 20. (07:44) Closing
#excel #microsoft #excelcourse #mikegirvin #excel365 #excelisfun #mikegirvin #freeexcellessons #pivottables #pivottable #excelpivottable #excelpivottables #excelpivot #spillerror #spill #dynamicspilledarrayformulas #autorefresh #summarize #summarizevaluesby #showvaluesas #excelreporting #excel2025 #excel2024 #excel2026
This video has subtitles or audio translations in these languages: Afrikaans, Amharic, Arabic (experimental), Armenian, Bangla (experimental), Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Chinese, Chinese (China), Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), Estonian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Hebrew (experimental), Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean (experimental), Kurdish, Latvian, Lithuanian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi (experimental), Romanian, Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Sindhi, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swati, Swedish, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Tigrinya, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.