Excel: Setting Up a Database (Microsoft 365).
(Online Course)
Author
Contributors
Published
Carpenteria, CA linkedin.com, 2021.
Format
Online Course
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
1/13/202112:00:00AM
Participants/Performers
Presenter: Dennis Taylor
Description
Learn how to create a simple yet powerful database using Microsoft Excel. This course covers all the steps, from preparing data to using slicers to filter data.
Description
Did you know you can use Excel to create a simple database and get even more insights into your data? Join instructor Dennis Taylor and learn how to create a simple database. Dennis explains how to prepare lists that are suitable for data analysis. He goes into how to use the Form tool to view and manage records in a list, then covers how to use the Data Validation command to enter data quickly and accurately. Dennis steps through how to convert data to a table and use its many valuable features. He discusses the Table Design tab, demonstrating how to access the many formatting features to apply to tables. He demonstrates how to expand tables quickly and easily by adding adjacent rows and columns, as well as total rows. Dennis highlights some techniques for creating formulas using field names. He concludes by showing you how to use slicers to filter data with appealing, easy-to-read visuals.
System Details
Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.
Citations
APA Citation, 7th Edition (style guide)
Taylor, D. (2021). Excel: Setting Up a Database (Microsoft 365) . linkedin.com.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Taylor, Dennis. 2021. Excel: Setting Up a Database (Microsoft 365). linkedin.com.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Taylor, Dennis. Excel: Setting Up a Database (Microsoft 365) linkedin.com, 2021.
MLA Citation, 9th Edition (style guide)Taylor, Dennis. Excel: Setting Up a Database (Microsoft 365) linkedin.com, 2021.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.