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

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I 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

Requirements

• Microsoft Excel 2016, 2019, 365
• A basic understanding of how to use Microsoft Excel

Target audience

• Business analysts who are Excel users