The Microsoft Excel Data Analysis Toolkit Bundle is a course designed to equip learners with the skills required to analyze data using Excel. The bundle comes with five comprehensive courses in one, providing learners with well over 30 hours of video tutorials and exercise files to practice.
Course Description
The course description is explicit about the goal of the course; to teach learners how to conduct comprehensive data analysis using Microsoft Excel. This is premised on the idea that data analysis is an essential skill in the modern workforce, and anyone looking to thrive must possess it.
What sets this course apart from others is the combination of five full-length courses into one, huge-value bundle. In this bundle, learners will gain new skills and refine their existing ones while learning advanced Excel techniques. Here's what the Microsoft Excel Data Analysis Toolkit Bundle entails:
Excel for Business Analysts
The Excel for Business Analysts course is detailed and comprehensive, covering a range of data analysis techniques. Learners will begin by learning how to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP. They will also learn how to clean and standardize data, readying it for analysis. Some of the topics covered in this course include IF, IFS, IFERROR, SUMIF, and COUNTIF.
Learners will get introduced to text functions like SEARCH, LEFT, RIGHT, and MID to split data. PivotTable functions are also covered, including how to draw out information using slicers and how to display analysis using Pivot Charts. This course covers forecasting and Forecast Sheets, and learners get to conduct Linear Forecast and Forecast Smoothing. Conditional Formatting and Histograms and Regression are also introduced, among other topics.
Advanced Excel 2019 Course
Advanced Excel 2019 Course contains over 230 individual video lectures and comes with exercise files, providing learners with the opportunity to put what they learn into practice. As the name implies, the course is centered around Excel 2019, although much of what is taught applies to other recent versions such as Excel 2013 and 2016.
Learners will begin by learning what's new and different in Excel 2016 before learning advanced charting and graphing techniques, including how to use detailed formatting tools. A range of lookup functions, financial functions, and statistical functions are also included. Connecting to other workbooks and datasets outside of Excel, like MS Access and the web, is also covered. Learners will gain mastery of PivotTables and Pivot Charts, as well as Scenario Manager, Goal Seek, and Solver.
PivotTables for Beginners
The PivotTables for Beginners course is designed to ease learners into PivotTables, ensuring they have a deep understanding of the fundamentals before moving on to advanced techniques. Learners will begin by learning how to clean and prepare their data before creating a basic PivotTable. They will get introduced to the PivotTable fields pane and learn how to add fields and pivot the fields.
The course covers different ways to summarize data, including how to Group PivotTable data and use multiple fields and dimensions. Learners will also understand the methods of aggregation before learning how to choose and lock the report layout. Then, they will learn how to apply PivotTable styles, sort data, and use filters. Creating pivot charts based on PivotTable data, selecting the right chart for data, and applying conditional formatting are also covered.
Advanced PivotTables
Advanced PivotTables Course is designed to build on the fundamentals covered in PivotTables for Beginners, introducing learners to more advanced topics. Learners get to do a quick review of PivotTables before learning how to combine data from multiple worksheets for a PivotTable. The course also covers advanced Formatting, including adjusting styles, and using the Value Field Settings.
Advanced Sorting and Filtering in PivotTables are also covered, including how to use Slicers, Timelines on multiple tables. Learners will learn how to create a Calculated Field, deal with GETPIVOTDATA, and create a Pivot Chart while adding sparklines and slicers. In this course, learners will grasp the concept of using 3D Maps from a PivotTable, how to update the data in a PivotTable, and Pivot Chart. The course also covers Conditional Formatting in a PivotTable and how to create amazing-looking dashboards.
Advanced Formulas in Excel
The Advanced Formulas in Excel course delves deeper into understanding complex formulas. Learners will understand how to filter a dataset using a formula, sort a dataset using formulas and defined variables, and create multi-dependent dynamic drop-down lists. The course also covers how to perform a 2-way lookup, make decisions with complex logical calculations, and extract parts of a text string.
Some of the other topics covered in the course include creating a dynamic chart title, finding the last occurrence of a value in a list, looking up information with XLOOKUP, and finding the closest match to a value. Given the increasing importance and usefulness of data in the workplace, this course bundle is well worth it.
Course Reviews and Ratings
The Microsoft Excel Data Analysis Toolkit Bundle has an impressive rating aggregate of 4.54933, based on 472 reviews. Most of the reviews were positive, with some students highlighting the clarity of instruction and the benefits they gained from taking the course. Others commended the instructors, noting their passion for teaching and the quality of content.
One student, Harlan, praised the instructors, stating, "Well described and clearly demonstrated." Another student, Kenvis, noted, "My name is Kenvis, and I have a knowledge of IT but never thought of specializing in Data Analytics before. This was so exciting, and I am now anxious to learn more." Beverly, on the other hand, praised the course's impact on her knowledge. She stated, "I like the instructor very much. I had a slight problem with the MIN function but I reviewed the tutorial again until I realized where my error was, and fixed it!".
In all, the reviews are evidence of the value of the course and reinforce the notion that any learner will benefit from taking the bundle.
Course Wrap Up
The Microsoft Excel Data Analysis Toolkit Bundle is a unique and comprehensive course bundle that aims to equip learners with the skills required for analyzing data using Excel. The five full courses combined in the bundle make it well worth the investment. Learners will gain invaluable skills around PivotTables and Pivot Charts, Advanced Excel techniques, Lookup Functions, Financial Functions, Statistical Functions, Worksheet Connectivity, and advanced formula usage among others.
Whether you're a beginner in Excel or an advanced user, this bundle is a must-have. The positive reviews from past learners are a testament to the course's quality and are evidence of the skills that learners will gain from taking the bundle.
