Udemy – Online Excel Course for Business Analysts 2020-10 – Download

Descriptions

Online Excel course for business analysts. In this course, we focus on specific functions, formulas, and tools that Excel helps you perform business intelligence or data analysis. We’ll take you on a serious journey to teach you how to use them. Let’s start by looking at how to take raw data and prepare it for analysis. After that, we’ll look at a number of tools and features you can use to perform analysis, such as pivot tables, before moving on to how to display your data in the most meaningful way using charts, pivot charts, slicers, and more. Finally, we’ll move on to some more advanced techniques designed to help forecast and use existing data to predict future trends. This course also includes hands-on exercises so you can immediately put into practice the new data analysis techniques you learn.

What will you learn

How to combine data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH and XLOOKUP.
How to Use IF, IF, IFERROR, SUMIF, and COUNTIF to Apply Logic to Analysis
How to split data using text functions SEARCH, LEFT, RIGHT, MIDDLE
How to Standardize and Clean Data Ready for Analysis in Excel
About using the PivotTable function to analyze data
How to Display Your Analysis Using PivotCharts in Excel
Performing a Linear Forecast and Smoothing the Forecast in Excel
All about histograms and regression in Excel
How to Use Goal Finder, Script Manager, and Solver to Fill Data Gaps in Excel