The Essential 2021 Advanced Excel Expert Bundle

189 Enrolled
6 Courses & 29 Hours
$19.99$433.00
You save 95% -

What's Included

Excel for Business Analysts
Excel for Business Analysts
Excel for Business Analysts
  • Experience level required: Advanced
  • Access 49 lectures & 5 hours of content 24/7
  • Length of time users can access this course: Lifetime

Excel for Business Analysts

SS
Stream Skill

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

Description

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.

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
  • Use Goal Seek, Scenario Manager, & Solver to fill data gaps
Note: Software NOT included.

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

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.