Udemy - Insights from Data Using Excel

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

Files

[ DevCourseWeb.com ] Udemy - Insights from Data Using Excel
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 01 - Introduction
    • 001 Explore.xlsx (996.8 KB)
    • 001 Introduction.mp4 (45.7 MB)
    • 001 Introduction_en.srt (4.3 KB)
    • 002 Sort, Filter and PivotTables in 2 minutes.mp4 (36.4 MB)
    • 002 Sort, Filter and PivotTables in 2 minutes_en.srt (3.4 KB)
    • 003 Preparing for Data Exploration Personal Finance Example.mp4 (43.7 MB)
    • 003 Preparing for Data Exploration Personal Finance Example_en.srt (5.6 KB)
    • 004 Useful Techniques Before Sorting and Filtering.mp4 (28.8 MB)
    • 004 Useful Techniques Before Sorting and Filtering_en.srt (4.2 KB)
    02 - Sorting and Filtering
    • 001 Installing Filter Buttons and Sorting.mp4 (42.1 MB)
    • 001 Installing Filter Buttons and Sorting_en.srt (4.7 KB)
    • 002 Filtering by Categories.mp4 (46.9 MB)
    • 002 Filtering by Categories_en.srt (5.2 KB)
    • 003 Filtering by Numerical Values.mp4 (44.3 MB)
    • 003 Filtering by Numerical Values_en.srt (5.2 KB)
    • 004 Combining Filters.mp4 (46.3 MB)
    • 004 Combining Filters_en.srt (4.9 KB)
    • 005 Solution to Case Study Challenge #2.mp4 (48.0 MB)
    • 005 Solution to Case Study Challenge #2_en.srt (6.1 KB)
    • 006 Review of Sort and Filter and More.mp4 (49.2 MB)
    • 006 Review of Sort and Filter and More_en.srt (5.0 KB)
    03 - PivotTables
    • 001 Building a PivotTable.mp4 (43.0 MB)
    • 001 Building a PivotTable_en.srt (5.5 KB)
    • 002 Exploring a PivotTable.mp4 (34.7 MB)
    • 002 Exploring a PivotTable_en.srt (3.9 KB)
    • 003 Turning Continuous Values into Categories with Grouping.mp4 (27.6 MB)
    • 003 Turning Continuous Values into Categories with Grouping_en.srt (3.6 KB)
    • 004 Filtering and a Couple Try-it-yourself PivotTables.mp4 (41.9 MB)
    • 004 Filtering and a Couple Try-it-yourself PivotTables_en.srt (5.1 KB)
    • 005 Consultant Time Log Example with PivotTable filtering.mp4 (20.6 MB)
    • 005 Consultant Time Log Example with PivotTable filtering_en.srt (2.9 KB)
    • 006 Case Study Challenge #2 Possible Solutions.mp4 (36.8 MB)
    • 006 Case Study Challenge #2 Possible Solutions_en.srt (6.3 KB)
    • 007 Analyzing Categories Store Purchase Analysis.mp4 (26.5 MB)
    • 007 Analyzing Categories Store Purchase Analysis_en.srt (5.3 KB)
    • 008 Using a PivotTable for Clustering.mp4 (23.6 MB)
    • 008 Using a PivotTable for Clustering_en.srt (4.3 KB)
    • 009 Summarized by Choices and How to Use them.mp4 (33.8 MB)
    • 009 Summarized by Choices and How to Use them_en.srt (5.0 KB)
    • 010 Data Representation Matters.mp4 (52.8 MB)
    • 010 Data Representation Matters_en.srt (6.6 KB)
    04 - Business Case Studies Banking and Marketing
    • 001 Who is Most Likely to Default on Their Loan at This Bank.mp4 (36.7 MB)
    • 001 Who is Most Likely to Default on Their Loan at This Bank_en.srt (3.9 KB)
    • 002 Structuring the Data for a PivotTable.mp4 (48.4 MB)
    • 002 Structuring the Data for a PivotTable_en.srt (6.6 KB)
    • 003 Using PivotTables to Find Groups of Interest.mp4 (36.3 MB)
    • 003 Using PivotTables to Find Groups of Interest_en.srt (6.2 KB)
    • 004 Case Study Challenge #3 Possible Solution.mp4 (18.5 MB)
    • 004 Case Study Challenge #3 Possible Solution_en.srt (3.1 KB)
    • 005 Case Study Challenge #4 Best Marketing Month.mp4 (31.9 MB)
    • 005 Case Study Challenge #4 Best Marketing Month_en.srt (3.8 KB)
    • 006 Case Study Challenge #4 Answers and More Questions.mp4 (22.6 MB)
    • 006 Case Study Challenge #4 Answers and More Questions_en.srt (5.0 KB)
    • 007 Case Study Challenge #5 Personalized Sales Campaign.mp4 (18.6 MB)
    • 007 Case Study Challenge #5 Personalized Sales Campaign_en.srt (2.7 KB)
    • 008 Case Study Challenge #5 Possible Solution.mp4 (32.1 MB)
    • 008 Case Study Challenge #5 Possible Solution_en.srt (5.1 KB)
    • 009 Case Study Challenge #6 Possible Solution.mp4 (30.0 MB)
    • 009 Case Study Challenge #6 Possible Solution_en.srt (6.0 KB)
    05 - Use Functions to Organize Your Data for Exploration
    • 001 Issues of Real-world Data and Missing Data.mp4 (30.5 MB)
    • 001 Issues of Real-world Data and Missing Data_en.srt (4.3 KB)
    • 002 Changing Categories to Numbers of Different Names.mp4 (22.2 MB)
    • 002 Changing Categories to Numbers of Different Names_en.srt (3.1 KB)
    • 003 Introducing the function VLOOKUP.mp4 (28.8 MB)
    • 003 Introducing the function VLOOKUP_en.srt (5.5 KB)
    • 004 The Power of AutoFill for Formulas.mp4 (23.0 MB)
    • 004 The Power of AutoFill for Formulas_en.srt (5.0 KB)
    • 005 Filling a Table by Looking up in Another.mp4 (38.2 MB)
    • 005 Filling a Table by Looking up in Another_en.srt (5.8 KB)
    • 006 Putting numbers in categories (binning) using VLOOKUP.mp4 (40.9 MB)
    • 006 Putting numbers in categories (binning) using VLOOKUP_en.srt (6.1 KB)
    • 007 Using a Calculated Column.mp4 (43.4 MB)
    • 007 Using a Calculated Column_en.srt (4.1 KB)
    • 008 Unstacking Data.mp4 (25.6 MB)
    • 008 Unstacking Data_en.srt (4.2 KB)
    06 - Summary
    • 001 Summary.mp4 (43.5 MB)
    • 001 Summary_en.srt (5.2 KB)
    • Bonus Resources.txt (0.4 KB)

Description

Insights from Data Using Excel



https://DevCourseWeb.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 38 lectures (2h 24m) | Size: 1.27 GB

Draw answers from your data using analysis tools such as filter and PivotTables, with business and personal case studies

What you'll learn
Draw hidden insights from any data file for which there is a question or issue
Merge disparate data files and put your data in a form for easy analysis
Design and apply a PivotTable to best answer a particular question, whether numerical or yes/no.
Sort and filter your data based on a range of criteria
Apply the VLOOKUP function in both forms, in particular to merge data or turn numerical values into pre-defined categories
Calculate an entire column using a simple formula and replicating

Requirements
Basic familiarity with Excel. If you've used it for a list, for example, you're good to go.



Download torrent
1.3 GB
seeders:4
leechers:5
Udemy - Insights from Data Using 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:4
leechers:5
Udemy - Insights from Data Using Excel

Torrent hash: EE7881C5F1E9587DF83558A38DF7F628E34AC46F