The Complete Excel Excellence Bundle for $39

Buy now

Expires October 18, 2120 06:59 PST
Buy now and get 93% off

Excel for Business Analysts

KEY FEATURES

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 so you can immediately put into practice the new data analysis techniques that you learn.

5.0/5 average rating:
★ ★ ★ ★ ★

  • Access 49 lectures & 5 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
  • Learn all about Histograms & Regression
  • Use Goal Seek, Scenario Manager, & Solver to fill data gaps

Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

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

THE EXPERT

StreamSkill.com

4.4/5 Instructior Rating:
★ ★ ★ ★


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

Power Pivot, Power Query & DAX in Excel

KEY FEATURES

This advanced Excel course will look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions 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 so you can build your data models as you learn.

4.2/5 average rating:
★ ★ ★ ★

  • Access 47 lectures & 4 hours of content 24/7
  • Get started w/ 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.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

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

THE EXPERT

StreamSkill.com

4.4/5 Instructior Rating:
★ ★ ★ ★


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

Advanced PivotTables in Excel

KEY FEATURES

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 onto 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 48 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.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: advanced

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Intermediate knowledge of Microsoft Excel

THE EXPERT

StreamSkill.com

4.4/5 Instructior Rating:
★ ★ ★ ★


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

Excel Beginner 2019

KEY FEATURES

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.

4.4/5 average rating:
★ ★ ★ ★

  • Access 95 lectures & 7.5 hours of content 24/7
  • Know what’s new in Excel 2019
  • Enter texts, numbers & work w/ dates
    Navigate workbooks
  • Work with rows, columns & cells
  • Learn about Functions & Formulas
  • Use PivotTables, charts & graphs

Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel 2016, 2019, 365

THE EXPERT

StreamSkill.com

4.4/5 Instructior Rating:
★ ★ ★ ★


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

Excel Advanced 2019

KEY FEATURES

Get beyond the basics and supercharge your current skill level in Excel. With this 8-hour, 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.4/5 average rating:
★ ★ ★ ★

  • Access 57 lectures & 8 hours of content 24/7
  • Learn advanced charting & graphing in Excel 2019
  • Use detailed formatting tools
  • Use lookup & advanced lookup functions
  • Know financial functions including calculating interest & depreciation
  • Connect to other workbooks & datasets outside of Excel

Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: advanced

Requirements

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

THE EXPERT

StreamSkill.com

4.4/5 Instructior Rating:
★ ★ ★ ★


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

Excel Beginner 2019 for Mac

KEY FEATURES

Ever tried learning Excel on a Mac with a course designed for a PC? It looks completely different. In this comprehensive course, you will go from knowing nothing to a confident Excel Mac user. If you’ve used Excel before but never on a Mac, or if you’re totally new to Excel and you’re using the Mac then this course is for you. This course was built using Excel for Mac 2019, but much of what is taught is still relevant if you’re using a different version.

4.7/5 average rating:
★ ★ ★ ★

  • Access 57 lectures & 5 hours of content 24/7
  • Discover Excel for Mac is different from Excel for PC
  • Discover how to format dates & numbers
  • Effectively use autofill & flashfill so you are more productive
  • Complete data entry, cell formatting, & working with multiple worksheets
  • Learn practical methods to sort & filter your data

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel 2016, 2019, 365

THE EXPERT

StreamSkill.com

4.4/5 Instructior Rating:
★ ★ ★ ★


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

VBA Beginners

KEY FEATURES

This 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. Here, you’ll learn the essentials you need to know to create powerful macros using VBA for Excel.

  • 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
  • Understand 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.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

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

THE EXPERT

StreamSkill.com

4.4/5 Instructior Rating:
★ ★ ★ ★


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

VBA Intermediate

KEY FEATURES

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.

  • Access 37 lectures & 4.5 hours of content 24/7
  • Learn advanced methods for automating tedious Excel jobs
  • Discover vital Event Patterns
  • Discuss Custom Object possibilities
  • Interface with Excel successfully
  • Work with references & libraries

Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

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

THE EXPERT

StreamSkill.com

4.4/5 Instructior Rating:
★ ★ ★ ★


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