[Lynda.com] Excel 2013: Managing and Analyzing Data In Depth [2014, ENG]

Содержание

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

Скриншоты