In this project, I analyzing a real life data from the New York Stock Exchange that provided by Kaggle it contains historical financial data from S&P 500 companies and creating an income statement and forecast financial metrics.
The main goal of this project is:
1- interpret the measures of central tendency and spread (mean, median, standard deviation, range.
2- use a combination of Excel functions (e.g., IF statements, INDEX and MATCH, calculating descriptive statistics with the IF statement, drop downs, data validation, VLOOKUP).
3- analyze and forecast financial business metrics using Excel.
4- create visualizations of a business metric and use Excel to create a financial forecast model.