Excel Functions and Macro Practical Application Analysis

Author: Xu Jinbiao
Publisher:
Publish Date: 2005-06-01
Features: Through specific operational steps, accompanied by rich illustrations, it guides readers to complete practical tasks. The book features concise language, clear structure, and is easy to understand, interspersed with numerous examples. The content is comprehensive and substantial, with most formulas and functions applicable to various Excel versions, making it a valuable reference book. The content design of the book primarily uses Excel formulas, functions, and macros to solve various problems. Numerous practical examples are provided throughout the book to illustrate how to use these Excel tools. The book is divided into two parts: Part 1 includes Chapters 1 to 15, introducing various techniques for using Excel formulas and functions. The topics covered by these formulas and functions include text, time, date, counting and summarization, queries, finance, database, and graphics, all of which are related to daily practical work. Part 2 includes Chapters 16 to 19, explaining how to use VBA macros to extend Excel's functionality and accomplish tasks that were originally beyond Excel's capabilities.