Managing and Analyzing Data in Excel

Shares easy-to-use database commands and methods for maintaining an Excel database.In this course, Dennis Taylor shares easy-to-use database commands and methods for maintaining an Excel database. The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions. Topics include: Multiple key sorting Single and multiple column numeric filters Creating a top-ten list with values or percentages Setting up subtotals Creating multiple-field criteria filters Creating unique lists from repeating field data Using the Remove Duplicates command Finding duplicate data with specialized arrays Counting the number of unique items in a list Using SUMIF and COUNTIF functions Working with the database functions such as DSUM and DMAX