Free Premium Courses
Home » Posts » Excel: Setting Up a Database (Office 365/Microsoft 365)

Excel: Setting Up a Database (Office 365/Microsoft 365)

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.

Add comment

Advertisement

Categories

Email Newsletter

Subscribe to receive latest articles, tutorials, and ideas in your inbox.

Advertisement

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Newsletter
Subscribe to our newsletter to get the latest updates
Subscribe Newsletter
Subscribe to our newsletter to get the latest updates
Thank You
You are now Subscribed to our newsletter.
Thank You
You are now Subscribed to our newsletter.