Ending In:
$275
89% off
Courses
4
Lessons
170
Enrolled
1,121
Courses
4
Lessons
170
Enrolled
1,121
What's Included
Microsoft Excel 2019: Advanced
$100 Value
Power Pivot, Power Query & DAX in Excel
$75 Value
VBA for Beginners
$50 Value
VBA Intermediate
$50 Value
Product Details
Access
Lifetime
Content
8.0 hours
Lessons
57
Microsoft Excel 2019: Advanced
Delve Into High-Level Consolidation, Analysis & Financial Reporting
By Stream Skill | 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.
- 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
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: advanced
Requirements
- Any device with basic specifications
- Microsoft Excel 2019
Access
Lifetime
Content
3.75 hours
Lessons
44
Power Pivot, Power Query & DAX in Excel
Analyze Data at Scale with These Advanced Excel Functions
By Stream Skill | in Online Courses
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.
- Access 44 lectures & 3.75 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
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.
The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: advanced
Requirements
- Any device with basic specifications
- Microsoft Excel 2019
Access
Lifetime
Content
4.0 hours
Lessons
32
VBA for Beginners
Learn Microsoft VBA to Automate Your Time-Consuming Procedures In Excel
By Stream Skill | in Online Courses
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 w/ end users
- Learn practical methods for using macro errors to improve your VBA code
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.
The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: advanced
Requirements
- Any device with basic specifications
- Microsoft Excel 2019
Access
Lifetime
Content
4.5 hours
Lessons
37
VBA Intermediate
Discover Excel Automation Secrets with Advanced Micros
By Stream Skill | 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.
- 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 w/ Excel successfully
- Work w/ references & libraries
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.
The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.
Important Details
- Length of time users can access this course: lifetime
- Access options: web & mobile streaming
- Certification of completion included
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: advanced
Requirements
- Any device with basic specifications
- Microsoft Excel 2019
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.