Accelerating Excel 2010 with Windows HPC

Introduction

This two-day instructor-led course provides students with the knowledge and skills for learning basic concepts for driving HPC Services for Excel 2010; general information about the product and technology; use cases and performance expectations.

This training is targeted to educate partners on how to “speed up”, “parallelize” Excel 2010 workbooks and spreadsheets using the latest features in Office Excel 2010 and Windows HPC Server 2008 R2 to be launched in the Summer of 2010. Assist your customers with Monte Carlo simulation for risk analytics and other suitable scenarios in Financial Services and Energy trading in Oil & Gas industry verticals.

Audience

This course is intended for Domain Consultants, Technical Consultants and Architects who have skill with VBA development in Excel, and C#, C/C++ and .NET Development with Visual Studio.

Module 1: Introduction to High-Performance Computing and HPC Server 2008 R2

Lessons
  • Basic concepts: HPC Services for Excel 2010
  • General information about the product and technology
  • Use cases
  • Performance expectations

Module 2: Installation and Configuration

Lessons
  • Installation requirements & considerations
  • Architecture types and implications
  • HPC Services for Excel 2010 requirements
  • Install & configure a Windows HPC Server 2008 R2 cluster for HPC Services for Excel 2010
  • Configure a desktop workstation to utilize HPC/Excel Applications

Module 3: Capital Markets

Lessons
  • HPC Services for Excel 2010: Use Cases in the capital markets industry
  • Case Study: Multinational Investment Bank
  • Building a practice in the cap markets industry with HPC Services for Excel 2010

Module 4: HANDS-ON Workshop: Excel/VBA Development

Lessons
  • Converting an Excel workbook to use HPC Services for Excel 2010
  • Using the VBA framework for cluster calculation
  • End-to-end solution design

Module 5: Insurance Industry

Lessons
  • HPC Services for Excel 2010: Use Cases in the insurance industry
  • Case Study: Fortune 100 Insurance Concern
  • Building a practice in the insurance industry with HPC Services for Excel 2010

Module 6: HANDS-ON Workshop: Cluster Clients and Services

Lessons
  • Developing custom client applications for the HPC Cluster
  • Building Excel-based calculation services

Module 7: Solution Development

Lessons
  • Constructing and developing a practice with HPC Services for Excel 2010
  • Management and implementation
  • Customer/partner expectations
  • Solution lifecycle

Module 8: Best Practices

Lessons
  • Selecting a solution (workbook/UDF)
  • Calculating workbooks on the cluster
  • Cluster-enabled UDFs

Module 9: HANDS-ON Workshop: Cluster UDFs

Lessons
  • Developing cluster-enabled UDFs for Excel 2010
  • Modifying existing UDFs for the cluster
  • Running cluster-enabled UDFs