MS Excel Programming

Duration: 2 days
Course description:
This course is designed to provide participants the knowledge to manipulate Excel and gives developers greater opportunities to create rich desktop applications for end users. An improved programming model gives easier access to office functionality allowing for the delivery of powerful custom desktop solutions.

Who would benefit:
All personnel using MS Excel

Working with Procedures and Functions.
Understanding Objects
Using Expressions
Variables and Intrinsic Functions
Controlling Program Execution
Working with Forms and Controls
Working with the PivotTable Object
Debugging Code
Handling Errors


Duration: 2 days
Course description:
ASP.NET is a web application framework developed by Microsoft to allow programmers to build dynamic websites, web applications and web services. It is built on the Common Language Runtime (CLR) and is the successor to Active Server Pages (ASP). This course provides participants with the knowledge and skills to create a fully functional Web application by using ASP.NET.

Who would benefit:
Web developers

Getting started with ASP.NET
Implementing a user interface with ASP.NET server controls
Displaying and manipulating data in ASP.NET
Creating responsive pages by using client-side technologies
Debugging and deploying ASP.NET applications
Writing ASP.NET applications for mobile devices


Duration: 2 days
Course description:
ADO.NET is a set of computer software components that programmers use to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. This course provides the knowledge and skills to design & build data-centric distributed applications by using ADO.NET

Who would benefit:
Platform developers

Data-Centric applications and ADO.NET
Connecting to data sources
Performing connected database operations
Building, binding, opening, and saving Data-SetsLab; manipulating DataSets
Reading and writing XML with ADO.NET

Advanced SharePoint Development

Duration: 5 days
Course description:
This course focuses on Windows SharePoint Services (WSS) Participants will learn how to assemble and configure business solutions by using and extending the portal and web content manage- ment features of MOSS as well as other server-side services such as the Business Data Catalog, Forms Services, Excel Services and Report Center.

Who would benefit:
Persons responsible for SharePoint customizations at core level

Custom authentication
SharePoint permissions
In Browser SharePoint customization
Basic SharePoint designer
Advanced SharePoint designer
Content types
Custom site definitions
Object model
Web services
SharePoint RPC
Web parts