Udemy - Foundations of Data Management and Analysis with Excel

seeders: 14
leechers: 16
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ DevCourseWeb.com ] Udemy - Foundations of Data Management and Analysis with Excel
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Welcome and Getting Started
    • 1. Welcome and Course Overview.mp4 (21.7 MB)
    • 2. Prerequisites and target audience.mp4 (20.4 MB)
    • 3. Importance of data management and analysis in Excel.mp4 (29.5 MB)
    2. Sorting and Filtering
    • 0203.xlsx (11.4 KB)
    • 1. Sorting data by various criteria.mp4 (79.8 MB)
    • 2. Filtering data with basic and advanced techniques.mp4 (144.2 MB)
    • 3. Exercise Sort and filter a sample dataset.mp4 (22.4 MB)
    • Excel 0203.pdf (207.1 KB)
      • __MACOSX
      • _0203.xlsx (1.0 KB)
      • _Excel 0203.pdf (1.9 KB)
      3. Grouping and Subtotaling
      • 0303 Activity.xlsx (12.7 KB)
      • 1. Grouping data by categories.mp4 (79.1 MB)
      • 2. Using subtotals to summarize grouped data.mp4 (69.3 MB)
      • 3. Exercise Group and subtotal sales data.mp4 (24.6 MB)
      • Excel 0303.pdf (175.7 KB)
        • __MACOSX
        • _0303 Activity.xlsx (0.9 KB)
        • _Excel 0303.pdf (1.8 KB)
        4. Removing Duplicates and Data Consolidation
        • 0404 Contact List.xlsx (15.6 KB)
        • 1. Methods to identify and remove duplicates.mp4 (58.3 MB)
        • 2. Consolidating data from multiple sources.mp4 (61.8 MB)
        • 3. Using Pivot Tables for summarizing data.mp4 (105.7 MB)
        • 4. Exercise Clean and consolidate a contact list.mp4 (29.5 MB)
          • __MACOSX
          • _0404 Contact List.xlsx (0.9 KB)
          5. Logical Functions
          • 0503 Exercise.xlsx (9.2 KB)
          • 1. IF, AND, OR functions.mp4 (86.5 MB)
          • 2. SUMIF and COUNTIF.mp4 (58.5 MB)
          • 3. Exercise Create conditional summaries.mp4 (16.5 MB)
          • Excel 0503.pdf (54.7 KB)
            • __MACOSX
            • _0503 Exercise.xlsx (0.9 KB)
            • _Excel 0503.pdf (1.8 KB)
            6. Lookup Functions
            • 0603.xlsx (13.8 KB)
            • 1. VLOOKUP and HLOOKUP.mp4 (92.9 MB)
            • 2. INDEX and MATCH as alternatives.mp4 (59.5 MB)
            • Excel 0603.pdf (48.9 KB)
              • __MACOSX
              • _0603.xlsx (0.8 KB)
              • _Excel 0603.pdf (1.8 KB)
              7. Text and Date Functions
              • 0703.xlsx (11.8 KB)
              • 1. CONCATENATE, LEFT, RIGHT, MID.mp4 (82.8 MB)
              • 2. TODAY, NOW, DATEVALUE.mp4 (45.5 MB)
              • Excel 0703.pdf (66.3 KB)
                • __MACOSX
                • _0703.xlsx (0.8 KB)
                • _Excel 0703.pdf (1.8 KB)
                8. Connecting to External Data Sets
                • 1. Connecting to databases.mp4 (65.0 MB)
                • 2. Working with JSON Data.mp4 (99.2 MB)
                • Excel 0803.pdf (60.1 KB)
                • Final Project_ TechGuru Inc.pdf (41.3 KB)
                • Product_Details.xlsx (10.2 KB)
                • TechGuru_Q1_data.xlsx (10.6 KB)
                • TechGuru_Q2_data.xlsx (10.6 KB)
                • TechGuru_Q3_data.xlsx (10.6 KB)
                • TechGuru_Q4_data.xlsx (10.6 KB)
                  • __MACOSX
                  • _Excel 0803.pdf (1.8 KB)
                  • _Final Project_ TechGuru Inc.pdf (1.9 KB)
                  • _Product_Details.xlsx (0.3 KB)
                  • _TechGuru_Q1_data.xlsx (0.3 KB)
                  • _TechGuru_Q2_data.xlsx (0.3 KB)
                  • _TechGuru_Q3_data.xlsx (0.3 KB)
                  • _TechGuru_Q4_data.xlsx (0.3 KB)
                  • _orders.json (0.8 KB)
                • orders.json (10.5 KB)
                  • Bonus Resources.txt (0.4 KB)

Description

Foundations of Data Management and Analysis with Excel

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.



Download torrent
1.3 GB
seeders:14
leechers:16
Udemy - Foundations of Data Management and Analysis with Excel

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
1.3 GB
seeders:14
leechers:16
Udemy - Foundations of Data Management and Analysis with Excel

Torrent hash: FDD3E94CA18998587A9A3050493A8F0432E71DAD