Excel Portable Genius

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 viiIntroduction xivChapter 1 How Do I Start Using Excel? 2Starting and Exiting Excel 4Taking a Look Around 5Reviewing key screen features 5Workbooks versus worksheets 8Changing views 8Zooming 10Working with Files 11Creating a blank file 11Exploring templates 12Opening an existing file 13Switching to another file 14Making Your First Cell Entries 16Moving around the sheet 16Text and values 17Dates and times 19Number formatting on the fly 20Making Selections 21Understanding cells and ranges 22Selecting a range 22Selecting a row or column 23Working with Sheets 24Adding, renaming, and jumping to a sheet 25Moving or copying a sheet 26Saving and Closing a File 27Chapter 2 How Do I Make Changes to My Sheet? 30Cell Editing Basics 32Making changes 32Commenting when editing 33Clearing cell contents 33Using Undo and Redo 34Spell-checking your work 35Copying or Moving a Range 35Using Paste Special 37Using Auto Fill and Filling Series 38Inserting and Deleting Rows, Columns, and Cells 41Creating Range Names 44Using the Name box 45Using the New Name dialog box 46Assigning multiple range names at once 47Deleting a range name 48Using Find and Replace 50Freezing Rows and Columns On-Screen 51Chapter 3 How Do I Add Up the Numbers with Formulas? 54Entering a Basic Formula 56Typing the formula 56Cell and range references in formulas 57Using the mouse to save time 58Dealing with minor errors 60Learning More About Operators 60Understanding Order of Precedence 63How order of precedence works 63Using parentheses in formulas 64Making a Cell or Range Reference Absolute Rather Than Relative 66Changing the reference type in a formula 66How referencing works when filling, copying, or moving a formula 67Showing Formulas in Cells 69Using Other Formula Review Techniques 70Chapter 4 When Do I Need to Include a Function? 72Understanding Functions 74Using AutoSum on the Home or Formulas Tab 74Typing a Function in a Formula 77Using the Formulas Tab to Insert a Function 79Choosing from the Function Library 79Using Insert Function to find a function 82Using Range Names in Formulas 83Reviewing Some Essential Functions 84Chapter 5 How Do I Use Formatting to Enhance My Worksheet? 90Changing the Number or Date Format 92Using number formats 94Using date and time formats 96Using special and custom formats 96Changing Cell Formatting 99Applying font formatting 100Applying alignment formatting 103Working with Borders and Shading 105Using Styles 107Clearing Formatting 109Understanding Themes 109Reviewing elements of a theme 109Changing themes 110Changing theme colors, fonts, and effects 111Working with Column Width and Row Height 113Using Conditional Formatting to Highlight Information 115Chapter 6 How Do I Use Graphics in Excel? 118Inserting Simple Graphics 120Shapes 120Pictures 122Icons 126Selecting and Formatting Graphics 127Adding text to shapes 128Changing styles 129Changing sizing and position 132Working with layering, alignment, and rotation 134Inserting WordArt 136Combining and Creating Your Own Graphics 138Creating and Working with SmartArt 141Adding a SmartArt graphic 141Editing and rearranging shapes 143Changing the graphic type and formatting 144Deleting a Graphic 145Adding a Background Image 146Chapter 7 How Do I Manage Lists of Information? 148Arranging a List in Excel 150Cleaning Up Data 152Using Flash Fill 152Using Text to Columns 155Removing duplicates and consolidating 157Sorting, Filtering, and Subtotaling Lists of Information 159Sorting and filtering a list 160Subtotaling a sorted list 162Understanding Excel’s Table Feature 163Converting a range to a table 164Importing or connecting to a list of data 166Changing table styles 168Resizing a table 169Renaming a table 170Sorting and Filtering a Table 170Using Table Calculations 170Adding a calculated column 171Adding a total row 173Converting a Table Back to a Range of Regular Cells 174Chapter 8 How Do I Present My Data in Charts? 176Charts and Their Role in Your Workbooks 178Chart Types 179Creating a Chart 180Changing the Chart Type and Layout 184Formatting Chart Elements 186Changing the Charted Data 189Moving a Chart to Its Own Sheet and Deleting a Chart 190Using Special Charts: Sparklines, PivotTables, and Maps 192Chapter 9 How Do I Print and Share My Content? 194Creating Headers and Footers 196Changing Page Settings 199Margins 199Orientation and paper size 200Scaling 201Changing Sheet Settings 201Adding print titles 201Controlling whether gridlines and other features print 203Working with Page Breaks 203Setting a print area 204Viewing and moving breaks 204Previewing a Printout and Printing 206Other Ways to Share Information 207Exporting a PDF 208Using OneDrive 209Index 212