Office 2010 Training Course

Office 2010 is a broadly extensible platform for building Information Worker productivity solutions and developing for Office with Visual Studio 2010 makes this easy. The Office 2010 Training Course includes videos, presentations, hands-on labs and source code. This content is designed to help you get started developing solutions, from Add-ins to full featured Office Business Applications (OBAs), using Visual Studio 2010 with Office 2010 and SharePoint 2010 as the core platform.

Units in this course

• Getting Started with Office 2010 on Channel 9 This Channel 9 Learning Center is to help you in developing on the Office and SharePoint 2010 platform. We are excited to offer developers this on Channel 9 which complements the great content already available on MSDN and provides 200 to 300 level guidance. To start with, the content consists of video presentations with demos and presentation decks. Hands-on labs and source code with source code are also available. If you want to take the course offline, click the Download Training Kit button on this page and download the kit to your desktop.
• Office 2010 Developer Roadmap Developers can build applications and solutions for Office 2010 using a number of tools including Visual Studio 2010, SharePoint Designer 2010, InfoPath 2010 and Access 2010. With many new features, these tools help developers be more productive by providing greater flexibility in how they approach developing and deploying their solutions. This unit is a tour around the tools and services available to developers for building on the Office platform.
• Office UI Customization Developing for Office with Visual Studio is a deeply integrated experience. Project templates abound for almost every Office client application making it easy to quickly build Add-ins, Outlook Form Regions, extend the Ribbon and Backstage View and create Context Menus. All 2007 supported scenarios persist forward in Office 2010 as well. This unit provides an overview on what is available in Visual Studio 2010 for customizing Office.
• Office Client Workflow This unit provides an introduction to workflows, the processes that help solve business problems. Workflows can help manage interactions between information workers, automate tasks that were previously done manually and provide consistency for business processes. Here you will learn about workflows and the tools used to build them, Visio 2010, SharePoint Designer 2010 and Visual Studio.
• Security and Deployment Once you build your solution, you will want to deploy it appropriately. This unit introduces you to how to deploy your Office Add-ins and SharePoint applications and the roles that the end user and administrator play in each. Topics covered are security, SharePoint Solution (WSP) files, ClickOnce, Add-ins and Document Templates.
• Business Connectivity Services In SharePoint 2010 Business Connectivity Services (BCS) enables integration with back end systems. Business Connectivity Services includes a set of presentation features, a connectivity framework and tooling within SharePoint Designer and Visual Studio that enable developers and ITPros to connect to external data and services and to surface this data in SharePoint and Office 2010. This unit provides an overview of the BCS capabilities and usage in Office 2010.
• Developing BI Applications Business Intelligence (BI) applications help enterprise users make business decisions. This unit focuses on the SharePoint BI tools available for bringing information together for analysis, examination and collaboration with others to gain the decision making knowledge needed. The BI development tools available in SharePoint include status indicators, chart web parts, PerformancePoint Services, Excel Services, BI Search and Visio Services.
• Open XML The Open XML SDK is a powerful tool for processing Office documents. This unit provides an overview of the benefits and architecture of Open XML and the APIs and tools (on many different platforms) that a developer can use to build document-based solutions using this format. The Open XML SDK which is provided by Microsoft and other community-based developer resources are highlighted.
• Office 2010 Services The power of Word, Excel, Access and Visio Services come to light in this unit. A number of tasks can now be pushed to these server-side services for processing. For instance, you can convert your documents at scale into other formats, whether fixed (XPS, PDF) or fluid (RTF), using Word Services. And Access Web databases can be published to SharePoint via Access Services where Access tables become Lists, forms become ASPX pages, macros become workflows, etc.
• InfoPath 2010 and Forms Services InfoPath 2010 is a way for Information Workers, IT or Developers to create robust user interfaces for Office Business Applications. InfoPath provides a rich form design experience and InfoPath Forms Services can render these forms in the browser. This unit covers development of custom SharePoint List Forms and workflows, publishing InfoPath Forms and connecting external data to InfoPath Forms.
• Access 2010 For years, Microsoft Access has enabled developers to create database applications that address a specific business need, task, or process. In Access 2010, applications are now modern-looking right out of the box – no customization necessary. Access, through Access Services in SharePoint 2010, is now on the web – developers can create and share databases online. The web is also integrated within Access with mashup-type web functionality within Access applications. To use this new functionality, developers need to be aware of the differences among web databases, client-only databases, and hybrid databases. This unit introduces the developer to these concepts and to the new Access 2010 and Access Services through SharePoint 2010 functionality.
• Application Compatibility The Application Compatibility tools, the Office Environment Assessment Tool (OEAT) and Compatibility Inspector tool, available for Office 2010 help you to analyze your enviroment for installed add-ins and identify potential migration issues. Using this assessment information the migration process from earlier versions of Office to Office 2010 can be better planned. In the event migration of custom Add-ins or VBA is needed, the Compatibility Inspector tools can perform an analysis of the code and suggest potential issues. This video introduces these tools and how to use them to assess your environment and code.
• Core Office Development Visual Basic for Applications (VBA) and the Visual Basic Editor (VBE) have provided the programmability environment for power users and developers alike in the Office applications for many years. VBA remains a constant in Office 2010 and this module will help you get started with these tools if you have never used them before. And may give some new ideas to others for how to work with data, extend the UI or automate processes using these core Office assets.