{"product_id":"excel-2019-advanced-topics-leverage-more-powerful-tools-to-enhance-your-productivity-paperback","title":"Excel 2019 Advanced Topics: Leverage More Powerful Tools to Enhance Your Productivity - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eNathan George\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003eGain expert skills in Excel 2019 and easily perform complex tasks\u003c\/p\u003e\u003cp\u003eWhether you have basic Excel skills or you're a power user, \u003ci\u003eExcel 2019 Advanced Topics\u003c\/i\u003e is full of tips, techniques and tools that will save you time and effort in performing challenging tasks in Excel. When building complicated spreadsheets 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\u003eGet real-world solutions for your data\u003cp\u003e\u003ci\u003eExcel 2019 Advanced Topics\u003c\/i\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 your time and effort.\u003c\/p\u003e\u003cp\u003eIncludes tons of examples and readymade formulas that you can copy and use in your own worksheets. The downloadable Excel practice files will also save you typing if you want to practice as you follow the examples detailed in the book.\u003c\/p\u003e\u003cp\u003eIMPORTANT: \u003cb\u003eThe accompanying sample files are easily downloadable with the provided weblink inside the book\u003c\/b\u003e. It appears some people have either typed the link incorrectly or are unaware that entering a weblink to a zip file automatically downloads the file to your computer's Downloads folder. So, the download process has been updated to make it clearer, with added instructions and a support email to contact if you encounter any issues.\u003c\/p\u003e\u003cp\u003e\u003cb\u003eIn this book, you'll learn how to: \u003c\/b\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eRemove duplicate values or rows from a data list.\u003c\/li\u003e\n\u003cli\u003eDelete blank rows in your 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 Internet web pages.\u003c\/li\u003e\n\u003cli\u003eTroubleshoot and fix errors in formulas with various debugging 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\u003eManipulate text with LEFT, RIGHT or MID functions.\u003c\/li\u003e\n\u003cli\u003eCarry out financial calculations with functions like PV, FV and NPV.\u003c\/li\u003e\n\u003cli\u003eUse \u003cb\u003eMacros\u003c\/b\u003e to automate Excel tasks.\u003c\/li\u003e\n\u003cli\u003eAnalyze different data scenarios and create projections with \u003cb\u003eWhat-If Analysis\u003c\/b\u003e tools.\u003c\/li\u003e\n\u003cli\u003eDynamically analyze large sets of data with \u003cb\u003ePivot Tables\u003c\/b\u003e and \u003cb\u003ePivot Charts\u003c\/b\u003e.\u003c\/li\u003e\n\u003cli\u003eProtect your workbook, worksheets, or specific cells in your worksheets from unauthorised or accidental changes.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eScroll up and click the \u003cb\u003eAdd to Cart\u003c\/b\u003e button at the top left-right side of the page to get started today \u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 222\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.47 x 9 x 6 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e September 16, 2019\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":52493346603315,"sku":"9781693650055","price":27.57,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0300\/5595\/6612\/files\/L1p5UHhxQklpU294ZGJrMmUvSEhMQT09.webp?v=1759949955","url":"https:\/\/www.vysn.com\/en-ca\/products\/excel-2019-advanced-topics-leverage-more-powerful-tools-to-enhance-your-productivity-paperback","provider":"VYSN","version":"1.0","type":"link"}