Excel for Business Analysts

Excel for Business Analysts
  • Tests
  • Anytime Learning
  • Certificates
  • CPD Accredited Training
  • Video Tutorials
  • 30-Day Refund Guarantee

This Excel for Business Analysts course focuses on the specific functions, formulas, and tools included in Excel that specifically help to conduct business or data analysis.


In this course you will learn:

  • How to use VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP to merge data from different sources
  • How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
  • How to split and clean data using text functions SEARCH, LEFT, RIGHT, MID Master the PivotTable function and use it to perform data analysis
  • How to use slicers to draw out information from Pivot Tables
  • How to display your analysis using Pivot Charts
  • What is forecasting and How to use the Forecast Sheets
  • How to conduct a Linear Forecast and Forecast Smoothing
  • How to use Conditional Formatting to highlight areas of your data
  • The Histograms and Regression in Excel
  • How to use Goal Seek, Scenario Manager, and Solver to fill data gaps in forecasting

+ Syllabus


About the author

Simon Sez IT

For this course, we’ve partnered with training experts SimonSezIT, who help learners win when it comes to computer and software technology. Just like EWB, the SimonSezIT team are passionate about Microsoft applications and computer programs, knowing what makes excellent training work. Their content is inventive and compelling, and we’re sure you’ll love it.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.

Sale price
£49.00
Regular price
Sale price
£49.00
Regular price
Sold out
Unit price
per 
Tax included.

This Excel for Business Analysts course focuses on the specific functions, formulas, and tools included in Excel that specifically help to conduct business or data analysis.


In this course you will learn:

  • How to use VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP to merge data from different sources
  • How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
  • How to split and clean data using text functions SEARCH, LEFT, RIGHT, MID Master the PivotTable function and use it to perform data analysis
  • How to use slicers to draw out information from Pivot Tables
  • How to display your analysis using Pivot Charts
  • What is forecasting and How to use the Forecast Sheets
  • How to conduct a Linear Forecast and Forecast Smoothing
  • How to use Conditional Formatting to highlight areas of your data
  • The Histograms and Regression in Excel
  • How to use Goal Seek, Scenario Manager, and Solver to fill data gaps in forecasting

+ Syllabus


About the author

Simon Sez IT

For this course, we’ve partnered with training experts SimonSezIT, who help learners win when it comes to computer and software technology. Just like EWB, the SimonSezIT team are passionate about Microsoft applications and computer programs, knowing what makes excellent training work. Their content is inventive and compelling, and we’re sure you’ll love it.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.