Skip to content
Sabaqاردو

Excel 365 Basics (ExcelIsFun)

By excelisfun

Course audio
Course audio: English
Level
Beginner
Length
15 lessons

What you'll be able to do

  • Build formulas with SUMIFS, COUNTIFS, IF and XLOOKUP
  • Summarise data with PivotTables, slicers and charts
  • Use dynamic array functions such as FILTER, SORT and GROUPBY

About this course

Mike Girvin, the Highline College instructor behind ExcelIsFun, teaches a free Excel 365 basics class aimed at using Excel at work. The numbered lessons cover what Excel is and how formulas and functions work, SUMIFS, COUNTIFS and IF, number and date formatting, logical tests, XLOOKUP, FILTER and XMATCH, a comprehensive formula lesson, PivotTables with slicers and charts, the new PIVOTBY and GROUPBY functions, Power Query and Flash Fill, and dynamic array functions such as SORT and FILTER. It suits complete beginners who want modern Excel. Take his Power Query and Power BI class next.

Before you start: Access to Microsoft 365 Excel

Syllabus

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

  1. 1Excel 365 Basics #1: What is Excel?, Formulas, Functions, Formatting, Cell References & Page Setup
  2. 2Excel 365 Basics #2: SUMIFS, COUNTIFS, COUNT, COUNTA, ROWS, SUM & IF Functions to Add & Count
  3. 3Excel 365 Basics #3: Number Formatting as Façade & when you MUST use ROUND Function
  4. 4Excel 365 Basics #4: Date & Time Formulas, Functions & Formatting: All The Basics You Need to Know
  5. 5Excel 365 Basics #5: IF Function & Logical Tests IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More
  6. 6Excel 365 Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task!
  7. 7Excel 365 Basics #7: Comprehensive Formula & Function Lesson To Become An Excel Formula Guru!
  8. 8MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!
  9. 9PivotTables Instantly Update When Source Data Change, Just Like Formulas!! Excel Magic Trick 1900
  10. 10Excel Revolution with PIVOTBY & GROUPBY Functions! #Short Preview of Upcoming Video
  11. 11MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!
  12. 12MS 365 Excel Basics 10: Power Query, FlashFill, XLOOKUP, PivotTables Sort & Filter! 7 DA Examples.
  13. 13MS 365 Excel Basics #10 Part 02: SORT Array Function & the Many Varied Tasks It Can Achieve!
  14. 14MS 365 Excel Basics #10 Part 03: FILTER Array Function to Dynamically Filter!
  15. 15MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total

What to take next

Videos by excelisfun, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Sabaq lists the first 15 videos of this playlist; the rest continue on YouTube. Full playlist on YouTube

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request