Spreadsheet school training courses in Columbus, OH (public, in-house or online)

Provides instruction in the use of electronic spreadsheet software in business applications. Students become proficient in creating and modifying spreadsheets in a business environment and in printing files that meet business standards. Topics include: spreadsheet concepts, data entry and modification, analyzing data, charts and graphs, formatting data and content and managing workbooks.

Using commercial spreadsheets, this course explores practical approaches to business modeling, emphasizing the needs of financial, retail, wholesale, service, publishing, or software concerns ranging in size from start-ups to global enterprises. Students learn to model costs, revenue, cash flow, plant and equipment requirements, and employee costs and productivity. In a term project of their design, students develop a business model and use it to study how a business responds to change. To simul...

Full archival course description>>

This course discusses the various approaches to credit risk modeling, including: CreditMetrics, the first available portfolio model for evaluating credit risk developed by JP Morgan; credit risk management framework introduced by Credit Suisse First Boston (CSFB); credit risk model developed by KMV Corporation (after Moody’s acquisition, it is called M-KMV); credit risk model namely ’CreditPortfolioView’ developed by McKinsey.

This is an online self study course that can be...

Full archival course description>>

Course Outcome

After completing Introduction to Microsoft Excel students will be equipped with a basic understanding of the following:

â–? Create spreadsheets using the Microsoft Excel program.

â–? Create, edit, save, and print worksheets.

â–? Build spreadsheets by formatting and charting.

â–? Enhance spreadsheets by formatting and charting.

â–? Develop spreadsheets within a Windows-based environment.

Recommended Prerequisites<...

Full archival course description>>

This is an intermediate level course in electronic spreadsheets. Students navigate spreadsheets more effectively, create macros, manage and analyze lists, link to other spreadsheets and external information on the World Wide Web, and build a Web page with pivot table functionality.