Forecast GDP using statistical functions. Evaluate sales data and stock data using statistical functions. Mine data using the lookup and reference functions. Analyze Sales data using descriptive statistics. Analyze time series data using exponential smoothing. Analyze data using regression. Analyze sector data using correlation and covariance matrices. Optimize a stock portfolio using solver. Develop an investment schedule using financial functions. Make investment decisions using financial functions. Analyze sales data, calculate stock returns and aggregate GDP data using math functions. Manipulate data using text functions. Validate data using information functions. Create advanced templates and charts. Manage date in workbooks.