Excel for Marketing Managers
February 2006
A MUST HAVE for better marketing decisions!
Buy Now »- 171 Pages
- Publisher: Holy Macro! Books
- ISBN: 1-932802-24-X
- PDF ISBN: 978-1-932802-64-1
"Packed with practical steps and real-life Excel tips"
This book covers real-life marketing opportunities that can be managed with Excel. In the process of learning the solutions and the opportunities, you will become confident with the many capabilities of Excel and be able to use Excel to manage your marketing plan.
"Help your marketing career soar!"
Clean-up, organize, and prioritize your marketing information like a pro. Learn Excel and present your research with a competitive edge and professional appearance.
"Covers the basics and more in-depth tasks"
The most powerful Microsoft Excel features that can be used to sort through data to produce meaningful marketing analyses are outlined in this manual. Marketing managers will learn the math functions to produce budgets and forecasts, and how to use survey analysis to quickly spot trends using pivot tables and other analysis tools. Ideas for launch schedules, life cycle management, and other date-related information are also presented.
The book covers marketing topics such as:
- Competitive Analysis
- Research
- Lead Tracking
- Trade Shows
- Forecasting
- Pricing
- Sales Reports
- New Markets
- Growth Rates
- Segmentation
- Targeting
- Positioning
- Charting
- Metrics
- Goal Seek
- Customer Satisfaction
- What’s in This Book and What Isn’t?
-
How to Use Excel to Become a Marketing Genius
- Excel Makes Your Job Easy
- Get Wise Before You Analyze: Cool Things Excel Can Do So You Won’t Have to
-
Excel-lent Beginnings
- Customizing Excel
- Copying a Worksheet
- Showing Numbers in Thousands
-
Time-saving Tricks
- Quickly Seeing Sum or Average
- Adding Subtotals
- Here’s the Situation
- Here’s What to Do
- Excel Details
- Quickly Filling a Series
-
Formulas 101
- Entering Formulas
- Seeing All Formulas
- Using a Fixed Value in Your Formula
- Replacing a Thousand Formulas with One
-
I’m the Marketing Manager – Now What?
- Manage This – Research!
-
Compiling Your Survey Data
- Creating a Random List
- Cleaning Your Database: Merging and Purging
- Finding and Analyzing Records Using AutoFilter
- Product Life Cycle Analysis and Product Line Management
- Highlighting Outliers
-
Strategy Development
- Market Segmentation
-
Disciplining Data
- Importing Data
- Looking up Data
- Quickly Sorting Your Data
- Custom Sorts
- Dealing with Dates
- Fiscal Responsibility (Fiscal Years NOT Ending on 12/31)
- Preparing Your Data: Joining Text
- Turning Your Data on Its Side with Transpose
- Counting Records
- Breaking Apart Text
-
Competitive Analysis: Moving from Data to Information
- Served Market Share Model
- Learning to Love Pivot Tables
-
Building Your Case: Presenting and Reporting Your Data
- Making Reports Look Great
- How to Wrap Text
- Chart Your Success
- Pie Charts
- Combo Charts
- Charting with a Second Axis
-
The Marketing Mix: Build an Irresistible Offering
- Creating an Offering That Your Ideal Customers Will Buy – Regardless of Price
- Implementation
-
Trade Shows: Make the Most of them
- Before the Show
- At the Show
- After the Show
-
Measurement: Key to Market Management
- Using Metrics
- Calculating Sales over Plan
- Calculating Compound Growth Rates
- Finding the Growth You Want with Goal Seek
- Not Really the End
- Index
