1. All topics
  2. Business
  3. Business Software and Tools
  4. Spreadsheets
Excel: Setting Up a Database (Microsoft 365) Preview

Excel: Setting Up a Database (Microsoft 365)

With Dennis Taylor Liked by 1,662 users
Duration: 47m Skill level: Intermediate Released: 1/13/2021

Start my 1-month free trial Buy for my team

Course details

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.

Skills you’ll gain

Meet the instructor

Learner reviews

4.6 out of 5

440 ratings
  • 5 star
    Current value: 319 73%
  • 4 star
    Current value: 89 20%
  • 3 star
    Current value: 27 6%
  • 2 star
    Current value: 5 1%
  • 1 star
    Current value: 0 0%

Contents

What’s included

  • Practice while you learn 1 exercise file
  • Learn on the go Access on tablet and phone

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play