{"product_id":"the-excel-analysts-guide-to-michael-alexander-9780470567012","title":"The Excel Analyst's Guide to Access","description":"\u003cp\u003e\u003cb\u003eThe ultimate handbook for Excel analysts who need reporting solutions using Access\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExcel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions.\u003c\/p\u003e \u003cp\u003eSales managers, operations analysts, administrative assistants, office managers, and many others who rely heavily on data can benefit from learning to integrate Excel and Access, and this book shows you how.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eCoverage includes: \u003c\/b\u003e\u003c\/p\u003e \u003cul\u003e \u003cli\u003eData Analysis in Access \u0026amp; the Basics of Access\u003c\/li\u003e \u003cli\u003eBeyond Select Queries\u003c\/li\u003e \u003cli\u003eTransforming Your Data with Access\u003c\/li\u003e \u003cli\u003eWorking with Calculations and Dates\u003c\/li\u003e \u003cli\u003ePerforming Conditional Analysis\u003c\/li\u003e \u003cli\u003eAdding Dimension with Subqueries and Domain Aggregate Functions\u003c\/li\u003e \u003cli\u003eRunning Descriptive Statistics in Access\u003c\/li\u003e \u003cli\u003eScheduling and Running Batch Analysis\u003c\/li\u003e \u003cli\u003eLeveraging VBA to Enhance Data Analysis\u003c\/li\u003e \u003cli\u003eReports, Dashboards, and Visualization in Access\u003c\/li\u003e \u003cli\u003ePresenting Data with Access Reports\u003c\/li\u003e \u003cli\u003eUsing Pivot Tables and Pivot Charts in Access\u003c\/li\u003e \u003cli\u003eEnhancing Queries and Reports with Visualizations\u003c\/li\u003e \u003cli\u003eAdvanced Excel and Access Integration Techniques\u003c\/li\u003e \u003cli\u003eGetting Access Data into Excel\u003c\/li\u003e \u003cli\u003eUsing VBA to Move Data between Excel and Access\u003c\/li\u003e \u003cli\u003eExploring Excel and Access Automation\u003c\/li\u003e \u003cli\u003eIntegrating Excel and Access with XML\u003c\/li\u003e \u003cli\u003eIntegrating Excel and Other Office Applications\u003c\/li\u003e \u003cli\u003eAccess VBA Fundamentals\u003c\/li\u003e \u003cli\u003eUnderstanding and Using SQL\u003c\/li\u003e \u003cli\u003eand more!\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eThe Excel Analyst's Guide to Access helps you get more from both applications.\u003c\/i\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eNote: \u003c\/b\u003e CD-ROM\/DVD and other supplementary materials are not included as part of eBook file.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Michael Alexander\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 0470567015\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9780470567012\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Wiley\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 04\/05\/2010\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 624\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 1.91lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.84h x 6.72w x 1.30d","brand":"Michael Alexander","offers":[{"title":"Paperback","offer_id":47136101662975,"sku":"9780470567012","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_e9593708-b124-4eb2-8fad-8391c04cea10.jpg?v=1755022350","url":"https:\/\/www.whiterainbookhouse.com\/products\/the-excel-analysts-guide-to-michael-alexander-9780470567012","provider":"WR Book House","version":"1.0","type":"link"}