The 2026 Microsoft Office Pro Bundle

8 Courses & 30 Hours
Deal Price$24.99
Suggested Price
$160.00
You save 84%
The 2026 Microsoft Office Pro Bundle
$24.99$160.0084% OFF

What's Included

  • 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

  • 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

AL
Apex Learning

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

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...