Excel Portable Genius

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.

Lisa A. Bucki is an author, trainer, and content creator who's been educating others about computers and software since 1990. She's written dozens of books, provided marketing and training services to her clients, and written online tutorials. She is the co-founder of 1x1 Media.
Fun, hip, and straightforward, the Portable Genius series gives forward-thinking computer 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 digital lifestyle.

Acknowledgments vii

Introduction xiv

Chapter 1 How Do I Start Using Excel? 2

Chapter 2 How Do I Make Changes to My Sheet? 30

Chapter 3 How Do I Add Up the Numbers with Formulas? 54

Chapter 4 When Do I Need to Include a Function? 72

Chapter 5 How Do I Use Formatting to Enhance My Worksheet? 90

Chapter 6 How Do I Use Graphics in Excel? 118

Chapter 7 How Do I Manage Lists of Information? 148

Chapter 8 How Do I Present My Data in Charts? 176

Chapter 9 How Do I Print and Share My Content? 194

Index 212

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.