{"product_id":"teach-yourself-visually-excel-365-paperback-softback-9781119933625","title":"Teach Yourself VISUALLY Excel 365 (Paperback \/ softback) 9781119933625","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eTeach Yourself VISUALLY Excel 365\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003ePaul McFedries (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781119933625, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 13 October 2022\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e320 pages\u003cbr\u003e23.1 x 18.8 x 1.5 cm, 0.635 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003eExcel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY series\u003c\/b\u003e \u003c\/p\u003e\n\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\n\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\n\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\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\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\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Business applications [\u003ca title=\"See our other books on Business applications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Business%20applications%20%5BUF%5D%22\"\u003eUF\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Visual","offers":[{"title":"Brand New","offer_id":52173717897496,"sku":"9781119933625","price":18.59,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781119933625.jpg?v=1781168117","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/teach-yourself-visually-excel-365-paperback-softback-9781119933625","provider":"Freshly Printed Books","version":"1.0","type":"link"}