Excel for Business Analysts Online Course
Learn the Functions and Formulas you need to perform detailed Data Analysis in Excel from Excel experts Simon Sez IT
4.52 (569 reviews)
2,131
students
9.5 hours
content
Mar 2023
last update
$74.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
About using the PivotTable function to perform data analysis
How to display your analysis using Pivot Charts 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
Screenshots
Related Topics
3474754
udemy ID
9/4/2020
course created date
9/16/2020
course indexed date
Bot
course submited by