| Description |
1 online resource (xxvi, 1074 pages) : illustrations |
| Series |
Mr. Spreadsheet's Bookshelf |
|
Mr. Spreadsheet's bookshelf.
|
| Contents |
Microsoft® Excel® 2013 Power Programming with VBA; Introduction; Topics Covered; What You Need to Know; What You Need to Have; Conventions in This Book; What the Icons Mean; How This Book Is Organized; About This Book's Website; About the Power Utility Pak Offer; How to Use This Book; Part 1: Some Essential Background; Chapter 1: Excel in a Nutshell; About Excel; Thinking in Terms of Objects; Workbooks; Excel's User Interface; Data Entry; Formulas, Functions, and Names; Selecting Objects; Formatting; Protection Options; Charts; Shapes and SmartArt; Database Access; Internet Features |
|
Analysis ToolsAdd-Ins; Macros and Programming; File Format; Excel's Help System; Chapter 2: Formula Tricks and Techniques; About Formulas; Calculating Formulas; Cell and Range References; Using Names; Formula Errors; Excel Auditing Tools; Array Formulas; Counting and Summing Techniques; Lookup Formulas; Working with Dates and Times; Creating Megaformulas; Chapter 3: Understanding Excel Files; Starting Excel; File Types; Excel File Compatibility; Protected View; Using AutoRecover; Working with Template Files; Inside an Excel File; The OfficeUI File; The XLB File; Add-In Files |
|
Excel Settings in the RegistryChapter 4: Essentials of Spreadsheet Application Development; What Is a Spreadsheet Application?; Steps for Application Development; Determining User Needs; Planning an Application That Meets User Needs; Determining the Most Appropriate User Interface; Concerning Yourself with the End User; Other Development Issues; Part 2: Understanding Visual Basic for Applications; Chapter 5: Introducing Visual Basic for Applications; Getting Some BASIC Background; Delving into VBA; Covering the Basics of VBA; Introducing Visual Basic Editor; Working with Project Explorer |
|
Working with Code WindowsCustomizing the VBE Environment; The Macro Recorder; About Objects and Collections; Properties and Methods; The Comment Object: A Case Study; Some Useful Application Properties; Working with Range Objects; Things to Know about Objects; Chapter 6: VBA Programming Fundamentals; VBA Language Elements: An Overview; Comments; Variables, Data Types, and Constants; Assignment Statements; Arrays; Object Variables; User-Defined Data Types; Built-in Functions; Manipulating Objects and Collections; Controlling Code Execution; Chapter 7: Working with VBA Sub Procedures |
|
About ProceduresExecuting Sub Procedures; Passing Arguments to Procedures; Error-Handling Techniques; A Realistic Example That Uses Sub Procedures; Chapter 8: Creating Function Procedures; Sub Procedures versus Function Procedures; Why Create Custom Functions?; An Introductory Function Example; Function Procedures; Function Arguments; Function Examples; Emulating Excel's SUM function; Extended Date Functions; Debugging Functions; Dealing with the Insert Function Dialog Box; Using Add-ins to Store Custom Functions; Using the Windows API; Chapter 9: VBA Programming Examples and Techniques |
| Summary |
Maximize your Excel 2013 experience using VBA application development The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.-Offers an analysis of Excel application development and a complete introduction to VBA -Features invaluable advice from "Mr. Spreadsheet" himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small -Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills -Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA |
| Notes |
Includes index |
|
Online resource; title from title page (ebrary, viewed April 16, 2013) |
| SUBJECT |
Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
|
Microsoft Visual Basic for applications
|
|
Microsoft Excel (Computer file) fast |
|
Microsoft Visual Basic for applications fast |
| Subject |
Business -- Computer programs.
|
|
Electronic spreadsheets.
|
|
Electronic spreadsheets -- Computer programs.
|
|
COMPUTERS -- Desktop Applications -- Spreadsheets.
|
|
Business -- Computer programs
|
|
Electronic spreadsheets
|
|
Electronic spreadsheets -- Computer programs
|
| Form |
Electronic book
|
| LC no. |
2013932111 |
| ISBN |
9781118490402 |
|
1118490401 |
|
9781118491805 |
|
1118491807 |
|
9781118491829 |
|
1118491823 |
|
1118490398 |
|
9781118490396 |
|
