Advanced Applications of Excel in Management

Author: Zhang Guoping
Publisher:
Publish Date: 2004-07-01
Features: This book introduces advanced applications of Excel in management in an accessible and practical manner, combining theory with practice. The book is divided into four parts and 24 chapters, covering practical techniques of Excel in accounting, financial management, economic management, and statistics. The Excel applications introduced in this book mainly include accounting vouchers, accounting ledgers, financial reports, daily expense statistics, payroll management, financial budgeting and planning, financing decisions, investment decisions, daily management, establishing financial models using VBA, supply and demand, consumer theory, producer theory, cost theory, firm theory, monopoly market structures, Keynesian theory models, descriptive statistical analysis of data, probability distributions and sampling distributions, parameter estimation, hypothesis testing, analysis of variance, regression analysis, time series analysis and forecasting, etc. The book is concise, well-illustrated, easy to learn and use, and focuses on practical applications. It can serve as a textbook and reference for students majoring in management at universities and colleges, as well as for management personnel in enterprises and institutions.