Excel for Marketers
Completed 2009
Click here for our short marketing courses
Principles, techniques and tips to enable marketers to harness the full power of Excel, enabling them to work faster, smarter and with greater impact- from beginner to advanced level.
Course aims
The course will enable delegates to use Excel effectively. From an understanding of relative and absolute cell addressing at the beginner level through to goal seeking, scenarios and automated macros at the advanced level, delegates will develop skills that will enable them to construct robust, easily adjustable spreadsheets quickly.
The course is set within a marketing context, addressing the types of problems that marketers face. We also use our expertise in marketing and strategy to build models and exercises that accurately mirror the real world. Many of the models used in our courses will be of lasting value to managers.
Who will benefit?
Product, category, sector and marketing managers, marketing budget holders, sales managers and marketing staff with responsibility for producing forecasts, analysing results, producing business cases for expenditure etc
Why should you attend?
- To save you time
- To enable you to undertake sophisticated sensitivity and scenario analysis
- To help you to produce clear, well-formatted documents to support business cases
Key content*
Beginner
- spreadsheet basics
- absolute and relative addressing
- moving and copying data
- formatting
- charting
- printing
Intermediate
- ranges and views
- 3d spreadsheets
- templates and styles
- sorting and filtering
- macros and customising the Excel environment
- functions
Advanced
- scenarios
- goal seeking
- pivot tables
- auditing
- customising user input - forms macros