Microsoft Applications

5 Items

Sort by Date | Title

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 Syrstad May 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.

Customizing an Excel 2013 Pivot Table Mar 12, 2013 This chapter covers six functional areas in making pivot table customization: Minor Cosmetic Changes, Layout Changes, Major Cosmetic Changes, Summary Calculations, Advanced Calculations, and Other (less common) Options.