Lynda - Excel 2013 Managing And Analyzing Data

mp4   Hot：740   Size：491.6 MB   Created：2017-08-28 17:01:18   Update：2021-12-07 02:02:02  

Download link

小提示：当迅雷提示“下载出错”或“无法下载”等字样时，并非资源有问题，请更换 bitcomet(比特彗星) 即可下载，或者使用迅雷5。

File List

  • 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

Download Info

  • Tips

    “Lynda - Excel 2013 Managing And Analyzing Data” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.