{"product_id":"expert-excel-daniel-reed-9781795221696","title":"Expert @ Excel: 2 In1 for Beginners + VBA Programming: A Step by Step Guide to Learn and Master Excel to Get Ahead @ Work, Business an","description":"Do you feel intimidated by how complex Excel can seem? Confused by VBA Programming? \u003cp\u003e\u003c\/p\u003eI know how you feel but keep on reading if you want to know how to overcome this.... \u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cstrong\u003e***\u003c\/strong\u003e\u003cstrong\u003eFREE BOOK when you purchase this book\u003c\/strong\u003e\u003cstrong\u003e*** \u003c\/strong\u003e\u003cbr\u003e\u003cp\u003e\u003cstrong\u003e\u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\u003cstrong\u003e***\u003c\/strong\u003e\u003cstrong\u003eGet the Kindle version for FREE when you order the paperback\u003c\/strong\u003e\u003cstrong\u003e***\u003c\/strong\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eDid you know that up to 78% of middle-skill jobs require applicants to be proficient in MS Excel? It is shown that those who were able to prove their mastery of the program were set to receive up to 30% more than their peers. But there's far more to Excel than just being a potent addition to your resume. \u003c\/p\u003e\u003cp\u003eExcel is essentially one of the most powerful software tools for collecting and analysing data when used to its full potential. But all too often you may not be making the most of what excel has to offer. \u003c\/p\u003e\u003cp\u003eIt is estimated that on average people only use 20% of functions available on excel because they are unaware of what each button and function does, are you part of the average? Well go beyond being average and learn new skills that will set you apart from the rest. \u003c\/p\u003e\u003cp\u003eWhether you want to enhance your productivity at work, in business or use it as a tool to help you organise your personal finances this is for you. \u003cbr\u003e\u003c\/p\u003eTopics Covered In This Book Include: \u003cstrong\u003e\u003c\/strong\u003e\u003cbr\u003e\u003cstrong\u003e\u003c\/strong\u003e\u003cbr\u003e\u003cstrong\u003eBook 1) \u003c\/strong\u003e\u003cstrong\u003eFor Beginners\u003c\/strong\u003e\u003cstrong\u003e\u003c\/strong\u003e\u003cbr\u003e\u003cul\u003e\n\u003cli\u003eReasons why excel is and will continue to be one of the most important software tools to get ahead in your career and personal finance. \u003c\/li\u003e\n\u003cli\u003eHow to navigate around the Excel interface\u003c\/li\u003e\n\u003cli\u003eAn in-depth look at \u003cstrong\u003eformulas and functions\u003c\/strong\u003eand when to use them\u003c\/li\u003e\n\u003cli\u003eEssential terms and vocabulary you must be familiar with in order to become a fluent excel user \u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSorting and filtering data.\u003c\/strong\u003eCommon mistakes that users make when using this function and how this could be used more efficiently. \u003c\/li\u003e\n\u003cli\u003eAmazing \u003cstrong\u003echarts and reports\u003c\/strong\u003eis the best way of presenting data. We will take a look at how to create charts and reports that can be used in meetings or present your monthly income and expenditure. \u003c\/li\u003e\n\u003cli\u003eLearn simple techniques to get your data message across clearly by making your worksheet presentable and less intimidating to others at work. \u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePivot tables.\u003c\/strong\u003eWhat are they and the advantages of them over other excel functions with examples and exercises on how and when to use them\u003c\/li\u003e\n\u003cli\u003eWhat are \u003cstrong\u003eMacros\u003c\/strong\u003e? This will be explained with examples of how and when they are used in excel?\u003c\/li\u003e\n\u003cli\u003eHow are macros created? This leads to introducing what \u003cstrong\u003eVBA programming\u003c\/strong\u003eis\u003c\/li\u003e\n\u003c\/ul\u003e\u003cstrong\u003eBook 2) VBA Programming\u003c\/strong\u003e\u003cbr\u003e\u003cul\u003e\n\u003cli\u003eWhat you can use Visual Basic Application and will go into detail how VBA can help automate documents such as word processing. \u003c\/li\u003e\n\u003cli\u003eHow to navigate your way around an \u003cstrong\u003eIDE (Integrated Development Environment)\u003c\/strong\u003eand what each window represents. \u003c\/li\u003e\n\u003cli\u003eClear steps on \u003cstrong\u003ehow to write a program\u003c\/strong\u003eand the 5 important questions you must think about before you start to write. \u003c\/li\u003e\n\u003cli\u003eThe syntax and the structure you must follow when writing code in VBA. \u003c\/li\u003e\n\u003cli\u003eHow to use the macro recorder and it's importance when performing tasks.\u003c\/li\u003e\n\u003cli\u003eThe four decision-making and \u003cstrong\u003eLoop statements\u003c\/strong\u003ethat VBA programming uses\u003c\/li\u003e\n\u003cli\u003eWhat arrays are and how could we use this in VBA programming\u003c\/li\u003e\n\u003cli\u003eWhat the user interface is and how to design a form. This shows clear illustrations on how to create this. \u003c\/li\u003e\n\u003cli\u003e\n\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Daniel Reed\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1795221690\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781795221696\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Independently Published\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 01\/26\/2019\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 170\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.57lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.00h x 6.00w x 0.39d\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Daniel Reed","offers":[{"title":"Paperback","offer_id":44077450297599,"sku":"9781795221696","price":22.95,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_7926a3fd-dbf6-4611-919c-421725ad3b21.jpg?v=1685470051","url":"https:\/\/www.whiterainbookhouse.com\/products\/expert-excel-daniel-reed-9781795221696","provider":"WR Book House","version":"1.0","type":"link"}