Download Excel File: https://excelisfun.net/files/ExcelShort68.xlsx
Full Length GROUPBY video with much more detail: https://www.youtube.com/watch?v=l5hcjfW81tQ&list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo&index=12
Link to full Excel Basics Class: https://www.youtube.com/watch?v=rXwZITn70Xo&list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo&index=9

Using the gear icon setting button below the video, you can watch subtitles in these languages: Afrikaans, Arabic, Bengali (some videos), Bangla, Dutch, Filipino, French, Hindi, Indonesian, Khmer, Malay, Malayalam, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Telugu, Thai, Tibetan, Urdu, Vietnamese.
Using the gear icon setting button below the video, you can listen to an audio track in these translated languages: French, German, Hindi, Indonesian, Italian, Japanese, Portuguese, and Spanish.

#dataanalysis #excel #excel365 #office365 #office365training Continue reading “Mind-Blowing: GROUPBY Function Beats PivotTable, Hands-down. Excel Short Magic Trick 75” →

Download Excel File: https://excelisfun.net/files/EMT1881.xlsx
Enny Kraft from YouTube and Hamidi Hamid from LinkedIn provide temporary fixes for the chart & GROUPBY bug brought up in EMT 1880:
When I create a single cell reporting formula with the GROUPBY array function or other single cell dynamic spilled array reporting formula, and then create an Excel Chart from the single cell formula, and then insert a column, the chart looses track of the correct location for the report. The chart breaks and poinst to the incorrect range.
Topics:
1. (00:00) Introduction
2. (00:01) What is the Bug?
3. (00:26) Hamidi Hamid fix
4. (00:46) Enny Continue reading “Temporary Fix for GROUPBY Function & Single Cell Reporting Formula Excel Chart Bug? EMT 1881” →

#excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions #groupby #excelchart #excelcharts #bug #excelbug

Excel Basics Free Class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo

PivotTables revolutionized reporting 40 years ago when they debuted in 1994 in Excel 5.

40 years later, in 2024, Microsoft introduced the PIVOTBY and GROUPBY functions, in 2024 to revolutionize reporting for our future generations!

PivotTables to create summary reports. They require a refresh when source data changes.

PIVOTBY Dynamic Spilled Array Formula to create summary reports. They instantly update when source data changes.

GROUPBY Dynamic Spilled Array Formula to create summary reports. They instantly update when source data changes.

Video has subtitles in these languages: Afrikaans, Arabic, Bengali, Bangla, India), Dutch, Filipino, French, Hindi, Track, Indonesian, Khmer, Continue reading “Excel Revolution with PIVOTBY & GROUPBY Functions! #Short Preview of Upcoming Video” →

In this short, learn how to add a Slicer to a PivotTable and Chart to Allow Quick Analysis. This is an outtake from Excel Basics Data 08, Introduction to Data Analysis:
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics08.xlsx
Pdf notes (free book): https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics08.pdf
Link to full Excel Basics Class: https://www.youtube.com/watch?v=rXwZITn70Xo&list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo&index=9
Link to full Data Analysis Class: https://www.youtube.com/watch?v=rXwZITn70Xo&list=PLrRPvpgDmw0kCv2ulsHk4uitL9meshr_k&index=1

Video has subtitles in these languages: Afrikaans, Arabic, Bangla, Bangla (India), Dutch, Filipino, Hindi, Indonesian, Khmer, Malay, Swahili, Thai, Urdu, Vietnamese

#dataanalysis #excel #excel365 #office365 #office365training #excelisfun #pivot_table #pivot #pivottable #pivottables #charts #excelcharts #slicer #excelslicer #slicers #keyboardshortcuts #excelbasics #excelbasicsforbeginners #slicerchart? Continue reading “Add Slicer to PivotTable & Chart To Enable Quick Analysis Excel Short Magic Trick 74” →