Sophia Passport | 15C402C68EAF38DB5436901F54845652275DD5DF

Sophia Passport

Name	Sophia Passport	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.8 GB
Total Files	209
Hash	15C402C68EAF38DB5436901F54845652275DD5DF

/.../01 Watch This First/
001 WATCH THIS FIRST How to use Udemy download files etc.mp4	172.5 MB
001 WATCH THIS FIRST How to use Udemy download files etc.en.srt	27.0 KB
002 Welcome.mp4	3.8 MB
/02 Jumpstart/
007 Jumpstart Part 2.mp4	84.0 MB
004 Jumpstart Overview.mp4	5.6 MB
006 Jumpstart Part 1.mp4	21.5 MB
006 vgsales-part-1.xlsx	1.2 MB
007 Jumpstart Part 2.en.srt	7.5 KB
008 Jumpstart Part 3.mp4	19.5 MB
008 vgsales-part-3-COMPLETED-updated-E9.xlsx	1.1 MB
008 vgsales-part-3-updated-E9.xlsx	105.8 KB
/.../03 Getting Acclimated with EXCEL - Foundations/
010 Getting Acclimated Section Overview.mp4	4.0 MB
011 EXCEL User Interface.en.srt	5.6 KB
011 EXCEL User Interface.mp4	12.6 MB
012 Adding Deleting and Editing Data in a Cell.en.srt	3.2 KB
012 Adding Deleting and Editing Data in a Cell.mp4	189.5 KB
017 Auto Fit Row and Column Size.mp4	4.1 MB
018 4-7-Reference-File.xlsx	24.9 KB
018 Freeze Panes and Split Boxes.en.srt	5.9 KB
018 Freeze Panes and Split Boxes.mp4	873.2 KB
019 Formatting Numbers.mp4	17.3 MB
020 9-12-Reference-File.xlsx	32.3 KB
020 Formatting Cells.en.srt	4.9 KB
020 Formatting Cells.mp4	4.9 MB
/.../04 Basic EXCEL Formulas Functions - Foundations/
023 Basic Excel Formulas Functions Section Overview.mp4	5.0 MB
024 Basic Math Functions in Excel.en.srt	5.2 KB
024 Basic Math Functions in Excel.mp4	12.7 MB
024 Basic-Mathematical-Operations-COMPLETED.xlsx	37.4 KB
024 Basic-Mathematical-Operations.xlsx	36.8 KB
025 Conditional Math Functions.en.srt	6.8 KB
025 Conditional Math Functions.mp4	12.5 MB
028 Anchoring Cell References and Name Ranges.mp4	17.7 MB
029 Array Functions.mp4	15.8 MB
029 Array-Functions-COMPLETED.xlsx	39.1 KB
029 Array-Functions.xlsx	38.9 KB
030 Quick note about next three lectures.html	1.4 KB
031 Internal Rate of Return (IRR) Functions.en.srt	10.6 KB
031 Internal Rate of Return (IRR) Functions.mp4	16.1 MB
032 Net Present Value (NPV) and Cash Multiple.mp4	26.0 MB
033 Loan Amortization Table.mp4	8.5 MB
036 Fill Commands.mp4	13.1 MB
037 IS Functions.mp4	8.7 MB
038 Rounding Numbers.mp4	7.8 MB
[FreeAllCourse.Com].url	0.1 KB
/.../05 Text Times and Dates Data Formats - Foundations/
040 How EXCEL Treats Text Times and Dates Data.mp4	9.1 MB
040 How-Excel-deals-with-text-times-and-dates-COMPLETED.xlsx	17.8 KB
040 How-Excel-deals-with-text-times-and-dates.xlsx	17.9 KB
041 Changing the Case of Text.en.srt	3.1 KB
041 Changing the Case of Text.mp4	6.7 MB
041 Changing-the-case-COMPLETED.xlsx	40.0 KB
041 Changing-the-case.xlsx	40.2 KB
042 Combine-Text-Strings-COMPLETED.xlsx	40.5 KB
042 Combine-Text-Strings.xlsx	25.9 KB
042 Combining Strings of Text Together.en.srt	3.1 KB
042 Combining Strings of Text Together.mp4	1.1 MB
043 Cutting Substrings from a Text.mp4	13.3 MB
043 Cutting-Substrings-from-Text-COMPLETED.xlsx	46.4 KB
043 Cutting-Substrings-from-Text.xlsx	45.1 KB
044 Cutting-Substrings-from-Text-Part-2-FIND-COMPLETED.xlsx	42.1 KB
044 Cutting-Substrings-from-Text-Part-2-FIND.xlsx	41.2 KB
044 Using the FIND Function.en.srt	6.8 KB
044 Using the FIND Function.mp4	12.4 MB
045 Searching for Specific Text in Data.mp4	3.0 MB
047 Converting Dates from Text into Values.mp4	8.2 MB
047 Converting-Dates-from-Text-into-Values-COMPLETED.xlsx	44.0 KB
047 Converting-Dates-from-Text-into-Values.xlsx	34.4 KB
048 Add-and-Subtract-Dates-COMPLETED.xlsx	43.9 KB
048 Add-and-Subtract-Dates.xlsx	42.1 KB
048 Adding and Subtracting Dates.en.srt	5.6 KB
048 Adding and Subtracting Dates.mp4	5.1 MB
049 Compiling Monthly and Annual Totals.mp4	6.5 MB
050 Conducting Day of the Week Analysis.mp4	9.7 MB
050 Day-of-the-Week-Analysis-COMPLETED.xlsx	95.1 KB
050 Day-of-the-Week-Analysis.xlsx	58.4 KB
051 Combining Date and Time Data.en.srt	4.3 KB
051 Combining Date and Time Data.mp4	378.5 KB
052 Adding and Subtracting Times.mp4	13.1 MB
053 Analysis-by-Hours-of-the-Day-COMPLETED.xlsx	147.8 KB
053 Analysis-by-Hours-of-the-Day.xlsx	86.3 KB
053 Conducting Hours of the Day Analysis.en.srt	6.1 KB
053 Conducting Hours of the Day Analysis.mp4	1.2 MB
/.../06 Introduction to Statistics in EXCEL - Foundations/
055 Brief Overview of Statistics.mp4	5.5 MB
056 Mean Median Mode.mp4	23.2 MB
056 Mean-Median-and-Mode-COMPLETED.xlsx	32.8 KB
056 Mean-Median-and-Mode.xlsx	23.0 KB
057 Percentile and PercentileRank.en.srt	6.6 KB
057 Percentile and PercentileRank.mp4	1.3 MB
058 Frequency Distributions.mp4	4.1 MB
059 Standard Deviation and Variance.mp4	13.6 MB
060 Trends in Data.mp4	18.8 MB
061 Correlations-COMPLETED.xlsx	65.2 KB
061 Correlations.xlsx	64.7 KB
061 Introduction to Correlation.en.srt	7.1 KB
061 Introduction to Correlation.mp4	1.6 MB
/.../07 Handling Data in EXCEL/
064 Lookup with HLOOKUP.mp4	4.9 MB
065 Name Arrays for Reuse and Readability.mp4	1.1 MB
067 Avoid Errors with IF and ISNUMBER.mp4	17.6 MB
067 Avoid-Errors-with-IF-and-ISNUMBER-COMPLETED.xlsx	51.1 KB
067 Avoid-Errors-with-IF-and-ISNUMBER.xlsx	50.5 KB
068 Create Dropdown Lists for Filtering.en.srt	12.3 KB
068 Create Dropdown Lists for Filtering.mp4	27.9 MB
069 Create Unique Lists.mp4	13.2 MB
069 Create-Unique-Lists-COMPLETED.xlsx	58.0 KB
069 Create-Unique-Lists.xlsx	54.3 KB
070 Fast Lookup with INDEX and MATCH.en.srt	12.1 KB
070 Fast Lookup with INDEX and MATCH.mp4	27.4 MB
071 Multi-Condition Lookup with DSUM.mp4	15.0 MB
071 Multi-Condition-Lookup-with-DSUM-COMPLETED.xlsx	58.5 KB
071 Multi-Condition-Lookup-with-DSUM.xlsx	58.2 KB
072 Create Rankings with SMALL and LARGE.en.srt	5.8 KB
072 Create Rankings with SMALL and LARGE.mp4	13.6 MB
073 Multi-Condition Lookup with INDEX and MATCH.mp4	14.7 MB
073 Multi-Condition-Lookup-with-INDEX-and-MATCH-COMPLETED.xlsx	60.2 KB
073 Multi-Condition-Lookup-with-INDEX-and-MATCH.xlsx	60.1 KB
/.../08 Pivot Tables/
074 Insert a Pivot Table.en.srt	8.2 KB
074 Insert a Pivot Table.mp4	12.5 MB
074 Insert-a-Pivot-Table.xlsx	4.3 MB
075 Prepare Data for Pivoting.mp4	26.4 MB
075 Prepare-Data-for-Pivoting-COMPLETED.xlsx	7.1 MB
076 Learn to Pivot a Table.mp4	24.7 MB
076 Learn-to-Pivot-a-Table-COMPLETED.xlsx	7.0 MB
076 Learn-to-Pivot-a-Table.xlsx	6.2 MB
077 Group Rows and Columns.mp4	8.6 MB
077 Group-Rows-and-Columns-COMPLETED.xlsx	6.9 MB
077 Group-Rows-and-Columns.xlsx	7.0 MB
078 Format for Readability.en.srt	6.9 KB
078 Format for Readability.mp4	15.0 MB
078 Format-for-Readability-COMPLETED.xlsx	6.9 MB
078 Format-for-Readability.xlsx	3.1 MB
079 Modify Output Values for Insights.mp4	12.9 MB
079 Modify-Output-Values-for-Insights-COMPLETED.xlsx	6.9 MB
079 Modify-Output-Values-for-Insights.xlsx	4.8 MB
080 Insert Calculated Fields.mp4	20.4 MB
080 Insert-Calculated-Fields-COMPLETED.xlsx	5.8 MB
080 Insert-Calculated-Fields.xlsx	5.7 MB
081 Sort Filter and Slicer.mp4	21.8 MB
081 Sort-Filter-and-Slicer-COMPLETED.xlsx	6.9 MB
081 Sort-Filter-and-Slicer.xlsx	4.1 MB
082 Handle New Data in Pivot Tables.mp4	21.3 MB
082 Handle-New-Data-in-Pivot-Tables-COMPLETED.xlsx	6.2 MB
/.../09 Introduction to Charts in Excel/
083 Intoduction to Charts in Excel Overview.mp4	4.0 MB
084 Why Use Charts Anyway.en.srt	12.3 KB
084 Why Use Charts Anyway.mp4	18.1 MB
085 Line Chart.mp4	7.8 MB
086 Pie Charts.mp4	11.7 MB
087 Bar Chart.mp4	4.4 MB
088 Column Chart - Clustered.mp4	14.7 MB
089 Column Chart - Stacked.en.srt	6.3 KB
089 Column Chart - Stacked.mp4	10.2 MB
090 Column Chart - 100 Stacked.mp4	12.0 MB
091 Combination Chart.en.srt	2.7 KB
091 Combination Chart.mp4	2.6 MB
091 COMBO-Chart.xlsx	30.5 KB
092 Scatter Plot.mp4	8.1 MB
093 Area Chart.en.srt	4.9 KB
093 Area Chart.mp4	2.9 MB
093 AREA-Chart.xlsx	29.2 KB
094 Bubble Chart.mp4	11.6 MB
096 Bullet Chart.mp4	17.7 MB
097 Waterfall Chart.mp4	31.9 MB
/.../10 Quick Note About Case Studies/
098 Quick Note About Case Studies.mp4	7.6 MB
/.../11 Case Study Crytocurrency Data/
099 Cryptocurrency Case Study Overview.en.srt	3.7 KB
099 Cryptocurrency Case Study Overview.mp4	7.2 MB
100 BTC-USD-Historical-Daily-Prices.csv	178.4 KB
100 ETH-USD-Historical-Daily-Prices.csv	32.7 KB
100 Getting and Prepping the Data.en.srt	16.5 KB
100 Getting and Prepping the Data.mp4	48.1 MB
100 LTC-USD-Historical-Daily-Prices.csv	61.2 KB
100 SP500-USD-Historical-Daily-Prices.csv	138.5 KB
101 CORRECTION.html	1.3 KB
102 Bitcoin vs SP500.en.srt	16.4 KB
102 Bitcoin vs SP500.mp4	25.8 MB
103 Ethereum Litecoin Bitcoin.mp4	14.0 MB
104 Introduction to Moving Averages.mp4	41.9 MB
/.../12 Case Study Survey Data/
105 LearnAirbnb.com-Airbnb-Home-Sharing-Report-v1.4.pdf	5.3 MB
105 Survey Data Overview.en.srt	4.0 KB
105 Survey Data Overview.mp4	9.0 MB
106 Preparing the Data.mp4	27.3 MB
107 Demographics - Who Are the Survey Respondents.mp4	21.3 MB
108 Pivoting the Data Part 1.mp4	36.1 MB
109 Pivoting the Data Part 2.mp4	17.0 MB
109 Survey-Data-Pivot-AFTER.xlsx	290.4 KB
/.../13 Case Study The Startup Market/
110 So You Want to Do a Startup.en.srt	4.6 KB
110 So You Want to Do a Startup.mp4	1.5 MB
111 A Note On Data Preparation.mp4	18.9 MB
113 Dig into the Categories.mp4	3.9 MB
115 Pivot and Chart Part 1.mp4	19.0 MB
115 Pivot-and-Chart-Part-1-COMPLETED.xlsx	6.9 MB
115 Pivot-and-Chart-Part-1.xlsx	6.4 MB
116 Pivot and Chart Part 2.en.srt	11.4 KB
116 Pivot and Chart Part 2.mp4	12.8 MB
116 Pivot-and-Chart-2-COMPLETED.xlsx	8.6 MB
116 Pivot-and-Chart-Part-2.xlsx	498.2 KB
117 Analysis Leads to Finding.mp4	4.0 MB
/.../14 Case Study Data Preparation (for Startup Market Data)/
118 Startup Funding CSV File Import.mp4	49.4 MB
118 startup-funding-E6.xlsx	1.1 MB
119 Import and Fix Startup Info Data - Part 1.en.srt	17.3 KB
119 Import and Fix Startup Info Data - Part 1.mp4	12.0 MB
120 Import and Fix Startup Info Data - Part 2.mp4	45.0 MB
120 Import-and-Fix-Startup-Info-Data-Part-2-COMPLETED.xlsx	2.9 MB
121 Import and Fix Startup Info Data - Part 3.mp4	21.9 MB
121 Import-and-Fix-Startup-Info-Data-Part-3-COMPLETED.xlsx	3.3 MB
121 Import-and-Fix-Startup-Info-Data-Part-3.xlsx	3.3 MB
122 Join the Two Tables.en.srt	15.9 KB
122 Join the Two Tables.mp4	47.8 MB
122 Join-the-Two-Tables-COMPLETED.xlsx	8.4 MB
123 Make Unique Lists.mp4	19.3 MB
/.../15 Appendix Bonus Topics/
124 How to extractcopy unique values from a column of data.mp4	30.4 MB
/[FreeAllCourse.Com] Udemy - Data Analysis Essentials Using Excel/
Verify Files.txt	1.0 KB
Total files 209