Skip to content

Lynda - Excel 2013 Managing And Analyzing Data

Sign up to create lists
Report Lynda - Excel 2013 Managing And Analyzing Data
Unverified source. This magnet is from an unverified source. The content may be unsafe or mislabeled. Proceed with caution.
Title: Lynda - ExcelGroup: NOGRPYear: 2013Source: Lynda
Info Hash
786227E52B10896E8E476B5FE00B23AF540132F2
Source
Unverified
Total Size
491.6 MB
Total Files
35
Seeders
2
Leechers
0
Health
2.00
Score
4
Type
Bookware

File List

FileSize
0. Introduction/01. Welcome.mp47.91 MB
0. Introduction/02. Using the exercise files.mp41.54 MB
1. Sorting Data/01. Sorting concepts and Sort dialog options.mp431.43 MB
1. Sorting Data/02. Sorting from menu icons.mp413.3 MB
1. Sorting Data/03. Multiple-key sorting.mp417.42 MB
1. Sorting Data/04. Sorting based on the order of data in custom lists.mp418.6 MB
1. Sorting Data/05. Sorting by color font, color background, or icon.mp424.34 MB
1. Sorting Data/06. Sorting columns from left to right.mp411.55 MB
1. Sorting Data/07. Sorting data in random order.mp47.51 MB
2. Filtering Data/01. Single- and multiple-column text filtering.mp414.44 MB
2. Filtering Data/02. Using text filters.mp417.96 MB
2. Filtering Data/03. Using date filters.mp414.84 MB
2. Filtering Data/04. Using numeric filters.mp46.47 MB
2. Filtering Data/05. Using the Top 10 (value or percent) option.mp410.36 MB
2. Filtering Data/06. Creating custom filters.mp413.79 MB
2. Filtering Data/07. Copying and sorting filtered lists.mp412.7 MB
2. Filtering Data/08. Recognizing the limitations of standard filtering.mp413.43 MB
3. Advanced Filter/01. Using Advanced Filter for complex OR criteria.mp433.09 MB
3. Advanced Filter/02. Using Advanced Filter for specialized filters.mp415.02 MB
3. Advanced Filter/03. Using Advanced Filter to create unique lists from repeating field data.mp410.47 MB
4. Creating Automatic Subtotals in Sorted Lists/01. Setting up single- and multiple-level subtotals.mp424.57 MB
4. Creating Automatic Subtotals in Sorted Lists/02. Expand and collapse displays quickly with grouping and outlining symbols.mp438.79 MB
5. Eliminate Duplicate Data/01. Using the Remove Duplicates command.mp412.72 MB
5. Eliminate Duplicate Data/02. Using a specialized array formula to identify data that's been duplicated.mp417.43 MB
5. Eliminate Duplicate Data/03. Using an array formula to count the number of unique items in a list.mp413.3 MB
6. Data Analysis Tools/01. Using SUMIF, COUNTIF, and related functions for quick data analysis.mp425.86 MB
6. Data Analysis Tools/02. Using database functions_ DSUM, DAVERAGE, DMAX, and more.mp410.17 MB
6. Data Analysis Tools/03. Converting lists to tables.mp448.54 MB
7. Conclusion/01. Next steps.mp41.43 MB
Exercise Files/CH_01.xlsx659.24 KB
Exercise Files/CH_02.xlsx1015.21 KB
Exercise Files/CH_03.xlsx235.4 KB
Exercise Files/CH_04.xlsx161.78 KB
Exercise Files/CH_05.xlsx341.4 KB
Exercise Files/CH_06.xlsx280.55 KB

Trackers

No trackers found.