[书籍] 101 Ready-To-Use Excel Macros 101个现成的Excel Macros使用技巧
出版社:
Wiley
简介:
Most books offer a very high-level overview of VBA, often providing readers with benign examples designed only to illustrate a particular topic. Analysts don't have the luxury of taking a few weeks time-out to learn VBA. The scenarios and issues they are facing require immediate help in the form of Excel Macros. In this case, many analysts turn to Google and online Excel forums here they can find that one Excel Macro (snippet of VBA code) that will solve their problem now. In the real world, most Excel analysts implement VBA code long before they actually learn or understand VBA.This book approaches the reader with the assumption that VBA "learning" will come later. Instead of the same general overview of VBA topics, this book provides 101 of the most commonly used real-world Excel Macros. Each segment of the book outlines a common problem that needs to be solved, and will provide the actual Excel Macro to solve the problem - along with detailed explanation of how the macro works and where to use the macro. The book is in the format of a Recipe/Tips and Tricks book where each segment shows how to perform a common task via Excel Macros. This lets the reader use the book as a handy reference where a common problem can be found in the book, and solved by plugging in the given macro.?After using this book and the CD, the reader will be able to:Immediately implement the required Excel MacroUnderstand how the given macro worksReuse the given macro in other workbooks or in conjunction with other macrosModify the macro for personal useContent OverviewWorking with WorkbooksWorking with WorksheetsWorking with RangesWorking with DataWorking With PivotTablesWorking With ChartsEmailing From ExcelIntegrating Excel and Other Office Applications
用户推荐(0)
暂无推荐，你也可以发布推荐哦:)
0
人收藏了这本书籍
广告
登录 | 立即注册