{"product_id":"microsoft-excel-365-bible-paperback-softback-9781394298242","title":"Microsoft Excel 365 Bible (Paperback \/ softback) 9781394298242","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eMicrosoft Excel 365 Bible\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\"\u003eMichael Alexander (Author), Dick Kusleika (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781394298242, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 17 April 2025\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e1088 pages\u003cbr\u003e23.4 x 18.8 x 5.8 cm, 1.52 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\u003eYour complete guide to Excel 365, written for newbies all the way to seasoned professionals\u003c\/b\u003e \u003c\/p\u003e\n\u003cp\u003eNeatly organised and written using accessible language, \u003ci\u003eMicrosoft Excel 365 Bible\u003c\/i\u003e contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains many useful examples and tips and tricks that cover all essential aspects of Excel—from the basics, such as navigating the user interface, to more advanced topics, such as creating visualisations and crafting custom functions. \u003c\/p\u003e\n\u003cp\u003eWritten by an accomplished team of authors with decades of Excel and business intelligence experience, this book explores topics including: \u003c\/p\u003e\n\u003cul\u003e \u003cli\u003eEntering and editing worksheet data, with information on data types, formulas, dates, times and other cell contents\u003c\/li\u003e \u003cli\u003eBuilding formulas with Excel table objects, correcting common formula errors and using formula variables\u003c\/li\u003e \u003cli\u003eWorking with data series, changing basic chart elements and making use of chart customization\u003c\/li\u003e \u003cli\u003eLoading data from other sources, performing common transformations and applying conditional logic\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eMicrosoft Excel 365 Bible\u003c\/i\u003e earns a well-deserved spot on the bookshelves of all professionals and individuals seeking to get the most out of Excel 365, from beginners with limited knowledge of the software all the way to advanced users with years of experience under their belts.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003eIntroduction xli\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Getting Started with Excel 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Introducing Excel 3\u003c\/p\u003e \u003cp\u003eChapter 2: Entering and Editing Worksheet Data 29\u003c\/p\u003e \u003cp\u003eChapter 3: Performing Basic Worksheet Operations 55\u003c\/p\u003e \u003cp\u003eChapter 4: Working with Excel Ranges and Tables 75\u003c\/p\u003e \u003cp\u003eChapter 5: Formatting Worksheets 125\u003c\/p\u003e \u003cp\u003eChapter 6: Understanding Excel Files and Templates 161\u003c\/p\u003e \u003cp\u003eChapter 7: Printing Your Work 181\u003c\/p\u003e \u003cp\u003eChapter 8: Customizing the Excel User Interface 203\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Working with Formulas and Functions 213\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 9: Introducing Formulas and Functions 215\u003c\/p\u003e \u003cp\u003eChapter 10: Understanding and Using Array Formulas 251\u003c\/p\u003e \u003cp\u003eChapter 11: Using Common Formulas for Math and Dates 273\u003c\/p\u003e \u003cp\u003eChapter 12: Using Formulas to Manipulate Text 311\u003c\/p\u003e \u003cp\u003eChapter 13: Using Formulas for Conditional Analysis 331\u003c\/p\u003e \u003cp\u003eChapter 14: Using Formulas for Matching and Lookups 347\u003c\/p\u003e \u003cp\u003eChapter 15: Using Formulas with Conditional Formatting 365\u003c\/p\u003e \u003cp\u003eChapter 16: Making Your Formulas Error-Free 379\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Creating Charts and Other Visualizations 399\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 17: Getting Started with Excel Charts 401\u003c\/p\u003e \u003cp\u003eChapter 18: Using Advanced Charting Techniques 439\u003c\/p\u003e \u003cp\u003eChapter 19: Creating Sparkline Graphics 473\u003c\/p\u003e \u003cp\u003eChapter 20: Visualizing with Custom Number Formats and Shapes 487\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Managing and Analyzing Data 519\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 21: Importing and Cleaning Data 521\u003c\/p\u003e \u003cp\u003eChapter 22: Using Data Validation 553\u003c\/p\u003e \u003cp\u003eChapter 23: Creating and Using Worksheet Outlines 567\u003c\/p\u003e \u003cp\u003eChapter 24: Linking and Consolidating Worksheets 577\u003c\/p\u003e \u003cp\u003eChapter 25: Introducing Pivot Tables 597\u003c\/p\u003e \u003cp\u003eChapter 26: Analyzing Data with Pivot Tables 619\u003c\/p\u003e \u003cp\u003eChapter 27: Performing Spreadsheet What-If Analysis 653\u003c\/p\u003e \u003cp\u003eChapter 28: Analyzing Data Using Goal Seeking and Solver 675\u003c\/p\u003e \u003cp\u003eChapter 29: Analyzing Data with the Analysis ToolPak 695\u003c\/p\u003e \u003cp\u003eChapter 30: Protecting Your Work 707\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Understanding Power Pivot and Power Query 721\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 31: Introducing Power Pivot 723\u003c\/p\u003e \u003cp\u003eChapter 32: Working Directly with the Internal Data Model 747\u003c\/p\u003e \u003cp\u003eChapter 33: Adding Formulas to Power Pivot 757\u003c\/p\u003e \u003cp\u003eChapter 34: Introducing Power Query 787\u003c\/p\u003e \u003cp\u003eChapter 35: Transforming Data with Power Query 813\u003c\/p\u003e \u003cp\u003eChapter 36: Making Queries Work Together 845\u003c\/p\u003e \u003cp\u003eChapter 37: Enhancing Power Query Productivity 861\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Automating Excel 873\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 38: Introducing Visual Basic for Applications 875\u003c\/p\u003e \u003cp\u003eChapter 39: Creating Custom Worksheet Functions 903\u003c\/p\u003e \u003cp\u003eChapter 40: Creating UserForms 917\u003c\/p\u003e \u003cp\u003eChapter 41: Using UserForm Controls in a Worksheet 939\u003c\/p\u003e \u003cp\u003eChapter 42: Working with Excel Events 953\u003c\/p\u003e \u003cp\u003eChapter 43: Creating Custom Excel Add-Ins 967\u003c\/p\u003e \u003cp\u003eChapter 44: Office Scripts for Excel 977\u003c\/p\u003e \u003cp\u003eIndex 1009\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":"Wiley","offers":[{"title":"Brand New","offer_id":52165124391192,"sku":"9781394298242","price":30.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781394298242.jpg?v=1781088764","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/microsoft-excel-365-bible-paperback-softback-9781394298242","provider":"Freshly Printed Books","version":"1.0","type":"link"}