0

Call Boomerang Books 1300 36 33 32

Description - The Excel Analyst's Guide to Access by Michael Alexander

The ultimate handbook for Excel analysts who need reporting
solutions using Access
Excel 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.
Sales 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.
Coverage includes:

Data Analysis in Access & the Basics of Access

Beyond Select Queries

Transforming Your Data with Access

Working with Calculations and Dates

Performing Conditional Analysis

Adding Dimension with Subqueries and Domain Aggregate
Functions

Running Descriptive Statistics in Access

Scheduling and Running Batch Analysis

Leveraging VBA to Enhance Data Analysis

Reports, Dashboards, and Visualization in Access

Presenting Data with Access Reports

Using Pivot Tables and Pivot Charts in Access

Enhancing Queries and Reports with Visualizations

Advanced Excel and Access Integration Techniques

Getting Access Data into Excel

Using VBA to Move Data between Excel and Access

Exploring Excel and Access Automation

Integrating Excel and Access with XML

Integrating Excel and Other Of?ce Applications

Access VBA Fundamentals

Understanding and Using SQL

and more!

The Excel Analyst's Guide to Access helps you get more from
both applications.
Note: CD-ROM/DVD and other supplementary materials are
not included as part of eBook file.

Buy The Excel Analyst's Guide to Access by Michael Alexander from Australia's Online Independent Bookstore, Boomerang Books.

Book Details

ISBN: 9780470567012
ISBN-10: 0470567015
Format: Paperback / softback
(234mm x 193mm x 32mm)
Pages: 624
Imprint: John Wiley & Sons Inc
Publisher: John Wiley & Sons Inc
Publish Date: 6-Apr-2010
Country of Publication: United States

Book Reviews - The Excel Analyst's Guide to Access by Michael Alexander

» Have you read this book? We'd like to know what you think about it - write a review about Excel Analyst's Guide to Access book by Michael Alexander and you'll earn 50c in Boomerang Bucks loyalty dollars (you must be a Boomerang Books Account Holder - it's free to sign up and there are great benefits!)


Author Biography - Michael Alexander

Michael Alexander is a Microsoft MVP and a veteran consultant. He creates and shares video tutorials with the Microsoft Excel and Access communities via www.datapigtechnologies.com. Mike has written several books on advanced business analysis, including Microsoft Access 2007 Data Analysis, also from Wiley.

A Preview for this title is currently not available.