{"product_id":"excel-2019-construction-kit-1-mike-smart-9781909253360","title":"Excel 2019 Construction Kit #1: Calendar and Year Planner","description":"\u003cp\u003e\u003cstrong\u003eThis book is suitable for both Excel beginners and seasoned experts.\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIn this Excel 2019 book (also suitable for Excel 365) you'll learn how to use and apply advanced Excel skills to construct a robust Excel business application that would be well beyond the powers of most advanced Excel users.\u003c\/p\u003e\u003cp\u003eEven if you only have very basic Excel skills, the book is designed in such a way that you'll be able to construct a complex, polished professional Excel 2019 application. In constructing this project you'll discover new and interesting ways to use many of Excel 2019's more powerful and complex features.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThis book will teach you best-practice when applying your Excel skills to large real-world projects.\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThis book won't only teach you Excel skills. You'll also learn a best-practice design and development methodology that will stand you in good stead when working on future Excel projects.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you will learn\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eMost Excel tutorials and reference books teach how to use individual Excel features but don't show how you can combine them into a robust and complex Excel application. In this book you will combine 80 key Excel skills to produce a single advanced Excel application. Here are just a few of the skills you'll use: \u003c\/p\u003e \u003cul\u003e \u003cli\u003eCreate a custom color set.\u003c\/li\u003e \u003cli\u003eUse custom formats.\u003c\/li\u003e \u003cli\u003eUse Spin Button and Check Box form controls.\u003c\/li\u003e \u003cli\u003eDefine named ranges and named cells.\u003c\/li\u003e \u003cli\u003eUse the Name Manager to view, delete and edit range names.\u003c\/li\u003e \u003cli\u003eCreate a drop-down list using a list validation.\u003c\/li\u003e \u003cli\u003eUse and understand the practical use of over 20 Excel functions including VLOOKUP, COUNTIF, DAY, MONTH, DATE, IFERROR, CHAR, IF, IFERROR, LEN, MOD, ROW, TEXT and WEEKDAY.\u003c\/li\u003e \u003cli\u003eUnderstand date serial numbers.\u003c\/li\u003e \u003cli\u003eUnderstand precedence rules.\u003c\/li\u003e \u003cli\u003eFormat date serial numbers using a custom format.\u003c\/li\u003e \u003cli\u003eCreate a formula-driven conditional format.\u003c\/li\u003e \u003cli\u003eUse the conditional format Rules Manager.\u003c\/li\u003e \u003cli\u003eCalculate the correct date (in any year) for Martin Luther King Day, President's Day, Labor Day, Columbus Day, Thanksgiving Day, New Year's Day, Independence Day, Christmas Day and Veterans Day, Easter Sunday and Memorial Day.\u003c\/li\u003e \u003cli\u003eUse structured table references.\u003c\/li\u003e \u003cli\u003eConcatenate text.\u003c\/li\u003e \u003cli\u003eCalculate the phases of the moon using Synodic Months and the MOD function.\u003c\/li\u003e \u003cli\u003eCreate user-friendly validation error messages.\u003c\/li\u003e \u003cli\u003eUse Smart Tags.\u003c\/li\u003e \u003cli\u003eLock cells, hide columns, hide entire worksheets and protect worksheets to prevent users from making unwanted changes.\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cstrong\u003eCompanies who have taken Smart Method courses include: \u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eAOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, The British Museum, The National Gallery, Pokerstars, Marks \u0026amp; Spencer, Virgin, O2, BMW... and many, many others.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Mike Smart\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1909253367\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781909253360\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Smart Method Ltd\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 11\/17\/2018\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 158\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.87lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 11.69h x 8.27w x 0.34d","brand":"Mike Smart","offers":[{"title":"Paperback","offer_id":47200928104703,"sku":"9781909253360","price":19.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_932d10f6-12f7-4d2a-b9e0-667b6cde1f57.jpg?v=1756788262","url":"https:\/\/www.whiterainbookhouse.com\/products\/excel-2019-construction-kit-1-mike-smart-9781909253360","provider":"WR Book House","version":"1.0","type":"link"}