Data Analysis
Course Objective
- Be more confident using Excel and be able to create a spreadsheet from scratch.
- Understanding and using some of the built-in calculation and formula functionality to be more productive in work and home Excel environments.
- Be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.
Course Module
- Entering and Editing data
- Documenting and Auditing
- List management
- Plan a forecast Model
- Forecasting Methods
- Measuring Forecast Accuracy
- Using the solver to optimize forecasts
- Trends and forecasting using charts
- Comparing Forecasting Methods and Models
- Manipulate Forecasts using What-If Analysis
- Correlation Coefficient
- Break-Even Analysis
- Data Analysis Tools
Related Program
English Grammar At The Workplace
Steve Naismith Transforms His Health With In-Home Personal Training.
- Age67
- Before80kg
- After67kg
- Timeframe5 Months
Business English Writing
Steve Naismith Transforms His Health With In-Home Personal Training.
- Age67
- Before80kg
- After67kg
- Timeframe5 Months
Communicate English Effectively At The Workplace
Steve Naismith Transforms His Health With In-Home Personal Training.
- Age67
- Before80kg
- After67kg
- Timeframe5 Months