Home > Topics > Business & Management > Business Applications

Business Applications

Titles

Just Released

Document Creation & Management Using Adobe Acrobat Pro (Video Course)
ChatGPT with Excel: Leverage ChatGPT for Data Success (Video)
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
Collect, Combine, and Transform Data Using Power Query in Power BI and Excel, 2nd Edition

See More Business Applications Titles

Articles

Tracy Syrstad

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.

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.

Bill Jelen

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.

Linda Rising

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.

See More Business Applications Articles