{"product_id":"expertexcel-daniel-reed-9781795223263","title":"Expert@excel: 2 In1 for Beginners +and Pivot Tables: A Step by Step Guide to Learn and Master Excel to Get Ahead @ Work, Business and Personal Finance","description":"Do you feel intimidated by how complex Excel can seem? Confused by Pivot tables?\u003cp\u003e\u003cbr\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\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. It 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\u003eTopics Covered In This Book Include: \u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cstrong\u003eBook 1) \u003c\/strong\u003e\u003cstrong\u003eFor Beginners\u003c\/strong\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\u003e. What 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) \u003c\/strong\u003e\u003cstrong\u003ePivot Tables\u003c\/strong\u003e\u003cul\u003e\n\u003cli\u003eThe history of the Pivot table and the mechanics of how it works. \u003c\/li\u003e\n\u003cli\u003eA step-by-step guide on when and how to use Pivot Tables. I will navigate you through examples. \u003c\/li\u003e\n\u003cli\u003eConcepts you need to understand when you are working with Excel Pivot Tables such as generating reports with pivot tables. \u003c\/li\u003e\n\u003cli\u003eThe first steps of feeding data into the pivot table and techniques on \u003cstrong\u003eadvanced visualisation.\u003c\/strong\u003e \u003c\/li\u003e\n\u003cli\u003eFind out the Various Functions You Can Undertake Using Pivot Tables such as creating a dynamic range of data. \u003c\/li\u003e\n\u003cli\u003eDid you know that there are different types of Pivot tables such as a time tracking pivot table, which uses \u003cstrong\u003eWEEKNUM \u003c\/strong\u003efunction. \u003c\/li\u003e\n\u003cli\u003eHow pivot tables can create monthly reports and the other 8 functions of using Pivot Tables \u003c\/li\u003e\n\u003cli\u003eThe benefits of using Pivot Tables over other excel functions\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eInclude End of Chapter Exercises That Will Test Your Newly Acquired knowledge with answers included. \u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eAnd much more \u003c\/p\u003eDon't delay BUY TODAY \u003cem\u003e\u003cstrong\u003escroll up, click the BUY button\u003c\/strong\u003e\u003c\/em\u003e\u003cem\u003e \u003c\/em\u003eand start learning what EXCEL 2 BOOKS IN 1 has to offer\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Daniel Reed\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 179522326X\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781795223263\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 156\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.52lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.00h x 6.00w x 0.36d","brand":"Daniel Reed","offers":[{"title":"Paperback","offer_id":46670468317439,"sku":"9781795223263","price":22.95,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_1bd50ca3-05c7-4834-b329-c5da701ef3ea.jpg?v=1741316923","url":"https:\/\/www.whiterainbookhouse.com\/products\/expertexcel-daniel-reed-9781795223263","provider":"WR Book House","version":"1.0","type":"link"}