All Levels
16 hours
Java Tutorial for Complete Beginners
Learn to program using the Java programming language
John Purcell
What you'll learn:
- ✓Learn to program in Java
16 hours
73 lectures
Access on mobile and TV
Certificate
DevelopmentJava
All LevelsOffice ProductivityExcel
Microsoft Excel - Excel from Beginner to Advanced
All-in-One Excel Training: Transform Your Skills with Hands-On Projects and Real-World Applications! - Excel 2007-2024
Created by Kyle Pew • 2,000,000+ Students, Office Newb
22 hours
Video Content
271
Lectures
1,649,634
Students
4.7
Rating
4.7
(1,649,634 students enrolled)What you'll learn
✓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
Course Content
44 sections • 271 lectures • 21:57:53 total length
Microsoft Excel 101 Course Introduction
3 lectures • 04:27
Microsoft Excel 101 Course Introduction
3 lectures • 04:27
Ask Questions01:42
Course Exercise Files01:27
Certificate of Completion01:18
Microsoft Excel Fundamentals
10 lectures • 36:08
Microsoft Excel Fundamentals
10 lectures • 36:08
Launching Excel01:25
Microsoft Excel Startup Screen04:12
Introduction to the Excel Interface04:39
TIP - Hide Excel Ribbon01:55
TIP - Customizing the Excel Quick Access Toolbar02:31
+6 more lectures
Entering and Editing Text and Formulas
7 lectures • 01:02:59
Entering and Editing Text and Formulas
7 lectures • 01:02:59
Entering Text to Create Excel Spreadsheet Titles08:15
Working with Numeric Data in Excel08:26
Entering Date Values in Excel08:37
Working with Cell References06:00
Creating Basic Formulas in Excel08:32
+3 more lectures
Working with Basic Excel Functions
9 lectures • 46:19
Working with Basic Excel Functions
9 lectures • 46:19
The structure of an Excel Function10:16
Working with the SUM() Function07:00
Working with the MIN() and MAX() Functions06:18
Working with the AVERAGE() Function02:51
Working with the COUNT() Function02:51
+5 more lectures
Modifying an Excel Worksheet
7 lectures • 36:45
Modifying an Excel Worksheet
7 lectures • 36:45
Moving and Copying Data in an Excel Worksheet06:33
Inserting and Deleting Rows and Columns07:13
Changing the Width and Height of Cells05:17
Hiding and Unhiding Excel Rows and Columns05:07
Renaming an Excel Worksheet02:51
+3 more lectures
Formatting Data in an Excel Worksheet
11 lectures • 44:41
Formatting Data in an Excel Worksheet
11 lectures • 44:41
Working with Font Formatting Commands07:20
Changing the Background Color of a Cell03:09
Adding Borders to Cells02:24
Excel Cell Borders Continued03:13
Formatting Data as Currency Values04:28
+7 more lectures
Inserting Images and Shapes into an Excel Worksheet
4 lectures • 18:32
Inserting Images and Shapes into an Excel Worksheet
4 lectures • 18:32
Inserting Images04:01
Inserting Excel Shapes02:29
Formatting Excel Shapes03:38
Working with Excel SmartArt08:24
Creating Basic Charts in Excel
7 lectures • 28:52
Creating Basic Charts in Excel
7 lectures • 28:52
Creating an Excel Column Chart03:22
Working with the Excel Chart Ribbon02:42
Adding and Modifying Data on an Excel Chart05:21
Formatting an Excel Chart06:36
Moving a Chart to another Worksheet03:34
+3 more lectures
Printing an Excel Worksheet
6 lectures • 27:07
Printing an Excel Worksheet
6 lectures • 27:07
Viewing your Document in Print Preview03:51
Changing the Margins, Scaling and Orientation08:12
Excel Worksheet Margins03:02
Working with Page Layout View03:23
Adding Header and Footer Content05:38
+2 more lectures
Working with Excel Templates
3 lectures • 18:14
Working with Excel Templates
3 lectures • 18:14
Intro to Excel Templates03:13
Opening an Existing Template08:43
Creating a Custom Template06:18
Excel Templates Quiz1 question
Excel 101 - Practice What You've Learned (DOWNLOAD)
1 lectures • 00:09
Excel 101 - Practice What You've Learned (DOWNLOAD)
1 lectures • 00:09
Excel 101 - Practice What You've Learned (DOWNLOAD)00:09
Excel 101 Topics Recap with AI
Congratulations! You've Built a Solid Microsoft Excel Foundation
1 lectures • 01:55
Congratulations! You've Built a Solid Microsoft Excel Foundation
1 lectures • 01:55
Congratulations!01:55
Microsoft Excel 102 Course Introduction
1 lectures • 01:15
Microsoft Excel 102 Course Introduction
1 lectures • 01:15
Excel 102 Course Exercise Files -- DOWNLOAD01:15
Working with an Excel List
9 lectures • 44:50
Working with an Excel List
9 lectures • 44:50
Understanding Excel List Structure05:39
Sorting a List Using Single Level Sort03:47
Sorting a List Using Multi-Level Sorts03:46
Using Custom Sorts in an Excel List04:33
Filter an Excel List Using the AutoFilter Tool04:56
+5 more lectures
Excel List Functions
7 lectures • 37:33
Excel List Functions
7 lectures • 37:33
Introduction to Excels Function: DSUM()05:30
Excel DSUM Function Single Criteria Continued04:47
Excel DSUM Function with OR Criteria02:33
Excel DSUM Function with AND Criteria05:34
Excel Function: DAVERAGE()04:55
+3 more lectures
Excel Data Validation
5 lectures • 24:13
Excel Data Validation
5 lectures • 24:13
Understanding the Need for Excel Data Validation05:00
Creating an Excel Data Validation List05:24
Excel Decimal Data Validation04:15
Adding a Custom Excel Data Validation Error04:51
Dynamic Formulas by Using Excel Data Validation Techniques04:43
+1 more lectures
Importing and Exporting Data
7 lectures • 34:07
Importing and Exporting Data
7 lectures • 34:07
Importing Data Into Microsoft Excel01:42
Importing Data from Text Files05:34
Importing Data from Microsoft Access04:14
NEW VERSION -- Import Data From Text Files into Excel07:55
NEW VERSION -- Import Data From a Database into Excel06:19
+3 more lectures
Excel PivotTables
10 lectures • 51:03
Excel PivotTables
10 lectures • 51:03
Understanding Excel PivotTables03:52
Creating an Excel PivotTable06:31
Modifying Excel PivotTable Calculations05:35
Grouping PivotTable Data07:49
Formatting PivotTable Data04:09
+5 more lectures
Working with Excel's PowerPivot Tools
7 lectures • 42:19
Working with Excel's PowerPivot Tools
7 lectures • 42:19
Introduction to Excel Power Pivot04:36
Why PowerPivot?07:47
Activating the Excel PowerPivot AddIn03:18
Creating Data Models with PowerPivot04:54
Excel Power Pivot Data Model Relationships04:46
+2 more lectures
Working with Large Sets of Excel Data
6 lectures • 25:17
Working with Large Sets of Excel Data
6 lectures • 25:17
Using the Freeze Panes Tool03:39
Grouping Data (Columns and/or Rows)04:17
Print Options for Large Sets of Data07:32
Linking Worksheets (3D Formulas)04:08
Consolidating Data from Multiple Worksheets05:30
+1 more lectures
Excel 102 Additional Practice Exercises
1 lectures • 00:09
Excel 102 Additional Practice Exercises
1 lectures • 00:09
Excel 102 - Practice What You've Learned (DOWNLOAD)00:09
Excel 102 Topics Recap with Alex an AI Avatar
Congratulations! You're an Intermediate Excel User
1 lectures • 01:32
Congratulations! You're an Intermediate Excel User
1 lectures • 01:32
Congratulations!01:32
Microsoft Excel 103 Course Introduction
1 lectures • 01:23
Microsoft Excel 103 Course Introduction
1 lectures • 01:23
Excel 103 Course Exercise Files -- DOWNLOAD01:23
Working with Excel's Conditional Functions
10 lectures • 50:58
Working with Excel's Conditional Functions
10 lectures • 50:58
Working with Excel Name Ranges04:22
Advantages and Disadvantages of Excel Name Ranges05:34
Editing an Excel Name Range02:33
Using Excel's IF() Function05:09
Excel's IF() Function with a Name Range05:23
+5 more lectures
Working with Excel's Lookup Functions
7 lectures • 51:47
Working with Excel's Lookup Functions
7 lectures • 51:47
Microsoft Excel VLOOKUP() Function09:36
Microsoft Excel HLOOKUP() Function05:25
Microsoft Excel INDEX() Function09:25
Microsoft Excel MATCH() Function04:40
Microsoft Excel INDEX() and MATCH() Function Combined06:41
+2 more lectures
Working with Excel's Text Based Functions
5 lectures • 28:11
Working with Excel's Text Based Functions
5 lectures • 28:11
Using Excel's LEFT(), RIGHT() and MID() Functions06:18
Using Excel's LEN() Function06:15
Using Excel's SEARCH() Function12:19
Using Excel's CONCATENATE() Function03:10
Microsoft Excel Adv. Functions and Formulas Quick Guide (DOWNLOAD)00:09
New Excel Functions for Excel 2019 and Microsoft 365 Excel Editions
13 lectures • 48:23
New Excel Functions for Excel 2019 and Microsoft 365 Excel Editions
13 lectures • 48:23
Introduction to New Excel Functions01:15
DOWNLOAD: Microsoft Excel 365 Functions Exercise File00:35
Microsoft Excel 365 FILTER() Function04:59
Microsoft Excel 365 SORT() Function05:33
Microsoft Excel 365 UNIQUE() Function04:07
+8 more lectures
Auditing an Excel Worksheet
4 lectures • 13:58
Auditing an Excel Worksheet
4 lectures • 13:58
Tracing Precedents in Excel Formulas04:01
Tracing Dependents in Excel Formulas02:52
Working with the Watch Window04:19
Showing Formulas02:46
Protecting Excel Worksheets and Workbooks
3 lectures • 15:33
Protecting Excel Worksheets and Workbooks
3 lectures • 15:33
Protecting Specific Cells in a Worksheet08:05
Protecting the Structure of a Workbook04:13
Adding a Workbook Password03:15
Mastering Excel's "What If?" Tools
4 lectures • 32:34
Mastering Excel's "What If?" Tools
4 lectures • 32:34
Working with Excel's Goal Seek Tool07:41
Working with Excel's Solver Tool10:45
Building Effective Data Tables in Excel06:17
Creating Scenarios in Excel07:51
Automating Repetitive Tasks in Excel with Macros
5 lectures • 21:38
Automating Repetitive Tasks in Excel with Macros
5 lectures • 21:38
Understanding Excel Macros03:50
Activating the Developer Tab in Excel01:42
Creating a Macro with the Macro Recorder07:39
Editing a Macro with VBA05:16
Creating Buttons to Run Macros03:11
Excel 103 Additional Practice Exercises
1 lectures • 00:09
Excel 103 Additional Practice Exercises
1 lectures • 00:09
Excel 103 - Practice What You've Learned (DOWNLOAD)00:09
Congratulations!
1 lectures • 01:39
Congratulations!
1 lectures • 01:39
Congratulations on Completing the Microsoft Excel 10301:39
Microsoft Excel Macros and VBA Course Introduction
2 lectures • 11:05
Microsoft Excel Macros and VBA Course Introduction
2 lectures • 11:05
Welcome to the Course05:50
Understanding the Why and How Behind Excel Macros05:15
Project #1: Using Excel's Macro Recorder Tool
11 lectures • 52:36
Project #1: Using Excel's Macro Recorder Tool
11 lectures • 52:36
Introduction to Project #1: Inserting and Formatting Text03:36
Project #1: Section Exercise Files (DOWNLOAD)00:16
Activating the Excel Developer Tab02:20
Project #1: Start Recording!11:16
Running a Microsoft Excel Macro04:15
+6 more lectures
Excel VBA Concepts
13 lectures • 01:16:07
Excel VBA Concepts
13 lectures • 01:16:07
Intro to Excel VBA Concepts07:02
Intro to Excel VBA Object Oriented Programming Concepts04:58
Intro to Excel VBA Exercise Files (DOWNLOAD)00:17
The Visual Basic Editor (VBE)05:07
Introduction to the Excel VBA Immediate Window12:34
+8 more lectures
Working with Excel VBA Logic Statements
9 lectures • 52:29
Working with Excel VBA Logic Statements
9 lectures • 52:29
Working with Excel VBA Logic Exercise Files (DOWNLOAD)00:16
Building Logic with an Excel VBA IF Statement08:46
Including an Else Statement in the VBA IF Statement01:43
Expanding the IF Logic with Multiple ElseIf Statements03:12
Working with Excel VBA Select Case Statements05:15
+4 more lectures
Project #2: Moving Beyond the Basics and into VBA
10 lectures • 56:40
Project #2: Moving Beyond the Basics and into VBA
10 lectures • 56:40
Introduction to Project #2: Interacting with the User01:56
Beyond the Basics Sort Project Exercise Files (DOWNLOAD)00:16
Project #2: Introduction to the Excel VBA Range.Sort Method04:47
Creating the Excel VBA Sort Procedures for this Project09:29
Project #2: Prompting the User for Information09:44
+5 more lectures
Project #3: Preparing and Cleaning Up Data with Excel VBA
9 lectures • 38:39
Project #3: Preparing and Cleaning Up Data with Excel VBA
9 lectures • 38:39
Introduction to Project #3: Cleaning Up and Formatting Data02:31
Project #3: Exercise Files (DOWNLOAD)00:15
Project #3: Preparing to the Use the Macro Recorder03:16
Project #3: Inserting the Headers04:57
Project #3: Formatting the Headers04:23
+4 more lectures
Project #4: Using VBA to Automate Excel Formulas
7 lectures • 28:55
Project #4: Using VBA to Automate Excel Formulas
7 lectures • 28:55
Introduction to Project #4: Automate Excel Formulas01:50
Project #4: Automate Sum Function Exercise Files (DOWNLOAD)00:15
Project #4: Start the Procedure to Automate the SUM Function06:49
Working with the Range Address Property05:25
Creating the SUM Function in VBA06:15
+2 more lectures
Project #5: Bringing it All Together and a Weekly Report
8 lectures • 31:16
Project #5: Bringing it All Together and a Weekly Report
8 lectures • 31:16
Introduction to Project #5: Creating the Final Report02:09
Project #5: Final Report Loop Exercise Files (DOWNLOAD)00:15
Project #5: Creating the Final Report Excel VBA Loop05:02
Project #5 - Copying Content with Excel VBA05:45
Project #5 - Pasting Content with Excel VBA04:53
+3 more lectures
Project #6: Working with Excel VBA User Forms
15 lectures • 01:05:16
Project #6: Working with Excel VBA User Forms
15 lectures • 01:05:16
Introduction to Project #6: Working with Excel VBA User Forms03:01
Project #6: Working with Excel VBA User Forms Exercise Files (DOWNLOAD)00:15
Project #6: Creating an Excel User Form05:29
Project #6: Working with Form and Control Properties06:36
Project #6: Formatting Excel VBA User Form Controls03:21
+10 more lectures
Project #7: Importing Data from Text Files
9 lectures • 49:09
Project #7: Importing Data from Text Files
9 lectures • 49:09
Project #7: Opening a Text File for Import02:42
Project #7: Opening a Text File for Import06:45
Project #7: Get Data from Text File05:30
Project #7: Importing Multiple Text Files with the GetOpenFilename Method09:32
Project #7: Creating a Loop to Read Each File07:26
+4 more lectures
Course Wrap Up
1 lectures • 01:02
Course Wrap Up
1 lectures • 01:02
Congratulations! You're an Excel Macro/VBA Master01:02
Description
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 2024, 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!
Who this course is for:
- This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
- If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
This course includes:
- 22 hours on-demand video
- 15 articles
- 55 downloadable resources
- Access on mobile and TV
- ∞Full lifetime access
- Certificate of completion
Instructors
Kyle Pew • 2,000,000+ Students
Office Newb
Students also download
Explore related courses to expand your learning journey.
All Levels
22 hours
The Complete Python Bootcamp From Zero to Hero in Python
Learn Python like a Professional Start from the basics and go all the way to creating your own applications and games
Jose Portilla
What you'll learn:
- ✓You will learn how to leverage the power of Python to solve tasks.
- ✓You will build games and programs that use Python libraries.
- ✓You will be able to use Python for your own work problems or personal projects.
- +9 more skills
22 hours
156 lectures
Access on mobile and TV
Certificate
DevelopmentPython
All Levels
52 hours
100 Days of Code: The Complete Python Pro Bootcamp
Master Python by building 100 projects in 100 days. Learn data science, automation, build websites, games and apps!
Dr. Angela Yu, Developer and Lead Instructor
What you'll learn:
- ✓You will master the Python programming language by building 100 unique projects over 100 days.
- ✓You will learn automation, game, app and web development, data science and machine learning all using Python.
- ✓You will be able to program in Python professionally
- +6 more skills
56.5 hours
592 lectures
Access on mobile and TV
Certificate
DevelopmentPython