Lynda - Excel 2013 Managing And Analyzing Data

大小 491.6 MB

文件数 35

Info Hash: 786227E52B10896E8E476B5FE00B23AF540132F2

收录时间 2026-01-16 08:47:28

更新时间 2026-01-16 08:47:28

文件列表 (35)

0. Introduction/01. Welcome.mp4

7.91 MB

0. Introduction/02. Using the exercise files.mp4

1.54 MB

1. Sorting Data/01. Sorting concepts and Sort dialog options.mp4

31.43 MB

1. Sorting Data/02. Sorting from menu icons.mp4

13.3 MB

1. Sorting Data/03. Multiple-key sorting.mp4

17.42 MB

1. Sorting Data/04. Sorting based on the order of data in custom lists.mp4

18.6 MB

1. Sorting Data/05. Sorting by color font, color background, or icon.mp4

24.34 MB

1. Sorting Data/06. Sorting columns from left to right.mp4

11.55 MB

1. Sorting Data/07. Sorting data in random order.mp4

7.51 MB

2. Filtering Data/01. Single- and multiple-column text filtering.mp4

14.44 MB

2. Filtering Data/02. Using text filters.mp4

17.96 MB

2. Filtering Data/03. Using date filters.mp4

14.84 MB

2. Filtering Data/04. Using numeric filters.mp4

6.47 MB

2. Filtering Data/05. Using the Top 10 (value or percent) option.mp4

10.36 MB

2. Filtering Data/06. Creating custom filters.mp4

13.79 MB

2. Filtering Data/07. Copying and sorting filtered lists.mp4

12.7 MB

2. Filtering Data/08. Recognizing the limitations of standard filtering.mp4

13.43 MB

3. Advanced Filter/01. Using Advanced Filter for complex OR criteria.mp4

33.09 MB

3. Advanced Filter/02. Using Advanced Filter for specialized filters.mp4

15.02 MB

3. Advanced Filter/03. Using Advanced Filter to create unique lists from repeating field data.mp4

10.47 MB

4. Creating Automatic Subtotals in Sorted Lists/01. Setting up single- and multiple-level subtotals.mp4

24.57 MB

4. Creating Automatic Subtotals in Sorted Lists/02. Expand and collapse displays quickly with grouping and outlining symbols.mp4

38.79 MB

5. Eliminate Duplicate Data/01. Using the Remove Duplicates command.mp4

12.72 MB

5. Eliminate Duplicate Data/02. Using a specialized array formula to identify data that's been duplicated.mp4

17.43 MB

5. Eliminate Duplicate Data/03. Using an array formula to count the number of unique items in a list.mp4

13.3 MB

6. Data Analysis Tools/01. Using SUMIF, COUNTIF, and related functions for quick data analysis.mp4

25.86 MB

6. Data Analysis Tools/02. Using database functions_ DSUM, DAVERAGE, DMAX, and more.mp4

10.17 MB

6. Data Analysis Tools/03. Converting lists to tables.mp4

48.54 MB

7. Conclusion/01. Next steps.mp4

1.43 MB

Exercise Files/CH_01.xlsx

659.24 KB

Exercise Files/CH_02.xlsx

1015.21 KB

Exercise Files/CH_03.xlsx

235.4 KB

Exercise Files/CH_04.xlsx

161.78 KB

Exercise Files/CH_05.xlsx

341.4 KB

Exercise Files/CH_06.xlsx

280.55 KB

资源详情

免责声明