In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best use. The course reviews the building-block functions, along with a few critical keyboard shortcuts that will speed up working with Excel data. It also covers how to perform advanced searching and data retrieval with LOOKUP functions, tabulate data with counting, statistical, and math functions, reformat data with text functions, and work with financial data using advanced formulas. Exercise files accompany the course.

Installing Apache, MySQL, and PHP with David Gassner describes how to install and perform the initial configuration of Apache, MySQL, and PHP, known as the AMP stack, on a local development computer. Chapters are devoted to multiple installation approaches: installing the components separately on both Windows and Mac, installing the pre-packaged Apache and MySQL distributions in WampServer on Windows and MAMP on Mac, and installing the cross-platform XAMPP on both Mac and Windows. Exercise files are included with the course.

In Color 1.5 Essential Training, colorist Robbie Carman details how to use Final Cut Studios dedicated color grading application to stylize projects and improve their look. Robbie explains the principles of color grading, discusses the color wheel and tonal range, and decodes color terminology for new users.
He shows how to prepare a Final Cut Pro project before sending it to color and how to use video scopes to evaluate a clip while making corrections. He provides information for new Color users as well as experienced colorists looking for whats new in this release.

Drupal Gardens Essential Training with Tom Geller demonstrates how to create and publish a complete web site with the powerful tools in Acquia's hosted service, Drupal Gardens. The course covers how to leverage its pre-built page layouts and add custom styling, without having to learn CSS, using the Theme Builder tool, how to integrate rich site features, such as forms, surveys, and media galleries, and how to push content to Twitter and Facebook. The course also shows how to transition a Drupal Gardens site to a self-hosted Drupal site.

In Adobe Connect Essential Training, author Tim Plumer, Jr. explains how to deliver and host interactive web meetings, webinars, and e-learning tutorials using Adobe Connect. The course covers the software's many tools for streamlining communication and engaging participants, such as the screen sharing, full-screen, and whiteboard features. Also included are tutorials on recording presentations, video conferencing, and using Connect with an iPhone or Android-based smartphone. Exercise files accompany the course.

In Excel 2010: Advanced Formatting Techniques, author Dennis Taylor shares simple and powerful tips for making spreadsheet information readable and understandable, from emphasizing specific cells to adding style and readability to worksheets. It also covers automation techniques that take the drudgery out of formatting even the largest amounts of data. Exercise files accompany this course.

YouTube is a revolutionary video-sharing platform that has facilitated broadcasts of user-generated content—hundreds of thousands of videos are uploaded every day. In YouTube Essential Training, author Jason Osder explores all the key concepts and techniques necessary to thrive on the site, including viewing, uploading, sharing, and tracking videos. The course covers building an account, sharing with social networks, and the fundamentals of shooting and editing film for a YouTube audience, as well as tips for creating a brand, removing compression artifacts, and analyzing video performance. Exercise files accompany the course.

In Word 2007: Mail Merge in Depth, author Gini Courter demonstrates how to take advantage of Word's Mail Merge feature to save a tremendous amount of time creating customized documents. The course offers tutorials on creating letters, emails, envelopes, and labels. It also shows how to use Mail Merge with Outlook and Excel, creating data sources, inserting fields, using IF and other rules for customized merges, and troubleshooting Mail Merge issues. Exercise files are included with the course.

In Visual Studio 2010 Essential Training, Author Walt Ritscher demonstrates how to develop full-featured applications targeting a variety of platforms. Starting with an overview of the integrated developer environment, the course covers working with code editors, navigating and formatting code, and deploying applications. Also included are tutorials on running performance and load tests, and debugging code. Exercise files accompany the course.

Lynda.com Home and Small Office Networking Interactive TutorialDo you have more than one computer in your home or small office? If you do, you need a network! Using the network, you can share a single internet connection between all your computers, transfer files with a few mouse-clicks rather than a pile of floppy disks, and work wirelessly with your laptop from anywhere in the room. You can also use your network for sharing printers, playing music, and vanquishing the enemy in multi-player online games.

In SQLite 3 with PHP Essential Training, Bill Weinman addresses all of SQLite’s major features in the context of the PHP environment. This course covers the fundamentals of SQLite, including a thorough overview of its unique data type system, expressions, functions, transactions, views, and event triggers. A functional CRUD application and web site testimonial engine are demonstrated, and a quick-start guide is included to get experienced developers up and running fast. Exercise files are included in the course.