Turn Excel into an unstoppable data-and number-crunching machineMicrosoft Excel is the Swiss Army knife of apps. With over 470 built-in functions and countless custom formulas, the program can help make you the smartest guy or gal in any room. And now that it's been supercharged with Copilot—Microsoft's AI-powered helper—it's even easier to produce accurate and useful results anywhere, anytime.Best of all, it doesn't take an advanced degree in mathematics o...

Get into the nitty gritty of Excel, the all-important spreadsheet toolMicrosoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organizing data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply advanced formulas and functions, create stunning data visualizations, build dashboards and reports, and automa...

If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works.Whether you use Access 2007 or an earlier version, this book will teach you new methods to q...

As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O'Reilly.This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to mast...

Develop cross-platform multimedia applications with HTML5Now you can create rich, interactive content in the browser and deploy it across all platforms. HTML5 Multimedia Developer's Guide shows you how. You'll learn to use the revolutionary new features of HTML5, including the native audio, video, and drawing elements that eliminate the need for third-party plug-ins. New tags, the simplified doctype, local data storage, drag-and-drop, and geolocation are also covered. De...

Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.Navigate with ease. Master Excel's tabbed toolbar and its new backstage viewPerform a va...

Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface. The once-simple toolbar has been packed with so many features over the years that few users know where to find them all. Microsoft has addressed this problem in Excel 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is ...

Adobe Acrobat X Classroom in a Book is the most thorough and comprehensive way for creative professionals and business users to learn how to deliver high-impact communications with next-generation Adobe Acrobat X. Each chapter in this step-by-step, project-based guide contains a project that builds on your growing knowledge of the program, while end-of-chapter review questions reinforce each lesson. This cross-platform (Mac and Windows) book shows you how to create high-quality PDF documen...

As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don't know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet.Analyzing Business Data with Excel shows you how to solve real...

This e-book will shows you the newer Excel’s basic and advanced features with tones of pictures and examples and in this way will help you to do your job quickly and more efficient. The presented examples are working under Excel 2010 for Windows and Excel for Mac 2011 too.We will discuss about:How to install Excel on Windows and MacMenu structure and the RibbonFormatting worksheetsWorking with formulasWorking with functions (math...

This collection represents the full spectrum of data-related content we’ve published on O’Reilly Radar over the last year. Mike Loukides kicked things off in June 2010 with “What is data science?” and from there we’ve pursued the various threads and themes that naturally emerged. Now, roughly a year later, we can look back over all we’ve covered and identify a number of core data areas:Data issues -- The opportunities and ambiguities of the data space are evident in discussions...

A comprehensive reference to the newest version of the world’s most popular spreadsheet application: Excel 2010John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel be...