DOwnload Udemy – The Microsoft Excel Data Analysis Toolkit Bundle

Description

The Microsoft Excel Data Analysis Toolkit Bundle is a Microsoft Excel Data Analysis Toolkit course published by Udemy Academy. This bundle includes hands-on exercises and teaches you the essential data analysis skills to succeed in the modern workplace. Data analysis is easier than you think – you don’t need to code or understand algorithms, just master Microsoft Excel techniques. This comprehensive five-part bundle offers in-depth training on business analysis, advanced Excel 2019 features, data analysis techniques, dashboard creation, and powerful user tools. You’ll learn how to merge data from multiple sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP; apply logic with IF, IFS, IFERROR, SUMIF, and COUNTIF; segment and clean data with text functions; create PivotTables and pivot charts; forecast with Forecast Sheets; and use conditional formatting to highlight key data points.

This package covers: advanced charting and graphing, detailed formatting tools, Power Query, advanced functions like SUMPRODUCT and LINEST, automated reporting, dynamic named ranges, and data import/export. You’ll become a master of creating dashboards with PivotTables, 3D maps, and advanced sorting/filtering. In addition, you’ll learn to create dynamic multi-dependent drop-down lists, perform 2-way lookups, automate tasks with macros and VBA programming, and use scenario analysis tools like Goal Seek, Scenario Manager, and Solver. By the end of this extensive training, you’ll have mastered financial and statistical functions, sparklines, data bars, histograms, regression analysis, and creating interactive dashboards that transform raw data into actionable business insights.

What you will learn

• How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
• How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
• How to split data using the SEARCH, LEFT, RIGHT, MID text functions
• How to standardize and clean data ready for analysis in Excel
• Performing linear forecasting and forecast smoothing in Excel
• All about histograms and regression in Excel
• How to use Goal Seek, Scenario Manager, and Solver to fill data gaps in Excel
• Averages, Percentiles, and LINEST Functions
• Spark lines and data strips
• Import data from other data sources
• Advanced data analysis techniques
• Financial and statistical functions
• How to Create Awesome Dashboards Using Pivot Tables
• How to format a PivotTable, including setting styles
• Advanced sorting and filtering in PivotTables
• How to use 3D maps from PivotTable
• How to update your data in PivotTable and Pivot Chart
• Creating dynamic multi-dependent drop-down lists in Excel
• Performing a 2-way search in Excel
• Automate repetitive tasks in Excel using macros
• How to edit macros in the VBA editor
• How to write your own macro from scratch

Who is this course suitable for?

• Those who want to automate Excel tasks or procedures.
• Users who have basic knowledge of Excel 2019/365 and those upgrading from previous versions of the software
• Users who have a basic understanding of Microsoft Excel and are looking to advance their Excel 2019/365 knowledge.

Course details The Microsoft Excel Data Analysis Toolkit Bundle

• Publisher: Udemy
• Instructor: Simon Sez IT
• Language: English
• Education level: Intermediate
• Number of lessons: 255
• Training duration: 32 hours and 44 minutes

Course Titles The Microsoft Excel Data Analysis Toolkit Bundle

Course prerequisites

• Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
• Intermediate knowledge of Microsoft Excel.

Pictures

Sample video

Installation Guide

After Extract, view with your favorite player.

Subtitles: English

Quality: 720

File size

15.48 GB

Download link