Microsoft Excel: Beginner to Advanced in 2026!

About this course

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 FacebookWhether you're a student, business professional, data analyst, or entrepreneur, this course gives you the tools to work smarter, faster, and more confidently in ExcelUnlock 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 watchingMy teaching style is concise and straight-to-the-point, while still thoroughly explaining the functionWhat You'll LearnBeginner Essentials:Math functions: SUM, AVERAGE, COUNTA, and moreData cleaning tools: TRIM, CLEAN, SUBSTITUTE, Find & Replace, Removing Blanks, and moreFormatting mastery: cell styles, number formats, conditional formatting, freezing panesNavigation tips and layout tricks to build clean, readable spreadsheetsIntermediate Power Moves:Pivot Tables: summarize and analyze data like a pro with slicers, filters, parent row calculations, and changing layoutsText extraction: LEFT, RIGHT, MID, TEXTSPLIT, TEXTJOIN, TEXTBEFORE, TEXTAFTER, and pattern-based logicLookup functions: XLOOKUP, FILTER, VLOOKUP, INDEX MATCHLogical formulas: IF, IFS, SUMIFS, COUNTIFS, AVERAGEIFS, Nested IF, and combining all these with AND/ORAdvanced Excel Wizardry:Duplicate detection and advanced handling techniques to identify and remove them