Microsoft Excel – Excel from Beginner to Advanced
-
Microsoft Excel 101 Course Introduction
-
Microsoft Excel FundamentalsLaunching Excel1m 26sMicrosoft Excel Startup Screen4m 12sIntroduction to the Excel Interface4m 39sTIP – Hide Excel Ribbon1m 55sTIP – Customizing the Excel Quick Access Toolbar2m 32sMore on the Excel Interface (Workbook and Status Bar)3m 4sUnderstanding the Structure of an Excel Workbook6m 18sSaving an Excel Document6m 13sOpening an Existing Excel Document2m 8sCommon Excel Shortcut Keys3m 46s
-
Entering and Editing Text and FormulasEntering Text to Create Excel Spreadsheet Titles8m 15sWorking with Numeric Data in Excel8m 27sEntering Date Values in Excel8m 37sWorking with Cell References0sCreating Basic Formulas in Excel8m 33sRelative Versus Absolute Cell References in Formulas0sUnderstanding the Order of Operation (DOWNLOAD EXERCISE FILE)0s
-
Working with Basic Excel FunctionsThe structure of an Excel Function0sWorking with the SUM() Function0sWorking with the MIN() and MAX() Functions0sWorking with the AVERAGE() Function0sWorking with the COUNT() Function0sAdjacent Cells Error in Excel Calculations0sUsing the AutoSum Command6m 48sExcel’s AutoSum Shortcut Key2m 13sUsing the AutoFill Command to Copy Formulas4m 24s
-
Modifying an Excel WorksheetMoving and Copying Data in an Excel Worksheet6m 33sInserting and Deleting Rows and Columns7m 13sChanging the Width and Height of Cells0sHiding and Unhiding Excel Rows and Columns5m 8sRenaming an Excel Worksheet2m 52sDeleting an Excel Worksheet4m 33sMoving and Copying an Excel Worksheet5m 12s
-
Formatting Data in an Excel WorksheetWorking with Font Formatting Commands7m 21sChanging the Background Color of a Cell0sAdding Borders to Cells0sExcel Cell Borders Continued0sFormatting Data as Currency Values0sFormatting Percentages0sUsing Excel’s Format Painter0sCreating Styles to Format Data0sMerging and Centering Cells0sUsing Conditional Formatting0sEditing Excel Conditional Formatting0s
-
Inserting Images and Shapes into an Excel Worksheet
-
Creating Basic Charts in Excel
-
Printing an Excel Worksheet
-
Working with Excel Templates
-
Excel 101 – Practice What You’ve Learned (DOWNLOAD)
-
Congratulations! You’ve Built a Solid Microsoft Excel Foundation
-
Microsoft Excel 102 Course Introduction
-
Working with an Excel ListUnderstanding Excel List Structure0sSorting a List Using Single Level Sort0sSorting a List Using Multi-Level Sorts0sUsing Custom Sorts in an Excel List0sFilter an Excel List Using the AutoFilter Tool0sCreating Subtotals in a List0sFormat a List as a Table0sUsing Conditional Formatting to Find Duplicates0sRemoving Duplicates0s
-
Excel List Functions
-
Excel Data Validation
-
Importing and Exporting DataImporting Data Into Microsoft Excel0sImporting Data from Text Files0sImporting Data from Microsoft Access0sNEW VERSION — Import Data From Text Files into Excel0sNEW VERSION — Import Data From a Database into Excel0sMicrosoft Excel Legacy Import Options for New Excel Versions0sExporting Data to a Text File0s
-
Excel PivotTablesUnderstanding Excel PivotTable0sCreating an Excel PivotTable0sModifying Excel PivotTable Calculations0sGrouping PivotTable Data0sFormatting PivotTable Data0sModifying PivotTable Calculations0sDrilling Down into PivotTable Data0sCreating PivotCharts0sFiltering PivotTable Data0sFiltering with the Slicer Tool0s
-
Working with Excel’s PowerPivot Tools
-
Working with Large Sets of Excel Data
-
Excel 102 Additional Practice Exercises
-
Congratulations! You’re an Intermediate Excel User
-
Microsoft Excel 103 Course Introduction
-
Working with Excel’s Conditional FunctionsWorking with Excel Name Ranges0sAdvantages and Disadvantages of Excel Name Ranges0sEditing an Excel Name Range0sUsing Excel’s IF() Function0sExcel’s IF() Function with a Name Range0sNesting Functions with Excel0sNesting Excels AND() Function within the IF() Function0sUsing Excel’s COUNTIF() Function0sUsing Excel’s SUMIF() Function0sUsing Excel’s IFERROR() Function0s
-
Working with Excel’s Lookup FunctionsMicrosoft Excel VLOOKUP() Function0sMicrosoft Excel HLOOKUP() Function0sMicrosoft Excel INDEX() Function0sMicrosoft Excel MATCH() Function0sMicrosoft Excel INDEX() and MATCH() Function Combined0sMicrosoft Excel INDEX() and MATCH() Function Combined Continued0sCreating a Dynamic HLOOKUP() with the MATCH() Function0s
-
Working with Excel’s Text Based Functions
-
New Excel Functions for Excel 2019 and Microsoft 365 Excel EditionsIntroduction to New Excel Functions0sDOWNLOAD: Microsoft Excel 365 Functions Exercise File0sMicrosoft Excel 365 FILTER() Function0sMicrosoft Excel 365 SORT() Function0sMicrosoft Excel 365 UNIQUE() Function0sMicrosoft Excel Dynamic FILTER() Function with Data Validation0sMicrosoft Excel 365 XLOOKUP() Function0sEXERCISE: Dynamic Employee Order List0sMicrosoft Excel 365 SWITCH() Function0sTIP: TRUE Expressions with Microsoft Excel 365 SWITCH() Function0sMicrosoft Excel 365 TEXTJOIN() Function0sTIP: TEXTJOIN() Function with Criteria0sMicrosoft Excel 365 TEXTSPLIT() Function0s
-
Auditing an Excel Worksheet
-
Protecting Excel Worksheets and Workbooks
-
Mastering Excel’s “What If?” Tools
-
Automating Repetitive Tasks in Excel with Macros
-
Excel 103 Additional Practice Exercises
-
Congratulations!
-
Microsoft Excel Macros and VBA Course Introduction
-
Project #1: Using Excel’s Macro Recorder ToolIntroduction to Project #1: Inserting and Formatting Text0sProject #1: Section Exercise Files (DOWNLOAD)Activating the Excel Developer Tab0sProject #1: Start Recording!0sRunning a Microsoft Excel Macro0sProject #1: Running an Excel Macro with a Button0sBONUS – Create a Custom Button Using Excel Shapes0sAdding the Excel Macro to the Quick Access Toolbar0sProject #1: Editing the VBA Recorded by the Macro Recorder0sSave a Workbook with a Macro/VBA Code0sPractical Uses of Excel Macros0s
-
Excel VBA ConceptsIntro to Excel VBA Concepts0sIntro to Excel VBA Object Oriented Programming Concepts0sIntro to Excel VBA Exercise Files (DOWNLOAD)The Visual Basic Editor (VBE)0sIntroduction to the Excel VBA Immediate Window0sExcel VBA Modules0sCreating an Excel VBA Procedure0sAdding Code to a VBA Procedure0sIncluding Excel VBA Comments0sExcel VBA MSGBOX Function0sExcel VBA MsgBox Microsoft Help Information0sUnderstanding and Working with Excel VBA Variables0sREMINDER: Saving an Excel Workbook with VBA Code0s
-
Working with Excel VBA Logic StatementsWorking with Excel VBA Logic Exercise Files (DOWNLOAD)Building Logic with an Excel VBA IF Statement0sIncluding an Else Statement in the VBA IF Statement0sExpanding the IF Logic with Multiple ElseIf Statements0sWorking with Excel VBA Select Case Statements0sWorking with an Excel VBA Do While Loop0sExcel VBA Do While Loop Dynamic Condition0sWorking with an Excel VBA For Each Loop0sWorking with an Excel VBA For Next Loop0s
-
Project #2: Moving Beyond the Basics and into VBAIntroduction to Project #2: Interacting with the User0sBeyond the Basics Sort Project Exercise Files (DOWNLOAD)Project #2: Introduction to the Excel VBA Range.Sort Method0sCreating the Excel VBA Sort Procedures for this Project0sProject #2: Prompting the User for Information0sContinue Excel VBA InputBox0sProject #2: Building Logic into Your Macros0sProject #2: Alerting the User of Errors0sUsing Excel VBA Error Control Statements0sCreate a Button to Run the Sort Procedure and Save0s
-
Project #3: Preparing and Cleaning Up Data with Excel VBAIntroduction to Project #3: Cleaning Up and Formatting Data0sProject #3: Exercise Files (DOWNLOAD)Project #3: Preparing to the Use the Macro Recorder0sProject #3: Inserting the Headers0sProject #3: Formatting the Headers0sProject #3: Testing the Macros0sProject #3: Using an Excel VBA Loop to Loop through all Worksheets0sProject #3: Testing the Excel VBA Loop0sProject #3: Adding Logic to an Excel VBA Loop0s
-
Project #4: Using VBA to Automate Excel FormulasIntroduction to Project #4: Automate Excel Formulas0sProject #4: Automate Sum Function Exercise Files (DOWNLOAD)Project #4: Start the Procedure to Automate the SUM Function0sWorking with the Range Address Property0sCreating the SUM Function in VBA0sRun the Excel VBA Procedure to SUM Records0sProject #4: Loop the SUM() Function Over Multiple Worksheets0s
-
Project #5: Bringing it All Together and a Weekly ReportIntroduction to Project #5: Creating the Final Report0sProject #5: Final Report Loop Exercise Files (DOWNLOAD)Project #5: Creating the Final Report Excel VBA Loop0sProject #5 – Copying Content with Excel VBA0sProject #5 – Pasting Content with Excel VBA0sCleaning Up the Final Report VBA Loop Code0sAdding Logic to Stop the Loop from Running Multiple Times on a Worksheet0sProject #5 – Running the Final Report Procedure0s
-
Project #6: Working with Excel VBA User FormsIntroduction to Project #6: Working with Excel VBA User Forms0sProject #6: Working with Excel VBA User Forms Exercise Files (DOWNLOAD)Project #6: Creating an Excel User Form0sProject #6: Working with Form and Control Properties0sProject #6: Formatting Excel VBA User Form Controls0sProject #6: Adding VBA Code to the Initialize Event0sProject #6: Using the AddItem Method within a Loop0sProject #6: Adding VBA Code to the ComboBox Change Event0sProject #6: Adding VBA Code to the Add Worksheet Button0sProject #6: Change Worksheet Name0sProject #6: Catch Errors When Adding a Worksheet0sAdd Sheet Procedure Catch ErrorsProject #6: Additional Conditions on the Loop0sProject #6: Running the Final Report Procedure0sProject #6: Showing the VBA User Form On Workbook Open0s
-
Project #7: Importing Data from Text FilesProject #7: Opening a Text File for Import0sProject #7: Opening a Text File for Import0sProject #7: Get Data from Text File0sProject #7: Importing Multiple Text Files with the GetOpenFilename Method0sProject #7: Creating a Loop to Read Each File0sProject #7: Adding a New Sheet for Imported Data0sProject #7: Clear the Clipboard0sProject #7: Working with the ScreenUpdating Property0sProject #7: Creating Reusable Code with a VBA Function0s
-
Course Wrap Up
Master Microsoft Excel: Beginner to Expert All-in-One Course
Unlock the full potential of Microsoft Excel in this comprehensive course designed to take you from beginner to advanced—plus expert-level tools like Macros and VBA. Perfect for any version from Microsoft Excel 2007 to 2025, this course bundles four intensive classes into one powerful package.
What You’ll Learn
Whether you’re just starting or looking to automate your workflow, we’ve got you covered:
Building organized and effective spreadsheets
Managing and analyzing large data sets with ease
Mastering essential Excel functions like SUM, VLOOKUP, IF, and INDEX/MATCH
Including new Microsoft 365 Functions like XLOOKUP, SWITCH, TEXTSPLIT and more
Creating dynamic reports with PivotTables
Harnessing PowerPivot for more advanced data modeling
Cleaning and auditing formulas to ensure accuracy
Automating tasks with Macros and VBA
What’s Included?
22+ hours of in-depth video instruction led by a Microsoft Certified Trainer
Downloadable exercise files to follow along and practice
Section quizzes to reinforce learning
An interactive Q&A board for questions and support
Student Success Story
“This course is amazing. Not everyone has the gift of teaching, but Kyle truly makes Excel easy and engaging. I now know Excel better than ever and feel ready to tackle any project!”
“This course made me an Excel pro! I was a total beginner, and now I feel confident tackling any Excel task. Kyle’s course is well-structured and easy to follow—highly recommend!”
“Excel has been a mystery to me until this course! Kyle’s teaching made it simple to understand. If you’re hesitant, don’t be—this is the course to buy!”
Take the next step in mastering Excel. Enroll now and transform from an Excel novice to an Excel expert!
What's included
- 22 hours on-demand video
- 15 articles
- 55 downloadable resources
- Access on mobile and TV
- Certificate of completion