Excel for Business Analysts Online Course by Simon Sez IT

Excel for Business Analysts Online Course by Simon Sez IT

Course Detail

Salepage: Excel for Business Analysts Online Course by Simon Sez IT

What you’ll discover

How to use VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP to combine data from several sources
How to add logic to your analysis using the logic symbols IF, IFS, IFERROR, SUMIF, and COUNTIF
Text function data splitting explained LEFT, RIGHT, MID, SEARCH
How to prepare data for analysis in Excel by standardizing and cleaning it
Regarding doing data analysis with the PivotTable function
How to use Pivot Charts in Excel to present your analysis
Using Excel to carry out a Linear Forecast and Forecast Smoothing
Excel: All about Histograms and Regression
How to fill data gaps in Excel using Goal Seek, Scenario Manager, and Solver

The precise Excel functions, formulae, and tools that may be used to undertake business or data analysis are the main emphasis of this course. To show you how to utilize them, we take you on a straightforward tour.
We begin by considering how to transform raw data into a form that can be analyzed. After that, we examine a number of analytical tools and features, including Pivot Tables, before moving on to how to utilize charts, Pivot Charts, Slicers, and a variety of other tools to show data in the most understandable manner. Finally, we turn to some more sophisticated methods for projecting and extrapolating patterns from historical data.
To help you put the new data analysis skills you learn into practice right away, this course also contains practice problems.

This course will teach you:
How to use VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP to combine data from several sources
How to add logic to your analysis using the logic symbols IF, IFS, IFERROR, SUMIF, and COUNTIF
Text function data splitting explained LEFT, RIGHT, MID, SEARCH
How to prepare data for analysis by standardizing and purging it
Regarding doing data analysis with the PivotTable function
How to extract information with slicers
How to use pivot charts to present your analysis
the whole forecasting process, including using the Forecast Sheets
Making a Linear Forecast and Smoothing the Forecast
How to highlight specific portions of your data with conditional formatting
Regression and Histograms in Detail
How to fill data gaps with Goal Seek, Scenario Manager, and Solver

7+ hours of video lessons are provided for this course.
55 distinct videos of lectures
Exercise files to put what you learnt into practice
a certificate of completion
In order to record this lecture, Excel from Office 365 was used. Additionally, it applies to users of the more current versions of Microsoft Excel, such as 2013, 2016, and 2019.

Did you realize?
Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Outlook, QuickBooks, Photoshop Elements, and Web Development Languages are just a few of the programs that Simon Sez IT teaches.
– And a whole lot more!

4GB in size

More From : Everything Else