Finance Classes Denver, CO

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 1-day introduction to Microsoft Excel teaches participants how to create, manage and work with spreadsheets. Throughout this experience, students will learn how to use Microsoft Excel to organize and analyze data. They will gain practice with writing formulas, creating tables, and presenting data in charts and reports.

Intermediate Microsoft Excel users can improve their skills with this 1-day program. This program explores the advanced editing tools of Excel, such as text-wrapping, borders, and effects. Students will learn how to adjust page layouts, insert page and section breaks, and handle multiple window views.

This 1-day program teaches experienced Microsoft Excel users how to leverage more advanced tools. This course teaches students how to use PivotTables to analyze data, trace precedents to understand cause and effect within the data, audit worksheets, and convert text. They will learn how to use macros to automate scripts and integrate Excel spreadsheets with other Microsoft Office tools.

This 1-day course gives a foundational understanding of Microsoft Excel. Students with novice computer skills will learn how to manipulate and organize data using Excel spreadsheets. They will also learn how to navigate the Excel interface, create, manage and save workbooks, and perform calculations. This program is available both face-to-face and with live online instruction.

In this 1-day course, students will learn how to use some of the more advanced features of Microsoft Excel. With online and in-person options, students will learn how to work with functions, lists, tables, conditional formatting, charts, and PivotTables. After completing this course, students will be able to leverage Excel’s capabilities to analyze and present data.

In this 1-day course, experienced users of Microsoft Excel can gain advanced skills. Students will learn how to work with multiple worksheets, use lookup functions, create and deploy macros, and use the goal seek feature. Completion of the program ensures that students can use Excel to forecast data and create sparklines.

This course in Microsoft Excel for Office 365 is designed to teach foundational skills in the use of this software. Students will learn the basic functions of Excel, as well as how to create workbooks, insert formulas, format text and numbers, and print workbooks. Graduates of this program will be prepared to sit for the Excel Associate certification exam.

This Excel course is a workshop intended to help individuals who know the fundamentals of Excel to take their skills to the next level. In this hands-on workshop, students will be able to polish and build their Excel capabilities to get one step closer to becoming a spreadsheet power user. Students in this workshop will review shortcuts and formula writing, review spreadsheet formatting best practices, and the basics of data structure and analysis. Students will also learn how to use VLOOKUP, PivotTables, and the logic behind absolute referencing.

This advanced Excel course is a 3-hour class designed for individuals who are comfortable working in Excel but want to learn more advanced functionality. In this hands-on class, students will be able to review and bolster their Excel capabilities to become a spreadsheet power user. Students in this course will walk away from this course with a more robust understanding of when and how to use VLOOKUPs and HLOOKUPs, the power of INDEX & MATCH, using PivotTables and PivotCharts, and how to record macros to automate repetitive tasks.

This Excel bootcamp is meant to give beginners an overview of Excel and a variety of functions you can use with Excel. Students will learn things like formatting techniques, mathematical formulas, PivotTables, charts, and more. This 4-hour Excel course is offered in-person in NYC or live online.

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.

This 3-day Excel bootcamp program will provide students with a hands-on learning experience to ensure they have the skills and confidence to work in spreadsheets like a seasoned professional. This course takes learners from beginner to expert user. In the beginner section, students learn the basics of working with spreadsheets and get introduced to formulas, charts, tables, hotkeys, and more. In the intermediate section, students take what they learned in the beginner section but develop those skills and are introduced to new skills, including LOOKUPs, PivotTables, data validation, and more. Finally, in the advanced section, students will build on what they learned in the first two sections while also learning advanced functions, like INDEX-MATCH, working with advanced PivotTable features, and students will learn how macros can help them automate simple tasks.