Finance Classes Dayton, OH

In this comprehensive Financial Modeling bootcamp, participants learn to master the advanced Excel, financial modeling, corporate finance, and accounting skills they need to succeed in various finance-related positions. This complete program covers advanced Excel for financial modeling, a crash course in finance and accounting, and a real-world financial modeling project, with essential topics including sensitivity analysis, financial functions, modeling shortcuts, financial statements, model drivers, and modeling assumptions. Tuition includes hands-on training, a free retake, and a training manual. The course has flexible scheduling options and is available online and in NYC.

In this comprehensive 5-day financial analyst program, participants will master Excel and finance concepts needed to succeed at top financial firms. Participants will learn how to value a company using a DCF model and will build a valuation model on a public company. Topics covered include core Excel skills, advanced Excel for financial modeling, accounting, corporate finance and valuation, and financial modeling. Tuition includes hands-on training, a free retake, and a course manual. The course has flexible scheduling options and is available online and in NYC.

This 1-day Microsoft Excel course is designed for individuals with some prior Excel experience but who are looking to build a career in finance and are excited to learn advanced Excel tools for financial analysis. There are a number of advanced topics and techniques covered in this course, including techniques to expedite workflow, advanced analytical tools and sensitivity analysis, database functions for finance, and functions for financial modeling. The course also incorporates three projects to help review and solidify the major topics covered throughout the course.

This 3-day financial modeling bootcamp has been designed for individuals looking to learn the fundamentals of corporate finance and accounting. Day one focuses on advanced Excel techniques for financial modeling and teaching students’ best practices with formula writing, short cuts, tools like Goal Seek and Scenario Manager, and advanced functions, including INDEX-MATCH, CHOOSE, and IFERROR. Day two centers on accounting and corporate finance topics, like Enterprise Value, Financial Statements, Discounted Cash Flow (DCF) models, sensitivity analysis, and leveraged buyouts. The third and final day dives deeper into advanced financial modeling and valuation topics and teaches students about how to perform company analysis, create financial projections, understanding terminal value, corporate valuations, as well as final analysis and reasonability testing.

This intensive five-day financial analyst bootcamp will equip students with the Excel skills and financial business acumen to launch a career as a financial analyst. The first section of this bootcamp centers around Excel fundamentals and introduces students to Excel basics like formulas, formatting, charts, and workbook best practices. The second section of the bootcamp exposes students to more intermediate topics in Excel, like working with text, LOOKUP functions, PivotTables, statistical functions, and combo charts. The third and final section of the bootcamp focuses on financial modeling and introduces students to advanced financial modeling techniques with Excel, covers key concepts in corporate finance and accounting, and explores in depth the best practices around financial modeling and valuation.

This course teaches the fundamentals of Microsoft Excel. Students attending this 1-day course will learn how to set up workbooks, enter and format data, create charts and graphs, and use formulas to perform calculations. Students will know how to work with multiple versions of Microsoft Excel, including the mobile app and online versions.

This 1-day course is intended to help beginners develop more advanced skills in Microsoft Excel. This intermediate program will teach students how to perform calculations, manage worksheet data, combine data from multiple sources, and analyze alternative data sets. Students will also learn how to collaborate with colleagues, track changes, and export workbooks.

Intermediate users of Microsoft Excel will learn advanced skills in this 1-day course. The topics covered include automation with macros, alternative datasets, and dynamic worksheets. Students will learn important principles of business intelligence data analysis, and how to create forecasts and visualizations. This course is delivered online with live instructors.

This 1-day program builds on foundational knowledge of Microsoft Excel. Students in this course will learn how to create advanced workbooks and worksheets and use them to create dashboards. The use of dashboards in Microsoft Excel will enable students to make business data more accessible, understandable and useful for decision-making.

In this three-day Microsoft Excel advanced course, participants add Microsoft BI techniques to their data analysis toolboxes. Excel is a compelling data presentation platform, and BI transforms seemingly unrelated bits of information into usable data. Specific course topics include data analysis, data modeling, importing information, formatting, and visualization.

Get to know Microsoft Excel in this one-day beginner course. Learn how to effectively sort, calculate, edit, analyze, update, and present information. Specific course topics include an Excel overview, basic calculations, worksheet modification and customization, publishing data, and multiple workbook management.

Go beyond basic Microsoft Excel skills in this one-day intermediate course. The curriculum focuses on advanced data analysis techniques and tools. Specific course topics include functions, lists, information analysis, and PivotTables, PivotCharts, and other advanced data mapping tools.

Take your Microsoft Excel skills to new heights in this one-day advanced course. Participants learn how to fully utilize this platform in order to work smarter as opposed to harder. Specific course topics include managing multiple workbooks, sharing and securing worksheets, automating repetitive tasks, forecasting data, using advanced formulas, creating sparklines, and mapping information.

This 2-day Microsoft PowerPivot workshop was designed to help Excel users learn the powerful data analysis skills capabilities using PowerPivot. The workshop covers a broad range of PowerPivot concepts and use cases, including PowerPivot basics, data visualization with PowerPivot and Power View, using calculations in pivot tables, advanced pivot table formatting, creating charts, manipulating PowerPivot data, creating PowerPivot reports, using the DAX functions, using Power View, and more.