Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics09.xlsx
Full free YouTube class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics09.pdf
The Only App That Matters book by Mike Girvib at Amazon: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ccs_id=70eb6de0-afb4-4979-a9a7-a1bdc0089ad3
Link to LAMBDA video:
https://www.youtube.com/watch?v=OxV-F0vXj8I&list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&index=13

In this video learn about PIVOTBY & GROUPBY Functions:
Topics:
1. (00:00) Introduction
2. (00:46) Topics in video
3. (01:48) Full list of Array Functions seen in this video
4. (02:10) Fundamental of Dynamic Spilled Array Formulas. Learn about the SEQUENCE array function.
5. (06:17) Conditional Formatting for Dynamic Spilled Array Formulas
6. (07:40) GROUPBY & PIVOTBY arguments
7. ( 08:07) History of Single Cell Reporting Formulas
8. Continue reading “PivotTables Can’t, But PIVOTBY & GROUPBY Can ! 10 Mind-Blowing Examples! MS 365 Excel Basics #9” →

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 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, Continue reading “Excel Revolution with PIVOTBY & GROUPBY Functions! #Short Preview of Upcoming Video” →

Learn how to add subtitles to your YouTube video. You can add subtitles in many languages.

excelisfun YouTub home page: https://www.youtube.com/user/excelisfun

Topics:
(00:00) Intro
(00:03) March 25, 2025 YouTube Subtotal Update
(01:21) What to do if Auto-translate option is greyed out
(02:22) Summary

For example, this video has subtitles in these languages: Afrikaans, Arabic, Bengali, Bangla, India), Dutch, Filipino, French, Hindi, Track, Indonesian, Khmer, Malay, Nepali, Persian, Polish, Spanish, Swahili, Tamil, Thai, Urdu, Vietnamese.
The steps to add subtitles are: Go to YouTube Studio, Go to Content, Hover over video, click the detail button, in the upper left click Language, on the right click Add Continue reading “How to Add Subtitles to YouTube Videos in Multiple Language March 25 2025 Update” →

In this short, learn the fast keyboard to create a PivotTable: Alt, N, V, T. 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 #keyboards #keybaord #keyboardshortcuts #excelbasics #excelbasicsforbeginners

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

In this video get an introduction to data analysis, data, information, and the Excel features: Excel Tables, PivotTables, Slicers, Excel Charts and Conditional Formatting.

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

Topics:
1. (00:00) Introduction
2. (00:29) Topics in Video
3. (01:13) Define Data Analysis, data and information
4. (03:38) What is Raw Data?
5. (04:13) What is a table?
6. (06:12) List Continue reading “MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!” →