DATA ANALYSIS AND BUSINESS MODELING IN EXCEL
By: Valuefronteira Training
Lagos State, Nigeria
Nov 12 - 13 Nov, 2012
This course is designed to enable participants build their analytical capacity using the MS Office Excel application. Participants will learn how to use the data analysis and modelling tools in Microsoft Excel to solve business problems requiring: Linear programming, Business forecasting techniques, Data summarizations with Pivot tables & charts, Descriptive analytics, Regression and correlation analysis, Reliability Testing, ANOVA, Chi2 tests, Scenario analysis, Sensitivity analysis, Exponential smoothing, Moving averages, Charting & graphing, Sampling, Rank & Percentiles, Data filtering & sorting, Data Filing, Conditional Formatting, Data Tables, What-if analysis, Optimization modeling with solver , Simple modeling with goal-seek.
Venue: 4th Floor (Rear Wing), 42 Olowu Street Ikeja