2014
Lynda
Dennis Taylor
2:02
English
When you work with large amounts of data, you need tools to manage the sheer volume of information and get the most value from it. Enter Excel 2013. In this course, Dennis Taylor shows a variety of ways to use sorting to order your spreadsheets, insert subtotals into sorted lists, see just data you need with filtering, identify and delete duplicate data, and use the SUMIF and database functions to further analyze your data.
Introduction
Welcome
Using the exercise files
1. Sorting Data
Sorting concepts and Sort dialog options
Sorting from menu icons
Multiple-key sorting
Sorting based on the order of data in custom lists
Sorting by color font, color background, or icon
Sorting columns from left to right
Sorting data in random order
2. Filtering Data
Single- and multiple-column text filtering
Using text filters
Using date filters
Using numeric filters
Using the Top 10 (value or percent) option
Creating custom filters
Copying and sorting filtered lists
Recognizing the limitations of standard filtering
3. Advanced Filter
Using Advanced Filter for complex OR criteria
Using Advanced Filter for specialized filters
Using Advanced Filter to create unique lists from repeating field data
4. Creating Automatic Subtotals in Sorted Lists
Setting up single- and multiple-level subtotals
Expand and collapse displays quickly with grouping and outlining symbols
5. Eliminate Duplicate Data
Using the Remove Duplicates command
Using a specialized array formula to identify data that's been duplicated
Using an array formula to count the number of unique items in a list
6. Data Analysis Tools
Using SUMIF, COUNTIF, and related functions for quick data analysis
Using database functions: DSUM, DAVERAGE, DMAX, and more
Converting lists to tables
Conclusion
Next steps
Download File Size:478.97 MB