Excel Expert Syllabus • My Online Training Hub

Excel 2007 & 2010 Expert
Excel 2013 Expert
Excel 2016 Expert
Excel 2019 and Office 365 Expert

Excel 2007 & 2010 Expert Course Syllabus


			Duration

		All videos are available in the Premium Excel course, except those marked with a which are only available in the Excel Expert course.	14:25:55

		Session 1: Introduction	0:29:28
Beginner	1.01	Introduction	0:00:52
Beginner	1.02	Interface	0:04:24
Beginner	1.03	Tabs and Ribbons	0:04:42
Beginner	1.04	Document Windows	0:11:50
Beginner	1.05	Navigation Tips	0:04:59
Beginner	1.06	Office Button and Save (2007) Backstage (2010)	0:02:41


		Session 2: Entering, Editing and Formatting Data	0:40:28
Beginner	2.01	Introduction	0:01:31
Beginner	2.02	Entering Data	0:02:58
Beginner	2.03	Fonts, Fills & Alignments	0:06:59
Beginner	2.04	Cut, Copy & Paste	0:06:01
Beginner	2.05	Paste Special	0:02:41
Beginner	2.06	Undo & Redo	0:02:45
Beginner	2.07	Moving, Finding and Replacing a Value	0:07:50
Intermediate	2.08	Cell Styles	0:04:17
Beginner	2.09	Comments	0:02:52
Intermediate	2.10	Copy as Picture (2010)	0:02:41


		Session 3: Formatting Numbers	0:35:35
Beginner	3.01	Introduction	0:01:00
Beginner	3.02	Currency Format	0:03:11
Beginner	3.03	Format Painter	0:03:15
Beginner	3.04	Formatting Dates	0:03:30
Intermediate	3.05	Custom and Special Formats	0:06:08
Advanced	3.06	Advanced Custom Formats	0:18:31


		Session 4: Managing Worksheets	0:16:42
Beginner	4.01	Introduction	0:01:25
Beginner	4.02	Naming and Moving Worksheets	0:03:26
Beginner	4.03	Copying Worksheets	0:02:37
Beginner	4.04	Adding, Deleting and Hiding Worksheets	0:02:43
Beginner	4.05	Grouping Worksheets	0:02:40
Beginner	4.06	Move, Copy, Delete and Hide Grouped Worksheets	0:03:51


		Session 5: Modifying Rows and Columns	0:18:09
Beginner	5.01	Introduction	0:01:13
Beginner	5.02	Inserting and Deleting Columns and Rows	0:04:17
Beginner	5.03	Inserting & Deleting Cells	0:03:01
Beginner	5.04	Inserting Multiple Columns and Rows	0:02:03
Beginner	5.05	Modifying Cell Width and Height	0:05:44
Beginner	5.06	Hiding and Unhiding Rows and Columns	0:01:51


		Session 6: Understanding Formulas	0:39:53
Beginner	6.01	Introduction	0:01:31
Beginner	6.02	Using Operations	0:03:11
Beginner	6.03	Creating Formulas	0:04:27
Beginner	6.04	AutoSum	0:03:40
Beginner	6.05	Common Functions	0:04:48
Beginner	6.06	Searching for Functions	0:03:52
Beginner	6.07	Copying Formulas	0:03:01
Beginner	6.08	Using Relative and Absolute References	0:08:19
Advanced	6.09	Troubleshooting Formula Tricks	0:07:04


		Session 7: Changing Views	0:28:40
Beginner	7.01	Introduction	0:01:47
Beginner	7.02	Workbook Views	0:05:13
Beginner	7.03	Show/Hide	0:02:00
Beginner	7.04	Zoom Features	0:02:34
Beginner	7.05	Freeze Panes	0:03:21
Beginner	7.06	Split Windows	0:01:49
Beginner	7.07	Viewing Multiple Windows	0:05:05
Beginner	7.08	Minimise The Ribbon	0:01:01
Intermediate	7.09	Worksheet Backgrounds	0:01:44
Intermediate	7.10	Watermarks	0:04:06


		Session 8: AutoFill and Custom Lists	0:11:33
Beginner	8.01	Introduction	0:01:30
Beginner	8.02	Autofill a Series	0:03:28
Intermediate	8.03	Autofill Non-Adjacent Cells	0:02:09
Intermediate	8.04	Autofill on Multiple Sheets	0:01:39
Advanced	8.05	Creating Custom Lists	0:01:18
Advanced	8.06	Series Formatting	0:01:29


		Session 9: Conditional Formatting	0:24:07
Intermediate	9.01	Introduction	0:01:02
Intermediate	9.02	Highlight Cell Rules	0:02:41
Intermediate	9.03	Top/Bottom Rules	0:02:34
Intermediate	9.04	Data Bars	0:01:19
Intermediate	9.05	Color Scales	0:01:39
Advanced	9.06	Custom Formatting Rules	0:03:14
Advanced	9.07	Conditional Formatting with Formulas	0:11:38


		Session 10: Tables	0:14:24
Intermediate	10.01	Introduction	0:01:03
Intermediate	10.02	Insert a Table and Style Options	0:03:26
Intermediate	10.03	Add Rows & Columns	0:02:39
Intermediate	10.04	Perform A Function In A Table	0:04:18
Intermediate	10.05	Summarise With Pivot Table	0:02:58


		Session 11: Data Tools	0:41:58
Intermediate	11.01	Introduction	0:01:38
Intermediate	11.02	Data Validation	0:06:27
Intermediate	11.03	Drop Down Lists	0:04:04
Intermediate	11.04	Removing Duplicates	0:02:35
Intermediate	11.05	Text To Columns	0:04:19
Advanced	11.06	Goal Seek	0:03:43
Advanced	11.07	Scenario Manager	0:04:39
Intermediate	11.08	Importing and Exporting Data	0:11:16
Advanced	11.09	Dependent Data Validation Lists	0:03:17


		Session 12: Referencing Formulas	0:16:04
Intermediate	12.01	Introduction	0:01:53
Intermediate	12.02	Multiple Sheet References	0:01:37
Intermediate	12.03	Consolidating Data – With or Without Links	0:06:37
Advanced	12.04	Trace the Precedents and Dependents	0:03:10
Advanced	12.05	Using the Watch Window	0:02:47


		Session 13: Ranges and Dates	1:06:05
Intermediate	13.01	Introduction	0:01:11
Intermediate	13.02	Cell Names	0:04:21
Advanced	13.03	Named Ranges	0:01:44
Advanced	13.04	Formulas With Cell Names	0:02:17
Intermediate	13.05	Date Formulas	0:05:22
Advanced	13.06	INDIRECT Function	0:08:33
Advanced	13.07	Dynamic Named Range using OFFSET	0:07:17
Advanced	13.08	Dynamic Named Range using INDEX	0:09:13
Advanced	13.09	NETWORKDAYS, WORKDAYS, EOMONTH etc.	0:08:38
Advanced	13.10	Working with Dates and Time	0:17:29


		Session 14: Lookups	0:35:49
Intermediate	14.01	Introduction	0:01:27
Intermediate	14.02	VLOOKUP	0:06:20
Intermediate	14.03	VLOOKUP Exact Match	0:09:17
Intermediate	14.04	HLOOKUP	0:03:52
Intermediate	14.05	HLOOKUP Exact Match	0:01:36
Intermediate	14.06	CHOOSE	0:06:12
Advanced	14.07	INDEX & MATCH	0:07:05
Advanced	14.08	MODE, MODE.MULT and MODE.SNGL	0:07:16
Advanced	14.09	LARGE and SMALL	0:04:37


		Session 15: Conditional Logic	2:08:36
Intermediate	15.01	Introduction	0:00:54
Intermediate	15.02	IF Statement	0:07:48
Advanced	15.03	Nested IF	0:03:30
Advanced	15.04	IF AND	0:03:01
Advanced	15.05	IF OR	0:02:43
Advanced	15.06	IF NOT	0:01:52
Intermediate	15.07	IFERROR	0:02:19
Intermediate	15.08	SUMIF and SUMIFS	0:04:15
Intermediate	15.09	AVERAGEIF and AVERAGEIFS	0:04:41
Intermediate	15.10	COUNTIF and COUNTIFS	0:09:46
Advanced	15.11	SUMPRODUCT	0:10:18
Advanced	15.12	Database Functions	0:07:43
Intermediate	15.13	SUBTOTAL Function	0:05:05
Advanced	15.14	Array Formulas - Introduction and Rules	0:05:39
Advanced	15.15	Array Formulas - Single Cell	0:20:40
Advanced	15.16	Array Formulas - Multi-cell VLOOKUP	0:04:10
Advanced	15.17	Array Formulas - Multi-cell Extract Unique Values	0:10:47
Advanced	15.18	Array Formulas - Sequences Return Multiple Matches	0:05:14
Advanced	15.19	Array Constants	0:08:52
Advanced	15.20	Naming Array Constants	0:03:27
Advanced	15.21	Operations, Boolean Values and Coercion	0:05:57


		Session 16: Text Formulas	0:09:35
Intermediate	16.01	Introduction	0:01:30
Intermediate	16.02	Case Formulas	0:01:41
Intermediate	16.03	Fix Number Fields	0:02:47
Intermediate	16.04	Trim Spaces	0:01:23
Intermediate	16.05	Substitute Text	0:02:14


		Session 17: Introduction to Charts	0:33:08
Intermediate	17.01	Introduction	0:00:50
Intermediate	17.02	Chart Types	0:02:01
Intermediate	17.03	Instant Chart – Pie Chart	0:01:33
Intermediate	17.04	Update Chart	0:02:56
Intermediate	17.05	Column Chart	0:03:47
Intermediate	17.06	Picture Fill	0:02:21
Intermediate	17.07	Adjust Chart Size	0:02:44
Intermediate	17.08	Line Chart	0:02:43
Intermediate	17.09	Scatter Chart	0:02:05
Intermediate	17.10	Sparklines (2010)	0:12:08


		Session 18: Formatting Charts	0:39:23
Intermediate	18.01	Introduction	0:01:05
Intermediate	18.02	Chart Styles	0:02:26
Intermediate	18.03	Chart Layouts	0:03:39
Intermediate	18.04	Add Labels	0:03:28
Intermediate	18.05	Axis Options	0:03:40
Intermediate	18.06	Chart Titles	0:03:40
Intermediate	18.07	Legends	0:02:15
Intermediate	18.08	Data Labels	0:03:40
Advanced	18.09	Secondary Axis	0:01:09
Advanced	18.10	Axis Formatting Tricks	0:01:52
Advanced	18.11	In-cell Charts	0:07:49
Advanced	18.12	Dynamic Source Data	0:04:40


		Session 19: Adding Graphics to Spreadsheets	0:26:57
Beginner	19.01	Introduction	0:01:07
Beginner	19.02	Insert Pictures	0:02:36
Beginner	19.03	Modifying Pictures	0:03:44
Beginner	19.04	Insert Shapes	0:04:01
Beginner	19.05	Insert Smart Art	0:05:11
Intermediate	19.06	Apply Themes	0:03:42
Intermediate	19.07	Arrange	0:06:36


		Session 20: Outline, Sort, Filter, and Subtotal	0:26:33
Intermediate	20.01	Introduction	0:00:57
Intermediate	20.02	Group & Ungroup	0:03:05
Intermediate	20.03	Sort Data	0:01:52
Intermediate	20.04	Sort Multiple Levels	0:02:37
Intermediate	20.05	Filter Data	0:03:18
Advanced	20.06	Advanced Filter	0:05:41
Advanced	20.07	Conditional Sorting and Filtering	0:01:47
Advanced	20.08	Sorting with Custom Lists	0:02:54
Intermediate	20.09	Subtotal	0:04:22


		Session 21: PivotTables	0:51:50
Intermediate	21.01	Introduction	0:01:14
Intermediate	21.02	Creating Pivot Tables	0:02:48
Intermediate	21.03	Choosing Fields	0:04:07
Intermediate	21.04	Pivot Table Layout	0:03:29
Intermediate	21.05	Filtering Pivot Tables	0:02:04
Intermediate	21.06	Modifying Pivot Table Data	0:02:10
Intermediate	21.07	Pivot Charts	0:03:38
Intermediate	21.08	Slicers (2010)	0:05:04
Intermediate	21.09	GETPIVOTDATA Function	0:11:25
Advanced	21.10	Grouping Dates	0:02:23
Advanced	21.11	Calculated Fields & Items	0:01:48
Advanced	21.12	Repeat Labels (2010)	0:01:57
Advanced	21.13	Ranking (2010)	0:06:02
Advanced	21.14	Automating PivotTable Refresh	0:03:41


		Session 22: Protecting Data	0:11:28
Intermediate	22.01	Introduction	0:00:40
Intermediate	22.02	Workbook Passwords	0:03:40
Intermediate	22.03	Protecting Workbooks	0:03:08
Intermediate	22.04	Unlocking Cells	0:04:00


		Session 23: Collaboration	0:21:21
Intermediate	23.01	Introduction	0:01:07
Intermediate	23.02	Documents Properties	0:03:33
Intermediate	23.03	Inserting Hyperlinks	0:04:23
Intermediate	23.04	Sharing A Workbook	0:02:45
Intermediate	23.05	Track Changes	0:03:55
Intermediate	23.06	Accept/Reject Changes	0:02:30
Intermediate	23.07	Mark As Final	0:03:08


		Session 24: Printing	0:19:47
Beginner	24.01	Introduction	0:01:24
Beginner	24.02	Page Orientation	0:01:28
Beginner	24.03	Page Breaks	0:03:35
Beginner	24.04	Print Area	0:01:54
Beginner	24.05	Margins	0:01:48
Beginner	24.06	Print Titles	0:01:06
Beginner	24.07	Headers and Footers	0:03:30
Beginner	24.08	Scaling	0:02:36
Beginner	24.09	Sheet Options	0:02:23


		Session 25: Saving a Workbook	0:18:26
Beginner	25.01	Introduction	0:01:21
Beginner	25.02	Save As Previous Version	0:03:29
Beginner	25.03	AutoRecover Save Options	0:02:42
Intermediate	25.04	Templates	0:03:06
Beginner	25.05	Save as PDF	0:02:25
Intermediate	25.06	Save As Web Page	0:03:26
Intermediate	25.07	Macro Enabled Workbook	0:02:00


		Session 26: Macros	0:37:56
Advanced	26.01	Introduction and Macro Security	0:03:40
Advanced	26.02	Recording a Macro	0:03:40
Advanced	26.03	Assign a Macro to a Button or Shape	0:04:08
Advanced	26.04	Run a Macro Upon Opening a Workbook	0:04:28
Advanced	26.05	How To Inspect and Modify a Macro	0:01:50
Advanced	26.06	Form Controls	0:12:28
Advanced	26.07	Active X Controls	0:07:00


		Session 27: Workbook Best Practices	0:14:56
Intermediate	27.01	Workbook Design	0:04:58
Intermediate	27.02	Excel Performance Killers	0:04:24
Intermediate	27.03	Report Design Principles	0:05:34

Excel 2013 Expert Course Syllabus


			Duration
		All videos are available in the Premium Excel course, except those marked with a which are only available in the Excel Expert course.	21:07:26

		Session 1: Introduction	0:28:55
Beginner	1.01	Interface	0:07:33
Beginner	1.02	Tabs and Ribbons	0:08:05
Beginner	1.03	File Tab	0:06:52
Beginner	1.04	Navigation Tips	0:06:25


		Session 2: Entering, Editing and Formatting Data	1:33:42
Beginner	2.01	Entering Data, Undo and Redo	0:06:35
Beginner	2.02	Fonts Fills and Alignment	0:19:38
Beginner	2.03	Mini Toolbar	0:02:11
Beginner	2.04	Cut, Copy & Paste	0:11:37
Beginner	2.05	Paste Special	0:11:57
Beginner	2.06	Find and Replace	0:11:52
Intermediate	2.07	Cell Styles	0:15:35
Beginner	2.08	Comments	0:09:55
Intermediate	2.09	Copy as Picture	0:04:22


		Session 3: Formatting Numbers	0:52:40
Beginner	3.01	Currency Format	0:08:12
Beginner	3.02	Formatting Dates	0:10:19
Beginner	3.03	Format Painter	0:06:11
Intermediate	3.04	Custom and Special Formats	0:09:30
Advanced	3.05	Advanced Custom Formats	0:18:27


		Session 4: Managing Worksheets	0:18:28
Beginner	4.01	Name, Copy, Move, Add, Delete & Hide Worksheets	0:09:33
Beginner	4.02	Grouping Worksheets	0:03:37
Beginner	4.03	Move, Copy, Delete and Hide Grouped Worksheets	0:05:18


		Session 5: Modifying Rows and Columns	0:23:07
Beginner	5.01	Inserting and Deleting Columns, Rows and Cells	0:13:39
Beginner	5.02	Modifying Cell Width and Height	0:06:35
Beginner	5.03	Hiding and Unhiding Rows and Columns	0:02:53


		Session 6: Changing Views	0:37:41
Beginner	6.01	Workbook Views	0:09:59
Beginner	6.02	Show/Hide	0:06:57
Beginner	6.03	Zoom Features	0:03:48
Beginner	6.04	Freeze Panes and Split Windows	0:06:22
Beginner	6.05	Viewing Multiple Windows	0:07:26
Beginner	6.06	Minimize the Ribbon	0:03:09


		Session 7: Saving a Workbook	0:46:30
Beginner	7.01	Save As and Save	0:06:57
Intermediate	7.02	Saving Different File Types	0:07:45
Intermediate	7.03	Auto Recover and Save Options	0:05:35
Intermediate	7.04	Templates	0:10:11
Intermediate	7.05	Save As PDF	0:04:44
Intermediate	7.06	Save As Web Page	0:06:20
Advanced	7.07	Macro-Enabled Workbook	0:04:58


		Session 8: Print Set Up	0:33:55
Beginner	8.01	Set Print Area, Margins, Orientation and Size	0:08:07
Beginner	8.02	Page Break and Titles	0:06:30
Beginner	8.03	Headers and Footers	0:09:51
Beginner	8.04	Sheet Options	0:04:08
Intermediate	8.05	Worksheet Backgrounds	0:05:19


		Session 9: Introduction to Formulas	1:01:20
Intermediate	9.01	Using Operations	0:08:47
Intermediate	9.02	Creating Formulas and Common Functions	0:05:46
Intermediate	9.03	Searching for Functions	0:06:04
Intermediate	9.04	Cutting and Copying Formulas	0:04:56
Intermediate	9.05	Date Formulas	0:12:27
Intermediate	9.06	Using Relative and Absolute References	0:10:50
Intermediate	9.07	Multiple Sheet References	0:05:26
Advanced	9.08	Troubleshooting Formula Tricks	0:07:04


		Session 10: Lookups	0:56:14
Intermediate	10.01	VLOOKUP Sorted List	0:07:19
Intermediate	10.02	VLOOKUP Exact Match	0:05:36
Intermediate	10.03	HLOOKUP Sorted List	0:05:32
Intermediate	10.04	HLOOKUP Exact Match	0:04:18
Intermediate	10.05	CHOOSE	0:07:14
Advanced	10.06	INDEX and MATCH	0:11:44
Intermediate	10.07	FORMULATEXT	0:02:38
Advanced	10.08	MODE, MODE.MULT and MODE.SNGL	0:07:16
Advanced	10.09	LARGE and SMALL	0:04:37


		Session 11: Conditional Logic	2:24:16
Intermediate	11.01	IF	0:04:39
Advanced	11.02	Nested IF	0:07:54
Advanced	11.03	IF AND	0:07:19
Advanced	11.04	IF OR	0:08:02
Advanced	11.05	IF NOT	0:05:56
Advanced	11.06	XOR	0:07:32
Intermediate	11.07	IFERROR & IFNA	0:06:06
Intermediate	11.08	SUMIF & SUMIFS	0:05:09
Intermediate	11.09	AVERAGEIF & AVERAGEIFS	0:04:19
Intermediate	11.10	COUNTIF & COUNTIFS	0:03:43
Advanced	11.11	SUMPRODUCT	0:06:03
Advanced	11.12	Database Functions	0:07:43
Intermediate	11.13	SUBTOTAL Function	0:05:05
Advanced	11.14	Array Formulas - Introduction and Rules	0:05:39
Advanced	11.15	Array Formulas - Single Cell	0:20:40
Advanced	11.16	Array Formulas - Multi-Cell VLOOKUP	0:04:10
Advanced	11.17	Array Formulas - Multi-cell Extract Unique Values	0:10:47
Advanced	11.18	Array Formulas - Sequences Return Multiple Matches	0:05:14
Advanced	11.19	Array Constants	0:08:52
Advanced	11.20	Naming Array Constants	0:03:27
Advanced	11.21	Operations, Boolean Values and Coercion	0:05:57

		Session 12: Text Formulas	0:16:17
Intermediate	12.01	Case Formulas - UPPER, LOWER, PROPER	0:02:39
Intermediate	12.02	Convert Text to Numbers with VALUE	0:03:09
Intermediate	12.03	Remove Spaces with TRIM	0:03:16
Intermediate	12.04	Substitute Text with SUBSTITUTE	0:03:47
Intermediate	12.05	Convert Numbers to Text with FIXED	0:03:26


		Session 13: Named Ranges	1:10:37
Intermediate	13.01	Cell Names	0:05:45
Advanced	13.02	Named Ranges	0:05:36
Advanced	13.03	Writing Formulas with Cell Names	0:03:01
Advanced	13.04	Named Formulas	0:05:05
Advanced	13.05	INDIRECT Function	0:08:33
Advanced	13.06	Dynamic Named Range using OFFSET	0:07:17
Advanced	13.07	Dynamic Named Range using INDEX	0:09:13
Advanced	13.08	NETWORKDAYS, WORKDAYS, EOMONTH etc.	0:08:38
Advanced	13.09	Working with Dates and Time	0:17:29


		Session 14: Formula Tools	0:23:54
Intermediate	14.01	Trace the Precedents and Dependents	0:05:04
Intermediate	14.02	Using the Watch Window	0:05:24
Advanced	14.03	Evaluate Formula Tool	0:05:04
Advanced	14.04	Show Formulas and Error Checking	0:08:22


		Session 15: AutoFill and Custom Lists	0:33:24
Beginner	15.01	AutoFill a Series	0:10:49
Intermediate	15.02	AutoFill Non-Adjacent Cells	0:04:52
Intermediate	15.03	AutoFill on Multiple Sheets	0:04:09
Intermediate	15.04	Flash Fill	0:03:16
Advanced	15.05	Creating Custom Lists	0:06:53
Advanced	15.06	Series Formatting	0:03:25


		Session 16: Conditional Formatting	0:47:28
Intermediate	16.01	Highlight Cells Rules	0:07:14
Intermediate	16.02	Top/Bottom Rules	0:06:17
Intermediate	16.03	Data Bars	0:04:09
Intermediate	16.04	Color Scales	0:04:34
Advanced	16.05	Custom Formatting Rule	0:05:23
Intermediate	16.06	Quick Analysis	0:04:27
Intermediate	16.07	Icon Sets	0:03:46
Advanced	16.08	Conditional Formatting with Formulas	0:11:38


		Session 17: Tables	0:22:13
Intermediate	17.01	Insert a Table and Style Options	0:04:38
Intermediate	17.02	Add Rows and Columns	0:04:42
Intermediate	17.03	Perform a Function in a Table	0:04:15
Intermediate	17.04	Slicers for Tables	0:08:38


		Session 18: Introduction to Charts	1:06:26
Intermediate	18.01	Chart Types	0:07:55
Intermediate	18.02	Recommended Charts	0:06:32
Intermediate	18.03	Update Chart	0:09:45
Intermediate	18.04	Column Chart	0:08:09
Intermediate	18.05	Picture Fill	0:08:23
Intermediate	18.06	Adjust Chart Size	0:05:46
Intermediate	18.07	Line Chart	0:05:48
Intermediate	18.08	Scatter and Bubble Charts	0:05:54
Intermediate	18.09	Sparklines	0:08:14
Advanced	18.10	Secondary Axis	0:02:48
Advanced	18.11	Axis Formatting Tricks	0:01:52
Advanced	18.12	In-cell Charts	0:07:35
Advanced	18.13	Dynamic Source Data	0:05:53


		Session 19: Formatting Charts	0:25:07
Intermediate	19.01	Chart Styles	0:05:02
Intermediate	19.02	Chart Layouts	0:08:46
Intermediate	19.03	Quick Fine Tune	0:07:57
Advanced	19.04	Animation in Charts	0:03:22


		Session 20: Adding Graphics	0:54:53
Beginner	20.01	Insert Pictures	0:06:25
Beginner	20.02	Modifying Pictures	0:15:06
Beginner	20.03	Insert Shapes	0:08:55
Beginner	20.04	Insert SmartArt	0:09:52
Intermediate	20.05	Apply Themes	0:04:48
Intermediate	20.06	Arrange	0:09:47


		Session 21: Data Tools	0:53:49
Intermediate	21.01	Data Validation	0:07:18
Intermediate	21.02	Removing Duplicates	0:03:49
Intermediate	21.03	Text to Columns	0:05:20
Advanced	21.04	Goal Seek	0:02:26
Advanced	21.05	Scenario Manager	0:09:15
Advanced	21.06	Importing and Exporting Data	0:16:26
Advanced	21.07	Consolidating Data	0:05:38
Advanced	21.08	Dependant Data Validation Lists	0:03:17


		Session 22: Sort, Filter and Subtotal	0:44:28
Beginner	22.01	Sort Data	0:02:31
Intermediate	22.02	Sort Multiple Levels	0:03:55
Beginner	22.03	Filter Data	0:04:31
Intermediate	22.04	Advanced Filter	0:09:19
Advanced	22.05	Conditional Sorting and Filtering	0:08:01
Advanced	22.06	Sorting with Custom Lists	0:04:50
Intermediate	22.07	Group and Ungroup	0:05:25
Intermediate	22.08	Subtotal Tool	0:05:56


		Session 23: PivotTables	0:41:43
Intermediate	23.01	Creating PivotTables	0:05:57
Intermediate	23.02	Choosing Fields	0:06:05
Intermediate	23.03	PivotTable Layout	0:06:11
Intermediate	23.04	Filtering PivotTables	0:04:17
Intermediate	23.05	Modifying PivotTableData	0:04:41
Intermediate	23.06	PivotCharts	0:03:52
Intermediate	23.07	Slicers	0:04:28
Intermediate	23.08	Timelines	0:05:12
Intermediate	23.09	GETPIVOTDATA Function	0:09:08
Advanced	23.10	Grouping Dates	0:05:53
Advanced	23.11	Calculated Fields	0:02:10
Advanced	23.12	Repeat Labels	0:01:36
Advanced	23.13	Ranking	0:03:23
Advanced	23.14	Automating PivotTable Refresh	0:03:51


		Session 24: Protecting Data	0:16:19
Intermediate	24.01	Workbook Passwords	:05:43
Intermediate	24.02	Protecting Workbooks	0:05:03
Intermediate	24.03	Unlocking Cells	0:05:33


		Session 25: Collaboration	0:42:19
Intermediate	25.01	Document Properties	0:08:20
Intermediate	25.02	Inserting Hyperlinks	0:11:57
Intermediate	25.03	Sharing Workbook	0:06:58
Intermediate	25.04	Track Changes	0:06:50
Intermediate	25.05	Accept/Reject Changes	0:03:11
Intermediate	25.06	Mark as Final	0:05:03


		Session 26: Macros	0:52:36
Advanced	26.01	Macro Security	0:07:15
Advanced	26.02	Recording a Macro	0:07:28
Advanced	26.03	How to Assign a Macro to a Button or Shape	0:05:55
Advanced	26.04	How to Run a Macro upon Opening a Workbook	0:05:47
Advanced	26.05	How To Inspect and Modify a Macro	0:06:43
Advanced	26.06	Form Controls	0:12:28
Advanced	26.07	ActiveX Controls	0:07:00


		Session 27: Workbook Best Practices	0:14:56
Intermediate	27.01	Workbook Design	0:04:58
Intermediate	27.02	Excel Performance Killers	0:04:24
Intermediate	27.03	Report Design Principles	0:05:34

Excel 2016 Expert Course Syllabus


			Duration
		All videos are available in the Premium Excel course, except those marked with a which are only available in the Excel Expert course.	17:29:30

		Session 1: Introduction	0:38:14
Beginner	1.01	Interface	0:04:51
Beginner	1.02	Tabs and Ribbons	0:08:04
Beginner	1.03	File Tab	0:08:04
Beginner	1.04	Navigation Tips	0:07:16
Beginner	1.05	Tell Me	0:02:30
Beginner	1.06	Touch Mode	0:03:06


		Session 2: Entering, Editing and Formatting Data	0:45:50
Beginner	2.01	Entering Data, Undo and Redo	0:04:31
Beginner	2.02	Fonts Fills and Alignment	0:07:33
Beginner	2.03	Mini Toolbar	0:01:29
Beginner	2.04	Cut, Copy & Paste	0:04:37
Beginner	2.05	Paste Special	0:05:43
Beginner	2.06	Find and Replace	0:07:02
Intermediate	2.07	Cell Styles	0:04:20
Beginner	2.08	Comments	0:06:53
Intermediate	2.09	Copy as Picture	0:03:42


		Session 3: Formatting Numbers	0:33:51
Beginner	3.01	Currency Format	0:05:19
Beginner	3.02	Formatting Dates	0:02:49
Beginner	3.03	Format Painter	0:02:27
Intermediate	3.04	Custom and Special Formats	0:05:13
Advanced	3.05	Advanced Custom Formats	0:18:03


		Session 4: Managing Worksheets	0:17:44
Beginner	4.01	Name, Copy, Move, Add, Delete & Hide Worksheets	0:08:09
Beginner	4.02	Grouping Worksheets	0:02:25
Beginner	4.03	Move, Copy, Delete and Hide Grouped Worksheets	0:07:10


		Session 5: Modifying Rows and Columns	0:18:45
Beginner	5.01	Inserting and Deleting Columns, Rows and Cells	0:08:46
Beginner	5.02	Modifying Cell Width and Height	0:06:05
Beginner	5.03	Hiding and Unhiding Rows and Columns	0:03:54


		Session 6: Changing Views	0:25:09
Beginner	6.01	Workbook Views	0:03:24
Beginner	6.02	Show/Hide	0:05:13
Beginner	6.03	Zoom Features	0:03:34
Beginner	6.04	Freeze Panes and Split Windows	0:07:15
Beginner	6.05	Viewing Multiple Windows	0:05:43


		Session 7: Saving a Workbook	0:30:50
Beginner	7.01	Save As and Save	0:06:.
Intermediate	7.02	Saving Different File Types	0:03:47
Intermediate	7.03	Auto Recover and Save Options	0:05:35
Intermediate	7.04	Templates	0:06:54
Intermediate	7.05	Save As PDF	0:04:27
Intermediate	7.06	Macro-Enabled Workbook	0:04:31


		Session 8: Print Set Up	0:35:06
Beginner	8.01	Set Print Area, Margins, Orientation and Size	0:12:01
Beginner	8.02	Page Break and Titles	0:05:25
Beginner	8.03	Headers and Footers	0:08:39
Beginner	8.04	Sheet Options	0:04:10
Intermediate	8.05	Worksheet Backgrounds	0:04:51


		Session 9: Introduction to Formulas	0:46:39
Intermediate	9.01	Using Operations	0:08:24
Intermediate	9.02	Creating Formulas and Common Functions	0:04:47
Intermediate	9.03	Searching for Functions	0:05:24
Intermediate	9.04	Using Relative and Absolute References	0:08:29
Intermediate	9.05	Cutting and Copying Formulas	0:04:01
Intermediate	9.06	Date Formulas	0:04:48
Intermediate	9.07	Multiple Sheet References	0:03:42
Advanced	9.08	Troubleshooting Formula Tricks	0:07:04


		Session 10: Lookups	0:42:32
Intermediate	10.01	VLOOKUP Sorted List	0:04:55
Intermediate	10.02	VLOOKUP Exact Match	0:03:09
Intermediate	10.03	HLOOKUP Sorted List	0:04:18
Intermediate	10.04	HLOOKUP Exact Match	0:02:28
Intermediate	10.05	CHOOSE	0:04:44
Advanced	10.06	INDEX and MATCH	0:11:05
Advanced	10.07	MODE, MODE.MULT and MODE.SNGL	0:07:16
Advanced	10.08	LARGE and SMALL	0:04:37


		Session 11: Conditional Logic	2:05:51
Intermediate	11.01	IF	0:03:40
Advanced	11.02	Nested IF	0:07:16
Advanced	11.03	IF AND	0:05:37
Advanced	11.04	IF OR	0:04:19
Advanced	11.05	IF NOT	0:03:37
Advanced	11.06	AGGREGATE	0:05:05
Intermediate	11.07	IFERROR & IFNA	0:04:32
Intermediate	11.08	SUMIF & SUMIFS	0:03:37
Intermediate	11.09	AVERAGEIF & AVERAGEIFS	0:03:16
Intermediate	11.10	COUNTIF & COUNTIFS	0:02:21
Advanced	11.11	SUMPRODUCT	0:05:07
Advanced	11.12	Database Functions	0:07:43
Intermediate	11.13	SUBTOTAL Function	0:05:05
Advanced	11.14	Array Formulas - Introduction and Rules	0:05:39
Advanced	11.15	Array Formulas – Single Cell	0:20:40
Advanced	11.16	Array Formulas – Multi-Cell VLOOKUP	0:04:10
Advanced	11.17	Array Formulas – Multi-cell Extract Unique Values	0:10:47
Advanced	11.18	Array Formulas – Sequences Return Multiple Matches	0:05:14
Advanced	11.19	Array Constants	0:08:52
Advanced	11.20	Naming Array Constants	0:03:27
Advanced	11.21	Operations, Boolean Values and Coercion	0:05:57

		Session 12: Text Formulas	0:27:50
Intermediate	12.01	Case Formulas - UPPER, LOWER, PROPER	0:03:16
Intermediate	12.02	Convert Text to Numbers with VALUE	0:04:12
Intermediate	12.03	Remove Spaces with TRIM and CLEAN	0:05:46
Intermediate	12.04	Substitute Text with SUBSTITUTE	0:04:20
Intermediate	12.05	SEARCH and FIND	0:10:16


		Session 13: Named Ranges	1:10:55
Intermediate	13.01	Cell Names	0:04:13
Advanced	13.02	Named Ranges	0:05:38
Advanced	13.03	Writing Formulas with Cell Names	0:04:45
Advanced	13.04	Named Formulas	0:05:09
Advanced	13.05	INDIRECT Function	0:08:33
Advanced	13.06	Dynamic Named Range using OFFSET	0:07:17
Advanced	13.07	Dynamic Named Range using INDEX	0:09:13
Advanced	13.08	NETWORKDAYS, WORKDAYS, EOMONTH etc.	0:08:38
Advanced	13.09	Working with Dates and Time	0:17:29


		Session 14: Formula Tools	0:22:32
Intermediate	14.01	Trace the Precedents and Dependents	0:05:30
Intermediate	14.02	Using the Watch Window	0:05:35
Advanced	14.03	Evaluate Formula Tool	0:03:39
Advanced	14.04	Show Formulas and Error Checking	0:07:48


		Session 15: AutoFill and Custom Lists	0:28:16
Beginner	15.01	AutoFill a Series	0:07:42
Intermediate	15.02	AutoFill Non-Adjacent Cells	0:04:46
Intermediate	15.03	AutoFill on Multiple Sheets	0:04:04
Intermediate	15.04	Flash Fill	0:04:10
Advanced	15.05	Creating Custom Lists	0:05:49
Advanced	15.06	Series Formatting	0:01:45


		Session 16: Conditional Formatting	0:45:59
Intermediate	16.01	Highlight Cells Rules	0:07:12
Intermediate	16.02	Top/Bottom Rules	0:05:16
Intermediate	16.03	Data Bars	0:03:44
Intermediate	16.04	Color Scales	0:03:13
Advanced	16.05	Custom Formatting Rule	0:05:54
Intermediate	16.06	Icon Sets	0:04:41
Intermediate	16.07	Quick Analysis	0:04:21
Advanced	16.08	Conditional Formatting with Formulas	0:11:38


		Session 17: Tables	0:22:37
Intermediate	17.01	Insert a Table and Style Options	0:03:47
Intermediate	17.02	Add Rows and Columns	0:04:56
Intermediate	17.03	Perform a Function in a Table	0:06:25
Intermediate	17.04	Slicers for Tables	0:07:29


		Session 18: Charts	1:00:33
Intermediate	18.01	Inserting Charts	0:04:52
Intermediate	18.02	Format Charts	0:10:51
Intermediate	18.03	Editing Chart Source Data	0:05:49
Intermediate	18.04	Filtering Charts	0:01:45
Intermediate	18.05	New Charts Types in Excel 2016	0:09:59
Intermediate	18.06	Sparklines	0:09:09
Advanced	18.07	Secondary Axis	0:02:48
Advanced	18.08	Axis Formatting Tricks	0:01:52
Advanced	18.09	In-cell Charts	0:07:35
Advanced	18.10	Dynamic Source Data	0:05:53


		Session 19: PivotTables	1:15:25
Intermediate	19.01	Creating PivotTables	0:04:48
Intermediate	19.02	Choosing Fields	0:06:44
Intermediate	19.03	PivotTable Layout	0:05:13
Intermediate	19.04	Filtering PivotTables	0:03:30
Intermediate	19.05	Changing Calculation Methods	0:06:09
Intermediate	19.06	PivotCharts	0:03:44
Intermediate	19.07	Slicers	0:08:51
Intermediate	19.08	Timelines	0:03:20
Intermediate	19.09	Introduction to the Data Model	0:05:54
Intermediate	19.10	GETPIVOTDATA Function	0:09:08
Advanced	19.11	Grouping Dates	0:07:04
Advanced	19.12	Calculated Fields	0:02:10
Advanced	19.13	Repeat Labels	0:01:36
Advanced	19.14	Ranking	0:03:23
Advanced	19.15	Automating PivotTable Refresh	0:03:51


		Session 20: Adding Graphics	0:43:47
Beginner	20.01	Insert Pictures	0:08:23
Beginner	20.02	Modifying Pictures	0:10:15
Beginner	20.03	Shapes	0:05:04
Beginner	20.04	SmartArt	0:06:00
Intermediate	20.05	Apply Themes	0:04:55
Intermediate	20.06	Arrange	0:09:10


		Session 21: Data Tools	0:51:32
Intermediate	21.01	Data Validation	0:08:12
Intermediate	21.02	Removing Duplicates	0:03:22
Intermediate	21.03	Text to Columns	0:04:55
Advanced	21.04	Importing and Exporting Data	0:08:43
Advanced	21.05	Introduction to Get and Transform aka Power Query	0:03:24
Advanced	21.06	Goal Seek	0:02:58
Advanced	21.07	Scenario Manager	0:05:41
Advanced	21.08	Consolidating Data	0:05:17
Advanced	21.09	Forecast	0:05:43
Advanced	21.10	Dependant Data Validation Lists	0:03:17


		Session 22: Sort, Filter and Subtotal	0:31:45
Beginner	22.01	Sort Data	0:05:15
Intermediate	22.02	Sorting with Custom Lists	0:02:50
Beginner	22.03	Filter Data	0:05:32
Intermediate	22.04	Advanced Filter	0:05:33
Advanced	22.05	Conditional Sorting and Filtering	0:03:58
Advanced	22.06	Subtotal Tool	0:04:31
Intermediate	22.07	Group and Ungroup	0:04:06


		Session 23: Protecting Data	0:14:10
Intermediate	23.01	Workbook Passwords	:04:52
Intermediate	23.02	Protecting Workbooks	0:03:55
Intermediate	23.03	Protecting Worksheets and Cells	0:05:23


		Session 24: Collaboration	0:36:06
Intermediate	24.01	Document Properties	0:09:28
Intermediate	24.02	Inserting Hyperlinks	0:06:56
Intermediate	24.03	Sharing Workbook	0:06:56
Intermediate	24.04	Track Changes	0:05:00
Intermediate	24.05	Accept/Reject Changes	0:03:02
Intermediate	24.06	Mark as Final	0:04:43


		Session 25: Macros	0:42:40
Advanced	25.01	Macro Security	0:04:04
Advanced	25.02	Recording a Macro	0:05:13
Advanced	25.03	How to Assign a Macro to a Button or Shape	0:05:13
Advanced	25.04	How to Run a Macro upon Opening a Workbook	0:03:45
Advanced	25.05	How To Inspect and Modify a Macro	0:04:57
Advanced	25.06	Form Controls	0:12:28
Advanced	25.07	ActiveX Controls	0:07:00


		Session 26: Workbook Best Practices	0:14:56
Intermediate	26.01	Workbook Design	0:04:58
Intermediate	26.02	Excel Performance Killers	0:04:24
Intermediate	26.03	Report Design Principles	0:05:34

Excel Expert 2019 and Office 365 Course Syllabus


			Duration
		All videos are available in the Premium Excel course, except those marked with a which are only available in the Excel Expert course.	12:36:12

		Session 1.0 Excel Essentials	1:31:11
Beginner	1.01	Interface and Ribbon	0:06:10
Beginner	1.02	Entering and Formatting Data	0:10:44
Beginner	1.03	Navigation	0:03:14
Beginner	1.04	Cut, Copy & Paste	0:09:38
Beginner	1.05	Working with Cells, Rows and Columns	0:05:08
Beginner	1.06	Move, Copy, Name, Group and Hide Sheets	0:03:47
Intermediate	1.07	Threaded Comments and Notes	0:05:08
Intermediate	1.08	Worksheet Views	0:06:07
Beginner	1.09	File Tab	0:03:38
Beginner	1.10	Save As and Save, Saving Different File Types	0:03:51
Beginner	1.11	Printing	0:07:18
Beginner	1.12	Search Box	0:03:01
Beginner	1.13	Find & Replace	0:05:27


		Session 2.0 Excel Formula Essentials	0:38:38
Beginner	2.01	Using Operations and Order of Evaluation	0:05:52
Beginner	2.02	Working with Functions and Formulas	0:09:04
Beginner	2.03	Relative and Absolute References	0:05:28
Intermediate	2.04	Multiple Sheet & External File References	0:04:48
Intermediate	2.05	Date and Time Formulas	0:09:18
Intermediate	2.06	Trace Precedents and Dependents	0:04:08


		Session 3.0 Conditional Functions	0:38:36
Intermediate	3.01	IF, Nested IF, IFS, IF(OR... and IF(AND...	0:11:00
Intermediate	3.02	SWITCH (New in Excel 2019/Office 365)	0:04:49
Intermediate	3.03	SUMIF, AVERAGEIF, SUMIFS and AVERAGEIFS	0:13:42
Intermediate	3.04	COUNTIF and COUNTIFS	0:04:16
Intermediate	3.05	MINIFS and MAXIFS (New in Excel 2019/Office 365)	0:04:49


		Session 3.1 Lookup & Reference Functions	1:36:52
Intermediate	3.11	VLOOKUP and HLOOKUP	0:10:49
Intermediate	3.12	MATCH	0:12:27
Intermediate	3.13	INDEX	0:15:12
Intermediate	3.14	COLUMN(S) and ROW(S)	0:10:51
Advanced	3.15	OFFSET	0:10:31
Advanced	3.16	INDIRECT	0:08:58
Advanced	3.17	CHOOSE	0:08:47
Advanced	3.18	XLOOKUP	0:19:17


		Session 3.2 Formula Errors	0:09:06
Intermediate	3.21	Debugging and Troubleshooting Formula Errors	0:05:19
Intermediate	3.22	IFERROR	0:03:47


		Session 3.3 Text Functions	0:43:00
Intermediate	3.31	LEFT, RIGHT and MID	0:06:04
Intermediate	3.32	SEARCH, FIND and LEN	0:06:09
Intermediate	3.33	SUBSTITUTE and REPLACE	0:05:36
Intermediate	3.34	UPPER, LOWER and PROPER	0:01:55
Intermediate	3.35	TRIM and CLEAN	0:04:01
Intermediate	3.36	CHAR, CODE and UNICHAR	0:04:52
Intermediate	3.37	TEXT	0:07:19
Intermediate	3.38	TEXTJOIN (New in Excel 2019)	0:07:04


		Session 3.4 Math Functions	0:20:09
Intermediate	3.41	SUBTOTAL	0:03:54
Advanced	3.42	AGGREGATE	0:06:59
Advanced	3.43	SUMPRODUCT	0:09:16


		Session 3.5 Array Formulas	0:43:25
Advanced	3.51	Introduction to Array Formulas	0:04:37
Advanced	3.52	Single Cell Array Formulas	0:17:01
Advanced	3.53	Multi-cell Array Formulas	0:15:19
Advanced	3.54	Array Constants	0:03:09
Advanced	3.55	Operations, Boolean Values, Coercion, Sequences	0:03:19


		Session 3.6 Dynamic Array Functions (Office 365 Only)	0:55:54
Intermediate	3.61	Introduction to Dynamic Array Functions	0:06:03
Intermediate	3.62	UNIQUE	0:04:14
Intermediate	3.63	SORT and SORTBY	0:06:16
Intermediate	3.64	FILTER	0:05:34
Intermediate	3.65	RANDARRAY	0:03:03
Intermediate	3.66	SEQUENCE	0:03:29
Intermediate	3.67	Implicit Intersection @ Notation	0:03:17
Intermediate	3.68	VSTACK & HSTACK	0:11:34
Intermediate	3.69	Array Shaping Functions	0:12:02


		Session 3.7 Named Ranges	0:40:06
Intermediate	3.71	Introduction to Named Ranges	0:04:19
Intermediate	3.72	Creating & Managing Names	0:08:14
Advanced	3.73	Named Constants	0:04:38
Advanced	3.74	Named Formulas	0:06:11
Advanced	3.75	Dynamic Named Ranges	0:08:46
Advanced	3.76	Relative Named Ranges	0:07:58


		Session 4.0 Excel Tables	0:50:38
Beginner	4.00	Introduction to Tables	0:02:18
Beginner	4.01	Getting Started with Tables	0:13:27
Intermediate	4.02	Sort, Filter & Slicers	0:10:32
Intermediate	4.03	Formulas, Structured References, Absolute References	0:12:16
Intermediate	4.04	Table Limitations and Workarounds	0:12:05

		Session 5.0 Excel PivotTables & PivotCharts	1:27:16
Intermediate	5.01	Introduction & Data Layout	0:03:45
Intermediate	5.02	Creating PivotTables	0:07:01
Intermediate	5.03	Formatting PivotTables	0:05:59
Intermediate	5.04	Aggregation Options & Show Values As	0:04:04
Intermediate	5.05	Grouping	0:03:37
Intermediate	5.06	Sorting	0:06:51
Intermediate	5.07	PivotCharts	0:05:24
Intermediate	5.08	Filters	0:05:11
Intermediate	5.09	Slicers & Timelines	0:09:51
Intermediate	5.10	GETPIVOTDATA Function	0:05:18
Intermediate	5.11	Adding New Data & Refreshing	0:02:40
Intermediate	5.12	Troubleshooting	0:04:09
Intermediate	5.13	Conditional Formatting	0:05:01
Advanced	5.14	Calculated Fields	0:05:45
Advanced	5.15	Calculated Items	0:03:33
Advanced	5.16	Data Model Introduction	0:06:25
Advanced	5.17	PivotTable Options	0:02:42


		Session 6.0 Excel Charts	0:35:21
Beginner	6.01	Inserting Charts, Recommended Charts	0:04:44
Beginner	6.02	Formatting Charts	0:04:25
Advanced	6.03	Changing Chart Source Data	0:04:13
Advanced	6.04	Secondary Axis/Combo Charts	0:03:14
Intermediate	6.05	Sparklines	0:04:06
Advanced	6.06	Forecasts	0:03:36
Advanced	6.07	3D Maps	0:07:30
Advanced	6.08	Ideas (Office 365 Only)	0:03:33


		Session 7.0 Excel Advanced Topics	1:48:18
Intermediate	7.01	Customizing the Ribbon & QAT	0:07:59
Intermediate	7.02	Data Validation	0:06:00
Intermediate	7.03	Text to Columns	0:04:10
Intermediate	7.04	Sorting & Filtering & Advanced Filter	0:09:45
Intermediate	7.05	Remove Duplicates	0:02:31
Intermediate	7.06	Autofill & Flash Fill	0:05:53
Intermediate	7.07	Group & Outline	0:04:28
Intermediate	7.08	Conditional Formatting	0:07:11
Intermediate	7.09	Quick Analysis	0:03:39
Intermediate	7.10	Shapes, Icons, SmartArt, Pictures & 3D Models	0:09:09
Intermediate	7.11	Hyperlinks	0:09:11
Intermediate	7.12	Themes	0:02:50
Intermediate	7.13	Go To	0:04:14
Intermediate	7.14	Co-authoring (Office 365 Only)	0:05:19
Intermediate	7.15	Workbook Views, Custom Views	0:04:50
Intermediate	7.16	Worksheet Protection	0:05:30
Intermediate	7.17	Custom Number Formats	0:08:36
Intermediate	7.18	Data Types (Office 365 Only)	0:07:48


		Session 8.0 Introduction to Macros	0:34:59
Advanced	8.01	Macro Introduction & Security	0:05:19
Advanced	8.02	Recording a Macro	0:04:15
Advanced	8.03	How to Assign a Macro to a Button or a Shape	0:04:26
Advanced	8.04	How to Run a Macro upon Opening a Workbook	0:03:10
Advanced	8.05	How to Inspect and Modify a Macro	0:03:26
Advanced	8.06	Form Controls	0:09:08
Advanced	8.07	Active X Controls	0:05:15