Excel Efficient Office: Market and Sales Management

Author: Shenlong Studio
Publisher:
Publish Date: 2006-02-01
Features: This book is primarily compiled for office personnel to achieve efficient office work. It comprehensively introduces the specific processes of using Excel to complete the statistics, calculation, analysis, and summarization of various marketing data from a fresh perspective, demonstrating strong practicality and operability. The book is divided into 15 chapters, covering topics such as the establishment and management of customer records, contract approval forms and product catalogs, sales data—chart analysis, sales data—summary analysis, sales data—pivot table analysis—creation of reimbursement budget sheets, the creation of market research questionnaires, the statistical analysis of market research questionnaire results, decision-making for installment payment businesses, marketing strategies, the creation of sales management systems, relative numbers and hypothesis testing for qualitative data, mean values, variation indicators, and hypothesis testing for quantitative data, multivariate data analysis in marketing, and marketing forecasting. There are also 3 appendices: Comprehensive Applications of Excel, Excel Tips and Solutions, and Excel Worksheet Functions. The book fully considers the practical needs of marketing personnel, including:
- Example Guide—introducing knowledge points and design ideas,
- Tips—helping readers avoid detours during learning,
- Example Expansion—meeting the diverse needs of different users.
With this book, whether you are a beginner or have some foundation, you can easily use Excel to solve practical marketing problems. The book is suitable for professionals engaged in marketing and marketing management, as well as students of economics and management in higher vocational and technical colleges. It can also serve as a training textbook for short-term training courses on efficient office work in marketing and marketing management.