Alexander, Michael
The Excel Analyst's Guide to Access
- ISBN 13:
- 9780470567012
- author:
- Alexander, Michael
- format:
- Paperback
- publisher:
- John Wiley & Sons
- language:
- English
- Publication Year:
- 2010
- Pages:
- 624
- Dimensions:
- 23.4 x 18.5 x 3.6 cm
- Genre:
- Computer Software Packages
- Condition:
- New
- Availability:
- Item usually sent within 10 working days
Description
The Excel Analyst's Guide to Access is a comprehensive handbook for those who need reporting solutions using both Excel and Access. This book provides an in-depth review of the analytical and reporting functionality offered by Access, highlighting how it enhances Excel reporting capabilities.
By learning how to integrate these two applications, sales managers, operations analysts, administrative assistants, and office managers can benefit from improved data analysis and reporting. The guide covers a range of topics, including data analysis in Access, working with calculations and dates, performing conditional analysis, and creating reports using pivot tables and pivot charts.
With this book, you'll gain the skills to get more from both Excel and Access, including automating tasks, integrating data between applications, and leveraging VBA to enhance your data analysis. The guide also covers advanced techniques for enhancing queries and reports with visualizations, as well as using SQL and other technologies.
Related Products
Related Products
R for Excel Users: An Introduction to R for Excel Analysts
Taveras, John L.
Power BI for the Excel Analyst: The essential guide to starting your Power BI journey
Hopkins, Wyn
The Art of Access: A Practical Guide for Museum Accessibility (Art of Access)
Pressman, Heather
Learn Excel: A Beginners Guide To Learning Excel (Excel for Beginners)
Adams, Terrence
The Analyst
John Katzenbach