From the course: Excel: Setting Up a Database (Microsoft 365)
Managing data with Excel
From the course: Excel: Setting Up a Database (Microsoft 365)
Managing data with Excel
- [Dennis] More than ever, businesses and individuals are looking to manage and learn from the data they collect. Building a database in Excel is the first step into managing and gaining even more insights into your data. In this course, I'll show you the best techniques for structuring data efficiently and coherently and how to convert data into a table for advanced visual and content control, including the easy-to-use slicer capability, ideal for presentations. I'll also show you how to use the form tool for viewing data on a record-by-record basis and some tips on using the powerful data validation command so you'll be assured that new data will be entered accurately and with speed, particularly with its powerful picklist technique. Hi, I'm Dennis Taylor. I've been working with Excel for many years and I'm looking forward to showing you the many powerful functions available in Excel. So let's get started.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.