{"product_id":"teach-yourself-visually-excel-365-isbn-9781119933625","title":"Teach Yourself VISUALLY Excel 365","description":"\u003cp\u003e\u003cb\u003eExcel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY series\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eIn \u003ci\u003eTeach Yourself VISUALLY: Excel 365\u003c\/i\u003e, veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world’s most popular spreadsheet app. The book is filled with easy two-page lessons containing large-size screenshots and walkthroughs demonstrating common and useful tasks in Excel 365. You’ll learn how to present, analyze, visualize, and organize your data, as well as how to: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eCreate and fill spreadsheets, charts, tables, and PivotTables\u003c\/li\u003e \u003cli\u003eFilter and sort your data, use and create formulas, and organize your information\u003c\/li\u003e \u003cli\u003eVisualize your data with a variety of effective charts, graphs, and more\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eA can’t-miss handbook perfect for anyone looking for straightforward and easy-to-follow tutorials on basic and advanced Excel techniques, \u003ci\u003eTeach Yourself VISUALLY: Excel 365\u003c\/i\u003e offers users of previous Excel versions—and complete Excel newbies—a clear roadmap to mastering Excel. \u003c\/p\u003e\u003cp\u003e\u003cb\u003eChapter 1 Getting Started with Excel\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGetting to Know Excel 4\u003c\/p\u003e \u003cp\u003eStart Excel on the Desktop 6\u003c\/p\u003e \u003cp\u003eNavigate to Excel for the Web 7\u003c\/p\u003e \u003cp\u003eTour the Excel Window 8\u003c\/p\u003e \u003cp\u003eWork with the Excel Ribbon 9\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Entering Data\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLearning the Layout of a Worksheet 12\u003c\/p\u003e \u003cp\u003eUnderstanding the Types of Data You Can Use 13\u003c\/p\u003e \u003cp\u003eEnter Text into a Cell 14\u003c\/p\u003e \u003cp\u003eEnter a Number into a Cell 16\u003c\/p\u003e \u003cp\u003eEnter a Date or Time into a Cell 18\u003c\/p\u003e \u003cp\u003eEdit Cell Data 20\u003c\/p\u003e \u003cp\u003eDelete Data from a Cell 22\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Working with Ranges\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSelect a Range 26\u003c\/p\u003e \u003cp\u003eFill a Range with the Same Data 28\u003c\/p\u003e \u003cp\u003eFill a Range with a Series of Values 30\u003c\/p\u003e \u003cp\u003eFlash Fill a Range 32\u003c\/p\u003e \u003cp\u003eMove or Copy a Range 34\u003c\/p\u003e \u003cp\u003eInsert a Row or Column 36\u003c\/p\u003e \u003cp\u003eInsert a Cell or Range 38\u003c\/p\u003e \u003cp\u003eDelete Data from a Range 40\u003c\/p\u003e \u003cp\u003eDelete a Range 42\u003c\/p\u003e \u003cp\u003eHide a Row or Column 44\u003c\/p\u003e \u003cp\u003eFreeze Rows or Columns 46\u003c\/p\u003e \u003cp\u003eMerge Two or More Cells 48\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Working with Range Names\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Benefits of Using Range Names 52\u003c\/p\u003e \u003cp\u003eDefine a Range Name 54\u003c\/p\u003e \u003cp\u003eUsing Worksheet Text to Define a Range Name 56\u003c\/p\u003e \u003cp\u003eNavigate a Workbook Using Range Names 58\u003c\/p\u003e \u003cp\u003eChange a Range Name 60\u003c\/p\u003e \u003cp\u003eDelete a Range Name 62\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Formatting Excel Ranges\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChange the Font and Font Size 66\u003c\/p\u003e \u003cp\u003eApply Font Effects 68\u003c\/p\u003e \u003cp\u003eChange the Font Color 70\u003c\/p\u003e \u003cp\u003eAlign Text Within a Cell 72\u003c\/p\u003e \u003cp\u003eCenter Text Across Multiple Columns 74\u003c\/p\u003e \u003cp\u003eRotate Text Within a Cell 76\u003c\/p\u003e \u003cp\u003eAdd a Background Color to a Range 78\u003c\/p\u003e \u003cp\u003eApply a Number Format 80\u003c\/p\u003e \u003cp\u003eChange the Number of Decimal Places Displayed 82\u003c\/p\u003e \u003cp\u003eApply a Conditional Format to a Range 84\u003c\/p\u003e \u003cp\u003eApply a Style to a Range 86\u003c\/p\u003e \u003cp\u003eChange the Column Width 88\u003c\/p\u003e \u003cp\u003eChange the Row Height 90\u003c\/p\u003e \u003cp\u003eWrap Text Within a Cell 92\u003c\/p\u003e \u003cp\u003eAdd Borders to a Range 94\u003c\/p\u003e \u003cp\u003eCopy Formatting from One Cell to Another 96\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Building Formulas\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Excel Formulas 100\u003c\/p\u003e \u003cp\u003eBuild a Formula 102\u003c\/p\u003e \u003cp\u003eUnderstanding Excel Functions 104\u003c\/p\u003e \u003cp\u003eAdd a Function to a Formula 106\u003c\/p\u003e \u003cp\u003eAdd a Range of Numbers 108\u003c\/p\u003e \u003cp\u003eBuild an AutoSum Formula 110\u003c\/p\u003e \u003cp\u003eAdd a Range Name to a Formula 112\u003c\/p\u003e \u003cp\u003eReference Another Worksheet Range in a Formula 114\u003c\/p\u003e \u003cp\u003eMove or Copy a Formula 116\u003c\/p\u003e \u003cp\u003eSwitch to Absolute Cell References 118\u003c\/p\u003e \u003cp\u003eTroubleshoot Formula Errors 120\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Manipulating Worksheets\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eNavigate a Worksheet 124\u003c\/p\u003e \u003cp\u003eRename a Worksheet 125\u003c\/p\u003e \u003cp\u003eCreate a New Worksheet 126\u003c\/p\u003e \u003cp\u003eMove a Worksheet 128\u003c\/p\u003e \u003cp\u003eCopy a Worksheet 130\u003c\/p\u003e \u003cp\u003eDelete a Worksheet 132\u003c\/p\u003e \u003cp\u003eZoom In on or Out of a Worksheet 134\u003c\/p\u003e \u003cp\u003eSplit a Worksheet into Two Panes 136\u003c\/p\u003e \u003cp\u003eHide and Unhide a Worksheet 138\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Dealing with Workbooks\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreate a New Blank Workbook 142\u003c\/p\u003e \u003cp\u003eCreate a New Workbook from a Template 144\u003c\/p\u003e \u003cp\u003eSave a Workbook 146\u003c\/p\u003e \u003cp\u003eOpen a Workbook 147\u003c\/p\u003e \u003cp\u003eFind Text in a Workbook 148\u003c\/p\u003e \u003cp\u003eReplace Text in a Workbook 150\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 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 10 Importing Data into Excel\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding External Data 168\u003c\/p\u003e \u003cp\u003eImport Data from an Access Table 170\u003c\/p\u003e \u003cp\u003eImport Data from a Word Table 172\u003c\/p\u003e \u003cp\u003eImport Data from a Text File 174\u003c\/p\u003e \u003cp\u003eImport Data from a Web Page 176\u003c\/p\u003e \u003cp\u003eImport Data from an XML File 178\u003c\/p\u003e \u003cp\u003eRefresh Imported Data 180\u003c\/p\u003e \u003cp\u003eSeparate Cell Text into Columns 182\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Working with Tables\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding Tables 186\u003c\/p\u003e \u003cp\u003eGet to Know Table Features 187\u003c\/p\u003e \u003cp\u003eConvert a Range to a Table 188\u003c\/p\u003e \u003cp\u003eSelect Table Data 190\u003c\/p\u003e \u003cp\u003eInsert a Table Row 192\u003c\/p\u003e \u003cp\u003eInsert a Table Column 193\u003c\/p\u003e \u003cp\u003eDelete a Table Row 194\u003c\/p\u003e \u003cp\u003eDelete a Table Column 195\u003c\/p\u003e \u003cp\u003eAdd a Column Subtotal 196\u003c\/p\u003e \u003cp\u003eConvert a Table to a Range 198\u003c\/p\u003e \u003cp\u003eApply a Table Style 199\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 Analyzing with PivotTables\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding PivotTables 202\u003c\/p\u003e \u003cp\u003eExplore PivotTable Features 203\u003c\/p\u003e \u003cp\u003eBuild a PivotTable from an Excel Range or Table 204\u003c\/p\u003e \u003cp\u003eRefresh PivotTable Data 206\u003c\/p\u003e \u003cp\u003eAdd Multiple Fields to the Row or Column Area 208\u003c\/p\u003e \u003cp\u003eAdd Multiple Fields to the Data Area 210\u003c\/p\u003e \u003cp\u003eMove a Field to a Different Area 212\u003c\/p\u003e \u003cp\u003eGroup PivotTable Values 214\u003c\/p\u003e \u003cp\u003eApply a PivotTable Filter 216\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Analyzing Data\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSort a Range or Table 220\u003c\/p\u003e \u003cp\u003eFilter a Range or Table 222\u003c\/p\u003e \u003cp\u003eSet Data Validation Rules 224\u003c\/p\u003e \u003cp\u003eCreate a Data Table 226\u003c\/p\u003e \u003cp\u003eSummarize Data with Subtotals 228\u003c\/p\u003e \u003cp\u003eGroup Related Data 230\u003c\/p\u003e \u003cp\u003eAnalyze Data with Goal Seek 232\u003c\/p\u003e \u003cp\u003eHighlight Cells That Meet Some Criteria 234\u003c\/p\u003e \u003cp\u003eHighlight the Top or Bottom Values in a Range 236\u003c\/p\u003e \u003cp\u003eAnalyze Cell Values with Data Bars 238\u003c\/p\u003e \u003cp\u003eAnalyze Cell Values with Color Scales 240\u003c\/p\u003e \u003cp\u003eAnalyze Cell Values with Icon Sets 242\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14 Visualizing Data with Charts\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExamine Chart Elements 246\u003c\/p\u003e \u003cp\u003eUnderstanding Chart Types 247\u003c\/p\u003e \u003cp\u003eCreate a Chart 248\u003c\/p\u003e \u003cp\u003eCreate a Recommended Chart 250\u003c\/p\u003e \u003cp\u003eAdd Chart Titles 252\u003c\/p\u003e \u003cp\u003eAdd Data Labels 253\u003c\/p\u003e \u003cp\u003ePosition the Chart Legend 254\u003c\/p\u003e \u003cp\u003eDisplay Chart Gridlines 255\u003c\/p\u003e \u003cp\u003eDisplay a Data Table 256\u003c\/p\u003e \u003cp\u003eChange the Chart Layout and Style 257\u003c\/p\u003e \u003cp\u003eSelect a Different Chart Type 258\u003c\/p\u003e \u003cp\u003eChange the Chart Source Data 260\u003c\/p\u003e \u003cp\u003eMove or Resize a Chart 262\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15 Adding Worksheet Graphics\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDraw a Shape 266\u003c\/p\u003e \u003cp\u003eInsert an Online Image 268\u003c\/p\u003e \u003cp\u003eInsert a Photo from Your PC 270\u003c\/p\u003e \u003cp\u003eInsert a SmartArt Graphic 272\u003c\/p\u003e \u003cp\u003eMove or Resize a Graphic 274\u003c\/p\u003e \u003cp\u003eFormat a Picture 276\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16 Collaborating with Others\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdd a Comment to a Cell 280\u003c\/p\u003e \u003cp\u003eProtect a Worksheet’s Data 282\u003c\/p\u003e \u003cp\u003eProtect a Workbook’s Structure 284\u003c\/p\u003e \u003cp\u003eSave a Workbook to Your OneDrive 286\u003c\/p\u003e \u003cp\u003eSend a Workbook as an Email Attachment 288\u003c\/p\u003e \u003cp\u003eSave Excel Data as a Web Page 290\u003c\/p\u003e \u003cp\u003eMake a Workbook Compatible with Earlier Versions of Excel 292\u003c\/p\u003e \u003cp\u003eMark Up a Worksheet with Digital Ink 294\u003c\/p\u003e \u003cp\u003eCollaborate on a Workbook Online 296\u003c\/p\u003e \u003cp\u003eIndex 298\u003c\/p\u003e  \u003cp\u003e\u003cb\u003ePaul McFedries\u003c\/b\u003e is a full-time technical writer. Paul has been authoring computer books since 1991, and he has more than 100 books to his credit. Paul's books have sold more than four million copies worldwide. These books include the Wiley titles \u003ci\u003eTeach Yourself VISUALLY Windows 11,\u003c\/i\u003e Second Edition, \u003ci\u003eTeach Yourself VISUALLY Microsoft 365,\u003c\/i\u003e Second Edition, \u003ci\u003eGoogle Workspace For Dummies,\u003c\/i\u003e and \u003ci\u003eHTML, CSS, and JavaScript for Dummies.\u003c\/i\u003e Paul invites you to drop by his personal website at https:\/\/paulmcfedries.com and to follow him on X @paulmcf and on Facebook at https:\/\/facebook.com\/PaulMcFedries.  \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 hundreds of Excel 365 tasks. Each task-based spread covers a single technique, sure to help you get up and running on Excel 365 in no time. \u003c\/p\u003e\u003cp\u003e\u003cb\u003eYou’ll learn to:\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e\u003cb\u003e\u003cli\u003eMaster formulas and functions\u003c\/li\u003e \u003cli\u003eUse tables and charts\u003c\/li\u003e \u003cli\u003eOrganize and analyze data\u003c\/li\u003e \u003cli\u003eCreate informative visualizations\u003c\/li\u003e \u003cli\u003eSummarize data with PivotTables\u003c\/li\u003e\u003c\/b\u003e\u003c\/ul\u003e \u003cp\u003e\u003cb\u003eDesigned for visual learners\u003c\/b\u003e  \u003c\/p\u003e\u003cul\u003e\u003cb\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\/b\u003e\u003c\/ul\u003e","brand":"Visual","offers":[{"title":"Default Title","offer_id":47990134472933,"sku":"NP9781119933625","price":30.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119933625.jpg?v=1761786635","url":"https:\/\/k12savings.com\/products\/teach-yourself-visually-excel-365-isbn-9781119933625","provider":"K12savings","version":"1.0","type":"link"}