|May 5, 2016||Hyperlink
Back in the old days, when I used workpapers that were made with, you know, paper, I used a red pencil to create cross-references that made it easy to navigate to related documents. Today, I use Excel hyperlinks instead. Check out this CalCPA Technology and Business Resource Guide article where I describe how to use Excel hyperlinks to cross-reference digital files.
Excel is not what it used to be.
You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.
Want to learn Excel?
Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.
As a former auditor working in voluminous workpapers, I know what you mean with the red pencils and countless references. I enjoyed your detailed hyperlink instruction. I use them quite a bit now in large excel workbooks when there are multiple sheets and lots of data. I also like to “define names” for specific rows/columns to hyperlink directly to those locations. The fastest way from point A to point B is the most direct line!