BeschreibungThis book will dramatically increase white collar productivity. Given the current state of MIS departments, this reader is probably stuck in a user department and can't get the reports they need in a timely manner. They've taken matters into their own hands, importing raw data daily and performing time-consuming manipulations using Excel's power tools. We teach them how to automate these processes, dramatically saving hours of time. a) The book is written from the perspective of Excel power users who are trying to get up the VBA learning curve. The authors take the reader up those painful initial steps of the learning curve and by chapter 3, the reader will understand why their attempts to use the macro recorder have failed and have the confidence that Bill and Tracy will solve their problems. b) There are generations of readers who have only learned procedural languages such as COBOL or BASIC. These novice programmers are confused by the seemingly senseless syntax of object oriented languages such as VBA. In very simple to understand language, the authors explain what is going on and why. Chapter 2 is destined to become the greatest introduction to Object Oriented Programming for the common person ever written. c) Even if you've never programmed before, this book will take you up the learning curve to enable you to automate common tasks in Microsoft Excel.
InhaltsverzeichnisIntroduction 1 1 Unleash the Power of Excel with VBA 7 2 This Sounds Like BASIC, So Why Doesn't It Look Familiar? 29 3 Referring to Ranges 61 4 User-Defined Functions 75 5 Looping and Flow Control 101 6 R1C1-Style Formulas 121 7 What's New in Excel 2007 and What's Changed 135 8 Create and Manipulate Names in VBA 143 9 Event Programming 155 10 UserForms--An Introduction 177 11 Creating Charts 197 12 Data Mining with Advanced Filter 249 13 Using VBA to Create Pivot Tables 281 14 Excel Power 337 15 Data Visualizations and Conditional Formatting 373 16 Reading from and Writing to the Web 393 17 XML in Excel 2007 413 18 Automating Word 421 19 Arrays 441 20 Text File Processing 449 21 Using Access as a Back End to Enhance Multi-User Access to Data 461 22 Creating Classes, Records, and Collections 477 23 Advanced UserForm Techniques 493 24 Windows Application Programming Interface (API) 517 25 Handling Errors 529 26 Customizing the Ribbon to Run Macros 543 27 Creating Add-Ins 569 Index 577
PortraitBill Jelen, Excel MVP and MrExcel, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill has made more than 50 guest appearances on Call for Help with Leo Laporte and has produced more than 250 episodes of his daily video podcast, Learn Excel from MrExcel. He is the host of Total Training's Excel 2007 Advanced DVD. He also enjoys taking his show on the road, doing a one- to four-hour power Excel seminar anywhere that a room full of accountants or Excellers will show up. Before founding MrExcel.com, Jelen spent 12 years in the trenches-working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio, with his wife, Mary Ellen, and sons, Josh and Zeke. Tracy Syrstad remembers the painful trek up the VBA learning curve while developing applications for herself and co-workers at a former job. Now, as the project manager for the MrExcel consulting team, she enjoys helping clients develop custom solutions for their unique situations, observing the myriad ways people use Excel and other Microsoft Office applications.
Untertitel: Sprache: Spanisch.
Seitenanzahl: 597 Seiten