OFFSET, INDIRECT, Power View, Solver, etc. multiple regression, exponential smoothing, etc.) as well as advanced Excel functions (i.e. Key tools included are trend analyses (i.e. This course is hands-on, scenario-based, and involves relational data base construction and integration including use of Pivot Tables and Descriptive Statistics. Our Excel Analysis and Dashboards course teaches you to use your data effectively to perform Data Analysis and build powerful Dashboards driving decisions. Students learn business modeling and analysis techniques with Microsoft Excel with the ultimate objective of transforming data and modeling assumptions into key metrics as well as bottom-line results of forecasts, simulations, and sensitivity analyses.

This course provides a thorough working knowledge of a “best practice” platform meeting many organizational and project analytical needs. This course provides a thorough working knowledge of business modeling and analysis techniques with Microsoft Excel 2013, with the ultimate objective of.

Market researchers, project managers, business analysts, economists, financial professionals, budgeters, venture capitalists, investment bankers, corporate treasurers, and operations heads are just a few examples of positions requiring a working knowledge of forecasting, evaluation, and analysis modeling.

Data analysis excel courses online