Your Cart

Your cart is empty. Continue Shopping!

Processing order...

The 2026 Microsoft Office Pro Bundle

8 Courses & 30 Hours

Deal Price$24.99

Suggested Price

$160.00

You save 84%

What's Included

$20.00 Value

Microsoft Excel: Beginner, Intermediate & Advanced

Apex Learning

168 Lessons (14.5h)

Lifetime

Experience level required: All levels
Access 168 lectures & 14.5 hours of content 24/7
Length of time users can access this course: Lifetime

Course Curriculum

168 Lessons (14.5h)

Your First Program
Preview
Section 01: Excel from A-Z Course Introduction

Excel from A-Z Course Intro3:20
Excel Job Opportunities2:43
Excel Job Types3:51
Microsoft Excel Marketplace4:08
What is Microsoft Excel?4:16
What is Microsoft Excel?3:30
Section 02: Getting Started With Excel

Finding & Opening Excel1:04
Excel’s Start Screen3:15
Explaining the Excel Interface2:43
Excel Interface Continued1:26
Excel Workbook vs. Excel Worksheet2:12
Saving an Excel Document3:33
Customizing the Quick Access Toolbar2:15
Customizing the Excel Ribbon3:04
Excel Shortcut Keys1:43
Section 03: Values, Referencing and Formulas

Creating Excel Labels2:32
Entering Numeric Values in Excel3:25
Formatting Date Values in Excel5:19
Building Basic Formulas in Excel4:44
Order of Operations6:28
Relative vs. Absolute Cell References7:23
Section 04: Intro to Excel Functions

Excel Functions Explained2:35
The SUM() Function7:31
The MIN() & MAX() Function3:44
The AVERAGE() Function2:00
COUNT() Functions4:57
Section 05: Adjusting Excel Worksheets

Moving & Copying Data6:45
Insert & Delete Rows and Columns5:04
Adjusting the Width and Height of Cells4:34
Hiding and Unhiding Excel Rows and Columns4:28
Renaming, Moving & Deleting Excel Worksheets5:27
Adding Protection to Specific Cells4:23
Protecting the Structure of a Workbook2:11
Adding a Workbook Password to Open File2:09
Section 06: Visually Pleasing Cell Formatting

Formatting Fonts and Cell Background Color4:54
Adding Cell Borders4:47
Formatting Data Appropriately5:21
The Magic behind Excel’s Format Painter3:29
Creating Styles for Formatting Efficiency5:55
Merging Cells for a Cleaner Look3:27
The Power of Conditional Formatting6:09
Section 07: How to Insert Images and Shapes!

Grab User’s Attention using Illustrations8:39
Customizing Icons4:41
Create Compelling Graphics with SmartArt5:36
Section 08: Visualize Data with Charts

The Commonly Used Column Chart2:45
Changing the Chart Design1:58
Section 09: Excel’s Printing Options

Print Preview Options4:25
Excel’s Page Layout View6:36
Printing a Specific Range of Cells2:38
Converting Spreadsheets to PDF Files2:28
Section 10: Benefits of Using Excel Templates

Why Create an Excel Template1:22
How to Create an Excel Template5:22
Section 11: Working with Excel Datasets

How to Prepare Data for Analysis4:01
How to Sort Data in Excel2:37
Multi-Level Sorting2:33
Custom Sorting Datasets in Excel2:26
Applying Filters to Datasets4:44
Creating Subtotals within a Dataset5:38
Converting Datasets into Tables5:55
Little Slice of Pie Charts5:11
Finding & Removing Duplicate Values7:29
Section 12: Excel Database Functions

The SUMIF() Function8:41
The DSUM() Function7:47
The DSUM() Function Cont.7:06
The SUBTOTAL() Function6:28
Section 13: Excel Data Validation

What is Excel Data Validation?1:56
Creating a Drop Down List with Data Validation7:08
Different Types of Excel Data Validation5:39
Adding Custom Alerts to Data Validation6:53
Creating a Dynamic Drop Down List3:09
Complex Validation: Dependent Drop Down List!8:38
Section 14: Excel PivotTables

Creating an Excel Pivot Table5:30
Modifying Excel PivotTables5:38
Grouping & Filtering PivotTable Data6:29
Drilling Down into PivotTable Data1:59
Creating Pivot Charts & Utilizing Slicers7:59
Section 15: Excel’s PowerPivot Add-In

What is PowerPivot?3:45
Activating the Excel PowerPivot Add-In1:33
Creating Relationships between Data Tables6:22
Using Data Models to Create PivotTables4:30
How to Create PowerPivot KPI’s8:26
Section 16: Excel’s Conditional Functions

Excels IF Function5:17
IF() Function with AND() Criteria5:23
IF() Function with OR() Criteria5:13
Nesting Multiple IF() Functions7:23
The COUNTIF() Function4:06
Key Benefits of Named Ranges4:10
Section 17: Excel’s Lookup Function

VLOOKUP() Function8:59
The Beauty of Excel’s IFERROR() Function3:55
HLOOKUP() Function6:21
The INDEX Function4:42
MATCH() Function4:55
INDEX() and MATCH() Combined5:08
Two-Way Lookup with INDEX() and MATCH()4:10
Section 18: Text Based Functions in Excel

LEFT(), RIGHT() and MID() Function7:08
Extracting Specific Text using LEN() & SEARCH()12:44
Combining Text with CONCATENATE()6:05
Quick Tips & Other Text Based Functions5:48
Section 19: Auditing Formulas and Views in Excel

Tracing Precedents & Dependents in Formulas4:28
Showing Formulas1:53
Grouping Data2:42
3D Referencing in Formulas5:04
Utilizing the Watch Window in Excel2:44
How to Freeze Panes in Excel2:55
Section 20: Excel’s “what If?” Tools

Excel’s Scenario Manager Tool5:55
Goal Seek in Excel6:15
Compare Results with Excel Data Tables4:23
Solver Tool10:59
Section 21: Welcome to Excel VBA

The Power Behind Excel VBA2:35
A Look Inside the Visual Basic Editor (VBE)3:56
Recording a Macro9:11
Saving & Opening a Macro-Enabled Workbook2:13
Section 22: The VBA Language

Modules and Procedures6:33
Using Variables in VBA Code4:32
Excel VBA Variables4:38
Section 23: Writing VBA Code

Referencing a Range13:30
InputBox & MsgBox5:32
If Then Else Statement10:22
Worksheet Functions inside VBA7:32
Creating User Defined Functions9:19
User Defined Functions within VBA Scripts6:08
Section 24: Important VBA Tools and Logic

Find Last Row of Data5:45
Find Last Column of Data3:12
With Statement4:51
Debugging & Error Handling6:36
Debugging & Error Handling Cont.6:45
Section 25: Excel VBA Loop

For Next Loop9:12
Do Until Loop6:03
For Each Loop3:36
Section 26: Triggering Macros

Assigning Macros to Shapes3:33
Form Controls vs ActiveX Controls7:50
Worksheet Events3:43
Workbook Events2:54
Fun with VBA Events!6:54
Section 27: Excel User Forms

Creating an Excel UserForm3:15
Adding Controls to UserForms10:00
How to Show an UserForm3:01
Passing TextBox Values to Desired Cells6:50
Passing Option Buttons to Desired Cells6:36
UserForm ComboBoxes8:08
Clearing Values from UserForm Controls3:06
How to Close an UserForm1:33
UserForms and Protected Sheets4:40
Section 28: Starting a Career in Excel

Getting Started with Freelancing6:15
Creating an Excel Resume4:51
How to Become an Excel Freelancer5:12
Top Freelance Websites5:12
How to Get Your First Client7:45
Personal Branding6:47
Formatting Elements of a Chart6:23
Networking Do’s and Don’ts4:21
Importance of Having a Website4:24
Modifying the Data, Type & Location of a Chart6:06

Microsoft Excel: Beginner, Intermediate & Advanced

Apex Learning

4.5/5 Instructor Rating: ★ ★ ★ ★ ★★

Apex Learning aims to be an online education that provides the necessary support to the learners and facilitates educators' work and contributes to professional development. They offer innovative pedagogical resources and training in a planned, updated, and oriented way.

Description

Master Pivot Tables, Formulas, Macros, VBA, Data Analysis, and More

Unlock the full potential of Microsoft Excel with this comprehensive course designed to take you from the basics to expert-level skills. Whether you're new to spreadsheets or looking to refine your expertise, this course covers everything from navigating the Excel interface, entering and formatting data, and building formulas to advanced topics like PivotTables, PowerPivot, VBA, and automation. Learn essential functions, data validation techniques, and visualization tools to create compelling charts and reports. Gain hands-on experience with real-world applications, explore career opportunities, and even dive into Excel freelancing. With step-by-step guidance, practical exercises, and expert tips, this course is your ultimate guide to mastering Excel for personal and professional success.

4.7/5 average rating: ★ ★ ★ ★ ★ ★

What you'll learn

Access to 168 lectures & 14.5 hours of content 24/7
Learn essential Excel skills, from basic to advanced functions
Master formulas, functions & data analysis techniques
Explore PivotTables, charts & data visualization tools
Automate tasks with macros & VBA programming
Improve efficiency with data validation & conditional formatting
Gain hands-on experience with real-world Excel applications
Enhance productivity for business, finance & freelancing opportunities

Who is this course for

Students who want to learn & master Microsoft Excel
Professionals who require Microsoft Excel for work

NOTE: You are purchasing the course only; Microsoft Excel is NOT included.

Specs

Important Details

Length of time users can access this course: lifetime
Access options: desktop
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
Certificate of Completion ONLY
Updates included
Closed captioning NOT available
NOT downloadable for offline viewing
Have questions on how digital purchases work? Learn more here
Learn more about our Lifetime deals here!

Requirements

Basic understanding of how to use a computer
Access to Microsoft Excel (any recent version)
Basic computer skills

$20.00 Value

Microsoft Access Databases Forms & Reports

Apex Learning

15 Lessons (3h)

Lifetime

$20.00 Value

Learn Filtering Techniques in Microsoft Excel

Apex Learning

3 Lessons (1h)

Lifetime

$20.00 Value

Using Excel with ChatGPT

Apex Learning

1 Lesson (1h)

Lifetime

$20.00 Value

Excel Data Analysis

Apex Learning

9 Lessons (1h)

Lifetime

$20.00 Value

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

Apex Learning

133 Lessons (9.5h)

Lifetime

$20.00 Value

Microsoft PowerPoint

International Open Academy

5 Lessons

Lifetime

$20.00 Value

Microsoft Word

International Open Academy

8 Lessons

Lifetime

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

The 2026 Microsoft Office Pro Bundle

8 Courses & 30 Hours

Deal Price$24.99

Suggested Price

$160.00

You save 84%

What's Included

$20.00 Value

Microsoft Excel: Beginner, Intermediate & Advanced

Apex Learning

168 Lessons (14.5h)

Lifetime

Experience level required: All levels
Access 168 lectures & 14.5 hours of content 24/7
Length of time users can access this course: Lifetime

Course Curriculum

168 Lessons (14.5h)

Your First Program
Preview
Section 01: Excel from A-Z Course Introduction

Excel from A-Z Course Intro3:20
Excel Job Opportunities2:43
Excel Job Types3:51
Microsoft Excel Marketplace4:08
What is Microsoft Excel?4:16
What is Microsoft Excel?3:30
Section 02: Getting Started With Excel

Finding & Opening Excel1:04
Excel’s Start Screen3:15
Explaining the Excel Interface2:43
Excel Interface Continued1:26
Excel Workbook vs. Excel Worksheet2:12
Saving an Excel Document3:33
Customizing the Quick Access Toolbar2:15
Customizing the Excel Ribbon3:04
Excel Shortcut Keys1:43
Section 03: Values, Referencing and Formulas

Creating Excel Labels2:32
Entering Numeric Values in Excel3:25
Formatting Date Values in Excel5:19
Building Basic Formulas in Excel4:44
Order of Operations6:28
Relative vs. Absolute Cell References7:23
Section 04: Intro to Excel Functions

Excel Functions Explained2:35
The SUM() Function7:31
The MIN() & MAX() Function3:44
The AVERAGE() Function2:00
COUNT() Functions4:57
Section 05: Adjusting Excel Worksheets

Moving & Copying Data6:45
Insert & Delete Rows and Columns5:04
Adjusting the Width and Height of Cells4:34
Hiding and Unhiding Excel Rows and Columns4:28
Renaming, Moving & Deleting Excel Worksheets5:27
Adding Protection to Specific Cells4:23
Protecting the Structure of a Workbook2:11
Adding a Workbook Password to Open File2:09
Section 06: Visually Pleasing Cell Formatting

Formatting Fonts and Cell Background Color4:54
Adding Cell Borders4:47
Formatting Data Appropriately5:21
The Magic behind Excel’s Format Painter3:29
Creating Styles for Formatting Efficiency5:55
Merging Cells for a Cleaner Look3:27
The Power of Conditional Formatting6:09
Section 07: How to Insert Images and Shapes!

Grab User’s Attention using Illustrations8:39
Customizing Icons4:41
Create Compelling Graphics with SmartArt5:36
Section 08: Visualize Data with Charts

The Commonly Used Column Chart2:45
Changing the Chart Design1:58
Section 09: Excel’s Printing Options

Print Preview Options4:25
Excel’s Page Layout View6:36
Printing a Specific Range of Cells2:38
Converting Spreadsheets to PDF Files2:28
Section 10: Benefits of Using Excel Templates

Why Create an Excel Template1:22
How to Create an Excel Template5:22
Section 11: Working with Excel Datasets

How to Prepare Data for Analysis4:01
How to Sort Data in Excel2:37
Multi-Level Sorting2:33
Custom Sorting Datasets in Excel2:26
Applying Filters to Datasets4:44
Creating Subtotals within a Dataset5:38
Converting Datasets into Tables5:55
Little Slice of Pie Charts5:11
Finding & Removing Duplicate Values7:29
Section 12: Excel Database Functions

The SUMIF() Function8:41
The DSUM() Function7:47
The DSUM() Function Cont.7:06
The SUBTOTAL() Function6:28
Section 13: Excel Data Validation

What is Excel Data Validation?1:56
Creating a Drop Down List with Data Validation7:08
Different Types of Excel Data Validation5:39
Adding Custom Alerts to Data Validation6:53
Creating a Dynamic Drop Down List3:09
Complex Validation: Dependent Drop Down List!8:38
Section 14: Excel PivotTables

Creating an Excel Pivot Table5:30
Modifying Excel PivotTables5:38
Grouping & Filtering PivotTable Data6:29
Drilling Down into PivotTable Data1:59
Creating Pivot Charts & Utilizing Slicers7:59
Section 15: Excel’s PowerPivot Add-In

What is PowerPivot?3:45
Activating the Excel PowerPivot Add-In1:33
Creating Relationships between Data Tables6:22
Using Data Models to Create PivotTables4:30
How to Create PowerPivot KPI’s8:26
Section 16: Excel’s Conditional Functions

Excels IF Function5:17
IF() Function with AND() Criteria5:23
IF() Function with OR() Criteria5:13
Nesting Multiple IF() Functions7:23
The COUNTIF() Function4:06
Key Benefits of Named Ranges4:10
Section 17: Excel’s Lookup Function

VLOOKUP() Function8:59
The Beauty of Excel’s IFERROR() Function3:55
HLOOKUP() Function6:21
The INDEX Function4:42
MATCH() Function4:55
INDEX() and MATCH() Combined5:08
Two-Way Lookup with INDEX() and MATCH()4:10
Section 18: Text Based Functions in Excel

LEFT(), RIGHT() and MID() Function7:08
Extracting Specific Text using LEN() & SEARCH()12:44
Combining Text with CONCATENATE()6:05
Quick Tips & Other Text Based Functions5:48
Section 19: Auditing Formulas and Views in Excel

Tracing Precedents & Dependents in Formulas4:28
Showing Formulas1:53
Grouping Data2:42
3D Referencing in Formulas5:04
Utilizing the Watch Window in Excel2:44
How to Freeze Panes in Excel2:55
Section 20: Excel’s “what If?” Tools

Excel’s Scenario Manager Tool5:55
Goal Seek in Excel6:15
Compare Results with Excel Data Tables4:23
Solver Tool10:59
Section 21: Welcome to Excel VBA

The Power Behind Excel VBA2:35
A Look Inside the Visual Basic Editor (VBE)3:56
Recording a Macro9:11
Saving & Opening a Macro-Enabled Workbook2:13
Section 22: The VBA Language

Modules and Procedures6:33
Using Variables in VBA Code4:32
Excel VBA Variables4:38
Section 23: Writing VBA Code

Referencing a Range13:30
InputBox & MsgBox5:32
If Then Else Statement10:22
Worksheet Functions inside VBA7:32
Creating User Defined Functions9:19
User Defined Functions within VBA Scripts6:08
Section 24: Important VBA Tools and Logic

Find Last Row of Data5:45
Find Last Column of Data3:12
With Statement4:51
Debugging & Error Handling6:36
Debugging & Error Handling Cont.6:45
Section 25: Excel VBA Loop

For Next Loop9:12
Do Until Loop6:03
For Each Loop3:36
Section 26: Triggering Macros

Assigning Macros to Shapes3:33
Form Controls vs ActiveX Controls7:50
Worksheet Events3:43
Workbook Events2:54
Fun with VBA Events!6:54
Section 27: Excel User Forms

Creating an Excel UserForm3:15
Adding Controls to UserForms10:00
How to Show an UserForm3:01
Passing TextBox Values to Desired Cells6:50
Passing Option Buttons to Desired Cells6:36
UserForm ComboBoxes8:08
Clearing Values from UserForm Controls3:06
How to Close an UserForm1:33
UserForms and Protected Sheets4:40
Section 28: Starting a Career in Excel

Getting Started with Freelancing6:15
Creating an Excel Resume4:51
How to Become an Excel Freelancer5:12
Top Freelance Websites5:12
How to Get Your First Client7:45
Personal Branding6:47
Formatting Elements of a Chart6:23
Networking Do’s and Don’ts4:21
Importance of Having a Website4:24
Modifying the Data, Type & Location of a Chart6:06

Microsoft Excel: Beginner, Intermediate & Advanced

Apex Learning

4.5/5 Instructor Rating: ★ ★ ★ ★ ★★

Description

Master Pivot Tables, Formulas, Macros, VBA, Data Analysis, and More

4.7/5 average rating: ★ ★ ★ ★ ★ ★

What you'll learn

Access to 168 lectures & 14.5 hours of content 24/7
Learn essential Excel skills, from basic to advanced functions
Master formulas, functions & data analysis techniques
Explore PivotTables, charts & data visualization tools
Automate tasks with macros & VBA programming
Improve efficiency with data validation & conditional formatting
Gain hands-on experience with real-world Excel applications
Enhance productivity for business, finance & freelancing opportunities

Who is this course for

Students who want to learn & master Microsoft Excel
Professionals who require Microsoft Excel for work

NOTE: You are purchasing the course only; Microsoft Excel is NOT included.

Specs

Important Details

Length of time users can access this course: lifetime
Access options: desktop
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
Certificate of Completion ONLY
Updates included
Closed captioning NOT available
NOT downloadable for offline viewing
Have questions on how digital purchases work? Learn more here
Learn more about our Lifetime deals here!

Requirements

Basic understanding of how to use a computer
Access to Microsoft Excel (any recent version)
Basic computer skills

$20.00 Value

Microsoft Access Databases Forms & Reports

Apex Learning

15 Lessons (3h)

Lifetime

$20.00 Value

Learn Filtering Techniques in Microsoft Excel

Apex Learning

3 Lessons (1h)

Lifetime

$20.00 Value

Using Excel with ChatGPT

Apex Learning

1 Lesson (1h)

Lifetime

$20.00 Value

Excel Data Analysis

Apex Learning

9 Lessons (1h)

Lifetime

$20.00 Value

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

Apex Learning

133 Lessons (9.5h)

Lifetime

$20.00 Value

Microsoft PowerPoint

International Open Academy

5 Lessons

Lifetime

$20.00 Value

Microsoft Word

International Open Academy

8 Lessons

Lifetime

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

The 2026 Microsoft Office Pro Bundle | BitsDuJour Exclusives