Get $1 credit for every $25 spent!

The 2022 Complete Microsoft Excel Expert Bundle

Ending In:
Add to Cart - $34.99
Add to Cart ($34.99)
$4,788
99% off
wishlist
Courses
12
Lessons
637
Enrolled
1,074

What's Included

Product Details

Access
Lifetime
Content
11.0 hours
Lessons
100

Microsoft Excel 2021/365: Beginners Course

Sharpen Your Skills & Upgrade from an Older Version of Excel

By StreamSkill | in Online Courses

Excel 2021 is the latest stand-alone release from Microsoft and includes many of the features and functionalities currently available only in the subscription-based Excel 365. If you have no Excel experience whatsoever, then this course is the perfect starting point for you. Perhaps you have some basic Excel knowledge, and you want to upgrade from an older version of Excel or sharpen your skills. Well, this training will get you up to speed. The course is 11 hours, with 100 individual video lessons and exercises. It includes downloadable course files and exercise files, so you can follow along with the instructor and then practice what you have learned at the end of each section.

4.43/5 average rating: ★ ★ ★ ★

  • Access 100 lectures & 11 hours of content 24/7
  • Know what's new in Excel 2021
  • Navigate the Excel 2021 interface
  • Learn useful keyboard shortcuts to increase pro
  • Effectively apply formatting to cells & use conditional formatting
  • Work efficiently by using the cut, copy, & amp;paste options
  • Analyze data using charts
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
2.5 hours
Lessons
12

Advanced Formulas in Excel

Perform Complex Tasks & Analysis with Advanced Excel Formulas, Functions, and Tools

By StreamSkill | in Online Courses

If you want to master Excel, you need to know how formulas work together to accomplish complex tasks. In this Advanced Formulas in Excel course, you'll focus on a set of Excel formulas, functions, and tools that enable you to perform complex tasks and analyses. The course will look at how to filter a dataset and sort using formulas. After that, you'll learn how to create multi-dependent drop-down lists, 2-way lookups, text extraction, dynamic chart titles, and so much more! We end by looking at how to use XLOOKUP.

4.4/5 average rating: ★ ★ ★ ★

  • Access 12 lectures & 2.5 hours of content 24/7
  • Filter a dataset using a formula
  • Sort a dataset using formulas & defined variables
  • Create multi-dependent dynamic drop-down lists
  • Perform a 2-way lookup
  • Make decisions with complex logical calculations
  • Extract parts of a text string
  • Create a dynamic chart title
  • Find the last occurrence of a value in a list
  • Look up information with XLOOKUP
  • Find the closest match to a value
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
4.5 hours
Lessons
37

Intermediate VBA

Become the Office VBA for Excel Expert & a Master of Productivity

By StreamSkill | in Online Courses

This professionally produced video course shows anyone with some VBA experience how to supercharge Excel. You will learn more advanced procedures for automating tough and time-consuming Excel jobs with advanced micros. This course gives you a lot more power to fully customize VBA to do some pretty miraculous things. This is the training you need to improve your abilities with VBA. Make yourself more valuable at work or use these concepts for your own business or personal needs.

  • Access 37 lectures & 4.5 hours of content 24/7
  • Understand more advanced VBA language
  • Learn advanced tools for doing just about anything you need with VBA
  • Know how to use References & Libraries
  • Practice what you've learned with included exercises & quiz
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
4.0 hours
Lessons
32

VBA for Beginners

Use VBA Macros in Excel to Automate Tasks & Operations Performed Frequently

By StreamSkill | in Online Courses

The course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently. Through 4 hours of video lectures, exercise files, and an optional quiz, you'll learn the essentials you need to know to create powerful macros using VBA for Excel. When you complete this course, you'll be well on your way to using VBA macros in Excel to help you and others automate tasks and operations performed frequently.

4.36/5 average rating: ★ ★ ★ ★

  • Access 32 lectures & 4 hours of content 24/7
  • Find out how to use the VBA editor, VBA syntax, keywords, & comments
  • Discover how to define & manage variables, set up subroutines, and create functions
  • Also, find out how to use input boxes & message boxes to interact with end users
  • Learn practical methods for using macro errors to improve your VBA code
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
7.5 hours
Lessons
49

Advanced PivotTables in Excel

Master PivotTables & Easily Perform Data Analysis Tasks

By StreamSkill | in Online Courses

In this Advanced PivotTables in Excel course, you'll learn how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. You'll get a PivotTable refresher and move on to some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function.

4.7/5 average rating: ★ ★ ★ ★

  • Access 49 lectures & 7.5 hours of content 24/7
  • Do a PivotTable (a quick refresher)
  • Combine data from multiple worksheets for a PivotTable
  • Group, ungroup & deal with errors
  • Format a PivotTable, including adjusting styles
  • Use the Value Field Settings
  • Learn Advanced Sorting & Filtering in PivotTables
  • Use Slicers, Timelines on multiple tables
  • Create a Calculated Field
  • Learn all about GETPIVOTDATA
  • Create a Pivot Chart & add sparklines and slicers
  • Use 3D Maps from a PivotTable
  • Update your data in a PivotTable & Pivot Chart
  • Learn all about Conditional Formatting in a PivotTable
  • Create a basic macro to refresh PivotTable data
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
3.5 hours
Lessons
44

Power Pivot, Power Query & DAX in Excel

Analyze Data at Scale with These Advanced Excel Functions

By StreamSkill | in Online Courses

This advanced Excel course will look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This Excel function suite allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. You'll first learn how to bring your data together, merge, and clean it using Power Query. You'll then perform calculations on your data model using DAX, and finally, look at displaying your analysis using PivotTables and PivotCharts. This course also includes practice exercises and follow-along files to build your data models as you learn.

4.2/5 average rating: ★ ★ ★ ★

  • Access 44 lectures & 3.5 hours of content 24/7
  • Get started with Power Query
  • Connect Excel to multiple workbooks
  • Merge & append queries using Power Query
  • Set up & manage relationships in a data model
  • Create a PivotTable to display your data
  • Use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
7.0 hours
Lessons
55

Excel for Business Analysts

All the Functions & Formulas You Need to Perform Detailed Data Analysis

By StreamSkill | in Online Courses

Microsoft Excel remains one of the best tools for Data Analysis. In this course, you'll learn the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. You'll take a look at raw data, tools, functions, and advanced techniques. This course also includes practice exercises to immediately put into practice the new data analysis techniques that you learn.

4.6/5 average rating: ★ ★ ★ ★

  • Access 55 lectures & 7 hours of content 24/7
  • Merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, & XLOOKUP
  • Use IF, IFS, IFERROR, SUMIF, & COUNTIF to apply logic to your analysis
  • Split data using text functions SEARCH, LEFT, RIGHT, MID
  • Standardize & clean data ready for analysis
  • Use the PivotTable function to perform data analysis
  • Use slicers to draw out information
  • Display your analysis using Pivot Charts
  • Learn about forecasting & using the Forecast Sheets
  • Conduct a Linear Forecast & Forecast Smoothing
  • Use Conditional Formatting to highlight areas of your data
  • Use Goal Seek, Scenario Manager, & Solver to fill data gaps
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
8.0 hours
Lessons
57

Microsoft Excel 2019: Advanced Course

Delve Into High-Level Consolidation, Analysis & Financial Reporting

By StreamSkill | in Online Courses

Get beyond the basics and supercharge your current skill level in Excel. With this expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.

4.29/5 average rating: ★ ★ ★ ★

  • Access 57 lectures & 8 hours of content 24/7
  • Learn what’s new/different in Excel 2019
  • Understand advanced charting & graphing in Excel
  • Discover how to use detailed formatting tools
  • Discuss financial functions including calculating interest & depreciation
  • Connect to other workbooks & datasets outside of Excel
  • Create awesome visualizations using sparklines & data bars
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: advanced
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
5.0 hours
Lessons
57

Microsoft Excel 2019 for Mac: Beginners

Go from Zero to Excel for Mac Hero with This Training

By StreamSkill | in Online Courses

Ever tried learning Excel on a Mac with a course designed for a PC? Well, it looks completely different. Luckily Stream Skill's got you covered. If you’ve used Excel before but never on a Mac, then this comprehensive Beginners Excel for Mac course is for you. If you’re brand new to Excel and you’re using the Mac version, then this course is definitely for you. This course was recorded using Excel for Mac 2019 but much of what is taught is still relevant if you’re using a different version.

4.68/5 average rating: ★ ★ ★ ★

  • Access 57 lectures & 5 hours of content 24/7
  • Create, open & save new workbooks in Excel Mac
  • Understand the basics of how Excel for Mac works including relative references & order of operations
  • Set up workbooks & print the right thing in Excel
  • Move data around in Excel for Mac
  • Know basic formulas & functions work
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Office 2019 & 2016

Access
Lifetime
Content
9.5 hours
Lessons
84

Microsoft Excel 2021/365: Intermediate Course

Experience All the New Functions & Features Available in Excel 2021

By StreamSkill | in Online Courses

This course will build on the skills learned in the beginners' course and expand their essential Excel toolkit. Students will learn how to create intermediate-level formulas, clean and analyze data using PivotTables and Pivot Charts, control data input with validation rules, make decisions with WhatIf analysis tools as well as learn the golden rules of spreadsheet design. That’s just scratching the surface! Students will also get to experience all the new functions and features available in Excel 2021, the latest standalone version of Excel from Microsoft.

Excel 2021 Intermediate is designed for students who have a beginner-level knowledge of Excel and are looking to build on those skills. It’s also perfect for students who have beginner to intermediate level skills in an older version of Excel and are looking to update their skills.

  • Access 84 lectures & 9.5 hours of content 24/7
  • Design better spreadsheets & control user input
  • Use logical functions to make better business decisions
  • Construct functional & flexible lookup formulas
  • Use Excel tables to structure data & make it easy to update
  • Extract unique values from a list
  • Explore the exciting world of dynamic array functions & learn how to use XLOOKUP, XMATCH, FILTER and so much more
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: intermediate
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
7.5 hours
Lessons
95

Microsoft Excel 2019: Beginners Course

Learn the Essentials of Microsoft Excel 2019/365 & Work with More Confidence Using Spreadsheets

By StreamSkill | in Online Courses

This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.

  • Access 95 lectures & 7.5 hours of content 24/7
  • Know what's new in Excel 2019
  • Enter text, numbers & working w/ dates
  • Create & navigate workbooks
  • Understand basic functions & formulas
  • Know basic formatting in Excel
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel

Access
Lifetime
Content
2.0 hours
Lessons
15

Macros & VBA for Beginners

Automate Excel Using Macros & VBA

By StreamSkill | in Online Courses

This course teaches you how to create your first Macros and edit them using the Excel programming language, VBA (Visual Basic for Applications). It starts by giving an overview of Marcos. After that, you'll move on to some VBA basics and how to edit and debug Macros. Finally, you'll look at creating a Macro from scratch using VBA and how to create a custom Macro ribbon. This course includes follow-along instructor files so you can immediately practice what you learn. This is an advanced level Excel course, an intermediate knowledge of Excel is required to get the most from this course.

4.4/5 average rating: ★ ★ ★ ★

  • Access 15 lectures & 2 hours of content 24/7
  • See examples of Excel Macros
  • Know what is VBA
  • Record your first macro
  • Record a macro using relative references
  • Record a complex, multi-step macro, & assign it to a button
  • Set up the VBA Editor
  • Learn all about VBA Code
  • Edit Macros in the VBA Editor
  • Fix issues with macros using debugging tools
  • Write your own macro from scratch
  • Create a custom Macro ribbon & add all the Macros you've created
Note: Software NOT included.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 14+ years and taught over 1 million students at the time. They've created over 90 software training courses, and 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Basic understanding of how to use Microsoft Excel


Terms

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