"In this day and age of 'too much information and not enough time, ' the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of." -Jerry Kohl, president of Brighton Collectibles Develop your Excel macro programming skills using VBA instantly with proven techniques Automate Reports Handle Errors Master Pivot Tables Produce Charts Build User-Defined Functions Migrate to Excel 2007 Query Web Data Build Dialog Boxes Use Data Visualizations Automate Word You are an expert in Excel, but the macro recorder doesn't work and you can't make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.

• Learn VBA syntax as easy-to-understand English
• Automate Excel's power tools: Pivot Tables, Charts, Advanced Filters
• Save hours per week by automating redundanttasks
• Create applications built on top of Excel with custom dialog boxes
• Automatically produce hundreds of Excel reports in seconds
• Understand how changes in Excel 2007 impact your VBA macros

Introduction 1 1 Unleash the Power of Excel with VBA 7 2 This Sounds Like BASIC, So Why Doesn't It Look Familiar? 29 3 Referring to Ranges 61 4 User-Defined Functions 75 5 Looping and Flow Control 101 6 R1C1-Style Formulas 121 7 What's New in Excel 2007 and What's Changed 135 8 Create and Manipulate Names in VBA 143 9 Event Programming 155 10 UserForms--An Introduction 177 11 Creating Charts 197 12 Data Mining with Advanced Filter 249 13 Using VBA to Create Pivot Tables 281 14 Excel Power 337 15 Data Visualizations and Conditional Formatting 373 16 Reading from and Writing to the Web 393 17 XML in Excel 2007 413 18 Automating Word 421 19 Arrays 441 20 Text File Processing 449 21 Using Access as a Back End to Enhance Multi-User Access to Data 461 22 Creating Classes, Records, and Collections 477 23 Advanced UserForm Techniques 493 24 Windows Application Programming Interface (API) 517 25 Handling Errors 529 26 Customizing the Ribbon to Run Macros 543 27 Creating Add-Ins 569 Index 577

Multimedia and its rich semantics are profligate in today s digital environment. Databases and content management systems serve as essential tools to ensure that the endless supply of multimedia content are indexed and remain accessible to end users. Methods and Innovations for Multimedia Database Content Management highlights original research on new theories, algorithms, technologies, system design, and implementation in multimedia data engineering and management with an emphasis on automatic indexing, tagging, high-order ranking, and rule mining. This book is an ideal resource for university researchers, scientists, industry professionals, software engineers and graduate students.

What is the influence of software systems on an organization's ability to create knowledge, learn, adapt to change and innovate? While organization, management and innovation theory has primarily focused on the impact of software on measures such as process efficiency and speed, this book argues that integrated systems and digital technologies offer even more fundamental implications for the innovating firm. A series of detailed case studies provides the foundations for a deeper theoretical and empirical understanding of the nature and dynamics of software, knowledge, organization and their complex interactions. The author demonstrates how software induces the radical reconfiguration of organizational knowledge and learning dynamics, including an organization's ability to create, store, transfer and integrate knowledge across heterogeneous organizational boundaries. The book provides a unique perspective on what organizations know and how they use that knowledge to build, sustain and renew their capabilities. This includes understanding how information systems can be designed or implemented in such a way as to favour innovation and adaptation, and to prevent unfavourable patterns of behaviour. The book represents an in-depth and systematic attempt to characterize the fundamental influence of software over the processes that underpin an organization's ability to create and manage knowledge. Scholars and students interested in innovation, technological change and information technology, and managers in software and other hi-tech industries will find this an insightful and highly rewarding study.

Although gaming was once primarily used for personal entertainment, video games and other similar technologies are now being utilized across various disciplines such as education and engineering. As digital technologies become more integral to everyday life, it is imperative to explore the underlying effects they have on society and within these fields. Exploring the Cognitive, Social, Cultural, and Psychological Aspects of Gaming and Simulations provides emerging research on the societal and mental aspects of gaming and how video games impact different parts of an individual's life. While highlighting the positive, important results of gaming in various disciplines, readers will learn how video games can be used in areas such as calculus, therapy, and professional development. This book is an important resource for engineers, graduate-level students, psychologists, game designers, educators, sociologists, and academics seeking current information on the effects of gaming and computer simulations across different industries.

In just the last few years, the visualization industry has arguably become the fastest-growing 3D industry and may soon overtake all others in total number of users. Just as the use of computer-aided design became the norm for nearly all architectural, engineering, and construction firms in the 1990s, 3D visualizations have become standard practice today. Autodesk (R) 3ds Max (R) is a powerful and versatile 3D software package that requires a thorough understanding in order to use it effectively. 3D Modeling Using Autodesk 3ds Max With Rendering View considers the challenges of learning 3ds Max (R), focuses on the critical aspects of the program needed to produce stunning architectural visualizations, and discusses some of the fastest and most efficient ways to accomplish tasks. Covering a range of topics such as camera rendering and standard light effects, this reference work is ideal for researchers, academicians, scholars, practitioners, industry professionals, instructors, and students.

NEW MEDIA THEORY Series Editor, Byron Hawk 327 pages, including photographs, bibliography, and index. (c) 2012 by Parlor Press AVATAR EMERGENCY is Gregory L. Ulmer's fourth book featuring the EmerAgency, an online virtual consultancy for the digital age. This time his point of departure is Paul Virilio's Generalized Accident from which he develops and theorizes the new concepts of Flash Reason, and specifically Avatar, which serves as the site for electrate identity formation in the twenty-first century. I have taught Ulmer's work on electracy for years, and his theoretical sophistication as well as the practical ambition and applicability of his work never ceases to amaze me. With Avatar Emergency, Ulmer shows once again that he is at the top of his game; I am positively thrilled to share this new and very timely treasure trove of a book with my students. -JAN RUNE HOLMEVIK, author of Inter/Vention: Free Play in the Age of Electracy Ulmer advances a ratio: "Avatar is to electracy what 'self' is to literacy, or 'spirit' to orality." He explores this "emergent logic through the invention of concept avatar." He begins, urgently, by asking: "What might wisdom be today, upon what authority might it be grounded, . . . what vision of well-being?" Perpetually asking the questions, Ulmer searches for "a vital anecdote" as an antidote to the "internet accident" by way of "flash reason." He claims, "Within this frame I present, in the genre of Mystory Internet Invention], what I have come to understand about living, my decision to become a professor of the Humanities and the lifestyle embraced as part of that choice." He invites his readers, thereby, to discover their own Mystory (mystery). Their own wisdom. After all, he explains: "Concept avatar must be not only understood, but undergone." My advice: Undergo the book -VICTOR J. VITANZA, author of Negation, Subjectivity, and the History of Rhetoric and Sexual Violence in Western Thought and Writing: Chaste Rape GREGORY L. ULMER is Professor of English and Media Studies at the University of Florida, where he teaches courses in Hypermedia, E-Lit, and Heuretics. He is also the Joseph Bueys Chair in the European Graduate School, Saas-Fee, Switzerland. Ulmer's books include Applied Grammatology (1985), Teletheory (1989), Heuretics (1994), Internet Invention (2003), Electronic Monuments (2005), and Miami Virtue (2011

Educational games facilitate players experiences, meet desired pedagogical objectives, and allow users to engage in learning while enjoying themselves. These educational games also give learners immediate feedback on their actions and decisions, inviting exploration and experimentation. Student Usability in Educational Software and Games: Improving Experiences explores new models of interaction and human-computer interaction paradigms as applied to learning environments. It focuses on the usability design and evaluation of learning systems and educational game environments. An excellent resource for experts in these fields, this research volume will help professionals, educators, and researchers improve their understanding of student experiences using learning-gaming environments.

The fall of 2016 saw the release of the widely popular First World War video game Battlefield 1. Upon the game's initial announcement and following its subsequent release, Battlefield 1 became the target of an online racist backlash that targeted the game's inclusion of soldiers of color. Across social media and online communities, players loudly proclaimed the historical inaccuracy of black soldiers in the game and called for changes to be made that correct what they considered to be a mistake that was influenced by a supposed political agenda. Through the introduction of the theoretical framework of the 'White Mythic Space', this book seeks to investigate the reasons behind the racist rejection of soldiers of color by Battlefield 1 players in order to answer the question: Why do individuals reject the presence of people of African descent in popular representations of history?

Technological tools have enhanced the available opportunities and activities in the realm of e-business. In organizations that support real-time business-critical operations, the proper use and maintenance of relevant technology is crucial. Maximizing Information System Availability Through Bayesian Belief Network Approaches: Emerging Research and Opportunities is a pivotal book that features the latest research perspectives on the implementation of effective information systems in business contexts. Highlighting relevant topics such as data security, investment viability, and operational risk management, this book is ideally designed for managers, professionals, academics, practitioners, and students interested in novel techniques for maintaining and measuring information system availability.

At the heart of Apple's hugely popular iLife software suite-iMovie, iPhoto, iDVD, GarageBand, and iTunes-is QuickTime, the powerful media engine that drives elegant applications for managing movies, images, and audio files. The enduring success of QuickTime is in no small part attributable to its component architecture. This key feature has allowed it to embrace emerging digital media technologies and standards one by one as they have appeared over the 12 or so years since its launch. None of the competing technologies even comes close, let alone on both Mac OS X and Windows.
QuickTime for .NET and COM Developers is the first guide to QuickTime for developers using popular RAD tools such a Visual Basic .NET, C#, and Visual Basic 6. A general introduction to QuickTime is followed by a detailed explanation of the QuickTime architecture from a.NET and COM perspective, liberally accompanied by code snippets. A number of implementation examples illustrate key QuickTime features, ranging from a simple movie player to a sophisticated interactive application. Also covered is QuickTime scripting in both QuickTime Player (using Windows Scripting) and in Microsoft Office applications (using VBA). Brief guides to developing with QuickTime in Delphi and ATL/WTL are also included.
Part of the official "Quicktime Developer Series," publishing the finest books on QuickTime in cooperation with Apple.
* The first book on QuickTime for .NET and COM application and scripting developers
* Written by one of the architects of Apple's QuickTime ActiveX/COM control
* Offers numerous sample applications and code examples

Kansei Engineering and Soft Computing: Theory and Practice offers readers a comprehensive review of kansei engineering, soft computing techniques, and the fusion of these two fields from a variety of viewpoints. It explores traditional technologies, as well as solutions to real-world problems through the concept of kansei and the effective utilization of soft computing techniques. This publication is an essential read for professionals, researchers, and students in the field of kansei information processing and soft computing providing both theoretical and practical viewpoints of research in humanized technology.

The first wave of Overwatch cinematics captured the imagination of millions of fans around the world. After the game released in 2016, Blizzard Entertainment embarked on a new mission to take cinematic storytelling to the next level. From the intense, action-packed rush of "Shooting Star" to the somber, noble ethos of "Honor and Glory," the creative team wanted to highlight a different side of the game's beloved heroes. In pursuit of their objectives, the crew added new artists in the mix, devised novel methods for making movies, and ventured into formats they hadn't tried before, such as in-game cinematics and stop-motion animation. Covering all the official Overwatch cinematics made from 2017-2020, including the Overwatch 2 announcement trailer, The Cinematic Art of Overwatch: Volume II showcases hundreds of pieces of never-before-seen artwork and documents the epic creative journey that Blizzard took to bring these films to life.

Expectations - of life, work, education, and so forth - are rooted in cultural values. As a result, access to an engagement with online learning is a culture-bound experience.Cases on Cultural Implications and Considerations in Online Learning illustrates ways in which to reach and engage learners across cultures by using online learning that accommodates cultural differences and preferences. This casebook helps online educators understand what cultural expectations their students have before they create online programs and tailor their instructional designs for multicultural and international learners.

Free/Open Source Enterprise Resource Planning systems (FOS-ERP) are gaining popularity and acceptance due to two main factors: their lack of licensing fees and customizability. Given this, organizations are able to easily adopt and manipulate these systems to meet their individual needs. Free and Open Source Enterprise Resource Planning: Systems and Strategies unites research on FOS-ERP, comparing differences with proprietary Enterprise Resource Planning products, and demonstrating key research factors. It includes cases demonstrating how small enterprises have benefited from FOS-ERP in Spain and in Belgium, along with difficulties encountered and solutions developed. This essential reference addresses key issues such as security and legal risks, as well as challenges, opportunities, and barriers to adoption.

The Web has metamorphosed into a powerful vehicle for the development and delivery of new, emergent products and services, creating vast implications for organizational strategies. E-Novation for Competitive Advantage in Collaborative Globalization: Technologies for Emerging E-Business Strategies highlights new business products, services, strategies, and philosophies drawn from an emerging collaborative information platform. This book explores connections between the development of new e-business technologies with users and consumers, existing and new businesses, and links to social and political visions and strategies.

The expectations of IT outsourcing in the delivery of strategic, economic, and technological benefits have drastically increased over the last decade. Although private companies and governments across the globe are involved in outsourcing arrangements, managing relationships and measuring performance still remains an issue. ""Managing IT Outsourcing Performance"" provides a unique collection of methodologies and tools useful in managing relationships and task execution to help in developing successful IT outsourcing interactions. A valuable compilation for a wide audience of managers and developers, this leading reference collection enables researchers to examine current issues and allows managers to improve outsourcing relationships.