From the course: Excel for Financial Planning and Analysis (FP&A)

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

FP&A applications with data tables

FP&A applications with data tables - Microsoft Excel Tutorial

From the course: Excel for Financial Planning and Analysis (FP&A)

Start my 1-month free trial Buy for my team

FP&A applications with data tables

“

- [Instructor] I mentioned in a prior video that one of the problems many FP&A professionals have is they spend too much time getting data teed up in the right way. Historically, business modelers had used all different kinds of tricks and hacks to get the data to fit. They'd use Excel functions like clean and trim and left and right and mid, and a whole assortment of other text functions to get it in the right form. Well, not anymore, what we can do is we can set up an output, a model, or a forecast or a graph, if you will, and use the dynamic data table as the intermediary, as I talked about previously. We can either bring the data in manually or we can import it with Power Query, as I talked about in a prior video. Then as we bring in new data, we can simply instruct the business model to look for the new data as we would like. Here, I'm going to show you two new ways of restructuring and importing raw data into a usable…

Contents