Microsoft Excel VBA and Macros

Tracy Syrstad has been deeply immersed in the world of Excel programming for 20 years, acquiring a comprehensive skillset largely through independent learning. VBA is more than just a programming language for her; it's a tool to unlock efficiency. Tracy's passion for empowering clients through automated projects and one-on-one Excel programming instruction extends beyond personal development. This hands-on experience, combined with her proven track record of authoring seven previous VBA books for Microsoft Press, equips her with the unique ability to translate complex Excel concepts into clear and engaging content for a broad audience.Bill Jelen is the host of MrExcel.com and the author of 67 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Microsoft Excel Inside Out. He was an ESPN commentator for the World Excel Championships, has made over 80 guest appearances on TV's Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He writes the Excel column for Strategic Finance magazine. He has produced over 2400 episodes of his video podcast Learn Excel from MrExcel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company.

• CHAPTER 1      Unleashing the power of Excel with VBACHAPTER 2      This sounds like BASIC, so why doesn’t it look familiar?CHAPTER 3      Referring to ranges, names, and tablesCHAPTER 4      Laying the groundwork with variables and structuresCHAPTER 5      Looping and flow controlCHAPTER 6      R1C1 style formulasCHAPTER 7      Event programmingCHAPTER 8      ArraysCHAPTER 9      Creating custom objects and collectionsCHAPTER 10   Userforms: An introductionCHAPTER 11   Data mining with Advanced FilterCHAPTER 12   Using VBA to create pivot tablesCHAPTER 13   Excel powerCHAPTER 14   Sample user-defined functionsCHAPTER 15   Creating chartsCHAPTER 16   Data visualizations and conditional formattingCHAPTER 17   Dashboarding with sparklines in ExcelCHAPTER 18   Reading from the web using M and VBACHAPTER 19   Text file processingCHAPTER 20   Automating WordCHAPTER 21   Using Access as a back end to enhance multiuser access to dataCHAPTER 22   Advanced userform techniquesCHAPTER 23   The Windows Application Programming Interface (API)CHAPTER 24   Handling errorsCHAPTER 25   Customizing the ribbon to run macrosCHAPTER 26   Creating Excel add-insCHAPTER 27   An introduction to creating Office Add-ins