{"title":"Excel 2019 Mastery","description":null,"products":[{"product_id":"excel-2019-basics-book-nathan-george-9781090517593","title":"Excel 2019 Basics","description":"A Step-By-Step Approach to Learning Excel Fast\u003cp\u003e\u003ci\u003eExcel 2019 Basics\u003c\/i\u003e covers all you need to quickly get up to speed with creating spreadsheets to provide solutions for your data. If you are new to Excel and the thought of spreadsheets makes your head spin, then you've come to the right place. This book will hold your hand through a step-by-step process in becoming skilled with Excel.\u003c\/p\u003e\u003cp\u003eIf you already have some Excel skills and you want to skill-up on more advanced topics like functions, Excel tables, pivot tables, and charts, then you've also come to the right place. \u003ci\u003eExcel 2019 Basics\u003c\/i\u003e goes beyond introduction topics and covers topics like functions, Excel tables, and analysing your data with charts.\u003c\/p\u003e\u003cp\u003eThe aim of this book is to guide you from beginner to being skilled with Excel within a few short hours.\u003c\/p\u003eLearn Excel Quicker by Avoiding Unnecessary Fillers\u003cp\u003eThis book cuts to the chase without the unnecessary verbosity seen in many other Excel books. You don't need to get through a wall of text to learn how to quickly carry out various tasks in Excel. Hence, \u003ci\u003eExcel 2019 Basics\u003c\/i\u003e focuses on providing direct instructions for how to complete tasks with screenshots where necessary to illustrate the concepts.\u003c\/p\u003e\u003cp\u003eIMPORTANT: \u003cb\u003eThe accompanying sample files are easily downloadable with the provided weblink inside the book.\u003c\/b\u003e Some people may be 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\u003cb\u003eIn this book, you'll learn how to: \u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eAdd, name, copy and move worksheets.\u003c\/li\u003e\n\u003cli\u003eFreeze and unfreeze panes (rows and columns).\u003c\/li\u003e\n\u003cli\u003eUse AutoFill and Flash Fill to automate repetitive tasks.\u003c\/li\u003e\n\u003cli\u003eMove and copy data.\u003c\/li\u003e\n\u003cli\u003eFormat cells, ranges and tables.\u003c\/li\u003e\n\u003cli\u003eCreate formulas for different types of calculations.\u003c\/li\u003e\n\u003cli\u003eUse absolute and relative cell references.\u003c\/li\u003e\n\u003cli\u003eUse AutoSum to quickly automate calculations.\u003c\/li\u003e\n\u003cli\u003eUse functions like IF, DATE, DATEDIF, LEN, MID, and VLOOLUP.\u003c\/li\u003e\n\u003cli\u003eUse the new XLOOKUP function introduced in 2020 for easier and faster lookups.\u003c\/li\u003e\n\u003cli\u003eWork with Excel tables, including applying table styles.\u003c\/li\u003e\n\u003cli\u003eEasily filter and sort your data.\u003c\/li\u003e\n\u003cli\u003eDynamically analyze your data with Pivot Table tools that can carry out automated data summaries in seconds that would have taken hours to do manually \u003c\/li\u003e\n\u003cli\u003eUse the Quick Analysis tool to generate charts and sparklines with just a few clicks.\u003c\/li\u003e\n\u003cli\u003eSecure your workbook data and design with a password.\u003c\/li\u003e\n\u003cli\u003eUse many more Excel features...\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eScroll up and click the \u003cb\u003eBuy Now\u003c\/b\u003e button on the right-hand side of the page to get started today \u003c\/p\u003e","brand":"WoB","offers":[{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":49546318610705,"sku":"GOR012576920","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49567839420689,"sku":"GOR011364858","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":50271180062993,"sku":"CIN1090517599G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50371175710993,"sku":"CIN1090517599VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51019024826641,"sku":"NIN9781090517593","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":52090267140369,"sku":"GOR013496753","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1090517599.jpg?v=1751367587"},{"product_id":"excel-2019-advanced-topics-book-nathan-george-9781693650055","title":"Excel 2019 Advanced Topics","description":null,"brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49567053512977,"sku":"GOR013575217","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51232566182161,"sku":"NIN9781693650055","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1693650053.jpg?v=1751090381"},{"product_id":"excel-2019-functions-book-nathan-george-9781796379945","title":"Excel 2019 Functions","description":null,"brand":"WoB","offers":[{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50135106650385,"sku":"CIN1796379948VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":52755162267921,"sku":"NIN9781796379945","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1796379948.jpg?v=1751154672"},{"product_id":"excel-2019-macros-and-vba-book-nathan-george-9781916211346","title":"Excel 2019 Macros and VBA","description":null,"brand":"WoB","offers":[{"title":"US \/ GOOD \/ SBYB","offer_id":50401676787985,"sku":"CIN1916211348G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50984553283857,"sku":"GOR014160423","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51057460773137,"sku":"NIN9781916211346","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ LIKE_NEW \/ INTERNAL","offer_id":53573816254737,"sku":"GOR014966555","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1916211348.jpg?v=1750899938"},{"product_id":"excel-2019-basics-book-nathan-george-9781916211308","title":"Excel 2019 Basics","description":"\u003cp\u003e\u003cstrong\u003eA Step-By-Step Approach to Learning Excel Fast\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e\u003cem\u003eExcel 2019 Basics\u003c\/em\u003e covers all you need to quickly get up to speed in creating spreadsheets to provide solutions for your data.\u003c\/p\u003e\u003cp\u003eIf you are new to Excel and the thought of spreadsheets makes your head spin, then you've come to the right place. This book will hold your hand through a step-by-step process in becoming skilled with Excel.\u003c\/p\u003e\u003cp\u003eIf you already have some Excel skills and you want to skill-up on more advanced topics like functions, Excel tables, pivot tables, and charts, then you've also come to the right place. \u003cem\u003eExcel 2019 Basics\u003c\/em\u003e goes beyond introduction topics and covers topics like functions, Excel tables, and analysing your data with charts.\u003c\/p\u003e\u003cp\u003eThe aim of this book is to guide you from beginner to being skilled with Excel within a few short hours.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eLearn Excel Quicker by Avoiding Unnecessary Fillers\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThis book cuts to the chase without the unnecessary verbosity seen in many other Excel books. You don't need to get through a wall of text to learn how to quickly carry out various tasks in Excel. Hence, \u003cem\u003eExcel 2019 Basics\u003c\/em\u003e focuses on providing direct instructions for how to complete tasks with screenshots where necessary to illustrate the concepts.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eIn this book, you'll learn how to: \u003c\/strong\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eAdd, name, copy and move worksheets.\u003c\/li\u003e \u003cli\u003eFreeze and unfreeze panes (rows and columns).\u003c\/li\u003e \u003cli\u003eUse AutoFill and Flash Fill to automate repetitive tasks.\u003c\/li\u003e \u003cli\u003eMove and copy data.\u003c\/li\u003e \u003cli\u003eFormat cells, ranges and tables.\u003c\/li\u003e \u003cli\u003eCreate formulas for different types of calculations.\u003c\/li\u003e \u003cli\u003eUse absolute and relative cell references.\u003c\/li\u003e \u003cli\u003eUse AutoSum to quickly automate calculations.\u003c\/li\u003e \u003cli\u003eUse functions like IF, DATE, DATEDIF, LEN, MID, and VLOLUP.\u003c\/li\u003e \u003cli\u003eWork with Excel tables, including applying table styles.\u003c\/li\u003e \u003cli\u003eEasily filter and sort your data.\u003c\/li\u003e \u003cli\u003eDynamically analyze your data with Pivot Table tools that can carry out automated data summaries in seconds that would have taken hours to do manually \u003c\/li\u003e \u003cli\u003eUse the Quick Analysis tool to generate charts and sparklines with just a few clicks.\u003c\/li\u003e \u003cli\u003eSecure your workbook data and design with a password.\u003c\/li\u003e \u003cli\u003eUse many more Excel features.\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eGet the book now to start your journey to Excel mastery today \u003c\/p\u003e","brand":"WoB","offers":[{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50416517873937,"sku":"CIN1916211305VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":51340291506449,"sku":"GOR014229420","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":52756308918545,"sku":"NIN9781916211308","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1916211305.jpg?v=1751428617"},{"product_id":"excel-2019-basics-book-nathan-george-9781916211353","title":"Excel 2019 Basics","description":"\u003cp\u003e\u003cstrong\u003eA Step-By-Step Approach to Learning Excel Fast\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e\u003cem\u003eExcel 2019 Basics\u003c\/em\u003e covers all you need to quickly get up to speed in creating spreadsheets to provide solutions for your data.\u003c\/p\u003e\u003cp\u003eIf you are new to Excel and the thought of spreadsheets makes your head spin, then you've come to the right place. This book will hold your hand through a step-by-step process in becoming skilled with Excel.\u003c\/p\u003e\u003cp\u003eIf you already have some Excel skills and you want to skill-up on more advanced topics like functions, Excel tables, pivot tables, and charts, then you've also come to the right place. \u003cem\u003eExcel 2019 Basics\u003c\/em\u003e goes beyond introduction topics and covers topics like functions, Excel tables, and analysing your data with charts.\u003c\/p\u003e\u003cp\u003eThe aim of this book is to guide you from beginner to being skilled with Excel within a few short hours.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eLearn Excel Quicker by Avoiding Unnecessary Fillers\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThis book cuts to the chase without the unnecessary verbosity seen in many other Excel books. You don't need to get through a wall of text to learn how to quickly carry out various tasks in Excel. Hence, \u003cem\u003eExcel 2019 Basics\u003c\/em\u003e focuses on providing direct instructions for how to complete tasks with screenshots where necessary to illustrate the concepts.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eIn this book, you'll learn how to: \u003c\/strong\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eAdd, name, copy and move worksheets.\u003c\/li\u003e \u003cli\u003eFreeze and unfreeze panes (rows and columns).\u003c\/li\u003e \u003cli\u003eUse AutoFill and Flash Fill to automate repetitive tasks.\u003c\/li\u003e \u003cli\u003eMove and copy data.\u003c\/li\u003e \u003cli\u003eFormat cells, ranges and tables.\u003c\/li\u003e \u003cli\u003eCreate formulas for different types of calculations.\u003c\/li\u003e \u003cli\u003eUse absolute and relative cell references.\u003c\/li\u003e \u003cli\u003eUse AutoSum to quickly automate calculations.\u003c\/li\u003e \u003cli\u003eUse functions like IF, DATE, DATEDIF, LEN, MID, and VLOLUP.\u003c\/li\u003e \u003cli\u003eWork with Excel tables, including applying table styles.\u003c\/li\u003e \u003cli\u003eEasily filter and sort your data.\u003c\/li\u003e \u003cli\u003eDynamically analyze your data with Pivot Table tools that can carry out automated data summaries in seconds that would have taken hours to do manually \u003c\/li\u003e \u003cli\u003eUse the Quick Analysis tool to generate charts and sparklines with just a few clicks.\u003c\/li\u003e \u003cli\u003eSecure your workbook data and design with a password.\u003c\/li\u003e \u003cli\u003eUse many more Excel features.\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eGet the book now to start your journey to Excel mastery today \u003c\/p\u003e","brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":50765148029201,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50765149634833,"sku":"CIN1916211356VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":52755876512017,"sku":"NIN9781916211353","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1916211356.jpg?v=1750931880"},{"product_id":"excel-xlookup-and-other-lookup-functions-book-nathan-george-9781916211360","title":"Excel XLOOKUP and Other Lookup Functions","description":"\u003cp\u003e\u003cstrong\u003eLeverage New Powerful Lookup Functions in Excel 2019 \u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eDynamic array formulas represent one of the biggest changes to Excel formulas in years. Maybe the biggest change ever. They enable you to work with multiple return values at the same time in a formula. XLOKUP is a new and exciting function that replaces VLOKUP and addresses most of the limitations of its predecessor. XLOKUP is so versatile that it also replaces HLOKUP and the INDEX\/MATCH\/MATCH combination used for simultaneous vertical and horizontal lookups. \u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eA Detailed Walkthrough of New and Exciting Lookup Functions Recently Released \u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThis book provides comprehensive coverage of several of the newly released dynamic array lookup formulas in more depth, and with more examples, than would have been practical in a general-purpose Excel book. Learn how to use functions like XLOKUP, XMATCH, FILTER, SORT, CHOSE, INDEX etc. VLOKUP will still be in use for a while as the new dynamic array functions are not available to one-time purchase version of Office users yet. For that reason, this book also covers the good old VLOKUP in some depth. If you're looking to skill up on VLOKUP, then this book is also for you. Functions can save you a lot of time as they're tried and tested predefined formulas.\u003c\/p\u003e\u003cp\u003eFrom simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.\u003c\/p\u003e\u003cp\u003eIncluded are downloadable Excel practice files to enable you to follow the examples in the book hands-on.\u003c\/p\u003e","brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":51057416765713,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":51057419452689,"sku":"NIN9781916211360","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1916211364.jpg?v=1751282972"},{"product_id":"excel-2019-functions-book-nathan-george-9781916211322","title":"Excel 2019 Functions","description":"\u003cp\u003e\u003cstrong\u003eLeverage the Full Power of Excel Functions\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eExcel 2019 Functions provides a detailed walkthrough of 70 of the most useful Excel functions, including many tips to enable you to maximize the power of Excel through the use of functions.\u003c\/p\u003e\u003cp\u003eThis book provides a detailed description of each function, its arguments, and its use is demonstrated with fitting examples. Learn how to use functions like VLOOKUP, IFS, COUNTIFS, DATEDIF, NETWORKDAYS, FIND, NPV, SUMIFS etc. From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAchieve More with Less Effort\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eLearn new functions introduced in Excel 2016 and 2019 like the IFS functions that make it easier to create powerful formulas much simpler syntax.\u003c\/p\u003e\u003cp\u003e\u003cem\u003eExcel 2019 Functions\u003c\/em\u003e will be a great reference guide for you whether you're a beginner or already skilled with Excel. By the time you finish this guide, you will understand how functions work in Excel, how to find the right functions, and how to combine them in solving complex problems.\u003c\/p\u003e\u003cp\u003eThis book comes with downloadable Excel practice files for all examples. Hence, you can follow the tutorials without needing to create the examples from scratch in Excel. You can also copy the tried and tested formulas and use them in your own workbooks.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eIn this book, you'll learn how to: \u003c\/strong\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eFind and enter functions in Excel.\u003c\/li\u003e \u003cli\u003eUse \u003cstrong\u003elookup and reference functions\u003c\/strong\u003e to find and reference values in your formulas.\u003c\/li\u003e \u003cli\u003eUse \u003cstrong\u003elogical functions\u003c\/strong\u003e to execute conditional statements and calculations.\u003c\/li\u003e \u003cli\u003eDeploy \u003cstrong\u003eIFS functions\u003c\/strong\u003e in place of convoluted nested functions for more efficient and robust formulas.\u003c\/li\u003e \u003cli\u003eUse a wide array of \u003cstrong\u003edate and time functions\u003c\/strong\u003e to address all kinds of date calculations.\u003c\/li\u003e \u003cli\u003eManipulate text strings with \u003cstrong\u003etext functions\u003c\/strong\u003e.\u003c\/li\u003e \u003cli\u003eCarry out financial calculations with special \u003cstrong\u003efinancial functions\u003c\/strong\u003e.\u003c\/li\u003e \u003cli\u003eAnd much more...\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eBuy now to get started today \u003c\/p\u003e","brand":"WoB","offers":[{"title":"- \/ - \/ INTERNAL","offer_id":52755876446481,"sku":null,"price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":52755876970769,"sku":"NIN9781916211322","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/9781916211322.jpg?v=1763574671"}],"url":"https:\/\/www.worldofbooks.com\/en-gb\/collections\/excel-2019-mastery-book-series.oembed","provider":"World of Books ","version":"1.0","type":"link"}