Setting Up A Database In Excel 2013 Год выпуска: 2014 Производитель: Lynda Сайт производителя: lynda.com Автор: Dennis Taylor Продолжительность: 0:49 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: Excel isn't just for flat files. You can use it to create a simple database and get even more insights into your data. Join author Dennis Taylor and learn how to create a simple database. The course explains the limits of Excel as a data-management tool and spells out the design considerations for creating a database with it. Dennis also shows how to simplify database creation with tables and manage data with the Form and Data Validation tools. В экселе можно хранить базы данных. Денис Тэйлор поведает об этом в своем лаконичном видеокурсе.
Содержание
Introduction Welcome Using the exercise files 1. Database Design Concerns Design concepts for setting up large lists and restructuring downloaded data Recognizing problems 2. Tables Converting data into tables for enhanced visual appeal and content control Using the Design tab to control table formatting Expanding tables automatically and adding totals Working with formulas in tables Using slicers to facilitate table filtering 3. Controlling the Creation of New Data Using the Form tool to build and view data Using Data Validation to restrict data entries Use validation tools to check the validity of existing data Conclusion Next steps
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
