Week	Class date	Topic	Videos	Time requirements	Time per week
Week 1	2/21/2018	Intro to Business Analytics	# 02 - Excel rules	12:37:24 AM	1:43:50 AM
Week 2	2/28/2018	Basic Excel functions 	# 03 - What If Analysis I	12:05:28 AM	
			# 04 - What If Analysis II	12:04:46 AM	
			# 05 - What If Analysis III	12:11:31 AM	
			# 06 - What If Analysis IV	12:09:46 AM	
			# 07 - Basic Data visualization	12:14:26 AM	
			# 08 - VLOOKUP & LOOKUP/SUMPRODUCT	12:19:51 AM	
			# 09 - INDEX & MATCH & IF	12:10:57 AM	
			# 10 - Fix Excel Formula Errors	12:17:16 AM	
			# 11 - Excel Tables (Excel dynamics)	12:09:49 AM	
Week 3	3/7/2018	Clean & Transform & Format Data	# 12 - Basic Data Rules	12:15:48 AM	1:20:43 AM
			"# 13 - Sort, Filter, Pivot Tables"	12:21:38 AM	
			"# 14 - Logical Formulas, Conditional Formatting"	12:13:29 AM	
			"# 27 - Formulas, Flash fill, Text to Columns"	12:29:48 AM	
Week 4	3/14/2018	Descriptive Statistics 	# 15 - Frequency Distributions (1)	12:11:51 AM	2:23:11 AM
			# 16 - Frequency Distributions (2)	12:07:29 AM	
			# 17 - Frequency Array Function 	12:23:01 AM	
			# 18 - Data Analysis Add In for Frequency and Distribution	12:09:33 AM	
			# 19 - Pivot Tables rules for Frequency	12:16:29 AM	
			# 20 - Skew shape of Histogram	12:03:18 AM	
			"# 21 - AVERAGE,MEDIAN MODE.MULT functions"	12:09:03 AM	
			# 22 - Geometric Mean	12:11:32 AM	
			"# 23 - Variability, Varinace, Standard Deviation"	12:18:20 AM	
			# 24 - Empirical Rules & NORM.DIST & NORM.S.DIST	12:13:58 AM	
			# 25 - Percentiles & Quartiles	12:13:16 AM	
			# 26 - Box & Whisker Plot Chart	12:05:21 AM	
Week 5	3/21/2018	Power Query	# 28 - Text file Import	12:21:53 AM	1:19:53 AM
			# 29 - CSV File Import	12:11:19 AM	
			# 31 - Excel Files I	12:12:06 AM	
			# 32 - Excel Files II	12:08:58 AM	
			# 33 - Transform Bad Data	12:11:21 AM	
			# 34 - Import & Merge Multiple Sources	12:05:01 AM	
			# 35 - Data from Web Side	12:03:00 AM	
			# 36 - Transform Data From Multiple Columns to Single Column	12:06:15 AM	
Week 6	3/28/2018	Case I 			
Week 7	4/4/2018				
Week 8	4/11/2018				
Week 9	4/18/2018				
Week 10	4/25/2018	Case II 			
Week 11	5/2/2018				
Week 12	5/9/2018				
Week 13	5/16/2018