TY - BOOK AU - Jelen,Bill TI - Excel 2013 VBA and Macros T2 - MrExcel Library SN - 9780789748614 U1 - 005.3 PY - 2014/// CY - Estados Unidos de América PB - Pearson KW - PROGRAMAS N1 - Factura Educativa; 1.- Unleash the power of excel with VBA 2.- This Sounds like BASIC, So Why Doesn't It Look Familiar? 3.- Referring to Ranges 4.- Looping and flow control 5.- R1C1-Style formulas 6.- Create and Manipulate Names in VBA 7.- Event Programming 8.- Arrays 9.- Creating Classes, Records, and Collections 10.- Userforms: An Introduction 11.- Data Mining with Advanced Filter 12.- Using VBA to Create Pivot Tables 13.- Excel Power 14.- Sample User-Defined Functions 15.- Creating Charts 16.- Data Visualizations and Conditional Formatting 17.- Dashboarding with Sparklines in Excel 2013 18.- Reading from and Writing to the Web 19.- Text file processing 20.- Automating Word 21.- Using Access as a Back End to Enhance Multiuser Access to Data 22.- Advanced Userform Techniques 23.- Windows API 24.- Handling Errors 25.- Customizing the Ribbon to Run Macros 26.- Creating Add-Ins 27.- An Introduction to Creating Apps for Office 28.- What Is New in Excel 2013 and What has Changed; Todas las carreras ER -