Course Overview
Master Microsoft Excel: Beginner to Expert All-in-One Course - 4 EXCEL COURSES IN ONE
Become confident, fast, and effective in Modern Excel — from your very first spreadsheet to advanced analytics, automation, and VBA. This all‑in‑one training covers Excel 101, 102, 103, Power Query, PowerPivot, and VBA, giving you every skill needed to succeed in today’s data‑driven workplace.
Perfect for Microsoft Excel 2007–2026 and Microsoft 365.
You’ll Learn
Build clean, professional spreadsheets
Master essential formulas like SUM, IF, VLOOKUP, INDEX/MATCH
Use Modern Excel tools: XLOOKUP, TEXTSPLIT, SWITCH
Work with lists, tables, slicers, and data validation
Import/export data from text files, Access, and more
Build PivotTables, PivotCharts, and data models
Clean, transform, and connect data with Power Query
Automate tasks with Macros & VBA
What’s Included
22+ hours of guided video lessons
Downloadable practice files
Quizzes to reinforce learning
Interactive Q&A support
A complete path from beginner → expert
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!"
Start Your Excel Transformation
If you want one course that teaches everything you need to work confidently in Modern Excel, this is it. Enroll today and become the Excel expert your team relies on.
FAQ
FAQ area empty
Course curriculum
Chương 1 Microsoft Excel 101 Course Introduction 3 bài · 7 phút
Chương 2 Microsoft Excel Fundamentals 11 bài · 25 phút
-
Launching Excel 2:04
-
Microsoft Excel Startup Screen 1:47
-
Introduction to the Excel Interface 4:41
-
TIP - Hide Excel Ribbon 1:45
-
TIP - Customizing the Excel Quick Access Toolbar 2:19
- Understanding the Structure of an Excel Workbook Học thử 3:48
-
Saving an Excel Document 3:42
- Opening an Existing Excel Document Học thử 2:22
- Common Excel Shortcut Keys Học thử 2:51
- Microsoft Excel Shortcut Keys Resource Học thử
-
Excel Fundamentals Quiz
Chương 3 Entering and Editing Text and Formulas 17 bài · 52 phút
-
Entering Text to Create Excel Spreadsheet Titles 3:57
-
Entering Column Header Text for Excel Spreadsheet 3:04
-
Using Excel Autofill for Dates 3:29
-
Working with Numeric Data in Excel 2:23
-
Working with Cell References 2:59
-
Microsoft Excel Basic Mathematical Operators 3:10
-
DOWNLOAD - Formulas Exercise File
-
Excel Addition Formulas 4:36
-
Excel Multiplication Formulas 1:11
-
BONUS - More Excel Formula Examples 3:01
-
Using Parenthesis in Excel Formulas 3:35
-
Adding Total Formulas to the Monthly Budget Spreadsheet 2:26
-
Working with Relative References in Formulas 4:20
-
TIP - Show & Hide Excel Formulas 2:58
-
Relative Versus Absolute Cell References in Formulas 5:13
-
Understanding the Order of Operation (DOWNLOAD EXERCISE FILE) 6:05
-
Entering and Editing Text and Formulas Quiz
Chương 4 Working with Basic Excel Functions 10 bài · 30 phút
-
The structure of an Excel Function 5:35
-
Working with the SUM() Function 4:47
-
Adjacent Cells Error in Excel Calculations 2:52
-
Working with the AVERAGE() Function 2:40
-
Working with the MIN() and MAX() Functions 2:44
-
Working with the COUNT() Function 2:34
-
Using the AutoSum Command 4:24
-
Excel's AutoSum Shortcut Key 1:47
-
Using the AutoFill Command to Copy Formulas 2:32
-
Basic Excel Functions Quiz
Chương 5 Modifying an Excel Worksheet 10 bài · 21 phút
-
Intro to Modifying Excel Worksheets 0:58
-
Moving Data in an Excel Worksheet 2:08
-
Copying Excel Data 2:44
-
Changing the Width and Height of Cells 3:34
-
TIP - Fixing the ##### Marks in an Excel Column 1:24
-
Hiding and Unhiding Excel Rows and Columns 2:21
-
Renaming an Excel Worksheet 1:58
-
Deleting Excel Worksheets 2:25
-
Moving and Copying an Excel Worksheet 3:29
-
Modifying Worksheets Quiz
Chương 6 Formatting Data in an Excel Worksheet 14 bài · 43 phút
-
Introduction to Formatting Data in an Excel Worksheet 1:16
-
Working with Font Formatting Commands 4:30
-
Changing the Background Color of a Cell 4:58
-
Adding Borders to Cells 3:32
-
Excel Cell Borders Continued 2:31
-
Formatting Data as Currency Values 4:30
-
Formatting Percentages 1:50
-
Using Excel's Format Painter 1:58
-
Creating Styles to Format Data 5:31
-
Formatting Dates in Excel 3:05
-
Merging and Centering Cells 3:15
-
Using Conditional Formatting 3:33
-
Editing Excel Conditional Formatting 2:39
-
Formatting Data Quiz
Chương 7 Inserting Images and Shapes into an Excel Worksheet 4 bài · 15 phút
-
Inserting Images 5:14
-
Inserting Excel Shapes 2:26
-
Formatting Excel Shapes 3:37
-
Working with Excel SmartArt 4:09
Chương 8 Creating Basic Charts in Excel 12 bài · 36 phút
-
Creating an Excel Column Chart 4:39
-
Working with the Excel Chart Ribbon 2:39
-
Adding and Modifying Data on an Excel Chart 2:43
-
TIP - Non-Adjacent Chart Data Source 4:07
-
Excel Charts - Switch Row/Column 2:26
-
Formatting an Excel Chart 4:07
-
Excel Chart Data Labels 4:54
-
Modifying the Excel Chart Title 2:54
-
Moving a Chart to another Worksheet 2:32
-
Working with Excel Pie Charts 4:30
-
Microsoft Excel Charts Quick Guide (DOWNLOAD)
-
Working with Excel Charts Quiz
Chương 9 Printing an Excel Worksheet 7 bài · 21 phút
-
Viewing your Document in Print Preview 1:57
-
Changing the Margins, Scaling and Orientation 5:54
-
Excel Worksheet Margins 5:39
-
Working with Page Layout View 2:35
-
Adding Header and Footer Content 2:33
-
Printing a Specific Range of Cells 2:06
-
Printing an Excel Worksheet Quiz
Chương 10 Working with Excel Templates 4 bài · 10 phút
-
Intro to Excel Templates 0:52
-
Opening an Existing Template 4:03
-
Creating a Custom Template 5:29
-
Excel Templates Quiz
Chương 11 Excel 101 - Practice What You've Learned (DOWNLOAD) 3 bài · 1 phút
-
Excel 101 - Practice What You've Learned (DOWNLOAD)
-
Excel 101 Recap Exercise 1:18
-
Excel 101 Topics Recap with AI
Chương 12 Congratulations! You've Built a Solid Microsoft Excel Foundation 1 bài · 1 phút
-
Congratulations! 0:53
Chương 13 Microsoft Excel 102 Course Introduction 2 bài · 6 phút
-
Microsoft Excel 102 Topics Introduction 4:07
-
Excel 102 Course Exercise Files -- DOWNLOAD 1:41
Chương 14 Working with an Excel List 20 bài · 1 giờ 9 phút
-
Understanding Excel List Structure 3:19
-
TIP - Working with Excel Lists 3:31
-
Sorting a List Using Single Level Sort 2:16
-
Sorting a List Using Multi-Level Sorts 3:13
-
Using Custom Sorts in an Excel List 4:21
-
TIP - Sorting Full Date Values by Month 5:09
-
Filter an Excel List Using the AutoFilter Tool 3:45
-
Multi-Column Filtering Using the AutoFilter Tool 2:08
-
Creating Subtotals in a List 6:56
-
EXERCISE - Subtotal by a Date Value 1:53
-
EXERCISE DEMO - Subtotal by a Date Value 3:08
-
Format a List as a Table 5:16
-
TIP - Clear Previous Formatting 1:43
-
Microsoft Excel Table Options 3:39
-
Adding Rows and Columns to an Excel Table 4:45
-
Filtering Excel Tables with Slicers 3:24
-
Excel Table Slicer Options 2:46
-
Using Conditional Formatting to Find Duplicates 5:18
-
Removing Duplicates 2:52
-
Excel List Quiz
Chương 15 Excel List Functions 9 bài · 29 phút
-
Introduction to Excels Function: DSUM() 5:09
-
Excel DSUM Function Single Criteria Continued 5:16
-
Excel DSUM Function with OR Criteria 2:11
-
Excel DSUM Function with AND Criteria 3:09
-
Excel Function: DAVERAGE() 1:58
-
Excel Function: DCOUNT() 2:19
-
Excel Function: DGET() 4:36
-
TIP - Return Multiple Values with DGET() 3:57
-
List Functions :Quiz
Chương 16 Excel Data Validation 11 bài · 35 phút
-
Understanding the Need for Excel Data Validation 4:58
-
Cleaning Excel Data Values 2:30
-
Cleaning Excel Numeric Values 3:27
-
Formatting the List as Table to Prepare for Data Validation 1:54
-
Creating an Excel Data Validation List 3:17
-
Cleaning Spelling Errors with a Data Validation List 2:11
-
Excel Whole Numbers Data Validation 2:31
-
Adding a Custom Excel Data Validation Error 4:40
-
Data Validation Enforced by Custom Formulas 7:47
-
Major Benefit of Formatting as Table 1:55
-
Data Validation Quiz
Chương 17 Importing and Exporting Data 7 bài · 26 phút
-
Importing Data Into Microsoft Excel 3:33
-
Import Exercise Files - DOWNLOAD 0:36
-
Importing Data from Text Files 6:36
-
Importing Multiple Text Files into Excel 5:40
-
Importing Data from Microsoft Access 4:07
-
Exporting Data to a Text File 5:49
-
Importing and Exporting Data Quiz
Chương 18 Excel PivotTables 15 bài · 52 phút
-
Understanding Excel PivotTables 1:35
-
Creating an Excel PivotTable 3:49
-
Placing Fields in the PivotTable 4:59
-
Modifying the PivotTable Layout 3:25
-
Understanding Excel PivotTable Summary Calculation Defaults 4:47
-
Modifying Excel PivotTable Calculations 2:32
-
Grouping PivotTable Data 3:13
-
Grouping PivotTables by Date Values 5:14
-
Formatting PivotTable Data 2:43
-
Modifying PivotTable Calculations 5:28
-
TIP - Drilling Down into PivotTable Data 2:03
-
Creating PivotCharts 5:30
-
Filtering PivotTable Data 3:31
-
Filtering with the Slicer Tool 3:01
-
PivotTable Quiz
Chương 19 Working with Excel's Power Query Tools 10 bài · 39 phút
-
Introduction to Excel Power Query 6:19
-
Intro to this Sections Data (Customers & Orders) 2:56
-
Creating a Data Connection in Excel Power Query 3:07
-
Sorting and Filtering Power Query Data 2:49
-
Removing Columns from a Data Set 1:01
-
Loading Data to Excel 3:09
-
Creating Power Query Conditional Columns 5:39
-
Creating Power Query Calculated Columns 2:56
-
Creating Relationships between Data Sets 5:03
-
Editing Power Query Steps 5:41
Chương 20 Working with Excel's PowerPivot Tools 8 bài · 44 phút
-
Microsoft Excel Course Updates 1:33
-
Introduction to Excel Power Pivot 4:36
-
Why PowerPivot? 7:47
-
Activating the Excel PowerPivot AddIn 3:18
-
Creating Data Models with PowerPivot 4:54
-
Excel Power Pivot Data Model Relationships 4:46
-
Creating PivotTables based on Data Models 5:58
-
Excel Power Pivot KPIs 11:00
Chương 21 Working with Large Sets of Excel Data 8 bài · 23 phút
-
Using the Freeze Panes Tool 3:19
-
TIP - Microsoft 365 Excel Focus Cell Feature 1:21
-
Grouping Data (Columns and/or Rows) 2:38
-
Print Options for Large Sets of Data 3:38
-
Repeating the Header Row on Each Page 1:50
-
Linking Worksheets (3D Formulas) 4:03
-
Consolidating Data from Multiple Worksheets 6:20
-
Microsoft Excel Managing Large Excel Datasets Quick Guide (DOWNLOAD)
Chương 22 Excel 102 Additional Practice Exercises 3 bài · 1 phút
-
Excel 102 - Practice What You've Learned (DOWNLOAD)
-
Excel 102 Recap Exercise 1:20
-
Excel 102 Topics Recap with Alex an AI Avatar
Chương 23 Congratulations! You've Reached Intermediate Excel Status 1 bài · 1 phút
-
Congratulations! 1:03
Chương 24 Microsoft Excel 103 Course Introduction 2 bài · 7 phút
-
Microsoft Excel 103 Topics Introduction 6:28
-
Excel 103 Course Exercise Files -- DOWNLOAD 0:54
Chương 25 Working with Excel's Conditional Functions 13 bài · 46 phút
-
Introduction to Excel Conditional Functions 2:34
-
Working with Excel Name Ranges 3:45
-
Advantages and Disadvantages of Excel Name Ranges 5:05
-
Editing an Excel Name Range 3:27
-
Using Excel's IF() Function 4:53
-
Excel's IF() Function with a Name Range 2:51
-
Nesting Functions with Excel 2:37
-
Nesting Excels AND() Function within the IF() Function 6:36
-
TIP - The Power of Nesting Functions 2:52
-
Using Excel's COUNTIF() Function 2:14
-
Using Excel's SUMIF() Function 3:30
-
Excel SUMIF vs. SUMIFS Functions 3:17
-
TIP - Data Validation Lists and Excels SUMIF Function 2:08
Chương 26 Working with Excel's Lookup Functions 11 bài · 47 phút
-
Introduction to Excel Lookup Functions 2:03
-
Microsoft Excel VLOOKUP() Function 5:59
-
TIP - Don't Forget Absolute References 2:20
-
Using Excel's IFERROR() Function 4:01
-
HOMEWORK - Complete the Employee List - VLOOKUP 1:05
-
Microsoft Excel HLOOKUP() Function 4:12
-
Issues with VLOOKUP & HLOOKUP Functions 5:55
-
Microsoft Excel INDEX() Function 5:09
-
Microsoft Excel MATCH() Function 3:56
-
Microsoft Excel INDEX() and MATCH() Function Combined 4:29
-
Microsoft Excel INDEX() and MATCH() Function Combined Continued 7:43
Chương 27 Working with Excel's Text Based Functions 14 bài · 40 phút
-
Introduction to Excel Text Functions 3:01
-
Using Excel's LEFT(), RIGHT() and MID() Functions 5:19
-
Using Excel's LEN() Function 2:05
-
HOMEWORK - Single Formula Multiple Output 3:28
-
Using Excel's SEARCH() Function 6:11
-
TIP - Remove the Space 1:43
-
Extract the Last Name Value 3:08
-
Using Excel's CONCAT() Function 3:18
-
TIP - Using the & Character 1:50
-
Using Excel's UPPER() Function 2:02
-
Using Excel's PROPER() Function 2:37
-
Using Excel's TRIM() & CLEAN() Functions 3:20
-
TIP - Remove Unwanted Data with PASTE SPECIAL 2:09
-
Microsoft Excel Adv. Functions and Formulas Quick Guide (DOWNLOAD)
Chương 28 New Excel Functions for Excel 2019 and Microsoft 365 Excel Editions 13 bài · 48 phút
-
Introduction to New Excel Functions 1:15
-
DOWNLOAD: Microsoft Excel 365 Functions Exercise File 0:35
-
Microsoft Excel 365 FILTER() Function 4:59
-
Microsoft Excel 365 SORT() Function 5:33
-
Microsoft Excel 365 UNIQUE() Function 4:07
-
Microsoft Excel Dynamic FILTER() Function with Data Validation 5:38
-
Microsoft Excel 365 XLOOKUP() Function 5:25
-
EXERCISE: Dynamic Employee Order List 1:46
-
Microsoft Excel 365 SWITCH() Function 4:57
-
TIP: TRUE Expressions with Microsoft Excel 365 SWITCH() Function 3:44
-
Microsoft Excel 365 TEXTJOIN() Function 3:19
-
TIP: TEXTJOIN() Function with Criteria 4:32
-
Microsoft Excel 365 TEXTSPLIT() Function 2:33
Chương 29 Auditing an Excel Worksheet 6 bài · 16 phút
-
Tracing Precedents in Excel Formulas 4:51
-
Clear the Trace Arrows 0:31
-
Tracing Dependents in Excel Formulas 2:57
-
Working with the Watch Window 5:22
-
Deleting an Item from the Watch Window 0:47
-
Showing Formulas 1:51
Chương 30 Protecting Excel Worksheets and Workbooks 3 bài · 14 phút
-
Protecting Specific Cells in a Worksheet 7:22
-
Protecting the Structure of a Workbook 3:46
-
Adding a Workbook Password 3:06
Chương 31 Mastering Excel's "What If?" Tools 7 bài · 31 phút
-
Working with Excel's Goal Seek Tool 5:28
-
Introduction to Excel's Solver Tool 5:13
-
Activating the Solver Tool 1:08
-
Working with Excel's Solver Tool 5:20
-
Keeping the Solver Results 0:43
-
Building Effective Data Tables in Excel 5:04
-
Creating Scenarios in Excel 8:01
Chương 32 Introduction to Python in Excel: From First Code Block to First Chart 9 bài · 35 phút
-
Introduction to Python for Excel 2:33
-
Writing Your First Python Code Block with =PY 5:40
-
TIP: Referencing Cell Values in Python 1:42
-
Creating a Python DataFrame 2:46
-
Referencing and Exploring the DataFrame 5:17
-
Adding New Columns with Python 5:35
-
Summarizing Data with Aggregate Functions 2:58
-
Grouping & Summarizing Data with Python 3:28
-
Building a Bar Chart with Python 4:48
Chương 33 Automating Repetitive Tasks in Excel with Macros 7 bài · 34 phút
-
Understanding Excel Macros 3:50
-
Activating the Developer Tab in Excel 1:31
-
Setting Up the Macro Recorder 5:54
-
Recording Excel Commands with the Macro Recorder 6:49
-
Saving an Excel Macro File 2:52
-
Running an Excel Macro 2:32
-
Editing a Macro with VBA 10:14
Chương 34 Excel 103 Additional Practice Exercises 1 bài
-
Excel 103 - Practice What You've Learned (DOWNLOAD)
Chương 35 Congratulations! 1 bài · 1 phút
-
Congratulations on Completing the Microsoft Excel 103 1:16
Chương 36 Microsoft Excel Macros and VBA Course Introduction 2 bài · 11 phút
-
Welcome to the Course 5:50
-
Understanding the Why and How Behind Excel Macros 5:15
Chương 37 Project #1: Using Excel's Macro Recorder Tool 11 bài · 52 phút
-
Introduction to Project #1: Inserting and Formatting Text 3:36
-
Project #1: Section Exercise Files (DOWNLOAD)
-
Activating the Excel Developer Tab 2:20
-
Project #1: Start Recording! 11:16
-
Running a Microsoft Excel Macro 4:15
-
Project #1: Running an Excel Macro with a Button 5:52
-
BONUS - Create a Custom Button Using Excel Shapes 4:05
-
Adding the Excel Macro to the Quick Access Toolbar 4:03
-
Project #1: Editing the VBA Recorded by the Macro Recorder 11:59
-
Save a Workbook with a Macro/VBA Code 2:34
-
Practical Uses of Excel Macros 2:21
Chương 38 Excel VBA Concepts 13 bài · 1 giờ 16 phút
-
Intro to Excel VBA Concepts 7:02
-
Intro to Excel VBA Object Oriented Programming Concepts 4:58
-
Intro to Excel VBA Exercise Files (DOWNLOAD)
-
The Visual Basic Editor (VBE) 5:07
-
Introduction to the Excel VBA Immediate Window 12:34
-
Excel VBA Modules 3:45
-
Creating an Excel VBA Procedure 6:22
-
Adding Code to a VBA Procedure 4:44
-
Including Excel VBA Comments 2:46
-
Excel VBA MSGBOX Function 7:27
-
Excel VBA MsgBox Microsoft Help Information 2:08
-
Understanding and Working with Excel VBA Variables 16:28
-
REMINDER: Saving an Excel Workbook with VBA Code 2:29
Chương 39 Working with Excel VBA Logic Statements 9 bài · 52 phút
-
Working with Excel VBA Logic Exercise Files (DOWNLOAD)
-
Building Logic with an Excel VBA IF Statement 8:46
-
Including an Else Statement in the VBA IF Statement 1:43
-
Expanding the IF Logic with Multiple ElseIf Statements 3:12
-
Working with Excel VBA Select Case Statements 5:15
-
Working with an Excel VBA Do While Loop 12:26
-
Excel VBA Do While Loop Dynamic Condition 6:14
-
Working with an Excel VBA For Each Loop 6:31
-
Working with an Excel VBA For Next Loop 8:07
Chương 40 Project #2: Moving Beyond the Basics and into VBA 10 bài · 56 phút
-
Introduction to Project #2: Interacting with the User 1:56
-
Beyond the Basics Sort Project Exercise Files (DOWNLOAD)
-
Project #2: Introduction to the Excel VBA Range.Sort Method 4:47
-
Creating the Excel VBA Sort Procedures for this Project 9:29
-
Project #2: Prompting the User for Information 9:44
-
Continue Excel VBA InputBox 9:17
-
Project #2: Building Logic into Your Macros 4:15
-
Project #2: Alerting the User of Errors 10:03
-
Using Excel VBA Error Control Statements 4:39
-
Create a Button to Run the Sort Procedure and Save 2:14
Chương 41 Project #3: Preparing and Cleaning Up Data with Excel VBA 9 bài · 38 phút
-
Introduction to Project #3: Cleaning Up and Formatting Data 2:31
-
Project #3: Exercise Files (DOWNLOAD)
-
Project #3: Preparing to the Use the Macro Recorder 3:16
-
Project #3: Inserting the Headers 4:58
-
Project #3: Formatting the Headers 4:23
-
Project #3: Testing the Macros 2:35
-
Project #3: Using an Excel VBA Loop to Loop through all Worksheets 10:04
-
Project #3: Testing the Excel VBA Loop 3:09
-
Project #3: Adding Logic to an Excel VBA Loop 7:29
Chương 42 Project #4: Using VBA to Automate Excel Formulas 7 bài · 29 phút
-
Introduction to Project #4: Automate Excel Formulas 1:50
-
Project #4: Automate Sum Function Exercise Files (DOWNLOAD)
-
Project #4: Start the Procedure to Automate the SUM Function 6:49
-
Working with the Range Address Property 5:25
-
Creating the SUM Function in VBA 6:15
-
Run the Excel VBA Procedure to SUM Records 2:56
-
Project #4: Loop the SUM() Function Over Multiple Worksheets 5:25
Chương 43 Project #5: Bringing it All Together and a Weekly Report 8 bài · 31 phút
-
Introduction to Project #5: Creating the Final Report 2:09
-
Project #5: Final Report Loop Exercise Files (DOWNLOAD)
-
Project #5: Creating the Final Report Excel VBA Loop 5:02
-
Project #5 - Copying Content with Excel VBA 5:45
-
Project #5 - Pasting Content with Excel VBA 4:53
-
Cleaning Up the Final Report VBA Loop Code 5:22
-
Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet 5:48
-
Project #5 - Running the Final Report Procedure 2:03
Chương 44 Project #6: Working with Excel VBA User Forms 15 bài · 1 giờ 4 phút
-
Introduction to Project #6: Working with Excel VBA User Forms 3:01
-
Project #6: Working with Excel VBA User Forms Exercise Files (DOWNLOAD)
-
Project #6: Creating an Excel User Form 5:29
-
Project #6: Working with Form and Control Properties 6:36
-
Project #6: Formatting Excel VBA User Form Controls 3:21
-
Project #6: Adding VBA Code to the Initialize Event 9:27
-
Project #6: Using the AddItem Method within a Loop 10:00
-
Project #6: Adding VBA Code to the ComboBox Change Event 3:53
-
Project #6: Adding VBA Code to the Add Worksheet Button 3:51
-
Project #6: Change Worksheet Name 3:21
-
Project #6: Catch Errors When Adding a Worksheet 2:48
-
Add Sheet Procedure Catch Errors
-
Project #6: Additional Conditions on the Loop 5:57
-
Project #6: Running the Final Report Procedure 2:54
-
Project #6: Showing the VBA User Form On Workbook Open 3:47
Chương 45 Project #7: Importing Data from Text Files 9 bài · 49 phút
-
Project #7: Opening a Text File for Import 2:42
-
Project #7: Opening a Text File for Import 6:45
-
Project #7: Get Data from Text File 5:30
-
Project #7: Importing Multiple Text Files with the GetOpenFilename Method 9:32
-
Project #7: Creating a Loop to Read Each File 7:26
-
Project #7: Adding a New Sheet for Imported Data 2:36
-
Project #7: Clear the Clipboard 3:38
-
Project #7: Working with the ScreenUpdating Property 3:16
-
Project #7: Creating Reusable Code with a VBA Function 7:44
Chương 46 Course Wrap Up 2 bài · 1 phút
-
Congratulations! You're an Excel Macro/VBA Master 1:02
-
Bonus Lecture – Explore More Resources!
Requirment
-
No Prior Excel Knowledge Required
-
Microsoft Excel 2007-2024 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended
Outcomes
-
22+ hours of in-depth video instruction and hands-on practice files led by a Microsoft Certified Trainer with 2M+ students
-
Create and manage organized, professional Microsoft Excel spreadsheets from scratch
-
Master essential Excel functions like SUM, VLOOKUP, IF, and more
-
Analyze large Excel data sets with confidence and find key insights
-
Build dynamic reports using Excel PivotTables and visualizations
-
Automate repetitive tasks efficiently with Excel Macros and VBA
-
Design interactive dashboards and reports with Excel PowerPivot
-
Use advanced Excel functions to tackle real-world business problems
-
Improve productivity with time-saving Excel shortcuts and best practices
-
Gain the confidence to solve complex Excel tasks with ease
0 Student
2 Courses
0 review