Location

Community Services & Continuing Education - Cairo

Objectives

• Spreadsheets are an essential tool for marketing and business today, no matter what your role is. They are incorporated into many aspects of companies; from advanced calculations for budget forecasts to reviewing marketing KPIs, or even making a drinks preference list for staff.

Outcomes

- Know basic data types in Spreadsheets. Is able to determine data types and convert them. Have skills of conditional formatting.- Know basic functions to calculate summary statistics. Is able to build pivot tables. Have skills of data visualizing depending on data and task type.

Course Contents

-Summarize Marketing Data Using Pivot Tables-Pricing-Sales Forecasting using Regression-Modeling Trend and Seasonality-Conjoint Anaysis-Customer Value Calculation-Measuring the Effectiveness of Advertising- Media Selection Models-Pay Per Click (PPC) Online Advesrtising-Analysis of Variance using ANOVA package