Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 18 Minute(s)
Language
English
Taught by
Kyle Mulka
Rating
Course Overview
Excel with Kyle — Master Every Essential Excel Function in 2026, From Beginner to Advanced
Master Microsoft Excel: Learn from Excel with Kyle using Hands-On Practice from a Microsoft Excel Instructor with over 300,000 followers across TikTok and Facebook
Whether you're a student, business professional, data analyst, or entrepreneur, this course gives you the tools to work smarter, faster, and more confidently in Excel
Unlock the full power of Microsoft Excel — from your very first formula to advanced data analysis and automation. This course is designed to take you from absolute beginner to Excel expert, with hands-on practice using downloadable files in every single lecture so you learn by doing, not just watching
My teaching style is concise and straight-to-the-point, while still thoroughly explaining the function
What You'll Learn
Beginner Essentials:
Math functions: SUM, AVERAGE, COUNTA, and more
Data cleaning tools: TRIM, CLEAN, SUBSTITUTE, Find & Replace, Removing Blanks, and more
Formatting mastery: cell styles, number formats, conditional formatting, freezing panes
Navigation tips and layout tricks to build clean, readable spreadsheets
Intermediate Power Moves:
Pivot Tables: summarize and analyze data like a pro with slicers, filters, parent row calculations, and changing layouts
Text extraction: LEFT, RIGHT, MID, TEXTSPLIT, TEXTJOIN, TEXTBEFORE, TEXTAFTER, and pattern-based logic
Lookup functions: XLOOKUP, FILTER, VLOOKUP, INDEX MATCH
Logical formulas: IF, IFS, SUMIFS, COUNTIFS, AVERAGEIFS, Nested IF, and combining all these with AND/OR
Advanced Excel Wizardry:
Duplicate detection and advanced handling techniques to identify and remove them
Dynamic formulas: REGEX, LET, FILTER, working with Wildcards for partial matches, and much more
Automation with Macros and Power Query (ETL)
Additional functions & tools: Python in Excel, AGGREGATE, TOCOL, Goal Seek, Solver, and more hidden gems
As we go through the course, we will build on the functions we learned in previous sections, teaching you new functions, and how to combine new functions with functions we already learned to create dynamic formulas
Why This Course Is Different:
Every lecture includes hands-on exercises — no passive learning with PowerPoint slides
Real-world examples you’ll actually use in business, finance, and data work from a long-time Data Analyst
Step-by-step progression and reinforcement from basics to advanced tools
Lifetime access and downloadable practice files
Ready to become the Excel expert everyone turns to? Enroll now and start building your skills — one function at a time!
Course Content
- 20 section(s)
- 160 lecture(s)
- Section 1 Introduction and Course Structure
- Section 2 Important Excel Basics
- Section 3 Basic Math Functions
- Section 4 Data Cleaning
- Section 5 Pivot Tables
- Section 6 Working with Dates in Excel
- Section 7 Pattern-Based Text Extracting and Text Parsing
- Section 8 XLOOKUP, INDEX MATCH, and VLOOKUP
- Section 9 IF and IFS Functions (and Common Functions that Are Used with Them)
- Section 10 SUMIFS, COUNTIFS, and AVERAGEIFS Functions
- Section 11 Duplicate Handling
- Section 12 Charts and Graphs
- Section 13 LET Function
- Section 14 FILTER Function
- Section 15 REGEX
- Section 16 Macros
- Section 17 PowerQuery
- Section 18 Python in Excel
- Section 19 Additional Cool Functions & Tools
- Section 20 Thank you and Congratulations!
What You’ll Learn
- Learn from a long-time Excel instructor with over 300,000 followers across TikTok and Facebook, Understand and apply advanced techniques like XLOOKUP, FILTER, or INDEX MATCH to retrieve data, Build clean, professional spreadsheets using formatting, data validation, and error‑proofing techniques., Need to use SUMIFS or COUNTIFS when there's multiple conditions or partial matches? No problem!, Learn every important function and tool for Excel in 2026 that you need to create powerful reports and perform at the top-level, You'll be capable of using advanced data extraction functions such as REGEX, advanced conditional logic such as Nested IF (with AND & OR), and much more, Analyze and summarize data using PivotTables, PivotCharts, and advanced filtering tools., Students will learn practical data‑cleaning and duplicate‑handling techniques to prepare accurate, analysis‑ready datasets in Excel.
Skills covered in this course
Reviews
-
AAlan Detwiler
yes, so far so good
-
MMatt Pansa
Good match, starting things slow with the basics but seasoned professionals are still learning with keyboard tricks!
-
CCarolyn Edwards
Although I'm familiar with the basic function of Excel, learning new short cuts and diving a tad bit deeper has made a huge difference even in the basics. Very cool! I can't wait to go deeper.
-
WWilliam Garcia Contreras
Its very well explained.
