Excel Application Examples and Detailed Explanations

Author: Ren Xianzhou / Wu Xinhua / Zhang Haifeng (editors)
Publisher:
Publish Date: 2004-06-01
Features: This book systematically introduces the main content of Excel applications from three aspects: basic operations, function applications, and VBA secondary development. The basic operations section includes the creation and formatting of workbooks, the use of graphics and charts, decision analysis, Web applications, network sharing, collaboration with other software, and more. The function application section focuses on financial analysis functions and statistical analysis functions, supplemented by specific application examples, categorically introducing the functions and syntax of commonly used Excel functions. The VBA secondary development section starts with macro recording, gradually expanding through the introduction of basic concepts and several specific examples from simple to complex, achieving the goal of low starting point and quick entry. The book is accompanied by tips and troubleshooting. For readers who have already mastered the basic operations of Windows application software, learning this book can help them flexibly master and apply Excel. This book is mainly written for intermediate and advanced Excel users, but it is believed that some content in the book will also be beneficial for advanced Excel users.