Lynda Excel 2013 Managing And Analyzing Data | 786227E52B10896E8E476B5FE00B23AF540132F2

Lynda Excel 2013 Managing And Analyzing Data

Name	Lynda - Excel 2013 Managing And Analyzing Data	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	515.5 MB
Total Files	35
Hash	786227E52B10896E8E476B5FE00B23AF540132F2

/0. Introduction/
01. Welcome.mp4	8.3 MB
02. Using the exercise files.mp4	1.6 MB
/1. Sorting Data/
01. Sorting concepts and Sort dialog options.mp4	33.0 MB
02. Sorting from menu icons.mp4	13.9 MB
03. Multiple-key sorting.mp4	18.3 MB
04. Sorting based on the order of data in custom lists.mp4	19.5 MB
05. Sorting by color font, color background, or icon.mp4	25.5 MB
06. Sorting columns from left to right.mp4	12.1 MB
07. Sorting data in random order.mp4	7.9 MB
/2. Filtering Data/
01. Single- and multiple-column text filtering.mp4	15.1 MB
02. Using text filters.mp4	18.8 MB
03. Using date filters.mp4	15.6 MB
04. Using numeric filters.mp4	6.8 MB
05. Using the Top 10 (value or percent) option.mp4	10.9 MB
06. Creating custom filters.mp4	14.5 MB
07. Copying and sorting filtered lists.mp4	13.3 MB
08. Recognizing the limitations of standard filtering.mp4	14.1 MB
/3. Advanced Filter/
01. Using Advanced Filter for complex OR criteria.mp4	34.7 MB
02. Using Advanced Filter for specialized filters.mp4	15.7 MB
03. Using Advanced Filter to create unique lists from repeating field data.mp4	11.0 MB
/4. Creating Automatic Subtotals in Sorted Lists/
01. Setting up single- and multiple-level subtotals.mp4	25.8 MB
02. Expand and collapse displays quickly with grouping and outlining symbols.mp4	40.7 MB
/5. Eliminate Duplicate Data/
01. Using the Remove Duplicates command.mp4	13.3 MB
02. Using a specialized array formula to identify data that's been duplicated.mp4	18.3 MB
03. Using an array formula to count the number of unique items in a list.mp4	13.9 MB
/6. Data Analysis Tools/
01. Using SUMIF, COUNTIF, and related functions for quick data analysis.mp4	27.1 MB
02. Using database functions_ DSUM, DAVERAGE, DMAX, and more.mp4	10.7 MB
03. Converting lists to tables.mp4	50.9 MB
/7. Conclusion/
01. Next steps.mp4	1.5 MB
/Exercise Files/
CH_01.xlsx	675.1 KB
CH_02.xlsx	1.0 MB
CH_03.xlsx	241.1 KB
CH_04.xlsx	165.7 KB
CH_05.xlsx	349.6 KB
CH_06.xlsx	287.3 KB
Total files 35