Business Applications

10 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.

Three New Patterns for Organizational and Personal Change Apr 1, 2015 Linda Rising, co-author of More Fearless Change: Strategies for Making Your Ideas Happen, introduces some new patterns that can have an effect not just on cooperation among co-workers, but on how we live and interact with other people day to day.

Foreword, Preface, and Introduction to More Fearless Change: Strategies for Making Your Ideas Happen Mar 26, 2015 Mary Lynn Manns and Linda Rising introduce their book, More Fearless Change: Strategies for Making Your Ideas Happen, which covers techniques for implementing change in teams of all sizes, and demonstrates how to use these techniques effectively.

Preface to "Peopleware: Productive Projects and Teams, Third Edition" Jun 18, 2013 Tom DeMarco and Tim Lister describe the evolution of their idea that the solution to many of the problems facing software engineering teams wasn't technological - it was sociological. From its genesis during an overnight flight to Sydney to the latest empirical studies, the third edition of Peopleware continues to expand and build upon their original premise that technology is not always the solution to managerial problems.

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.

Creating User Feedback Forms Dec 23, 2003 Communicating with users is necessary if you want to create exciting applications that perform useful tasks. John Mueller discusses and demonstrates effective communication techniques to get constructive feedback that can keep you in touch with user needs.

Building Windows Applications in VB.NET Dec 5, 2003 In Visual Basic .NET, the technologies that enable you to create "standard" windows applications are part of the .NET Framework, available to any .NET language. This is a huge change from earlier versions of Visual Basic. Learn what's different -- and how you can take advantage of it.