Spreadsheet school training courses in Bellevue, NE (public, in-house or online)

BTS 151 Spreadsheet Applications: Formulas & Functions . 1 CR
Develops and creates a workbook with formulas and functions using spreadsheet software. Prerequisite: BTS 161 or equivalent experience recommended.
BTS 152 Spreadsheet Applications: Charts & Formatting . 1 CR
Develops Workbooks and creates and modifies charts using spreadsheet software. Prerequisite: BTS 161 or equivalent experience recommended.
BTS 153 Spreadsheet Applications: Data Lists & Pivot Tables . 1 CR
Dev...

Full archival course description>>

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.