Courses

Enter a term to search on in the box below.
ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data. ADO.NET cleanly factors data access from data manipulation into discrete components that can be used separately, or in tandem. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results. Those results can be presented to the database users in any number of ways. In this tutorial, Mark Long shows you, step by step, how to take advantage of ADO.NET's functionality to enhance your network's productivity.
course level image
programming image
vendor image
subscription image
Microsoft's ASP.NET is a free technology that provides programmers with the tools to create dynamic web applications. ASP.NET can be used to create solutions ranging from small, personal websites to enterprise-level web applications and web services. In this course, Microsoft Certified Trainer Mark Long teaches you the basics of ASP.NET 3.5 and show you how to use Microsoft's free Visual Web Developer to create your own ASP.NET 3.5 web applications.
course level image
programming image
vendor image
subscription image
C# is the Microsoft flagship programming language. It is a simple, powerful, type-safe, and object-oriented language. The many innovations of C# enable rapid application development while retaining the expressiveness and elegance of C-style languages. Since its introduction in the early 2000s as a competitor to Java, C# has steadily developed a very strong identity and is outpacing all competitors as a platform for mission critical applications. In this VTC course, author Mark Long will teach you how to program with C#. He will explain the language's features, quirks, and functionalities in a way that is easy to follow and understand. From simple variable declaration to understanding delegates and events, you'll learn a lot about developing with C#.
course level image
programming image
vendor image
subscription image
Microsoft Office is the foundation of most business computer systems; understanding its power and utilizing its productivity is crucial in today's environment. The Microsoft Certified Application Specialist (MCAS) certification is a series of performance-based exams of the Microsoft Office Suite. The exams focus on the use of these programs in a "real world" enviroment: Microsoft Office Word 2007, Excel 2007, PowerPoint 2007, Access 2007, Outlook 2007, and Windows Vista. Acquiring MCAS Certification places a candidate above the rest when searching for new positions and advancement opportunities. This course prepares you for MCAS exams 77-600 through 77-605 by teaching the skills you need to master in each of the programs to achieve the highest standards of performance and efficiency.
course level image
programming image
vendor image
subscription image
Though Microsoft Excel has been around for many years, Excel 2007 has an entirely new look and feel. Many new features have been added to improve productivity and workflow. In this in-depth VTC course, VTC Author Cheryl Brumbaugh-Duncan explores using Excel to create, manage, and analyze spreadsheet data. Users will learn to develop all the necessary worksheets and workbooks for financial and informational data, for a company that distributes healthy snacks to companies throughout a city. The course steps the participant through the various topics and skills needed to master Excel 2007 and provides a fun project for applying the new knowledge. Work Files are included.
course level image
business image
vendor image
subscription image
VTC's Microsoft Excel course is intended for users of all levels. Whether you are working on a simple spreadsheet or a complex analysis, it's all covered. Learn how to master the wide array of tools contained in Excel with efficiency, accuracy, and productivity. This course will help students master the art of spreadsheet design. You will learn formulas and functions, along with the database-oriented features such as pivot tables and filters. Learn about the new features of Excel 2010 and tips to increase the readability of your spreadsheets. Although taught using Excel 2010, this course is appropriate for all versions of Excel. Work files are included.
course level image
business image
vendor image
subscription image

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010.

course level image
business image
vendor image
cost range image
This VTC course will give you the knowledge and skills you need to get the most out of Microsoft Excel 2013. You will learn about the Excel interface by working in it. You will create and format worksheets, make calculations, create charts, and use tools to analyze data in meaningful ways. Author Helen Bradley teaches Excel from a business perspective, focusing on tools that maximize productivity and accuracy. She demonstrates how to design worksheets intelligently and then shows you how to check for accuracy to ensure that worksheets return correct results. She also covers automating data entry, testing formulas, and using PivotTables for data analysis. She concludes with a discussion of SkyDrive and the Excel WebApp.
course level image
business image
vendor image
subscription image

In this training course for Microsoft Excel 2013, expert training provider InfiniteSkills takes you through the basics of the worlds most popular spreadsheet software. Excel can be a complex and confusing program to use, but this course breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel or spreadsheets is required to get the most out of this Excel beginners video training. You will start with the absolute basics, creating and saving a new workbook. The course proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas. Once you are comfortable with the basics, you will move on to more advance formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas, and applying conditional formatting to your worksheet.

course level image
business image
vendor image
cost range image
VTC's Microsoft Excel Automation course is intended for intermediate and advanced users who wish to increase their efficiency, accuracy, and productivity. Students should have already completed Excel introduction courses or have equivalent knowledge. Created for all versions of Excel, this course will help students master the art of spreadsheet design and will provide comprehensive instruction in the automation and simplification of even the most complex data. Expanding upon our basic Excel courses, Lauri Matson explores the more advanced features of Excel such as VLookup functions, validation, pivot tables, analysis tools, charting, and more.
course level image
business image
vendor image
subscription image

Pages