Technology Column Gets an A

BY JOHN KEEGAN

Once again Technology Q&A discussed an Excel feature that previously I had noticed only in passing. My knowledge of hyperlinks was limited to guessing they had something to do with Web sites. After reading “ Create an Excel Contents Tab ” ( JofA , Aug.05, page 87) and playing with the menu for a few minutes, I much better understand the application of the feature. I had a similar experience with the discussion of conditional formatting (“Shade Alternating Rows or Columns,” page 88).

I live and breathe Excel in my daily work. However, it seems there often are features and tricks I had no knowledge of that may improve my work or make it more interesting. I get more information that directly affects me from this monthly column than the rest of the JofA . Keep up the great work.

John Keegan
Controller
Duferco Steel Inc.
Oakhurst, N.J.

RESOURCES

Keeping you informed and prepared amid the coronavirus outbreak

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.