My Balance Sheet Doesn’t Balance: How to Balance Your Balance Sheet in 3 Easy Steps Have you ever been there?  It’s late at night, you’ve been slugging away at your model for days.  Now comes the pièce de résistance – it’s time to build the balance sheet and bring the model across...

Continue reading

Ensuring Consistent Excel Formulas In a previous TTS Resource, we discussed how to evaluate a formula with “Edit” mode, as well as with the F9 key. But what if you have already reviewed your formula for correct syntax and want to ensure consistent Excel formulas for other cells? This is where CTRL +...

Continue reading

Using Find & Select for Objects in Excel When we build large models for our consulting clients, we will typically include a navigation dashboard to allow the user to easily jump to various parts of the model with just a mouse click. These dashboards are constructed via hyperlinked shapes or text...

Continue reading

Closing Workbooks in Excel with Alt + F4 At Training The Street, we are strong advocates of using the keyboard for all things Excel. This includes the creation of new workbooks right up to and including the closing of these workbooks – or even the closing of Excel itself. Most people know...

Continue reading

Evaluating an Excel Formula with “Edit” Mode and the F9 Key Almost everybody knows that pressing the F9 key in Excel recalculates all of the worksheets within all of the workbooks that a user has open. What many people don’t know, however, is that F9 can also be used to understand...

Continue reading

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

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