The Microsoft Excel Data Analysis Toolkit Bundle
Conquer data analysis in Excel with five comprehensive Excel courses in one
4.66 (883 reviews)
4,845
students
33 hours
content
Mar 2024
last update
$89.99
regular price
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 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
Related Topics
3833982
udemy ID
2/8/2021
course created date
2/17/2021
course indexed date
Bot
course submited by