Feel the power of VBA and Excel

No one can uncover Excel’s hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user’s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you’re fairly new to Excel programming, here’s the foundation you need. If you’re already a VBA veteran, you can start mining a rich lode of programming ideas right away.

Everything you need to know about:

* Creating stellar UserForms and custom dialog box alternatives
* Working with VBA subprocedures and function procedures
* Incorporating event-handling and interactions with other applications
* Building user-friendly toolbars, menus, and help systems
* Manipulating files and Visual Basic® components
* Understanding class modules
* Managing compatibility issues

Beginning PivotTables in Excel 2007 explains what Pivot Tables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a Pivot Table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data.

• Carefully explains the benefits of using Pivot Tables for fast data analysis
• Provides a step-by-step approach to those new to Pivot Tables
• Offers tips and tricks that cannot be found elsewhere

What you’ll learn

• Summarize thousands of records in a Pivot Table with a few clicks of the mouse.
• Quickly change the Pivot Table layout to view a different summary of the data.
• Filter a Pivot Table to focus on one region or the top 10 products.
• Add colors or icons to highlight the high or low results.
• Use calculations to enhance the Pivot Table summaries.
• Create visual impact with a pivot chart.

First you'll learn how to build out your shared, virtual, or dedicated host. Then, you'll see how to build your applications for production and deploy them with one step, every time. Deploying Rails Applications will take you from a simple shared host through a highly scalable clustered and balanced setup with Nginx. See how to tell whether you've bought enough firepower, and learn how to optimize your Rails projects applications in a systemic, rational way. Take advantage of advanced caching techniques, and become and expert with the latest servers in Nginx and Mongrel. Don't worry. You'll get a dose of Apache too. Not only will you learn how to configure your production environment, you'll also see how to monitor it with free, automated tools that can restart your servers when the memory use gets too high for comfort. You'll see how to take a performance baseline, profile for bottlenecks, and solve the most common performance problems you're likely to see.

Ruby on Rails continues to build up a tremendous head of steam. Fueled by significant benefits and an impressive portfolio of real-world applications already in production, Rails is destined to continue making significant inroads in coming years. Each new Rails application showing up on the web adds yet more to the collective wisdom of the Rails development community. Yesterday's best practices yield to today's latest and greatest techniques, as the state of the art is continually refined in kitchens all across the Internet. Indeed, these are times of great progress.

The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer.

- Lightning–quick introduction to SQL Server 2008
- Written by top experts in the field
- Provides a solid grounding in key features and technologies