No cover art

Udemy - Foundations of Data Management and Analysis with Excel

Other

Size

1.3 GB

Seeders

Leechers

Files

Category

Other

Added

02/29/24 at 4:52pm GMT+1

Status

Verified by VeriPLUS

Infohash

fdd3e94ca18998587a9a3050493a8f0432e71dad

Direct link Torrent file Download now

Description

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

If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com

Published 2/2024

Created by SkillSprints Inc.

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English | Duration: 22 Lectures ( 1h 39m ) | Size: 1.32 GB

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...

File list

Udemy - Foundations of Data Management and Analysis with Excel
~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 299 B
~Get Your Files Here !/Bonus Resources.txt 386 B

Rating

Not rated yet

Comments

No comments yet.

Similar torrents

Name	Size	Date
Udemy - Foundations with Data Management with SQL Verified in Other	1.4 GB	02/29/24	3	0
Python in Excel Advanced_ Mastering Data Analysis and Financial Modeling with Python Au ... Verified in eBooks	1 MB	06/08/24	3	1
Foundational Statistics for Data Analysis with Excel 2022 Verified in Other	2.3 GB	05/21/23	2	0
Udemy - Advance Analytics with Excel - data analysis toolpak - Solver Verified in Other	1.4 GB	08/17/23	2	1
Udemy - Data Processing and Analysis with MS EXCEL & MS ACCESS Verified in Other	548 MB	03/02/21	1	1
[ FreeCryptoLearn.com ] Udemy - Investment Analysis and Portfolio Management (with Python) Verified in Other	3.2 GB	01/27/22	1	0
[GigaCourse.Com] Udemy - Data Analysis with Pandas and Python Verified in Other	4.2 GB	06/09/22	1	0
[ CourseWikia.com ] Udemy - Data Analysis with ChatGPT in Excel Verified in Other	1.1 GB	10/30/23	1	0
Udemy - Time Series Analysis and Forecasting with MS Excel Verified in Other	1.5 GB	11/16/23	1	2
[DesireCourse.Com] Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables Verified in Other	1.1 GB	10/30/18	0	0
[FreeCourseLab.com] Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables Verified in Other	1.1 GB	11/27/18	0	1
[DesireCourse.Com] Udemy - Data Analysis with Pandas and Python Verified in Other	2.3 GB	12/16/18	0	1
[FreeCourseSite.com] Udemy - Microsoft Excel - Data Analysis with Excel Pivot Tables in Other	1.1 GB	12/20/18	0	1
[DesireCourse.Com] Udemy - Microsoft Excel - Master Data Analysis, Pivot Tables and BI Verified in Other	2.5 GB	01/02/19	0	1
Power Excel with MrExcel - Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Pow ... in Other	48 MB	02/03/19	0	0