No one is better at revealing the secrets of Excel than "Mr. Spreadsheet" himself. This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic® for Applications. Excel 2007 has a few new tricks up its sleeve, and John Walkenbach helps you make the most of them all.

You'll learn to customize Excel UserForms, develop new utilities, use VBA with charts and PivotTables, and create event-handling applications. Work with VBA subprocedures and function procedures, facilitate interactions with other applications, build user-friendly toolbars, menus, and help systems, and much more. Get ready to make Excel do your bidding.

WiMAX Broadband Wireless Access Technology, based on the IEEE 802.16 standard, is at the origin of great promises for many different markets covering fixed wireless Internet Access, Backhauling and Mobile cellular networks. WiMAX technology is designed for the transmission of multimedia services (voice, Internet, email, games and others) at high data rates (of the order of Mb/s per user). It is a very powerful but sometimes complicated technique.

The WiMAX System is described in thousands of pages of IEEE 802.16 standard and amendments documents and WiMAX Forum documents. WiMAX: Technology for Broadband Wireless Access provides a global picture of WiMAX and a large number of details that makes access to WiMAX documents much easier. All the aspects of WIMAX are covered.

Featuring thirty-two pages of full-color examples, this guide is the perfect digital photography reference for serious amateurs as well as nonprofessional photographers who use a digital camera on the job.

Walks readers through the entire digital photography workflow, from shooting photos and editing them in the digital darkroom to cataloging, printing, and publishing images online.
Topics covered include selecting cameras, printers, and accessories; mastering basic digital camera techniques; getting great results when shooting sports, nature, landscapes, and people; and working with Photoshop and other image-editing and image-management software.
Features step-by-step tutorials, full-color before-and-after images, and a companion Web site with bonus sample images plus a mini take-along field guide that readers can print out.

With the XQuery 1.0 standard, you finally have a tool that will make it much easier to search, extract and manipulate information from XML content stored in databases. This in-depth tutorial not only walks you through the XQuery specification, but also teaches you how to program with this widely anticipated query language.

XQuery is for query writers who have some knowledge of XML basics, but not necessarily advanced knowledge of XML-related technologies. It can be used both as a tutorial, by reading cover to cover, and as a reference, by using the comprehensive index and appendixes. Either way, you will find the background knowledge in namespaces, schemas, built-in types and regular expressions that is relevant to writing XML queries. This book provides:

• A high-level overview and quick tour of XQuery
• Information to write sophisticated queries, without being bogged down by the details of types, namespaces, and schemas
• Advanced concepts for users who want to take advantage of modularity, namespaces, typing and schemas
• Guidelines for working with specific types of data, such as numbers, strings, dates, URIs and processing instructions
• A complete alphabetical reference to the built-in functions and types

You will also learn about XQuery's support for filtering, sorting, and grouping data, as well as how to use FLWOR expressions, XPath, and XQuery tools for extracting and combining information. With this book, you will discover how to apply all of these tools to a wide variety of data sources, and how to recombine information from multiple sources into a single final output result.

Whether you're coming from SQL, XSLT, or starting from scratch, this carefully paced tutorial takes you through the final 1.0 standard in detail.

Essential Silverlight teaches experienced .NET and ASP.NET developers how to add more interactive and graphically rich interfaces to their web applications using the new Microsoft Silverlight™ cross browser plug-in.

Concise: Essential Silverlight is a concise introduction to Silverlight 1.0 and Silverlight 1.1 that doesn't waste your time.
Always Up-to-Date: Essential Silverlight will be published initially as an eBook with a print-on-demand option when Silverlight 1.0 ships and will be updated each time Microsoft releases a new beta or release candidate for Silverlight 1.1 releases.
Day and date: The final edition of Essential Silverlight will be published when Silverlight 1.1 releases in 2008.
Expert author: Christian Wenz is author of Programming ASP.NET AJAX (O'Reilly, 2007) and numerous books on JavaScript in English and in German. He has written on all of the competing RIA technologies — - Flash, PHP, ActionScript, ASP.NET — and understands the market well.
Loaded with code: Essential Silverlight includes scores of tested examples readers can cut and paste for reuse in their own applications.
All code is available for download from O'Reilly.
Browser agnostic and platform aware: Essential Silverlight will cover all of the browsers supported by Silverlight (including IE, Firefox, Safari and Opera), and will also point out differences as they become known between the Windows and Mac OS platforms.

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks — clever tools, tips and techniques — that will leapfrog your work beyond the ordinary.

Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to:

• Reduce workbook and worksheet frustration — manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
• Analyze and manage data — extend and automate these features, moving beyond the limited tasks they were designed to perform.
• Hack names — learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
• Get the most out of PivotTables — avoid the problems that make them frustrating and learn how to extend them.
• Create customized charts — tweak and combine Excel's built-in charting capabilities.
• Hack formulas and functions — subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
• Make the most of macros — including ways to manage them and use them to extend other features.
• Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.

You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.

Create strange lands filled with mysterious objects (cows frozen in blocks of ice, chirping penguins, golden globes with wavering eyes) and throw away your keyboard and mouse, to go exploring armed only with a gamepad, power glove, or just your bare hands…

Java gaming expert Andrew Davison will show you how to develop and program 3D games in Java™ technology on a PC, with an emphasis on the construction of 3D landscapes. It's assumed you have a reasonable knowledge of Java - the sort of thing picked up in a first Java course at school.
Topics are split into three sections: Java 3D™ API, non-standard input devices for game playing, and JOGL. Java 3D is a high-level 3D graphics API, and JOGL is a lower-level Java wrapper around the popular OpenGL graphics API. You'll look at three non-standard input devices: the webcam, the game pad, and the P5 data glove.
Along the way, you'll utilize several other games-related libraries including: JInput, JOAL, JMF, and Odejava. Learn all the latest Java SE 6 features relevant to gaming, including: splash screens, JavaScript™ scripting as well as the desktop and system tray interfaces. Unique coverage of Java game development using both the Java 3D API and Java for OpenGL, as well as invaluable experience from a recognized Java gaming guru, will provide you with a distinct advantage after reading this book.

- Eight minibooks comprising nearly 900 pages give developers the tips and techniques they need to get up and running on the new J2SE 6 (Java Standard Edition 6) and JDK 6 (Java Development Kit 6).

- This friendly, all-inclusive reference delivers the lowdown on Java language and syntax fundamentals as well as Java server-side programming, with explanations, reference information, and how-to instructions for both beginning and intermediate-to-advanced programmers.

- Minibooks cover Java basics; programming basics; strings, arrays, and collections; programming techniques; Swing; Web programming; files and databases; and fun and games.

Completely Revised for the New 2007 Version of the CCNA Exam (#640-802)

Cisco networking authority Todd Lammle has completely updated this new edition to cover all of the exam objectives for the latest version of the CCNA exam. Todd’s straightforward style provides lively examples, easy-to-understand analogies, and real-world scenarios that will not only help you prepare for the exam, but also give you a solid foundation as a Cisco networking professional.

Packed with updated topics that have been added to the 2007 version of the CCNA exam, this updated study guide features expanded coverage of key topic areas plus new material on switching, network address translation, and OSPF. Inside, find the complete instruction you need, including:
Full coverage of all exam objectives in a systematic approach, so you can be confident you’re getting the instruction you need for the exam
Practical hands-on exercises and labs to reinforce critical skills,
Real-world scenarios that put what you’ve learned in the context of actual job roles
Challenging review questions in each chapter to prepare you for exam day
Exam Essentials, a key feature in each chapter that identifies critical areas you must become proficient in before taking the exam. 

Grid architecture is Oracles strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the distribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC.
Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes network configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.

* Focuses on implementing, testing and tuning features of Real Application Clusters (RAC) database
version 10g Release 2
* Provides extensive coverage of usage, day-to-day functions and operations
* Includes tips and techniques such as script samples
to illustrate various features of RAC
* A jumpstart into all the key features of 10g R2 RAC