Get $1 credit for every $25 spent!

The 2021 Excel to Alteryx Data Analyst Essentials Bundle

Ending In:
Add to Cart - $29.99
Add to Cart ($29.99)
$348
91% off
wishlist
Courses
4
Lessons
179

What's Included

Product Details

Access
Lifetime
Content
5.0 hours
Lessons
49

Excel for Business Analysts

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

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

4.6/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.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 430,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.

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

Access
Lifetime
Content
4.0 hours
Lessons
47

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.

4.2/5 average rating: ★ ★ ★ ★

  • Access 47 lectures & 4 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 10+ years and taught over 430,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.

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

Access
Lifetime
Content
7.5 hours
Lessons
48

Advanced PivotTables

Master PivotTables & Easily Perform Data Analysis Tasks

By Stream Skill | 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 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.
StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 430,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.

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

Access
Lifetime
Content
6.0 hours
Lessons
35

Introduction to Alteryx

Learn to Use the Alteryx Designer to Master Data

By Stream Skill | in Online Courses

There is no getting away from it. We now live in a world where data dominates. Decisions in business, government, the economy, which music to listen to or new shows to watch, it's all about data. Happily, there is a growing number of tools to help make sense of the volume of raw data now available. Alteryx is one of those. In this course, you'll get started with the Alteryx Designer and set you on a path to becoming an Alteryx developer. You don't need any previous knowledge of Alteryx to take this course. An intermediate to advanced Excel understanding is useful.

  • Access 35 lectures & 6 hours of content 24/7
  • Use Alteryx workflows to cut out repetitive tasks
  • Build visual workflows in Alteryx
  • Make the most of 'Favorite Tools' as core Alteryx building blocks
  • Filter data in Alteryx
  • Use the basic functions in Alteryx to match data
  • Dynamically rename datasets
  • Parse data in Alteryx
  • Create reports in Alteryx that run on demand
  • Use the predictive tools in Alteryx to perform data analysis
  • Build a k-centroid clustering model using Alteryx
  • Turn a workflow into an analytic app using a GUI
  • Publish work in Alteryx to a gallery to allow others to view
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 10+ years and taught over 430,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.

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

  • Alteryx Designer


Terms

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