Excel 2013 VBA and Macros (MrExcel Library)
Product Description
Excel 2013 VBA and Macros (MrExcel Library)
<P style="MARGIN: 0px">SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS! </P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">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 style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">•  Get started fast with Excel 2013 macro development</P> <P style="MARGIN: 0px">•  Write macros that use Excel 2013 enhancements, including Timelines and the latest pivot table models</P> <P style="MARGIN: 0px">•  Work efficiently with ranges, cells, and R1C1-style formulas</P> <P style="MARGIN: 0px">•  Build super-fast applications with arrays</P> <P style="MARGIN: 0px">•  Write Excel 2013 VBA code that works on older versions of Excel</P> <P style="MARGIN: 0px">•  Create custom dialog boxes to collect information from your users</P> <P style="MARGIN: 0px">•  Use error handling to make your macros more resilient</P> <P style="MARGIN: 0px">•  Use web queries and new web service functions to integrate data from anywhere</P> <P style="MARGIN: 0px">•  Master advanced techniques such as classes, collections, and custom functions</P> <P style="MARGIN: 0px">•  Build sophisticated data mining and business analysis applications</P> <P style="MARGIN: 0px">•  Read and write to both Access and SQL Server databases</P> <P style="MARGIN: 0px">•  Control other Office programs–and even control Windows itself</P> <P style="MARGIN: 0px">•  Start writing Excel Apps similar to those in the Excel App Store</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px"> <B>About MrExcel Library: </B> Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks <BR>and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, <BR>Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will</P> <P style="MARGIN: 0px"> </P> <P style="MARGIN: 0px">•  Dramatically increase your productivity–saving you 50 hours a year or more</P> <P style="MARGIN: 0px">•  Present proven, creative strategies for solving real-world problems </P> <P style="MARGIN: 0px">•  Show you how to get great results, no matter how much data you have</P> <P style="MARGIN: 0px">•  Help you avoid critical mistakes that even experienced users make</P> <P style="MARGIN: 0px"> </P>
