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

  • 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
  • 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
  • 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
  • Excel Functions Explained2:35
    The SUM() Function7:31
    The MIN() & MAX() Function3:44
    The AVERAGE() Function2:00
    COUNT() Functions4:57
  • 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
  • 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
  • Grab User’s Attention using Illustrations8:39
    Customizing Icons4:41
    Create Compelling Graphics with SmartArt5:36
  • The Commonly Used Column Chart2:45
    Changing the Chart Design1:58
  • Print Preview Options4:25
    Excel’s Page Layout View6:36
    Printing a Specific Range of Cells2:38
    Converting Spreadsheets to PDF Files2:28
  • Why Create an Excel Template1:22
    How to Create an Excel Template5:22
  • 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
  • The SUMIF() Function8:41
    The DSUM() Function7:47
    The DSUM() Function Cont.7:06
    The SUBTOTAL() Function6:28
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Excel’s Scenario Manager Tool5:55
    Goal Seek in Excel6:15
    Compare Results with Excel Data Tables4:23
    Solver Tool10:59
  • 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
  • Modules and Procedures6:33
    Using Variables in VBA Code4:32
    Excel VBA Variables4:38
  • 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
  • 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
  • For Next Loop9:12
    Do Until Loop6:03
    For Each Loop3:36
  • Assigning Macros to Shapes3:33
    Form Controls vs ActiveX Controls7:50
    Worksheet Events3:43
    Workbook Events2:54
    Fun with VBA Events!6:54
  • 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
  • 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 about digital products
  • Learn more about what lifetime access means!

 

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.
Processing order...