Paul Barnhurst walks through Excel's new navigation pane, a feature designed to help users move around large workbooks more easily. It's especially useful for financial modeling and FP&A work where spreadsheets get complex and hard to navigate.
Paul Barnhurst, the FPA guy here. Today I'm going to share with you a new feature in Excel that I'm super excited for. It's the navigation pane. This is something we've been waiting for a long time and it's now out. If you're on a monthly update, you should have it. If you're on a semi annual, you may need to wait a few more months before you get it. But if you're on Office365, you want to look for it. So, you know, many of us have always struggled to work our way through a workbook, right? You can come down here and click on a sheet. But hey, if I want to go to the last sheet, you could come over, drag over and click on it. Or you could right click here and select a sheet and say that and it takes you to the sheet. Well, another thing many of us would do is we'd build a table of contents, which I would still encourage if you're adding a description. If you're not adding a description to each sheet, you can do away with the table of contents with this new feature. I'm going to show you in a minute here. All right, with the table of contents, I could click on Graph, I could put a link here to take me back if I wanted to my table contents, which is what I normally do is I'll click here and then each sheet I'd go back. So now what I'm going to show you is the new feature that basically works much like a table of contents in Excel. So what I'm going to do here is I'm going to go to View, I'm going to click Navigation, and you'll notice what came up is a navigation pane that has every single one of my sheets. So you'll see if I go to the beginning cover sheet, that's my first sheet. If I go to the end here, you'll notice.
Trust and Leadership Lessons for FP&A From 100+ Top Leaders with CFO Jon Laudie
