Linking, Automating, and Sharing Spreadsheets
IN THIS CHAPTER
Using Office and Excel Add-ins to automate and enhance Excel 2016
Adding hyperlinks to other workbooks, worksheets, Office documents, web pages, or email
Creating and using macros to automate common spreadsheet tasks
Sharing your worksheets on the web
Editing your worksheets in a web browser with Excel Online
At your first reading of the chapter title, you might have the impression that this is just a catch-all, potpourri chapter, containing the last bits of program information that don’t fit anywhere else in the book. Actually, this is not the case because this chapter has a very definite theme, and that theme is how you go about extending the power of Excel 2016.
It just so happens that apps for Office, Excel add-ins, hyperlinks, and macros are four major ways to make Excel more vigorous and versatile: add-ins through the extra features they give Excel 2016; hyperlinks through links to other worksheets and Office documents; and web pages and macros through complex automated command sequences that you can play back whenever needed. And sharing your worksheets by attaching them to email messages or publishing them to the web as well as being able to edit them anywhere in the world using the Excel Online web application are all part of the new collaboration features that enable you to both communicate and collaborate more quickly and effectively.
Using Office Add-ins
Office Add-ins are small programs ...