Organizing Workbook Tabs in Excel Everyone knows that well-formatted Excel models look professional and instill confidence in the user. This may seem intuitive for a large analysis like your budget model, but what about a quick and simple one-time analysis? You have been asked by your boss to prepare a quick “back-of-the-envelope”...

Continue reading

Removing Phantom Excel Links If you have ever opened an Excel file and been prompted to update links to another file, yet you are certain that there are no links to any other files, your file may contain phantom links. To remove Phantom Links from a workbook, first check to make sure...

Continue reading

How to Reduce Excel File Size Did you ever wonder why your seemingly simple Excel file is so large (in terms of KB or MB) or why it seems “sluggish”? We recently received a file from a client who was frustrated because it was taking Excel way too long to open...

Continue reading

Excel’s “Double” F2 Key Everybody (well, almost everybody) knows that pressing the F2 key in Excel activates the “editing” mode for the active cell – the cursor goes into the cell so that you can change the contents, and the various cell references in that formula turn different colors. What many people...

Continue reading

Toggling Between Open Excel Files Using the CTRL + F6 Shortcut Many PC users know that Alt + Tab cycles through all the files and programs that are open on your computer. However, if you are working in Excel and you just want to toggle between all of your open spreadsheets,...

Continue reading

Help, I Am Lost in this Massive Excel File! A Short Guide to Hyperlinks in Excel Have you ever opened an Excel file and seen multiple tabs each containing multiple schedules? Did you start working through the file and find yourself frustrated going back and forth between different schedules and /...

Continue reading

Data Tables – How to Set Up and Troubleshoot One of Excel’s Most Powerful Tools The Data Table is one of the most powerful tools in Excel because it allows users to sensitize their data. However, Data Tables are also a frequent source of headaches for Excel users. This article describes...

Continue reading

Data Tables Part II – Building an Excel Data Table Across Worksheets This article will dive into more detail on one of the particular issues we identified within a previous resource, which is that Excel’s data table must be on the same worksheet as the original inputs being sensitized. Part I...

Continue reading

Top 5 Time-Saving Tips to Automate Excel Charts Data analysis, communication, and visualization continue to grow in importance and popularity. At TTS, Data Analysis and Communications with Excel, Power BI, and Python Training (Part 1 and Part 2) are among our fastest-growing, highest-demand courses, so it's important to learn and utilize time-saving tricks to...

Continue reading

Threaded Comments in Excel There have been a number of changes to Excel in the last couple of years that have greatly improved the software. One such improvement has been the changes to the Notes and Threaded Comments. The way Comments used to be in Excel In previous versions of Excel, users were...

Continue reading