Name [ DevCourseWeb.com ] Udemy - Foundations of Data Management and Analysis with Excel

File Type video

Size 1.32GB

UpdateDate 2024-9-26

hash *****94CA18998587A9A3050493A8F0432E71DA

Hot 47

Files Get Bonus Downloads Here.url | 182B ~Get Your Files Here !/1. Welcome and Getting Started/1. Welcome and Course Overview.mp4 | 21.66MB ~Get Your Files Here !/1. Welcome and Getting Started/2. Prerequisites and target audience.mp4 | 20.44MB ~Get Your Files Here !/1. Welcome and Getting Started/3. Importance of data management and analysis in Excel.mp4 | 29.47MB ~Get Your Files Here !/2. Sorting and Filtering/0203.xlsx | 11.36KB ~Get Your Files Here !/2. Sorting and Filtering/1. Sorting data by various criteria.mp4 | 79.83MB ~Get Your Files Here !/2. Sorting and Filtering/2. Filtering data with basic and advanced techniques.mp4 | 144.22MB ~Get Your Files Here !/2. Sorting and Filtering/3. Exercise Sort and filter a sample dataset.mp4 | 22.38MB ~Get Your Files Here !/2. Sorting and Filtering/Excel 0203.pdf | 207.07KB ~Get Your Files Here !/2. Sorting and Filtering/__MACOSX/_0203.xlsx | 986B ~Get Your Files Here !/2. Sorting and Filtering/__MACOSX/_Excel 0203.pdf | 1.86KB ~Get Your Files Here !/3. Grouping and Subtotaling/0303 Activity.xlsx | 12.69KB ~Get Your Files Here !/3. Grouping and Subtotaling/1. Grouping data by categories.mp4 | 79.05MB ~Get Your Files Here !/3. Grouping and Subtotaling/2. Using subtotals to summarize grouped data.mp4 | 69.28MB ~Get Your Files Here !/3. Grouping and Subtotaling/3. Exercise Group and subtotal sales data.mp4 | 24.58MB ~Get Your Files Here !/3. Grouping and Subtotaling/Excel 0303.pdf | 175.71KB ~Get Your Files Here !/3. Grouping and Subtotaling/__MACOSX/_0303 Activity.xlsx | 874B ~Get Your Files Here !/3. Grouping and Subtotaling/__MACOSX/_Excel 0303.pdf | 1.76KB ~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/0404 Contact List.xlsx | 15.57KB ~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/1. Methods to identify and remove duplicates.mp4 | 58.26MB ~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/2. Consolidating data from multiple sources.mp4 | 61.84MB ~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/3. Using Pivot Tables for summarizing data.mp4 | 105.68MB ~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/4. Exercise Clean and consolidate a contact list.mp4 | 29.50MB ~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/__MACOSX/_0404 Contact List.xlsx | 881B ~Get Your Files Here !/5. Logical Functions/0503 Exercise.xlsx | 9.21KB ~Get Your Files Here !/5. Logical Functions/1. IF, AND, OR functions.mp4 | 86.53MB ~Get Your Files Here !/5. Logical Functions/2. SUMIF and COUNTIF.mp4 | 58.49MB ~Get Your Files Here !/5. Logical Functions/3. Exercise Create conditional summaries.mp4 | 16.48MB ~Get Your Files Here !/5. Logical Functions/Excel 0503.pdf | 54.72KB ~Get Your Files Here !/5. Logical Functions/__MACOSX/_0503 Exercise.xlsx | 875B ~Get Your Files Here !/5. Logical Functions/__MACOSX/_Excel 0503.pdf | 1.76KB ~Get Your Files Here !/6. Lookup Functions/0603.xlsx | 13.83KB ~Get Your Files Here !/6. Lookup Functions/1. VLOOKUP and HLOOKUP.mp4 | 92.86MB ~Get Your Files Here !/6. Lookup Functions/2. INDEX and MATCH as alternatives.mp4 | 59.49MB ~Get Your Files Here !/6. Lookup Functions/Excel 0603.pdf | 48.93KB ~Get Your Files Here !/6. Lookup Functions/__MACOSX/_0603.xlsx | 864B ~Get Your Files Here !/6. Lookup Functions/__MACOSX/_Excel 0603.pdf | 1.76KB ~Get Your Files Here !/7. Text and Date Functions/0703.xlsx | 11.76KB ~Get Your Files Here !/7. Text and Date Functions/1. CONCATENATE, LEFT, RIGHT, MID.mp4 | 82.80MB ~Get Your Files Here !/7. Text and Date Functions/2. TODAY, NOW, DATEVALUE.mp4 | 45.54MB ~Get Your Files Here !/7. Text and Date Functions/Excel 0703.pdf | 66.29KB ~Get Your Files Here !/7. Text and Date Functions/__MACOSX/_0703.xlsx | 864B ~Get Your Files Here !/7. Text and Date Functions/__MACOSX/_Excel 0703.pdf | 1.76KB ~Get Your Files Here !/8. Connecting to External Data Sets/1. Connecting to databases.mp4 | 64.96MB ~Get Your Files Here !/8. Connecting to External Data Sets/2. Working with JSON Data.mp4 | 99.17MB ~Get Your Files Here !/8. Connecting to External Data Sets/Excel 0803.pdf | 60.10KB ~Get Your Files Here !/8. Connecting to External Data Sets/Final Project_ TechGuru Inc.pdf | 41.34KB ~Get Your Files Here !/8. Connecting to External Data Sets/Product_Details.xlsx | 10.15KB ~Get Your Files Here !/8. Connecting to External Data Sets/TechGuru_Q1_data.xlsx | 10.59KB ~Get Your Files Here !/8. Connecting to External Data Sets/TechGuru_Q2_data.xlsx | 10.60KB ~Get Your Files Here !/8. Connecting to External Data Sets/TechGuru_Q3_data.xlsx | 10.60KB ~Get Your Files Here !/8. Connecting to External Data Sets/TechGuru_Q4_data.xlsx | 10.58KB ~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_Excel 0803.pdf | 1.76KB ~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_Final Project_ TechGuru Inc.pdf | 1.88KB ~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_Product_Details.xlsx | 299B ~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_TechGuru_Q1_data.xlsx | 299B ~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_TechGuru_Q2_data.xlsx | 299B ~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_TechGuru_Q3_data.xlsx | 299B ~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_TechGuru_Q4_data.xlsx | 299B ~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_orders.json | 866B ~Get Your Files Here !/8. Connecting to External Data Sets/orders.json | 10.47KB ~Get Your Files Here !/Bonus Resources.txt | 386B