The Excel Analyst's Guide to Access, 1st Edition

The Excel Analyst's Guide to Access, 1st Edition

The Excel Analyst's Guide to Access, 1st Edition

eBook
Author(s):Alexander
Format: Original PDF
Published year: 2010
Publisher: Wiley
Language: English
ISBN: 9781118081976, 9781118081808, 9780470646540, 9780470567012

Summary

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, Da

Similar books

© 2026 VitalBooks. All rights reserved.