8-page bifold quick reference guide, one of several quick reference guides for Excel 2010.

This quick reference guide is dedicated to database functionality and database features in Excel. Whether you work with large or small spreadsheets, there are important database features that you need to master to make working in Excel easier and more efficient. In this guide you will learn about: creating subtotals in large worksheet data sets, using grouping and outlines to simply data printing and consolidation, parsing data especially when you import text or csv-based records, working with database functions such as DSUM, using automated data entry forms to simply data entry and ensure accuracy, working with tables and table styles, working with external data from Access-based data, web-based data and text-based data and how to perform ad-hoc queries in Access through Excel.

Product Features

• Part of a series of several quick reference guides for Excel 2010, each focusing on a set of specific and important topics such as Excel 2010-201, Excel 2010-202, Excel 2010-203, Excel 2010-204, Excel 2010-301, Excel 2010-302, Excel 2010-303, Excel 2010-304, Excel 2010-401, Excel 2010-402 and much more.
• A complete guide to learn the basics of database functionality and improve your data analysis skills.
• Manage large worksheet using tools such as subtotals, grouping and outlines.
• Apply database formulas to analyze your data, and create data reports.
• Interact with Access databases and queries while storing the data in Excel.