Spreadsheet school training courses in Detroit, MI (public, in-house or online)

This course presents both spreadsheet design concepts and hands-on experience in the use of
spreadsheet software and includes use of a worksheet with graphics and a database management
program. Students are required to integrate user-interface concepts, commands, worksheet mechanics,
and applications in a problem-solving environment. A version of Microsoft Excel is used.

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.