This
8-page bifold quick reference guide (cheat sheet) 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.

All of our quick guides are developed, designed and published in the US. They are printed on a high-quality sustainable stock that features UV coating which resists fading and spills. Unlike the competition, our guides offer in-depth details, step-by-step exercises, structured content that is based on adult learning concepts and are written by expert instructors who are every day users of the software application. Yes, our guides are priced higher; however, the quality and value found in these guides are far superior to the competition. With our quick reference guides, you can achieve more today, and make a great investment for tomorrow.

Note for Corporate Training Departments: Save time and save money. Do not eliminate software training, improve it! With our unique and affordable quick reference guides, you will empower your employees to do more with less, to be more productive and learn what they need when they need it. Preserve the investment you have made in your employees, by offering them this quick reference guide, either as a self-learning tool or as part of your corporate training strategy.

Product Features

• Part of a series of several quick reference guides for Excel 2013, each focusing on a set of specific and important topics such as Excel 2013-201, Excel 2013-202, Excel 2013-203, Excel 2013-204, Excel 2013-205, Excel 2013-206, Excel 2013-301, Excel 2013-302, Excel 2013-303, Excel 2013-304, Excel 2013-401, Excel 2013-402 and much more.
• A complete guide to learn the basics of database functionality: database setup, importing/exporting of data, interaction with data set formats and database analysis.
• Manage large worksheet using tools such as subtotals, grouping and outlines
• Apply database formulas to analyze your data. Save valuable time and increase productivity.
• Interact with Access databases and queries; create linked data sets and dynamic queries.