Excel 365 Basics - Learn to Efficiently Use Excel at Work and to Get a Job

Learn to efficiently use Microsoft Excel 365 for workplace tasks and career advancement through this comprehensive 11-hour course taught by Highline College Professor and YouTube educator Mike Girvin. Master essential Excel skills including formulas, functions, formatting, cell references, and page setup while progressing through advanced topics like SUMIFS, COUNTIFS, date and time calculations, and logical functions such as IF, IFS, and XLOOKUP. Explore powerful data analysis tools including FILTER, XMATCH, and SWITCH functions, then advance to creating PivotTables, slicers, charts, and conditional formatting for comprehensive data analysis. Discover the revolutionary PIVOTBY and GROUPBY functions that can outperform traditional PivotTables, and learn to use Power Query, FlashFill, and dynamic array functions like SORT and FILTER. Progress to advanced data modeling with Power Pivot, DAX measures, and relationship management, culminating in Power BI Desktop skills for creating interactive dashboards and visualizations from large datasets including SQL data with millions of rows. Access downloadable workbooks for hands-on practice, homework assignments for skill reinforcement, and PDF notes summarizing each lesson to transform from basic user to advanced Excel professional.

Syllabus

Excel 365 Basics #1: What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup
Excel 365 Basics #2: SUMIFS, COUNTIFS, COUNT, COUNTA, ROWS, SUM & IF Functions to Add & Count
Excel 365 Basics #3: Number Formatting as Façade & when you MUST use ROUND Function
Excel 365 Basics #4: Date & Time Formulas, Functions & Formatting: All The Basics You Need to Know
Excel 365 Basics #5: IF Function & Logical Tests IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More
Excel 365 Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task!
Excel 365 Basics #7: Comprehensive Formula & Function Lesson To Become An Excel Formula Guru!
MS 365 Excel Basics #3.5: Spill Rectangle Range of Weekly Commission Paid Amounts: #Short EMT 34
MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!
Excel Revolution with PIVOTBY & GROUPBY Functions! #Short Preview of Upcoming Video
MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!
MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples.
MS 365 Excel Basics #10 Part 02: SORT Array Function & the Many Varied Tasks It Can Achieve!
MS 365 Excel Basics #10 Part 03: FILTER Array Function to Dynamically Filter!
MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total
MS 365 Excel Basics 11: Power Pivot, Data Model, Relationships & DAX Measures, & Filter Context Too!
MS 365 Excel Basics 12: Power BI Desktop & Interactive Visuals / Dashboards, Import Excel Data Model
MS 365 Excel Basics #13: Power BI Dashboard from 7 Million Rows of SQL Data and DAX Formulas