Excel Portable Genius

Power up your proficiency with this genius guide to popular Microsoft 365 apps Do you want to make your Microsoft 365 account a productivity behemoth? Do you want to squeeze every last bit of awesome from Word, Excel, and PowerPoint and learn a little more about Outlook, too? Microsoft 365 Portable Genius has got you covered. A seasoned tech expert and trainer, author Lisa A. Bucki shows you how to build Word documents, Excel workbooks, and PowerPoint presentations the right way, as well as how to use high-impact design techniques to make your documents pop. This book answers 11 key questions about how to make the most of Microsoft 365, providing genius tips as it leads you through the essentials. You’ll learn how to: Tackle common skills like creating files, adding basic content, navigating in a file, making selections, copying and moving content, and saving files Build a new Word document by using outlining, bullets and numbering, columns, and other features for creating and enhancing content Enhance Excel workbook files by organizing data on different sheets, filling entries, creating range names, and entering powerful, accurate formulas Develop a PowerPoint presentation by choosing the right layout for each slide and adding content to placeholders, and then transform it into an on-screen show with transitions and animations Add punchy design and branding by using text formatting, themes, and graphics in your files Use lists, tables, and charts to make data easier to interpret Create, send, reply to, and organize email in Outlook, as well as add contacts Share file contents on paper or digitally Check out the Online Bonus Appendix at Wiley for more genius coverage of topics including additional Excel formula review techniques, essential Excel functions, theme colors and fonts changes, and WordArt Whether you have used Office in the past or are new to its subscription successor Microsoft 365, Microsoft 365 Portable Genius provides the expert guidance you need to work smarter in Microsoft 365.

Your genius-level guide to Excel excellence Excel Portable Genius covers the key features of Microsoft Excel in a concise, fast-paced, portable format that provides the perfect quick and easy-to-follow reference for novices and experienced users alike. Written by seasoned tech expert and trainer Lisa A. Bucki, it answers the nine key questions Excel users are most likely to face in their work and adds some hot tips and advice on this incredibly useful—but sometimes difficult-to-learn—program's lesser-known features. Build formulas to perform powerful calculations Format data to make it easy to find interpret and to highlight key results Sort and filter to organize or display specific information Chart data to pinpoint changes and identify trends Communicate results by printing and sharing Complete with a comprehensive index and extensive illustrations complementing straightforward instructions, this is the ideal guide to mastery of the world's most popular spreadsheet program.

Power up your proficiency with this genius guide to popular Microsoft 365 apps Do you want to make your Microsoft 365 account a productivity behemoth? Do you want to squeeze every last bit of awesome from Word, Excel, and PowerPoint and learn a little more about Outlook, too? Microsoft 365 Portable Genius has got you covered. A seasoned tech expert and trainer, author Lisa A. Bucki shows you how to build Word documents, Excel workbooks, and PowerPoint presentations the right way, as well as how to use high-impact design techniques to make your documents pop. This book answers 11 key questions about how to make the most of Microsoft 365, providing genius tips as it leads you through the essentials. You’ll learn how to: Tackle common skills like creating files, adding basic content, navigating in a file, making selections, copying and moving content, and saving files Build a new Word document by using outlining, bullets and numbering, columns, and other features for creating and enhancing content Enhance Excel workbook files by organizing data on different sheets, filling entries, creating range names, and entering powerful, accurate formulas Develop a PowerPoint presentation by choosing the right layout for each slide and adding content to placeholders, and then transform it into an on-screen show with transitions and animations Add punchy design and branding by using text formatting, themes, and graphics in your files Use lists, tables, and charts to make data easier to interpret Create, send, reply to, and organize email in Outlook, as well as add contacts Share file contents on paper or digitally Check out the Online Bonus Appendix at Wiley for more genius coverage of topics including additional Excel formula review techniques, essential Excel functions, theme colors and fonts changes, and WordArt Whether you have used Office in the past or are new to its subscription successor Microsoft 365, Microsoft 365 Portable Genius provides the expert guidance you need to work smarter in Microsoft 365.

Maximize your use of Apple's unique office productivity suite Dedicated Mac fans love the convenience and practicality of Numbers spreadsheets, Pages word processing, and Keynote presentations, the components of the iWork suite. This guide cuts to the chase, packed with tips and advice for getting the most from the newest version of these applications. It provides the basics on each application and how they work together, intermediate information, and cool ways to enhance your presentations and documents and create reports that analyze and interpret your data. The iWork productivity suite provides spreadsheet, word processing, and presentation applications that Mac users love; this guide helps you make the most of each one Presents the essential information about the newest version of iWork in addition to tips and more advanced advice for making Numbers, Pages, and Keynote produce exactly what you want Shows how to create compelling and lively presentations, use formulas and functions to generate reports, format a variety of documents, and much more iWork Portable Genius offers Mac aficionados the hip tips and tricks that maximize the power of the iWork suite.

A portable guide to the most-used features of iWork '09, Apple's office productivity suite Even in a down economy, Macs are enjoying increased popularity. iWork '09 provides an alternative to Microsoft Office. This guide covers the key skills, tools, and shortcuts to help you make the most of the iWork applications: keynote presentation software, pages for document creation, and the numbers spreadsheet program. Here are the tips and tricks that will help you work more efficiently and use all the features of iWork. iWork '09 Portable Genius gets straight to the point with the authoritative information Mac-savvy users want to know. And the handy portable size makes it easy to slip in your laptop case so it goes where you go. A full-color guide to the shortcuts and tips that let you maximize what you can do with iWork '09 Learn to edit, organize, and create documents using Pages; create stellar presentations with Keynote; and calculate and analyze data in Numbers Handy 6 x 9 trim size size fits in your MacBook case Designed for those who want to make the most of the Mac digital lifestyle Helps you take full advantage of Apple's office productivity suite With iWork '09 Portable Genius, you'll be able to do more with iWork than you ever imagined.

The Genius is in. You don't have to be a genius to switch from a PC to a Mac. But if you want to make the move with less hassle, put this savvy Portable Genius guide to work. Want to share data between your Mac and your PC? Understand the differences between Mac OS®X and Windows®? Learn how to perform everyday Mac tasks? Transfer important stuff like calendars, contact lists, and music? You'll find cool and useful Genius tips, full-color screenshots, and pages of easy-to-access shortcuts and tools that will save you loads of time and let you enjoy your Mac to the max. Paul McFedries is the president of Logophilia Limited, a technical writing company. He has written more than four dozen books that have sold more than two million copies worldwide. These books include Macs Portable Genius, Teach Yourself VISUALLY Macs, and Teach Yourself VISUALLY Windows Vista. Paul encourages all readers to drop by his Web site, www.mcfedries.com. Portable GENIUS Fun, hip, and straightforward, the new Portable Genius series gives forward-thinking Apple users useful information in handy, compact books that are easy to navigate and don't skimp on the essentials. Collect the whole series and make the most of your Apple digital lifestyle.

Make the most of your iPad with these savvy tips and techniques The iPad, iPad Air, and iPad mini are taking the world by storm. This no-nonsense guide covers everything you want to know to take full advantage of all your iPad has to offer. Along with necessary basics about the newest iPad; iPad Air, iPad mini; and iOS; it gives you smart; innovative ways to accomplish a variety of tasks and tips to help you maximize the convenience of your Apple digital lifestyle. More than 100 million iPads have been sold; and the number continues to grow Hip and practical; Portable Genius guides are packed with suggestions and tricks to help devotees of the Apple digital lifestyle get the most from their devices This guide includes tips and techniques you may not discover just by using your iPad; including creative ways to save time and effort Previous editions of this book have sold more than 74,000 copies iPad Portable Genius, 2nd Edition is the ultimate guide to a productive relationship with your iPad.

Shortcuts, tips, and tools for making the most of the new Mac OS X Lion Mac OS X Lion is the eagerly anticipated updated desktop operating system installed on every new Apple computer. Packed with the latest and greatest tips, tricks, and techniques for getting the most out of all that Lion has to offer, this handy guide is like having an Apple genius at your fingertips. Inside you'll find savvy advice on everything from simple tasks like getting started to intermediate-level information that covers how to use the coolest features of the new Mac operating system. Written in an authoritative and no-nonsense, yet approachable, tone, this book can go where you go so you can conveniently find invaluable insight and helpful tips, all aimed at making your Max OS X Lion experience as enjoyable as possible. Serves as an ideal guide for anyone eager to get started enjoying the new Mac OS X Lion to the max Shares shortcuts, tips, and tricks about Mac OS X Lion so that you can accomplish whatever task necessary Features a straightforward, no-nonsense writing style that skips the fluff and pares down to only the essentials Explains how to customize your computer and workspace, troubleshoot and maintain your Mac, listen to music and podcasts, manipulate images, copy music to an iPod, add a printer, and sync to other devices With this book by your side, you're well on your way to enjoying the new Mac OS X Lion to its fullest!