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.
- [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.