Course image
Course name Excel for Business Analysts

In this course, you will learn how to leverage one of the most sought-after data analytic tools, Microsoft Excel. As you explore the tools and functions that allow you to transform raw data into meaningful information, you gain the insight to forecast and predict future trends. By the end of this course, you will have a firm grasp of this all-in-one data management software that allows you to easily import, explore, clean, analyze, and visualize your data. To get the most out of the coursework, you should have a working knowledge of Excel.

Less

  •  Merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
  •  Apply logic to your analysis by using IF, IFS, IFERROR, SUMIF, and COUNTIF
  •  Standardize and clean data ready for analysis
  •  Use the PivotTable function to perform data analysis
  •  Use conditional formatting to highlight areas of your data
  •  Use goal seek, scenario manager, and solver to fill data gaps
  •  Conduct forecasting and use the forecast sheets