Discover timesaving features, accessibility and internal control approaches, data integrity improvements, and spreadsheet automation techniques by exploring Excel shortcuts and nuances in Microsoft 365, Excel versions till 2021Key FeaturesGet hands-on experience by carrying out techniques in detailed example workbooksReclaim portions of your day by immediately implementing data integrity and automation featuresIncorporate spreadsheet disaster r...

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...

The complete guide to Excel 2016, from Mr. Spreadsheet himselfWhether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implem...

If you think that getting creative with Excel means the underhanded tweaking of numbers, think again. Excel Hacks shows even the most experienced users how to do things with Excel they might never have thought of doing--and lets them have a little fun while they're at it.Microsoft Excel is not just the dominant spreadsheet in the world; it's also one of the most popular applications ever created. Its success lies not only in its power and flexibility, but also in its streamlined, ...

Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!Create macros to automate repetitive tasksAutomatically format charts, shapes, and textManipulate tables and other objects—even build PivotTable reportsWrite your own functions and proceduresUse lo...

You don’t have to be a techie to use FileMaker Pro 12, but you do need to know what you’re doing. With this crystal-clear guide, you’ll learn how to create a powerful database that lets you do almost anything with your data. Whether you’re running a business, printing a catalog, or planning a wedding, you’ll learn how to customize your database and put it to work.The important stuff you need to know:Get started. Tour FileMaker Pro’s features and creat...

In-depth guidance on Word 2010 from a Microsoft MVPMicrosoft Word 2010 arrives with many changes and improvements, and this comprehensive guide from Microsoft MVP Herb Tyson is your expert, one-stop resource for it all. Master Word's new features such as a new interface and customized Ribbon, major new productivity-boosting collaboration tools, how to publish directly to blogs, how to work with XML, and much more. Follow step-by-step instructions and best practices, avoid pitfalls,...

A nontechnical manual for groundbreaking technologyThe Complete Idiot's Guide® to Google Chrome OS presents readers with a clear overview of Google's free operating system—targeting users of netbook computers and allowing them to work primarily on the web—including how to send email, work with pictures, save and manage files, use common office applications as well as more specialized programs, and deal with problems.• Available day-and-dat...

Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables.Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel i...

The fast and easy way to get things done with OfficePerplexed by PowerPoint? Looking to excel at Excel? From Access to Word—and every application in between—this all-encompassing guide provides plain-English guidance on mastering the entire Microsoft Office suite. Through easy-to-follow instruction, you'll quickly get up and running with Excel, Word, PowerPoint, Outlook, Access, Publisher, Charts and Graphics, OneNote, and more—and make your work and home life easi...

Get to grips with a new technology, understand what it is and what it can do for you, and then get to work with the most important features and tasks. This book is a Starter which teaches you how to use Google Drive practically. This book is perfect for people of all skill levels who want to enjoy the benefits of using Google Drive to safely store their files online and in the cloud. It's also great for anyone looking to learn more about cloud computing in general. Readers are expected to ...

It's EASIER than ever to get started with Microsoft Office 2010!Navigate your way around the Microsoft Office 2020 suite without getting lost in too many details. Microsoft Office 2010 Demystified shows you the ropes and explains the new, handy, and most popular functions of each application.Written in a step-by-step, tutorial format, this practical guide begins with an overview of the suite and the universal features that can be used in all of the individual pro...