This short course surveys fundamental Microsoft Excel concepts and functionality applicable to SIPA courses and in professional settings. Topics include interacting with spreadsheets, understanding references and functions, writing formulas, building basic models, controlling formatting and presentation, and creating basic charts. The course is targeted at students with limited or no prior Excel experience.
This short course surveys fundamental Microsoft Excel concepts and functionality applicable to SIPA courses and in professional settings. Topics include interacting with spreadsheets, understanding references and functions, writing formulas, building basic models, controlling formatting and presentation, and creating basic charts. The course is targeted at students with limited or no prior Excel experience.
Prerequisites: Instructor-Managed Waitlist & Course Application.
This short course explores techniques that enable sophisticated problem solving and data analysis in Microsoft Excel. Topics include implementing advanced logic using complex formulas and intermediate calculations; managing complexity with Excel's auditing features; importing, parsing and cleaning raw data; pulling data together using lookup functions; and summarizing and analyzing data with conditional aggregate functions and PivotTables. This course does not focus on specific policy or financial applications, but instead explores general concepts and techniques that can be flexibly applied to different solutions in Excel.
This one-day seminar, conducted by Training The Street, explores best practices and efficient techniques for building finance-related spreadsheets.
The lectures will use a real company as a case study and direct participants to blend accounting, corporate finance, and Excel skills to create a dynamic, three-statement financial model. The completed product has five years of projections, three years of historical data, and supporting schedules, including working capital, debt, equity, depreciation, and amortization. Other advanced topics include understanding and controlling circularity errors, troubleshooting, sensitivity analysis, and discounted cash flow valuations.
The course is best suited for students with exposure to basic accounting and corporate finance concepts. It stresses efficiency in using Excel and awareness of common pitfalls when developing financial models.