Microsoft Applications

• The Next Step Beyond the Macro Recorder in VBA Programming
• Jan 5, 2016

Don’t rely solely on the macro recorder to teach you VBA programming; it’s meant only as an introduction, and you can’t rely on it for more advanced programming methods. Tracy Syrstad, co-author of Excel 2016 VBA and Macros, provides 10 macro recorder tips that will take your VBA programming skills up a level or two.

• Excel 2016 VBA and Macros: Referring to Ranges
• Dec 11, 2015

This chapter from Excel 2016 VBA and Macros shows you different ways of referring to ranges, such as specifying a row or column. You’ll also find out how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.

• Customizing Excel 2016
• Dec 9, 2015

This chapter from Excel 2016 In Depth walks you through examples of customizing the ribbon and discusses some of the important option settings available in Excel.

• Getting Data onto a Sheet in Excel 2013
• By Tracy SyrstadMay 13, 2013

This chapter provides tricks for copying down data, fixing entered data, and helping your users enter data correctly by providing a predefined list of entries for Excel 2013 users.