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