From the course: Excel for Financial Planning and Analysis (FP&A)
Join today to access over 23,700 courses taught by industry experts.
Implementing what you've learned - Microsoft Excel Tutorial
From the course: Excel for Financial Planning and Analysis (FP&A)
Implementing what you've learned
- [Carl] This brings us to the end. We've covered a lot together. You've discovered a lot more about the world of FP&A and how Excel plays a vital role. You've heard about how the technology market is changing, where Excel fits in, and where it doesn't. You've seen the many different approaches that you can use to implement dynamic functionality within Excel over to your work. We began with discussions and illustrations about dynamic tables. I shared with you how you can create them in just a few seconds and populate your data manually. I also showed you how you can leverage Microsoft's Power Query to populate dynamic tables with your backend data. We then went into discussions around dynamic ranges with SUMS, AVERAGES, MINIMUMS, and MAXIMUMS that you are in complete control of. Then we got into a wide array of dynamic functions, SUMIFS, MATCH and XMATCH, INDEX, INDIRECT, XLOOKUP, DATA, VALIDATION, CHOOSE OFFSET, and more.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.