KEY FEATURES

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.

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

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

Google Sheets is an amazing tool that allows you to create and collaborate with data in a spreadsheet while still having access to the same tools that are available locally in your Google Drive. This course is designed specifically for beginners and will teach you how to create basic spreadsheets, including formulas and conditional formatting, as well as to insert images, draw sectors, create labels, create notes, and export your data for further remixing. Plus many other spreadsheet goodies!

• Access 38 lectures & 4 hours of content 24/7
• Learn multiple ways to access Google Sheets
• Get familiar with the Google Sheets interface
• Work with cells, rows & columns, including group and merge functions
• Learn keyboard shortcuts (for both PC and Mac)
• Apply themes, formatting & conditional formatting
• Insert links, images, checkboxes, notes, and comments
• Use Google Drawings to insert drawings & videos
• Add data validations & dropdowns in cells
• Sorti & filter data
• Use basic formulas & functions

PRODUCT SPECS

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

• Any device with basic specifications

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

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.

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

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

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 & 10 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.

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

Excel is a high-level object-oriented programming language for Microsoft Office. This course will teach you advanced concepts in Excel and Power BI, including array formulas, index arrays and sets, dynamic arrays, table functions, and data types. You will learn how to create advanced lookup functions to produce accurate results when working with financial data. Furthermore, you'll see how to analyze data with PivotTable & PivotChart hacks, use advanced Power Query techniques to import or clean your data, and finally introduce statistical functions for further analysis of the data.

• Access 87 lectures & 10 hours of content 24/7
• Use the NEW Dynamic Array functions to perform tasks
• Create advanced & flexible lookup formulas
• Use statistical functions to rank data & calculate the MEDIAN and MODE
• Produce accurate results when working with financial data using math functions
• Create variables & functions with LET and LAMBDA
• Analyze data with advanced PivotTable & PivotChart hacks
• Add interaction to reports & dashboards by incorporating form controls
• Import & clean data using Power Query
• Predict future values using forecast functions & forecast sheets
• Record & run macros to automate repetitive tasks
• Understand & make minor edits to VBA code
• Combine functions together to create practical formulas to complete specific tasks

Note: Software NOT included.

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

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.

• Access 12 lectures & 3 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.

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

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.

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

PRODUCT SPECS

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
• Mac

THE EXPERT

StreamSkill.com
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.

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.

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

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

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

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

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

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.

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

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

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

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

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

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.

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

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

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

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

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.

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

PRODUCT SPECS

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

THE EXPERT

StreamSkill.com
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.

KEY FEATURES

The course gives an overview of the basics of financial modeling and forecasting. It focuses on how to build a sound financial model using Excel. You will learn about the purpose of forecasting and how to go through the three financial statements (balance sheet, income statement, and cash flow statement) in order to define your forecasting objectives. This class will be helpful for those who want to predict future sales at a company based on historical sales data.

• Access 38 lectures & 5 hours of content 24/7
• Learn the basics of financial modeling & forecasting
• Understand the purpose of financial forecasting
• Build a sound financial model
• Know the role of forecasting in strategic planning
• Go through the three financial statements (balance sheet, income statement & cash flow statement)
• Define your forecasting objectives
• Edit Macros in the VBA Editor
• Identifying key variables & drivers
• Analyze financial forecasts using ratio analysis
• Learn future trends in forecasting

Note: Software NOT included.

PRODUCT SPECS

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

• Any device with basic specifications

THE EXPERT

StreamSkill.com
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.