Location

Community Services & Continuing Education - Alexandria

Objectives

• Help the attendees to know the following:• Using Excel charts and functions to summarize marketing data.• Estimating demand curves and using Solver to determine profit-maximizing pricing strategies.• Using cluster analysis for market segmentation.• Developing customized forecasting models that show you how your marketing mix impacts sales.• Measuring the effectiveness of your advertising program.

Outcomes

Upon successful completion of this course, the student will be able to: • Perform sophisticated business analysis using the cost-effective and widely available Microsoft Excel instead of expensive, proprietary analytical tools.• Reveal how to target and retain profitable customers and avoid high-risk customers.• Forecast sales and improve response rates for marketing campaigns.• Explore how to optimize price points for products and services, optimize store layouts, and improve online advertising.

Course Contents

• Hyperlinks• Using Custom Lists• Importing Data from a Database• Using Charts• Using Functions:Data/Time Functions - Mathematical Functions - Statistical Functions - Lookup Function - Database Functions – IF and Nested IF statement.• Using Data Analysis: Data Validation- Data sorting & Filtering (Auto Filter – Advanced Filter) - Conditional Formatting - Data Consolidation - Subtotals• Summarizing Data with a Pivot Table• Using Macros• Data Protection