From the course: Excel Spreadsheet Design: Extreme Makeover

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Working with shortcuts to unpack formulas

Working with shortcuts to unpack formulas - Microsoft Excel Tutorial

From the course: Excel Spreadsheet Design: Extreme Makeover

Start my 1-month free trial Buy for my team

Working with shortcuts to unpack formulas

“

- [Narrator] When working with Excel formulas, sometimes debugging can be quite tricky. I suggest having the exercise file open for this movie to follow along with me and start by unprotecting the worksheet. Okay, say that we're being quizzed on how the total of $56,320 has been derived. One way to answer this question might be to click on cell C11 and then review the formula. In fact, if we click in the formula bar here, Excel will actually show us what's feeding this cell. Now, please note that this will only work if the linked cells are on the same sheet. That's why the Assumptions!C6 aspect of this formula isn't visible here. So the only parts that are being highlighted are the cells that are linked from the same worksheet, being the summary worksheet. Okay, let's click on the Escape key on your keyboard and say that the questions keep coming about each cell and how they're being calculated. There are quite a few formulas on here, so it would be quite tedious to click on every…

Contents