17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - Foundations Of Data Management And Analysis With Excel
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
Learn to Use Excel to Manage and Analyze Your Data
What you'll learn:
Master Data Organization: Learn to efficiently sort, filter, group, and subtotal data, turning chaos into order in your Excel spreadsheets.
Enhance Analysis with Functions: Acquire essential Excel functions such as logical, lookup, text, and date functions, empowering you to perform complex analysis
Connect and Transform Data: Explore advanced techniques like live SQL queries, data validation, and Power Query, enabling you to connect, transform, and visuali
Hands-on Skill Application: Through guided exercises, apply the techniques learned to real-world scenarios, reinforcing your ability to manage and analyze data
Requirements:
Some experience with Excel basis is helpful for those wishing to complete this course.
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/1. Welcome and Getting Started/1. Welcome and Course Overview.mp4
21.7 MB
~Get Your Files Here !/1. Welcome and Getting Started/2. Prerequisites and target audience.mp4
20.4 MB
~Get Your Files Here !/1. Welcome and Getting Started/3. Importance of data management and analysis in Excel.mp4
29.5 MB
~Get Your Files Here !/2. Sorting and Filtering/0203.xlsx
11.4 KB
~Get Your Files Here !/2. Sorting and Filtering/1. Sorting data by various criteria.mp4
79.8 MB
~Get Your Files Here !/2. Sorting and Filtering/2. Filtering data with basic and advanced techniques.mp4
144.2 MB
~Get Your Files Here !/2. Sorting and Filtering/3. Exercise Sort and filter a sample dataset.mp4
22.4 MB
~Get Your Files Here !/2. Sorting and Filtering/Excel 0203.pdf
207.1 KB
~Get Your Files Here !/2. Sorting and Filtering/__MACOSX/_0203.xlsx
986 B
~Get Your Files Here !/2. Sorting and Filtering/__MACOSX/_Excel 0203.pdf
1.9 KB
~Get Your Files Here !/3. Grouping and Subtotaling/0303 Activity.xlsx
12.7 KB
~Get Your Files Here !/3. Grouping and Subtotaling/1. Grouping data by categories.mp4
79.1 MB
~Get Your Files Here !/3. Grouping and Subtotaling/2. Using subtotals to summarize grouped data.mp4
69.3 MB
~Get Your Files Here !/3. Grouping and Subtotaling/3. Exercise Group and subtotal sales data.mp4
24.6 MB
~Get Your Files Here !/3. Grouping and Subtotaling/Excel 0303.pdf
175.7 KB
~Get Your Files Here !/3. Grouping and Subtotaling/__MACOSX/_0303 Activity.xlsx
874 B
~Get Your Files Here !/3. Grouping and Subtotaling/__MACOSX/_Excel 0303.pdf
1.8 KB
~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/0404 Contact List.xlsx
15.6 KB
~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/1. Methods to identify and remove duplicates.mp4
58.3 MB
~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/2. Consolidating data from multiple sources.mp4
61.8 MB
~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/3. Using Pivot Tables for summarizing data.mp4
105.7 MB
~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/4. Exercise Clean and consolidate a contact list.mp4
29.5 MB
~Get Your Files Here !/4. Removing Duplicates and Data Consolidation/__MACOSX/_0404 Contact List.xlsx
881 B
~Get Your Files Here !/5. Logical Functions/0503 Exercise.xlsx
9.2 KB
~Get Your Files Here !/5. Logical Functions/1. IF, AND, OR functions.mp4
86.5 MB
~Get Your Files Here !/5. Logical Functions/2. SUMIF and COUNTIF.mp4
58.5 MB
~Get Your Files Here !/5. Logical Functions/3. Exercise Create conditional summaries.mp4
16.5 MB
~Get Your Files Here !/5. Logical Functions/Excel 0503.pdf
54.7 KB
~Get Your Files Here !/5. Logical Functions/__MACOSX/_0503 Exercise.xlsx
875 B
~Get Your Files Here !/5. Logical Functions/__MACOSX/_Excel 0503.pdf
1.8 KB
~Get Your Files Here !/6. Lookup Functions/0603.xlsx
13.8 KB
~Get Your Files Here !/6. Lookup Functions/1. VLOOKUP and HLOOKUP.mp4
92.9 MB
~Get Your Files Here !/6. Lookup Functions/2. INDEX and MATCH as alternatives.mp4
59.5 MB
~Get Your Files Here !/6. Lookup Functions/Excel 0603.pdf
48.9 KB
~Get Your Files Here !/6. Lookup Functions/__MACOSX/_0603.xlsx
864 B
~Get Your Files Here !/6. Lookup Functions/__MACOSX/_Excel 0603.pdf
1.8 KB
~Get Your Files Here !/7. Text and Date Functions/0703.xlsx
11.8 KB
~Get Your Files Here !/7. Text and Date Functions/1. CONCATENATE, LEFT, RIGHT, MID.mp4
82.8 MB
~Get Your Files Here !/7. Text and Date Functions/2. TODAY, NOW, DATEVALUE.mp4
45.5 MB
~Get Your Files Here !/7. Text and Date Functions/Excel 0703.pdf
66.3 KB
~Get Your Files Here !/7. Text and Date Functions/__MACOSX/_0703.xlsx
864 B
~Get Your Files Here !/7. Text and Date Functions/__MACOSX/_Excel 0703.pdf
1.8 KB
~Get Your Files Here !/8. Connecting to External Data Sets/1. Connecting to databases.mp4
65 MB
~Get Your Files Here !/8. Connecting to External Data Sets/2. Working with JSON Data.mp4
99.2 MB
~Get Your Files Here !/8. Connecting to External Data Sets/Excel 0803.pdf
60.1 KB
~Get Your Files Here !/8. Connecting to External Data Sets/Final Project_ TechGuru Inc.pdf
41.3 KB
~Get Your Files Here !/8. Connecting to External Data Sets/orders.json
10.5 KB
~Get Your Files Here !/8. Connecting to External Data Sets/Product_Details.xlsx
10.2 KB
~Get Your Files Here !/8. Connecting to External Data Sets/TechGuru_Q1_data.xlsx
10.6 KB
~Get Your Files Here !/8. Connecting to External Data Sets/TechGuru_Q2_data.xlsx
10.6 KB
~Get Your Files Here !/8. Connecting to External Data Sets/TechGuru_Q3_data.xlsx
10.6 KB
~Get Your Files Here !/8. Connecting to External Data Sets/TechGuru_Q4_data.xlsx
10.6 KB
~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_Excel 0803.pdf
1.8 KB
~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_Final Project_ TechGuru Inc.pdf
1.9 KB
~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_orders.json
866 B
~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_Product_Details.xlsx
299 B
~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_TechGuru_Q1_data.xlsx
299 B
~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_TechGuru_Q2_data.xlsx
299 B
~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_TechGuru_Q3_data.xlsx
299 B
~Get Your Files Here !/8. Connecting to External Data Sets/__MACOSX/_TechGuru_Q4_data.xlsx
