Filename Size 01.Introduction/01.01.Become efficient and effective with your data in Excel.mp4 5.8 MB 01.Introduction/01.01.Become efficient and effective with your data in Excel.srt 1.5 KB 02.Data Preparation/02.02.Structure data for optimum usage in Excel.mp4 15.4 MB 02.Data Preparation/02.02.Structure data for optimum usage in Excel.srt 7.9 KB 02.Data Preparation/02.03.Convert lists to tables.mp4 23.3 MB 02.Data Preparation/02.03.Convert lists to tables.srt 4 KB 02.Data Preparation/02.04.Use formulas in tables.mp4 18.8 MB 02.Data Preparation/02.04.Use formulas in tables.srt 7.8 KB 03.Sort Data/03.05.Sort concepts and Sort menu options.mp4 15.1 MB 03.Sort Data/03.05.Sort concepts and Sort menu options.srt 1.3 KB 03.Sort Data/03.06.Multiple-key sorting.mp4 14.4 MB 03.Sort Data/03.06.Multiple-key sorting.srt 3.3 KB 03.Sort Data/03.07.Sort from menu icons.mp4 16.4 MB 03.Sort Data/03.07.Sort from menu icons.srt 1.5 KB 03.Sort Data/03.08.Sort based on the order of data in custom lists.mp4 21.3 MB 03.Sort Data/03.08.Sort based on the order of data in custom lists.srt 1.2 KB 03.Sort Data/03.09.Sort by cell color, font color, or cell icon.mp4 23.4 MB 03.Sort Data/03.09.Sort by cell color, font color, or cell icon.srt 3.2 KB 03.Sort Data/03.10.Sort columns.mp4 7.4 MB 03.Sort Data/03.10.Sort columns.srt 2.7 KB 03.Sort Data/03.11.Sort data in random order.mp4 7.4 MB 03.Sort Data/03.11.Sort data in random order.srt 4.5 KB 04.Create Automatic Subtotals in Sorted Lists/04.12.Set up single- and multiple-level subtotals.mp4 19.4 MB 04.Create Automatic Subtotals in Sorted Lists/04.12.Set up single- and multiple-level subtotals.srt 9 KB 04.Create Automatic Subtotals in Sorted Lists/04.13.Expand and collapse displays quickly with grouping and outlining symbols.mp4 20.4 MB 04.Create Automatic Subtotals in Sorted Lists/04.13.Expand and collapse displays quickly with grouping and outlining symbols.srt 2.8 KB 05.Filter Data/05.14.Filter single and multiple columns.mp4 15.9 MB 05.Filter Data/05.14.Filter single and multiple columns.srt 5.4 KB 05.Filter Data/05.15.Text filters.mp4 13.3 MB 05.Filter Data/05.15.Text filters.srt 3.8 KB 05.Filter Data/05.16.Date filters.mp4 11.6 MB 05.Filter Data/05.16.Date filters.srt 6 KB 05.Filter Data/05.17.Numeric filters.mp4 16.5 MB 05.Filter Data/05.17.Numeric filters.srt 6.9 KB 05.Filter Data/05.18.Top ten (value or percent) option.mp4 14.1 MB 05.Filter Data/05.18.Top ten (value or percent) option.srt 8.8 KB 05.Filter Data/05.19.Custom filters and wildcards ( and ).mp4 20.5 MB 05.Filter Data/05.19.Custom filters and wildcards ( and ).srt 3 KB 05.Filter Data/05.20.Copy and print filtered lists.mp4 17.9 MB 05.Filter Data/05.20.Copy and print filtered lists.srt 4.6 KB 05.Filter Data/05.21.Recognize the limitations of standard filtering.mp4 11.4 MB 05.Filter Data/05.21.Recognize the limitations of standard filtering.srt 6.2 KB 05.Filter Data/05.22.Filter table data interactively using slicers.mp4 22.8 MB 05.Filter Data/05.22.Filter table data interactively using slicers.srt 3.1 KB 06.Advanced Filtering Tools/06.23.Advanced Filter for complex OR criteria.mp4 20 MB 06.Advanced Filtering Tools/06.23.Advanced Filter for complex OR criteria.srt 2.5 KB 06.Advanced Filtering Tools/06.24.Advanced Filter for specialized filters.mp4 12.5 MB 06.Advanced Filtering Tools/06.24.Advanced Filter for specialized filters.srt 5.9 KB 06.Advanced Filtering Tools/06.25.Advanced Filter to create unique lists from repeating field data.mp4 13 MB 06.Advanced Filtering Tools/06.25.Advanced Filter to create unique lists from repeating field data.srt 7 KB 06.Advanced Filtering Tools/06.26.Add the AutoFilter button for selection filtering.mp4 7.4 MB 06.Advanced Filtering Tools/06.26.Add the AutoFilter button for selection filtering.srt 3.1 KB 07.Eliminate Duplicate Data/07.27.Remove Duplicates command.mp4 11.1 MB 07.Eliminate Duplicate Data/07.27.Remove Duplicates command.srt 7.1 KB 07.Eliminate Duplicate Data/07.28.Use formulas to identify duplicate data and number of unique entries.mp4 15.8 MB 07.Eliminate Duplicate Data/07.28.Use formulas to identify duplicate data and number of unique entries.srt 8.9 KB 07.Eliminate Duplicate Data/07.29.Use new Excel functions to count unique entries and create unique lists.mp4 16.5 MB 07.Eliminate Duplicate Data/07.29.Use new Excel functions to count unique entries and create unique lists.srt 3 KB 08.Data Analysis Tools/08.30.SUMIF, COUNTIF, and related functions for quick data analysis.mp4 17.6 MB 08.Data Analysis Tools/08.30.SUMIF, COUNTIF, and related functions for quick data analysis.srt 8.4 KB 08.Data Analysis Tools/08.31.Explore more database functions.mp4 13.9 MB 08.Data Analysis Tools/08.31.Explore more database functions.srt 1 KB 08.Data Analysis Tools/08.32.Use the AGGREGATE function to bypass errors and hidden rows.mp4 16.8 MB 08.Data Analysis Tools/08.32.Use the AGGREGATE function to bypass errors and hidden rows.srt 1.1 KB 09.Conclusion/09.33.Next steps.mp4 1006.8 KB 09.Conclusion/09.33.Next steps.srt 649 B Ex_Files_Managing_Analyzing_Data_Excel.zip 2.3 MB Udemy Course downloader.txt 94 B