Author Description

<p>SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS! </p> <p> </p> <p>Use <i>Excel</i>®<i> 2013 VBA and Macros</i> to automate virtually any routine task, and save yourself hours, days, maybe <br>even weeks. Then, learn how to make Excel do things you thought were simply impossible! You’ll discover macro <br>techniques you won’t find anywhere else and learn how to create automated reports that are amazingly powerful <br>and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues <br>can understand and act on it...how to capture data from anywhere, and <i>use</i> it anywhere...how to automate <br>Excel 2013’s most valuable new features. Mastering advanced Excel macros has never been easier. You’ll find <br>simple, step-by-step instructions, real-world examples and case studies, and 50 workbooks packed with bonus <br>examples, macros, and solutions–straight from MrExcel.</p> <p> </p> <p>• Get started fast with Excel 2013 macro development</p> <p>• Write macros that use Excel 2013 enhancements, including Timelines and the latest pivot table models</p> <p>• Work efficiently with ranges, cells, and R1C1-style formulas</p> <p>• Build super-fast applications with arrays</p> <p>• Write Excel 2013 VBA code that works on older versions of Excel</p> <p>• Create custom dialog boxes to collect information from your users</p> <p>• Use error handling to make your macros more resilient</p> <p>• Use web queries and new web service functions to integrate data from anywhere</p> <p>• Master advanced techniques such as classes, collections, and custom functions</p> <p>• Build sophisticated data mining and business analysis applications</p> <p>• Read and write to both Access and SQL Server databases</p> <p>• Control other Office programs–and even control Windows itself</p> <p>• Start writing Excel Apps similar to those in the Excel App Store</p> <p> </p> <p><b>About MrExcel Library: </b> Every book in the MrExcel Library pinpoi