Managing and Analyzing Data in Excel 2010
Managing and Analyzing Data in Excel 2010
MP4 | Video: 540p | Duration: 1:32:12 | English | Subtitles: VTT | 213.2 MB
MP4 | Video: 540p | Duration: 1:32:12 | English | Subtitles: VTT | 213.2 MB
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