Chapter 12

Linking, Automating, and Sharing Spreadsheets

IN THIS CHAPTER

check Using Office and Excel Add-ins to automate and enhance Excel 2019

check Adding hyperlinks to other workbooks, worksheets, Office documents, web pages, or e-mail

check Creating and using macros to automate common spreadsheet tasks

check Sharing your worksheets on the web

check 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 2019.

It just so happens that Office and Excel Add-ins, hyperlinks, and macros represent major ways to make Excel worksheets more vigorous and versatile: add-ins through the extra features they give Excel 2019; hyperlinks through links to other worksheets, ...

Get Excel 2019 For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.