Now that you got your feet wet learning the new features in Microsoft Excel 2007 in the first video series, Total Training for Microsoft Excel 2007: Essentials, you're ready to dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you'll be at ease learning some new techniques that will streamline your next data analysis project. Sit back and discover how to unleash the power of Excel with this in-depth video series.

Adam’s combination of real-world design experience, technical expertise, and training background make him an ideal InDesign CS3 software guide. In Part 1, he shows you how to navigate the new Adobe InDesign CS3 interface as well as all the paragraph, text, and character options available. In Part 2 you’ll learn how to insert Photoshop, Illustrator and PDF files into your work and how to create and transform shapes and effects. Plus, you’ll learn necessary skills for using color, working with layers, and preparing your designs for final output.

Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed!

Give your website a new look! Now is the time to give it a zap of creativity with animated objects and sound effects. Whether you are a web designer or game developer, you will learn the necessary techniques to get your project rolling. Discover how to design fun, creative, interactive websites through structured and easy to follow lessons. With help from a pro, you'll be able to expand your knowledge as you learn to utilize all of the amazing techniques with Adobe Flash CS3.

Running Time: 8.5 Hrs, 2 DVDs
Project Files: Included

Highlights

• Explore the wondrous capabilities of the Pen tool.
• Discover how to import existing materials from Adobe Photoshop and Illustrator.
• See how easy it is to work with Flash Video, plus create and control animations on the timeline.
• Create added interest with buttons and interactivity.
• Learn how to publish your new Flash Site to the web.

Get your digital assets in order with Microsoft Expression Media. Hosted by Nick Wilcox-Brown, this video series teaches you how to organize and catalog your entire library of digital files for easy retrieval and presentation. In addition, you'll learn how to rank and rate your files, add metadata and copyright information, and output your digital assets to an HTML gallery. Sorting out your files just got easier.

These self-guided lessons from Total Training help you increase your knowledge and understanding of Visual Studio. Whether you are looking to stay competitive or just keep up to date on the latest Microsoft technology, this series is your ticket to success. Get warmed up with some basics on building smart client and web applications, as well as exception handling, debugging and security considerations. See how you can rapidly build applications using the productivity features of Visual Studio 2005.

Lesson 1: The Many Ways to Design a Web Page (33:05 min)
1 Comparing the Sites Used in the Training
2 Getting Started with Site Setup
3 Visual Aids & Tips for Designing with Tables
4 Controlling Window Size
5 Introducing Guides & Navigation Tools
6 Status Bar, CSS Styles, & Layer Preferences
7 When to Use HTML Tags Instead of CSS
8 Accessibility & File Types/Editors Preferences
9 Customizing Your Favorite Objects

Lesson 2: Enhancing Dreamweaver® with Extensions (20:06 min)
1 Downloading Extensions from the Exchange Site
2 Creating a Slideshow Using an Extension
3 Updating the Remote Site to View the Slideshow
4 Adding Flash® Buttons Using an Extension

The host, Deke McClelland, provides more than eight hours of detailed instruction for advanced Photoshop topics including 16-bit support, HDR integration, tools for adding sharpness and removing blur and noise, as well as how to apply duotones, spot colors, and gradients. You'll also learn the new Vanishing Point and Smart Objects features.

Total Training for Microsoft ASP.NET 2.0 is the latest in Total Trainings DVD training series focusing on web development.  In this two DVD set, Andy Olsen walks the viewer through the development of ASP.NET web applications using C# and Visual Studio 2005.In order to build rich web experience, users are going to have to move away from traditional HTML web creation tools, and begin to incorporate database driven applications to build everything from a shopping cart to user generated content.  If you don’t know how to do that, the ASP.NET training series from Total Training may help.