{"product_id":"teach-yourself-visually-excel-2016-isbn-9781119074731","title":"Teach Yourself VISUALLY Excel 2016","description":"\u003cb\u003eSee your way to Excel spreadsheet stardom with this visual guide\u003c\/b\u003e \u003cp\u003eIf you're always hearing about the cool things Excel can do, here's your chance to \u003ci\u003esee\u003c\/i\u003e how to do them!\u003ci\u003eTeach Yourself Visually Excel\u003c\/i\u003e offers you a straightforward visual approach to working with the newest version of the world's leading spreadsheet program. Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time! \u003c\/p\u003e\u003cp\u003eExcel can seem daunting, but with \u003ci\u003eTeach Yourself Visually Excel\u003c\/i\u003e, you'll quickly and painlessly learn how to perform dozens of tasks, including creating spreadsheets and charts, filtering and sorting data, working with PivotTables, and so much more. Covering the latest additions and changes to the newest version of Excel, a series of easy-to-follow, full-color tutorials helps you to excel at working with Excel! \u003c\/p\u003e\u003cul\u003e \u003cli\u003eTutorials and step-by-step screenshots make lessons easy to follow and understand\u003c\/li\u003e \u003cli\u003eHelps you grasp the basic functions of Excel—and beyond\u003c\/li\u003e \u003cli\u003eWalks you through Excel s new features\u003c\/li\u003e \u003cli\u003eClearly demonstrates how to organize, present, analyze, and chart data with Excel\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eWhether you've never used Excel or just need to brush up on its new features, \u003ci\u003eTeach Yourself Visually Excel\u003c\/i\u003e will be the dog-eared resource you'll turn to again and again. \u003c\/p\u003e\u003cp\u003e\u003cb\u003eChapter 1 Working with Ranges\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSelect a Range 4\u003c\/p\u003e \u003cp\u003eFill a Range with the Same Data 6\u003c\/p\u003e \u003cp\u003eFill a Range with a Series of Values 8\u003c\/p\u003e \u003cp\u003eFlash Fill a Range 10\u003c\/p\u003e \u003cp\u003eMove or Copy a Range 12\u003c\/p\u003e \u003cp\u003eInsert a Row or Column 14\u003c\/p\u003e \u003cp\u003eInsert a Cell or Range 16\u003c\/p\u003e \u003cp\u003eDelete Data from a Range 18\u003c\/p\u003e \u003cp\u003eDelete a Range 20\u003c\/p\u003e \u003cp\u003eHide a Row or Column 22\u003c\/p\u003e \u003cp\u003eFreeze Rows or Columns 24\u003c\/p\u003e \u003cp\u003eMerge Two or More Cells 26\u003c\/p\u003e \u003cp\u003eTranspose Rows and Columns 28\u003c\/p\u003e \u003cp\u003eSelect and Enter Data Using Touch Gestures 30\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Working with Range Names\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Benefits of Using Range Names 34\u003c\/p\u003e \u003cp\u003eDefine a Range Name 36\u003c\/p\u003e \u003cp\u003eUsing Worksheet Text to Define a Range Name 38\u003c\/p\u003e \u003cp\u003eNavigate a Workbook Using Range Names 40\u003c\/p\u003e \u003cp\u003eChange a Range Name 42\u003c\/p\u003e \u003cp\u003eDelete a Range Name 44\u003c\/p\u003e \u003cp\u003ePaste a List of Range Names 46\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Formatting Excel Ranges\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChange the Font and Font Size 50\u003c\/p\u003e \u003cp\u003eApply Font Effects 52\u003c\/p\u003e \u003cp\u003eChange the Font Color 54\u003c\/p\u003e \u003cp\u003eAlign Text Within a Cell 56\u003c\/p\u003e \u003cp\u003eCenter Text Across Multiple Columns 58\u003c\/p\u003e \u003cp\u003eRotate Text Within a Cell 60\u003c\/p\u003e \u003cp\u003eAdd a Background Color to a Range 62\u003c\/p\u003e \u003cp\u003eApply a Number Format 64\u003c\/p\u003e \u003cp\u003eChange the Number of Decimal Places Displayed 66\u003c\/p\u003e \u003cp\u003eApply an AutoFormat to a Range 68\u003c\/p\u003e \u003cp\u003eApply a Conditional Format to a Range 70\u003c\/p\u003e \u003cp\u003eApply a Style to a Range 72\u003c\/p\u003e \u003cp\u003eChange the Column Width 74\u003c\/p\u003e \u003cp\u003eChange the Row Height 76\u003c\/p\u003e \u003cp\u003eWrap Text Within a Cell 78\u003c\/p\u003e \u003cp\u003eAdd Borders to a Range 80\u003c\/p\u003e \u003cp\u003eCopy Formatting from One Cell to Another 82\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Building Formulas\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Excel Formulas 86\u003c\/p\u003e \u003cp\u003eBuild a Formula 88\u003c\/p\u003e \u003cp\u003eUnderstanding Excel Functions 90\u003c\/p\u003e \u003cp\u003eAdd a Function to a Formula 92\u003c\/p\u003e \u003cp\u003eAdd a Row or Column of Numbers 94\u003c\/p\u003e \u003cp\u003eBuild an AutoSum Formula 96\u003c\/p\u003e \u003cp\u003eAdd a Range Name to a Formula 98\u003c\/p\u003e \u003cp\u003eReference Another Worksheet Range in a Formula 100\u003c\/p\u003e \u003cp\u003eMove or Copy a Formula 102\u003c\/p\u003e \u003cp\u003eSwitch to Absolute Cell References 104\u003c\/p\u003e \u003cp\u003eHide the Formula Bar or Ribbon 106\u003c\/p\u003e \u003cp\u003eTroubleshoot Formula Errors 108\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Manipulating Worksheets\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eNavigate a Worksheet 112\u003c\/p\u003e \u003cp\u003eRename a Worksheet 113\u003c\/p\u003e \u003cp\u003eCreate a New Worksheet 114\u003c\/p\u003e \u003cp\u003eMove a Worksheet 116\u003c\/p\u003e \u003cp\u003eCopy a Worksheet 118\u003c\/p\u003e \u003cp\u003eDelete a Worksheet 120\u003c\/p\u003e \u003cp\u003eChange the Gridline Color 122\u003c\/p\u003e \u003cp\u003eToggle Worksheet Gridlines On and Off 124\u003c\/p\u003e \u003cp\u003eToggle Worksheet Headings On and Off 125\u003c\/p\u003e \u003cp\u003eSet the Worksheet Tab Color 126\u003c\/p\u003e \u003cp\u003eSet the Worksheet Background 128\u003c\/p\u003e \u003cp\u003eZoom In on or Out of a Worksheet 130\u003c\/p\u003e \u003cp\u003eSplit a Worksheet into Two Panes 132\u003c\/p\u003e \u003cp\u003eHide and Unhide a Worksheet 134\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Dealing with Workbooks\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreate a New Blank Workbook 138\u003c\/p\u003e \u003cp\u003eCreate a New Workbook from a Template 140\u003c\/p\u003e \u003cp\u003eSave a Workbook 142\u003c\/p\u003e \u003cp\u003eOpen a Workbook 143\u003c\/p\u003e \u003cp\u003eArrange Workbook Windows 144\u003c\/p\u003e \u003cp\u003eFind Text in a Workbook 146\u003c\/p\u003e \u003cp\u003eReplace Text in a Workbook 148\u003c\/p\u003e \u003cp\u003eCheck Spelling and Grammar 150\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Formatting Workbooks\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModify the Workbook Colors 154\u003c\/p\u003e \u003cp\u003eSet the Workbook Fonts 156\u003c\/p\u003e \u003cp\u003eChoose Workbook Effects 158\u003c\/p\u003e \u003cp\u003eApply a Workbook Theme 160\u003c\/p\u003e \u003cp\u003eAdd a Workbook Header 162\u003c\/p\u003e \u003cp\u003eAdd a Workbook Footer 164\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Importing Data into Excel\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding External Data 168\u003c\/p\u003e \u003cp\u003eImport Data from a Data Source 170\u003c\/p\u003e \u003cp\u003eImport Data from an Access Table 172\u003c\/p\u003e \u003cp\u003eImport Data from a Word Table 174\u003c\/p\u003e \u003cp\u003eImport Data from a Text File 176\u003c\/p\u003e \u003cp\u003eImport Data from a Web Page 180\u003c\/p\u003e \u003cp\u003eImport Data from an XML File 182\u003c\/p\u003e \u003cp\u003eRefresh Imported Data 184\u003c\/p\u003e \u003cp\u003eSeparate Cell Text into Columns 186\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Printing Workbooks\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdjust the Workbook Margins 190\u003c\/p\u003e \u003cp\u003eChange the Page Orientation 192\u003c\/p\u003e \u003cp\u003eInsert a Page Break 193\u003c\/p\u003e \u003cp\u003eChoose a Paper Size 194\u003c\/p\u003e \u003cp\u003eSet the Print Area 196\u003c\/p\u003e \u003cp\u003eConfigure Titles to Print on Each Page 198\u003c\/p\u003e \u003cp\u003ePreview the Printout 200\u003c\/p\u003e \u003cp\u003ePrint a Workbook 202\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Working with Tables\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Tables 206\u003c\/p\u003e \u003cp\u003eGet to Know Table Features 207\u003c\/p\u003e \u003cp\u003eConvert a Range to a Table 208\u003c\/p\u003e \u003cp\u003eSelect Table Data 210\u003c\/p\u003e \u003cp\u003eInsert a Table Row 212\u003c\/p\u003e \u003cp\u003eInsert a Table Column 213\u003c\/p\u003e \u003cp\u003eDelete a Table Row 214\u003c\/p\u003e \u003cp\u003eDelete a Table Column 215\u003c\/p\u003e \u003cp\u003eAdd a Column Subtotal 216\u003c\/p\u003e \u003cp\u003eConvert a Table to a Range 218\u003c\/p\u003e \u003cp\u003eApply a Table Style 219\u003c\/p\u003e \u003cp\u003eBuild a Custom Table Style 220\u003c\/p\u003e \u003cp\u003eCreate a PivotTable 222\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Analyzing Data\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSort a Range or Table 226\u003c\/p\u003e \u003cp\u003eFilter a Range or Table 228\u003c\/p\u003e \u003cp\u003eSet Data Validation Rules 230\u003c\/p\u003e \u003cp\u003eCreate a Data Table 232\u003c\/p\u003e \u003cp\u003eSummarize Data with Subtotals 234\u003c\/p\u003e \u003cp\u003eGroup Related Data 236\u003c\/p\u003e \u003cp\u003eAnalyze Data with Goal Seek 238\u003c\/p\u003e \u003cp\u003eAnalyze Data with Scenarios 240\u003c\/p\u003e \u003cp\u003eRemove Duplicate Values from a Range or Table 244\u003c\/p\u003e \u003cp\u003eHighlight Cells That Meet Some Criteria 246\u003c\/p\u003e \u003cp\u003eHighlight the Top or Bottom Values in a Range 248\u003c\/p\u003e \u003cp\u003eAnalyze Cell Values with Data Bars 250\u003c\/p\u003e \u003cp\u003eAnalyze Cell Values with Color Scales 252\u003c\/p\u003e \u003cp\u003eAnalyze Cell Values with Icon Sets 254\u003c\/p\u003e \u003cp\u003eCreate a Custom Conditional Formatting Rule 256\u003c\/p\u003e \u003cp\u003eConsolidate Data from Multiple Worksheets 258\u003c\/p\u003e \u003cp\u003eLoad the Excel Analysis ToolPak 262\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 Visualizing Data with Charts\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExamine Chart Elements 266\u003c\/p\u003e \u003cp\u003eUnderstanding Chart Types 267\u003c\/p\u003e \u003cp\u003eCreate a Chart 268\u003c\/p\u003e \u003cp\u003eCreate a Recommended Chart 270\u003c\/p\u003e \u003cp\u003eAdd Chart Titles 272\u003c\/p\u003e \u003cp\u003eAdd Data Labels 273\u003c\/p\u003e \u003cp\u003ePosition the Chart Legend 274\u003c\/p\u003e \u003cp\u003eDisplay Chart Gridlines 275\u003c\/p\u003e \u003cp\u003eDisplay a Data Table 276\u003c\/p\u003e \u003cp\u003eChange the Chart Layout and Style 277\u003c\/p\u003e \u003cp\u003eSelect a Different Chart Type 278\u003c\/p\u003e \u003cp\u003eChange the Chart Source Data 280\u003c\/p\u003e \u003cp\u003eMove or Resize a Chart 282\u003c\/p\u003e \u003cp\u003eAdd a Sparkline to a Cell 284\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Adding Worksheet Graphics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDraw a Shape 288\u003c\/p\u003e \u003cp\u003eInsert a Clip Art Image 290\u003c\/p\u003e \u003cp\u003eInsert a Photo 292\u003c\/p\u003e \u003cp\u003eInsert a WordArt Image 294\u003c\/p\u003e \u003cp\u003eInsert a SmartArt Graphic 296\u003c\/p\u003e \u003cp\u003eMove or Resize a Graphic 298\u003c\/p\u003e \u003cp\u003eCrop a Picture 300\u003c\/p\u003e \u003cp\u003eFormat a Picture 302\u003c\/p\u003e \u003cp\u003eChapter 14 Collaborating with Others\u003c\/p\u003e \u003cp\u003eAdd a Comment to a Cell 306\u003c\/p\u003e \u003cp\u003eProtect a Worksheet’s Data 308\u003c\/p\u003e \u003cp\u003eProtect a Workbook’s Structure 310\u003c\/p\u003e \u003cp\u003eShare a Workbook with Other Users 312\u003c\/p\u003e \u003cp\u003eTrack Workbook Changes 314\u003c\/p\u003e \u003cp\u003eAccept or Reject Workbook Changes 316\u003c\/p\u003e \u003cp\u003eSave a Workbook to Your OneDrive 318\u003c\/p\u003e \u003cp\u003eSend a Workbook as an E‐Mail Attachment 320\u003c\/p\u003e \u003cp\u003eSave Excel Data as a Web Page 322\u003c\/p\u003e \u003cp\u003eMake a Workbook Compatible with Earlier Versions of Excel 324\u003c\/p\u003e \u003cp\u003eMark Up a Worksheet with a Digital Pen 326\u003c\/p\u003e \u003cp\u003eCollaborate on a Workbook Online 328\u003c\/p\u003e \u003cp\u003eIndex\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePaul McFedries\u003c\/b\u003e (Toronto, Ontario) is the president of Logophilia Limited, a technical writing company. He has been programming since he was a teenager in the mid-1970s, has programmed everything from mainframes to desktops to bar code scanners, and has worked with many different languages, including Fortran, assembly language, C++, and, of course, JavaScript. Paul has written more than four dozen books that have sold more than two million copies worldwide. These books include \u003ci\u003eWindows 8.1 Simplified,\u003c\/i\u003e \u003ci\u003eTeach Yourself VISUALLY Windows 8.1, Excel Data Analysis Visual Blueprint,\u003c\/i\u003e and previous editions of \u003ci\u003eTeach Yourself VISUALLY Excel\u003c\/i\u003e. Paul encourages all readers to drop by his Web site, mcfedries.com.\u003c\/p\u003e   \u003cp\u003e\u003cb\u003e\u003ci\u003eTeach Yourself\u003c\/i\u003e VISUALLY\u003csup\u003e™\u003c\/sup\u003e\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eAre you a visual learner? Do you prefer instructions that \u003ci\u003eshow\u003c\/i\u003e you how to do something — and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle nearly 160 Excel 2016 tasks. Each task-based spread covers a single technique, sure to help you get up and running on Excel 2016 in no time.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eYou'll learn to:\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eMaster ranges and range names\u003c\/li\u003e \u003cli\u003eMake sense of Excel formulas\u003c\/li\u003e \u003cli\u003eWork your way through worksheets\u003c\/li\u003e \u003cli\u003eImport data into Excel\u003c\/li\u003e \u003cli\u003eTackle tables and analyze data\u003c\/li\u003e \u003c\/ul\u003e  \u003cp\u003e\u003cb\u003eDesigned for visual learners\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eTwo-page lessons break big topics into bite-sized modules\u003c\/li\u003e \u003cli\u003eSuccinct explanations walk you through step by step\u003c\/li\u003e \u003cli\u003eFull-color screen shots demonstrate each task\u003c\/li\u003e \u003cli\u003eHelpful sidebars offer practical tips and tricks\u003c\/li\u003e \u003c\/ul\u003e","brand":"Visual","offers":[{"title":"Default Title","offer_id":47990134407397,"sku":"NP9781119074731","price":29.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119074731.jpg?v=1761786634","url":"https:\/\/k12savings.com\/es\/products\/teach-yourself-visually-excel-2016-isbn-9781119074731","provider":"K12savings","version":"1.0","type":"link"}