Skip to main content

The Must-Have Microsoft Excel for Business Analysts Course for $9 April 10, 2021 at 02:00AM



Checkout Now

Expires April 10, 2121 23:59 PST
Buy now and get 89% off



KEY FEATURES

Microsoft Excel remains one of the best tools for Data Analysis. This course focuses on the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. It starts by looking at how to take raw data and clean it, so it’s in a useable format. After that, you'll look at several tools and functions that can be used to analyze before moving onto how to display data in the most meaningful way. Finally, it moves onto some more advanced techniques designed to aid forecasting and using existing data to predict future trends. This course also includes practice exercises to immediately put into practice the new data analysis techniques you learn.

4.8/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 all about forecasting & using the Forecast Sheets
  • Conduct a Linear Forecast & Forecast Smoothing
  • Use Conditional Formatting to highlight areas of your data
  • Explore all about Histograms & Regression
  • Use Goal Seek, Scenario Manager, & Solver to fill data gaps
Note: Software NOT included.

"The explanation was simple and lucid. I strongly recommend this course to all the guys who want to speed up their daily office tasks" – Teja Naganaboyina

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

THE EXPERT

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.




Checkout Now

Comments

Popular posts from this blog

2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! W/ Coupon code - January 01, 2019 at 01:18AM

2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! Make 2019 the year you rise to your potential and achieve all your New Year resolutions, with the most popular courses from leading instructors, for as low as $9.99 each! *New Year’s Sale: Get Udemy courses for as low as $9.99 […] The post 2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! W/ Coupon code appeared first on CouponRim . from CouponRim https://cpr.im/2An4ERS

SyncMate 7: Lifetime Expert License for $14 January 02, 2019 at 02:00AM

Checkout Now Expires April 02, 2019 23:59 PST Buy now and get 71% off Checkout Now KEY FEATURES If you jump between Apple and non-Apple devices, you understand the hassle that is keeping your data synced across the board. That's why there's SyncMate, the ingenious tool that lets you synchronize data between your Mac and other devices all in a single, convenient application. From contacts and calendars to folders and iTunes, SyncMate makes it easy to keep all of your data synchronized, and with an Expert license, you'll enjoy even more syncing options, like automatic syncing, backups, and more. Keep your data in sync between your Mac & other platforms, including Android, iCloud and Dropbox Sync your Mac w/ multiple devices simultaneously Automatically keep data on your devices up to speed with Autosync Use hassle-free w/ invisible background syncing Sync your contacts, calendars, folders & more Seamlessly sync multimedia files in

The Complete Big Data Master Class Bundle for $35 March 10, 2019 at 03:00AM

Checkout Now Expires March 10, 2024 23:59 PST Buy now and get 96% off Learn By Example: Plotly KEY FEATURES You don't need to be a programming prodigy to get started in data science. Easy to use and highly accessible, Plotly is library in Python that lets you create complex plots and graphs with minimal programming know-how. From creating basic charts to adding motion to your visualizations, this course will walk you through the Plotly essentials with hands-on examples that you can follow. Access 28 lectures & 2 hours of content 24/7 Learn how to build line charts, bar charts, histograms, pie charts & other basic visualizations Explore visualizing data in more than two dimensions Discover how to add motion to your graphs Work w/ plots on your local machine or share them via the Plotly Cloud PRODUCT SPECS Important Details Length of time users can access this course: lifetime Access options: web and mobile streaming Certification of completion in