Week	Class date	Topic	Videos	Time requirements	Time per week	
Week 1	3/4/2021	Intro to Business Analytics	# 02 - Excel rules	12:37:24 AM	1:43:50 AM	
Week 2	3/11/2021	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/18/2021	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/25/2021	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	4/1/2021	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		
##### Sheet/List 2 #####
Týden 1	2/17/2022	"Air France, Chytré auto"						
Týden 2	2/24/2022	"Chytré auto - závěry. Podpora rodin? hypotéka a neb co umí excel , Customers Relationship Management (CRM)"						
Týden 3	3/3/2022	BMW Case - CRM						
Týden 4	3/10/2022							
Týden 5	3/17/2022							
Týden 6	3/24/2022							
Týden 7	3/31/2022	prezentace výsledků						
Týden 8	4/7/2022	klimatická data						
Týden 9	4/14/2022	COVID - model pro rozhodování státu						
Týden 10	4/21/2022							
Týden 11	4/28/2022							
Týden 12	5/5/2022							
Týden 13	5/12/2022	prezentace výsledků						
##### Sheet/List 3 #####
100	93	A
92	85	B
84	77	C
76	69	D
68	61	E
60	49	F