Excel 2007 PivotTables Recipes: A Problem-Solution Approach



Debra Dalgleish “Excel 2007 PivotTables Recipes: A Problem-Solution Approach"
Apress | 2007-12-10 | ISBN:1590599209 | 272 pages | PDF | 2,9 Mb

Debra Dalgleish, Microsoft Office Excel MVP since 2001, and an expert and trainer in Excel, brings together a one-stop resource for anyone curious about representing, analyzing, and using their data with PivotTables and PivotCharts. You’ll find this book inimitable when facing any new or difficult problem in PivotTables, covering the entire breadth of situations you could ever encounter, from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting.
The author presents tips and techniques in this collection of recipes that can’t be found in Excel’s Help section, while carefully explaining the most confusing features of PivotTables to help you realize their powerful potential.
The chapters in this book have been organized into a collection of recipes to take you step by step from the problem you are experiencing to the solution you are aiming for. Without fuss, you’ll find clear and precise information to help you assess your situation, whether common or unique, and solve your problem. Working examples of complex PivotTables and numerous PivotTable programming examples will help you solve problems quickly, without the need to digest heavy content.

Designing Smart Homes: The Role of Artificial Intelligence



Juan Carlos Augusto, Chris D. Nugent “Designing Smart Homes: The Role of Artificial Intelligence"
Springer | 2006-07-28 | ISBN:354035994X | 183 pages | PDF | 3,3 Mb


The area of smart homes is fast developing as an emergent area which attracts the synergy of several areas of science. This volume offers a collection of contributions addressing how artificial intelligence (AI), one of the core areas of computer science, can bring the growing area of smart homes to a higher level of functionality where homes can truly realize the long standing dream of proactively helping their inhabitants in an intelligent way.

After an introductory section to describe a smart home scenario and to provide some basic terminology, the following 9 sections turn special attention to a particular exemplar application scenario (provision of healthcare and safety related services to increase the quality of life) exploring the application of specific areas of AI to this scenario.