{"product_id":"excel-365-advanced-topics-leverage-more-powerful-tools-to-enhance-your-productivity-9781915476098","title":"Excel 365 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity","description":"Gain expert Excel skills and easily perform complex tasks\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eWhether you have basic Excel skills or you're a power user, \u003cem\u003eExcel 365 Advanced Topics\u003c\/em\u003e is full of tips, techniques, and tools that will save you time and effort in performing challenging tasks in Excel. When building complicated spreadsheet solutions, using the right tool in Excel can increase the accuracy and efficiency of your work. This book does not only show you how to use specific features but also in what context those features need to be used.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003eGet real-world solutions for your data\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cem\u003eExcel 365 Advanced Topics\u003c\/em\u003e focuses on a selection of topics relevant to real-world productivity tasks you're likely to perform at home or at work requiring more than a basic knowledge of Excel. Even if you're an Excel power user, you'll find lots of ideas and tips in this book that will save you time and effort.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eIncludes tons of examples and readymade formulas that you can copy and use in your own worksheets. The downloadable practice files enable you to follow the book hands-on, which is the best way to learn.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eThis book covers Excel for Microsoft 365 (2023 update).\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eIn this book, you'll learn how to: \u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eTransform data in Excel using the Power Query Editor.\u003c\/li\u003e\n\u003cli\u003eRemove duplicate rows from a data list.\u003c\/li\u003e\n\u003cli\u003eConsolidate data from different worksheets or workbooks.\u003c\/li\u003e\n\u003cli\u003eImport and use data from external sources like Microsoft Access databases, CSV text files, and websites.\u003c\/li\u003e\n\u003cli\u003eTroubleshoot and fix formula errors with various tools.\u003c\/li\u003e\n\u003cli\u003eUse functions like IFS and SUMIFS to create simpler but more efficient conditional formulas in place of convoluted nested IF functions.\u003c\/li\u003e\n\u003cli\u003eUse modern dynamic array functions like TEXTBEFORE, TEXTAFTER, and TEXTSPLIT to manipulate text strings.\u003c\/li\u003e\n\u003cli\u003eCarry out financial calculations with functions like PV, FV, and NPV.\u003c\/li\u003e\n\u003cli\u003eUse \u003cstrong\u003eMacros\u003c\/strong\u003e to automate Excel tasks.\u003c\/li\u003e\n\u003cli\u003eAnalyze different data scenarios and create projections with \u003cstrong\u003eWhat-If Analysis\u003c\/strong\u003e tools.\u003c\/li\u003e\n\u003cli\u003eDynamically analyze large sets of data with \u003cstrong\u003ePivot Tables\u003c\/strong\u003e and \u003cstrong\u003ePivot Charts\u003c\/strong\u003e.\u003c\/li\u003e\n\u003cli\u003eProtect your workbook, worksheets, or specific cells in your worksheets from unauthorized or accidental changes.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cbr\u003e","brand":"Gtech Publishing","offers":[{"title":"Default Title","offer_id":50394226196754,"sku":"9781915476098","price":18.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_bf49c87d-544d-45f3-a194-e7272374e7c5.jpg?v=1728999960","url":"https:\/\/surprise-castle.myshopify.com\/products\/excel-365-advanced-topics-leverage-more-powerful-tools-to-enhance-your-productivity-9781915476098","provider":"Surprise Castle","version":"1.0","type":"link"}