{"product_id":"excel-portable-genius-isbn-9781119763611","title":"Excel Portable Genius","description":"\u003cp\u003e\u003cb\u003eYour genius-level guide to Excel excellence\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003ci\u003eExcel Portable Genius\u003c\/i\u003e 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eBuild formulas to perform powerful calculations\u003c\/li\u003e \u003cli\u003eFormat data to make it easy to find interpret and to highlight key results\u003c\/li\u003e \u003cli\u003eSort and filter to organize or display specific information\u003c\/li\u003e \u003cli\u003eChart data to pinpoint changes and identify trends\u003c\/li\u003e \u003cli\u003eCommunicate results by printing and sharing\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eComplete 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.\u003c\/p\u003e \u003cp\u003eAcknowledgments vii\u003c\/p\u003e \u003cp\u003eIntroduction xiv\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 How Do I Start Using Excel? 2\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eStarting and Exiting Excel 4\u003c\/p\u003e \u003cp\u003eTaking a Look Around 5\u003c\/p\u003e \u003cp\u003eReviewing key screen features 5\u003c\/p\u003e \u003cp\u003eWorkbooks versus worksheets 8\u003c\/p\u003e \u003cp\u003eChanging views 8\u003c\/p\u003e \u003cp\u003eZooming 10\u003c\/p\u003e \u003cp\u003eWorking with Files 11\u003c\/p\u003e \u003cp\u003eCreating a blank file 11\u003c\/p\u003e \u003cp\u003eExploring templates 12\u003c\/p\u003e \u003cp\u003eOpening an existing file 13\u003c\/p\u003e \u003cp\u003eSwitching to another file 14\u003c\/p\u003e \u003cp\u003eMaking Your First Cell Entries 16\u003c\/p\u003e \u003cp\u003eMoving around the sheet 16\u003c\/p\u003e \u003cp\u003eText and values 17\u003c\/p\u003e \u003cp\u003eDates and times 19\u003c\/p\u003e \u003cp\u003eNumber formatting on the fly 20\u003c\/p\u003e \u003cp\u003eMaking Selections 21\u003c\/p\u003e \u003cp\u003eUnderstanding cells and ranges 22\u003c\/p\u003e \u003cp\u003eSelecting a range 22\u003c\/p\u003e \u003cp\u003eSelecting a row or column 23\u003c\/p\u003e \u003cp\u003eWorking with Sheets 24\u003c\/p\u003e \u003cp\u003eAdding, renaming, and jumping to a sheet 25\u003c\/p\u003e \u003cp\u003eMoving or copying a sheet 26\u003c\/p\u003e \u003cp\u003eSaving and Closing a File 27\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 How Do I Make Changes to My Sheet? 30\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCell Editing Basics 32\u003c\/p\u003e \u003cp\u003eMaking changes 32\u003c\/p\u003e \u003cp\u003eCommenting when editing 33\u003c\/p\u003e \u003cp\u003eClearing cell contents 33\u003c\/p\u003e \u003cp\u003eUsing Undo and Redo 34\u003c\/p\u003e \u003cp\u003eSpell-checking your work 35\u003c\/p\u003e \u003cp\u003eCopying or Moving a Range 35\u003c\/p\u003e \u003cp\u003eUsing Paste Special 37\u003c\/p\u003e \u003cp\u003eUsing Auto Fill and Filling Series 38\u003c\/p\u003e \u003cp\u003eInserting and Deleting Rows, Columns, and Cells 41\u003c\/p\u003e \u003cp\u003eCreating Range Names 44\u003c\/p\u003e \u003cp\u003eUsing the Name box 45\u003c\/p\u003e \u003cp\u003eUsing the New Name dialog box 46\u003c\/p\u003e \u003cp\u003eAssigning multiple range names at once 47\u003c\/p\u003e \u003cp\u003eDeleting a range name 48\u003c\/p\u003e \u003cp\u003eUsing Find and Replace 50\u003c\/p\u003e \u003cp\u003eFreezing Rows and Columns On-Screen 51\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 How Do I Add Up the Numbers with Formulas? 54\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEntering a Basic Formula 56\u003c\/p\u003e \u003cp\u003eTyping the formula 56\u003c\/p\u003e \u003cp\u003eCell and range references in formulas 57\u003c\/p\u003e \u003cp\u003eUsing the mouse to save time 58\u003c\/p\u003e \u003cp\u003eDealing with minor errors 60\u003c\/p\u003e \u003cp\u003eLearning More About Operators 60\u003c\/p\u003e \u003cp\u003eUnderstanding Order of Precedence 63\u003c\/p\u003e \u003cp\u003eHow order of precedence works 63\u003c\/p\u003e \u003cp\u003eUsing parentheses in formulas 64\u003c\/p\u003e \u003cp\u003eMaking a Cell or Range Reference Absolute Rather Than Relative 66\u003c\/p\u003e \u003cp\u003eChanging the reference type in a formula 66\u003c\/p\u003e \u003cp\u003eHow referencing works when filling, copying, or moving a formula 67\u003c\/p\u003e \u003cp\u003eShowing Formulas in Cells 69\u003c\/p\u003e \u003cp\u003eUsing Other Formula Review Techniques 70\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 When Do I Need to Include a Function? 72\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Functions 74\u003c\/p\u003e \u003cp\u003eUsing AutoSum on the Home or Formulas Tab 74\u003c\/p\u003e \u003cp\u003eTyping a Function in a Formula 77\u003c\/p\u003e \u003cp\u003eUsing the Formulas Tab to Insert a Function 79\u003c\/p\u003e \u003cp\u003eChoosing from the Function Library 79\u003c\/p\u003e \u003cp\u003eUsing Insert Function to find a function 82\u003c\/p\u003e \u003cp\u003eUsing Range Names in Formulas 83\u003c\/p\u003e \u003cp\u003eReviewing Some Essential Functions 84\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 How Do I Use Formatting to Enhance My Worksheet? 90\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChanging the Number or Date Format 92\u003c\/p\u003e \u003cp\u003eUsing number formats 94\u003c\/p\u003e \u003cp\u003eUsing date and time formats 96\u003c\/p\u003e \u003cp\u003eUsing special and custom formats 96\u003c\/p\u003e \u003cp\u003eChanging Cell Formatting 99\u003c\/p\u003e \u003cp\u003eApplying font formatting 100\u003c\/p\u003e \u003cp\u003eApplying alignment formatting 103\u003c\/p\u003e \u003cp\u003eWorking with Borders and Shading 105\u003c\/p\u003e \u003cp\u003eUsing Styles 107\u003c\/p\u003e \u003cp\u003eClearing Formatting 109\u003c\/p\u003e \u003cp\u003eUnderstanding Themes 109\u003c\/p\u003e \u003cp\u003eReviewing elements of a theme 109\u003c\/p\u003e \u003cp\u003eChanging themes 110\u003c\/p\u003e \u003cp\u003eChanging theme colors, fonts, and effects 111\u003c\/p\u003e \u003cp\u003eWorking with Column Width and Row Height 113\u003c\/p\u003e \u003cp\u003eUsing Conditional Formatting to Highlight Information 115\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 How Do I Use Graphics in Excel? 118\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eInserting Simple Graphics 120\u003c\/p\u003e \u003cp\u003eShapes 120\u003c\/p\u003e \u003cp\u003ePictures 122\u003c\/p\u003e \u003cp\u003eIcons 126\u003c\/p\u003e \u003cp\u003eSelecting and Formatting Graphics 127\u003c\/p\u003e \u003cp\u003eAdding text to shapes 128\u003c\/p\u003e \u003cp\u003eChanging styles 129\u003c\/p\u003e \u003cp\u003eChanging sizing and position 132\u003c\/p\u003e \u003cp\u003eWorking with layering, alignment, and rotation 134\u003c\/p\u003e \u003cp\u003eInserting WordArt 136\u003c\/p\u003e \u003cp\u003eCombining and Creating Your Own Graphics 138\u003c\/p\u003e \u003cp\u003eCreating and Working with SmartArt 141\u003c\/p\u003e \u003cp\u003eAdding a SmartArt graphic 141\u003c\/p\u003e \u003cp\u003eEditing and rearranging shapes 143\u003c\/p\u003e \u003cp\u003eChanging the graphic type and formatting 144\u003c\/p\u003e \u003cp\u003eDeleting a Graphic 145\u003c\/p\u003e \u003cp\u003eAdding a Background Image 146\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 How Do I Manage Lists of Information? 148\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eArranging a List in Excel 150\u003c\/p\u003e \u003cp\u003eCleaning Up Data 152\u003c\/p\u003e \u003cp\u003eUsing Flash Fill 152\u003c\/p\u003e \u003cp\u003eUsing Text to Columns 155\u003c\/p\u003e \u003cp\u003eRemoving duplicates and consolidating 157\u003c\/p\u003e \u003cp\u003eSorting, Filtering, and Subtotaling Lists of Information 159\u003c\/p\u003e \u003cp\u003eSorting and filtering a list 160\u003c\/p\u003e \u003cp\u003eSubtotaling a sorted list 162\u003c\/p\u003e \u003cp\u003eUnderstanding Excel’s Table Feature 163\u003c\/p\u003e \u003cp\u003eConverting a range to a table 164\u003c\/p\u003e \u003cp\u003eImporting or connecting to a list of data 166\u003c\/p\u003e \u003cp\u003eChanging table styles 168\u003c\/p\u003e \u003cp\u003eResizing a table 169\u003c\/p\u003e \u003cp\u003eRenaming a table 170\u003c\/p\u003e \u003cp\u003eSorting and Filtering a Table 170\u003c\/p\u003e \u003cp\u003eUsing Table Calculations 170\u003c\/p\u003e \u003cp\u003eAdding a calculated column 171\u003c\/p\u003e \u003cp\u003eAdding a total row 173\u003c\/p\u003e \u003cp\u003eConverting a Table Back to a Range of Regular Cells 174\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 How Do I Present My Data in Charts? 176\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCharts and Their Role in Your Workbooks 178\u003c\/p\u003e \u003cp\u003eChart Types 179\u003c\/p\u003e \u003cp\u003eCreating a Chart 180\u003c\/p\u003e \u003cp\u003eChanging the Chart Type and Layout 184\u003c\/p\u003e \u003cp\u003eFormatting Chart Elements 186\u003c\/p\u003e \u003cp\u003eChanging the Charted Data 189\u003c\/p\u003e \u003cp\u003eMoving a Chart to Its Own Sheet and Deleting a Chart 190\u003c\/p\u003e \u003cp\u003eUsing Special Charts: Sparklines, PivotTables, and Maps 192\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 How Do I Print and Share My Content? 194\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating Headers and Footers 196\u003c\/p\u003e \u003cp\u003eChanging Page Settings 199\u003c\/p\u003e \u003cp\u003eMargins 199\u003c\/p\u003e \u003cp\u003eOrientation and paper size 200\u003c\/p\u003e \u003cp\u003eScaling 201\u003c\/p\u003e \u003cp\u003eChanging Sheet Settings 201\u003c\/p\u003e \u003cp\u003eAdding print titles 201\u003c\/p\u003e \u003cp\u003eControlling whether gridlines and other features print 203\u003c\/p\u003e \u003cp\u003eWorking with Page Breaks 203\u003c\/p\u003e \u003cp\u003eSetting a print area 204\u003c\/p\u003e \u003cp\u003eViewing and moving breaks 204\u003c\/p\u003e \u003cp\u003ePreviewing a Printout and Printing 206\u003c\/p\u003e \u003cp\u003eOther Ways to Share Information 207\u003c\/p\u003e \u003cp\u003eExporting a PDF 208\u003c\/p\u003e \u003cp\u003eUsing OneDrive 209\u003c\/p\u003e \u003cp\u003eIndex 212\u003c\/p\u003e \u003cp\u003e\u003cb\u003eLisa A. Bucki\u003c\/b\u003e 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.\u003cbr\u003eFun, 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.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eTHE GENIUS IS IN.\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eYou don't have to be a genius to use Excel. But if you want to get the very most out of your worksheets, put this savvy \u003ci\u003ePortable Genius\u003c\/i\u003e guide to work and start ramping up the pace. Want to graph and chart data? Build powerful formulas? Import from databases? Sort and filter your data? You'll find cool and useful Genius tips, numerous screenshots, and pages of easy-to- access shortcuts and tools that will save you loads of time and let you enjoy Excel to the max.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989182365925,"sku":"NP9781119763611","price":19.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119763611.jpg?v=1761783119","url":"https:\/\/k12savings.com\/es\/products\/excel-portable-genius-isbn-9781119763611","provider":"K12savings","version":"1.0","type":"link"}