Excel 303 - Database Functionality
Product Description
8-page bi-fold.
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 automate 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.
The guide is also structured to be a companion for hands-on training or self-paced training. It includes step by step instructions and downloadable exercise files.
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 automate 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.
The guide is also structured to be a companion for hands-on training or self-paced training. It includes step by step instructions and downloadable exercise files.