Book + Content Update Program My Office 2016 introduces readers to this new version of the suite and shows them how to get the most out of the apps. The book clearly explains what to expect from the new version of Office, what the program limitations are, and discusses best practices for using the apps. My Office 2016 teaches readers how to use Word, Excel, PowerPoint, Outlook, Access, and OneDrive in an easy-to-follow, task-based format. Topics covered include how to use the main features that come with each Office application, how to synchronize documents between devices, and how to collaborate with others. • Master core skills you can use in every Office 2016 program • Quickly create visual documents with advanced formatting and graphics • Build complex documents with columns, footnotes, headers, and tables • Enter and organize Excel data more accurately and efficiently • Quickly move, copy, delete, and format large amounts of data with Excel ranges • Use charts to make data more visual, intuitively understandable, and actionable • Add pizzazz to PowerPoint slide shows with animations and transitions • Use Outlook 2016 to efficiently manage your email, contacts, and calendar • Bring all your ideas and notes together in a OneNote notebook • Start building useful Access 2016 databases • Customize your Office applications to work the way you do • Store and share your Office files in the cloud with Microsoft OneDrive • Collaborate with others, including people using other versions of Office In addition, this book is part of Que’s exciting new Content Update Program. As Microsoft updates features of Office 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP. How to access the free web edition: Follow the instructions within the book to learn how to register your book to access the FREE Web Edition.

Visual QuickStart Guides, designed in an attractive tutorial and reference format, are the quickest, easiest, and most thorough way to learn applications, tasks, and technologies. The Visual QuickStart Guides are a smart choice and guide the learner in a friendly and respectful tone. Visually presented with copious screenshots, the focused discussions by topic and tasks make learning a breeze and quickly take you to exactly what you want to learn. Microsoft Office 2011 for Macintosh: Visual QuickStart Guide, written by best-selling author Steve Schwartz, has been extensively rewritten to provide expanded coverage of the core Office applications: Word, Excel, PowerPoint, and Outlook, provides in-depth instructions on many of the new features and changes introduced in Office 2011, and offers a thorough introduction to the Office Web Apps. Coverage of each application is jam-packed with information and tips that not only explain HOW to perform a task, but WHY you need this procedure and WHEN it's best to use it. Table of Contents PART I: GETTING STARTED Chapter 1: Introducing Office 2011 Chapter 2: Office Basics Chapter 3: Working with Graphics PART II: MICROSOFT WORD Chapter 4: Introducing Word 2011 Chapter 5: Document Formatting Chapter 6: Text Formatting Chapter 7: Creating Tables Chapter 8: Working in Other Views Chapter 9: Other Word Features PART III: MICROSOFT EXCEL Chapter 10: Spreadsheet Essentials Chapter 11: Modifying Worksheets Chapter 12: Formulas and Functions Chapter 13: Working with Tables Chapter 14: Charts and Graphs Chapter 15: Database Techniques Chapter 16: Sharing Workbooks PART IV: MICROSOFT POWERPOINT Chapter 17: Creating a Presentation Chapter 18: Charts and Tables Chapter 19: Wrapping up a Presentation PART V: MICROSOFT OUTLOOK Chapter 20: Introducing Outlook Chapter 21: Email Chapter 22: Contacts Chapter 23: Calendar Chapter 24: Tasks Chapter 25: Notes Chapter 26: My Day Part VI: ADVANCED TOPICS Chapter 27: Combining Office Data Chapter 28: Office 2011 and the Internet Chapter 29: The Office Web Apps Index

At long last there is now a professional Excel course available for Mac users This book is only for the Apple Mac version of Excel 2016. (There's also an Excel for Windows version available (ISBN: 978-1-909253-08-7). This Excel 2016 for Mac book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel 2016 for Mac. Here are just five of the many ways in which this book is unique: The book will equip you with excellent Excel 2016 for Mac skills, good enough to impress any employer, but it doesn't confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Excel 2016 for Mac Expert Skills book. Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, Excel 2016 for Mac adult training courses. Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book).Each lesson has a sample file that models a real-world business problem. You'll immediately appreciate the value and relevance of each skill as it is taught. Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way. From the Back Cover Amongst other things you'll learn how to: Create stunning, professional, presentation-quality chartsUse the new Excel 2016 for Mac Cloud Computing features to share dataUnderstand absolute, relative and mixed cell referencesCreate stunning, professional, presentation-quality chartsUse the Themes feature to create visually excellent worksheets Use Sparklines to visually represent large data setsBring your data alive with VisualizationsCreate custom conditional formatting rules with the Rules ManagerCreate your own formulas with the Formula AutoComplete featureMaster Excel 2016 for Mac's Fluent User Interface and RibbonUnderstand the different Excel 2016 for Mac file formatsAdd a professional sheen to your work with 3-D ElementsUnderstand and work with three-dimensional worksheet groups Companies who have taken Smart Method courses include: AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, Marks & Spencer, Virgin, O2, BMW... and many, many others.

Beyond the Basics… Beneath the Surface…In Depth Do more in less time! Whatever your Microsoft Office experience, don’t let Office 2016 make you feel like a beginner! This book is packed with intensely useful knowledge, tips, and shortcuts you just won’t find anywhere else. It’s the fastest, best way to master Office 2016’s full power, and the great new features built into Word, Excel, PowerPoint, Outlook, Publisher, and OneNote. This friendly, expert guide will make you way more productive… whether you’re creating documents, analyzing data, delivering presentations, designing newsletters, taking quick notes, or managing your life! Take full advantage of Office 2016’s cloud integration Use Insights for Office to quickly access information Easily create complex Word documents, from books to mail merges Coauthor Word documents with collaborators in real time Build flexible, reliable Excel workbooks with formulas and functions Transform data into insight with Excel charts and PivotTables Discover best practices for creating great PowerPoint slides, handouts, and notes Take advantage of the new Tell Me Box, which provides access to contextual and traditional Office help features including the new Insights pane Use Outlook 2016’s Clutter feature to clear away low-priority email Create visually compelling documents of all kinds with Publisher 2016 Gather, organize, share, and use knowledge with OneNote 2016 Get more done faster by integrating OneNote with other Office 2016 components Discover Microsoft’s new mobile Word, Excel, and PowerPoint apps for Windows 10 All In Depth books offer Comprehensive coverage, with detailed solutions Practical, real-world examples with nothing glossed over or left out Troubleshooting help for tough problems you can’t fix on your own This book is part of Que’s Content Update Program. As Microsoft updates features of Office, sections of this book will be updated or new sections will be added to match the updates to the software. See inside for details.

Retain outstanding talent with a successful training and development program One of the best ways to retain great talent in your business is to deliver a strong training and development program—and this book gives you the tools to do just that. Featuring the latest strides in talent development, such as social learning, hybrid training, creating videos, and more, it arms you with everything you need to upskill employees to be more effective, productive, satisfied, and loyal. Develop a robust training and development program Foster a supportive and innovative work environment Use mentoring, coaching, and informal learning effectively Align learning to your organization’s needs Engage your employees with a motivating training program using the helpful guidance in Training & Development For Dummies!

Work, play, connect, and share with the ultimate tour to macOS 'X' macOS 'X' For Dummies is the ultimate tour guide to the Mac operating system, written by Bob "Dr. Mac" LeVitus himself! Whether you're upgrading your trusty old MacBook or venturing into new territory for the very first time, this easy to use guide will get you up and running quickly. It's all here: navigation, preferences, file management, networking, music and movies, and so much more. From the absolute basics to advanced techniques, this book shows you everything you need to know to turn your Mac into an extension of your brain. Concerned about security? Need to troubleshoot an issue? Want to make your Mac perform even better? Let Dr. Mac walk you through it with clear explanations and a little bit of humor. Read this book beginning-to-end for a complete tutorial, or dip in and out as needed when things take an unexpected turn; if you have macOS questions, Dr. Mac has the answers you need. macOS has powered Macs since 2001. Each free annual update improves the system's functionality, and typically offers a few new tools and fixes old issues. If you need to learn your way around this year's update quickly, easily, and thoroughly, this book is for you. Get organized and find your way around the interface Customize your Mac's look, "feel," and behavior Get connected, get online, and into the cloud Access your movies and music, back up your data, and more! Famous for its reliability and usability, macOS offers the sort of streamlined tools and operations you won't find anywhere else. macOS 'X' For Dummies helps you discover just how much your Mac can do for you.

Become a U.S. immigration wiz with this hands-on and practical guide to U.S. citizenship In U.S. Citizenship For Dummies, expert citizenship and ESL instructor Jennifer Gagliardi walks you through the ins and outs of the complicated process of obtaining citizenship in the United States. From preparing for test day to understanding the interview process and learning about recent changes to immigration laws, this book demystifies the legal process of transforming a foreign national into a citizen of the U.S. In this book, you’ll get: Up-to-date info on the various application and immigration forms you’ll need to complete to become a citizen Needed preparation for the all-important interview Complete coverage of the different visas and green cards available to foreign nationals and how you can qualify for them Whether you’re an immigrant-to-be who’s interested in becoming an American citizen, or you’re already a citizen but you want to bone up on U.S. history, government, and civics knowledge, U.S. Citizenship For Dummies is the perfect guide to the procedural and substantive knowledge you need to understand the American immigration system.