Complete Guide to Excel 365: Pivot PowerPivot & Financial Modeling

In this course youll recognize how relational data – data with schema and clearly-defined column names – can be imported into Excel as a set of data tables. This data can be sliced-and-diced using classic Excel pivot tables or the more robust PowerPivot add-in. Now a standard part of Excel this add-in vastly expands the tools capabilities with some serious entity-relationship modeling and big data analysis. Excel has powerful capabilities to detect relationships across models and infer foreign key relationships between parent and child tables. Creating visualizing and modeling such relationships is an important aspect of working with relational databases. As youll recognize you can now accomplish much of that from within Excel using PowerPivot. In this course youll use some classic yet powerful worksheet functions that have ensured Excels use in Wall Street for decades. These functions can be used to compute the yield of a bond and the present and future values of a set of cash flows. They can also be used to perform complex operations on settlement dates and compounding rates of financial instruments.