Unleashing the power of Excel with VBA -- This sounds like BASIC, so why doesn't it look familiar? -- Referring to ranges -- Looping and flow control -- R1C1-style formulas -- Creating and manipulating names in VBA -- Event programming -- Arrays -- Creating classes and collections -- Userforms: an introduction -- Data mining with advanced filter -- Using VBA to create pivot ables -- Excel power -- Sample user-defined functions -- Creating charts -- Data visualizations and conditional formatting -- Dashboarding with Sparklines in Excel 2016 -- REading from and writing to the web -- Text file processing -- Automating Word -- Using Access as a back end to enhance a multiuser access to data -- Advanced userform techniques -- The Windows application programming interface (API) -- Handling errors -- Customizing the ribbon to run macros -- Creating add-ins -- An introduction to creating Office add-ins -- What's new in Excel 2016 and what's changed.
