The Microsoft Excel Data Analysis Toolkit Bundle
Conquer data analysis in Excel with five comprehensive Excel courses in one
What you'll 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 text functions SEARCH, LEFT, RIGHT, MID
- How to standardize and clean data ready for analysis in Excel
- Conducting a Linear Forecast 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
- Sparklines and data bars
- Importing data from other data sources
- Advanced data analysis techniques
- Financial & Statistical Functions
- How to create amazing looking dashboards using Pivot Tables
- How to format a PivotTable, including adjusting styles
- Advanced Sorting and Filtering in PivotTables
- How to use 3D Maps from a PivotTable
- How to update your data in a PivotTable and Pivot Chart
- Create multi-dependent dynamic drop-down lists in Excel
- Perform a 2-way lookup 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
Requirements
- 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.
Who this course is for
- Those wanting to automate Excel task or procedures.
- Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
- Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.
Download Links
14.50 GB Total Size