The 3-in-1 Excel, VBA & SQL Master Course
Focused View
Mark Lengyel
47:35:28
24 View
1. Introduction.mp4
02:31
2.1 FB Support Group.html
2.2 Join us on Quora.html
2. How to Use The Course.mp4
03:34
3.1 Office Homepage.html
3. Select the appropriate plan for you.mp4
04:25
4. Install Office on Windows.mp4
03:39
5. Install Office on a Mac.mp4
03:27
1. What is Excel.mp4
02:10
2. Overview of the worksheet.mp4
08:35
3. Overview of the ribbon.mp4
06:51
4. Overview of the top area.mp4
13:30
5. The file tab.mp4
07:03
6. Basic data organisation.mp4
21:51
7. Self check.html
1.1 SUM function.xlsx
1. The SUM function - Part I.mp4
07:25
2. The SUM function - Part II.mp4
10:48
3. The SUM function - Part III.mp4
06:34
4.1 01-Addition-Exercise-Starter-File.xlsx
4.2 02-Addition-Exercise-Final-File.xlsx
4. Addition.mp4
03:34
5.1 01-Subtraction-Exercise-Starter-File.xlsx
5.2 02-Subtraction-Exercise-Final-File.xlsx
5. Subtraction.mp4
03:06
6.1 01-Multiplication I start.xlsx
6.2 02-Multiplication I final.xlsx
6. Multiplication - Part I..mp4
05:13
7.1 01-Multiplication II start.xlsx
7.2 02-Multiplication II final.xlsx
7. Multiplication - Part II..mp4
05:58
8.1 01-Division start.xlsx
8.2 02-Division final.xlsx
8. Division.mp4
02:51
9. Self check.html
10.1 01-Dynamic cell references start.xlsx
10.2 02-Dynamic cell references final.xlsx
10. Dynamic cell References - Part I..mp4
05:15
11.1 01-Dynamic cell references II start.xlsx
11.2 02-Dynamic cell references II final.xlsx
11. Dynamic Cell References - Part II..mp4
05:35
12.1 Basic formatting I start.xlsx
12. Basic Formatting - Part I..mp4
06:57
13.1 Basic formatting II start.xlsx
13. Basic Formatting - Part II..mp4
06:48
14.1 Basic formatting III start.xlsx
14. Basic Formatting - Part III..mp4
04:24
15.1 01-Basic formatting start.xlsx
15.2 02-Basic formatting final.xlsx
15. Basic Formatting - Part IV..mp4
03:44
16.1 01-Formulas bar I start.xlsx
16.2 02-Formulas bar I final.xlsx
16. Formulas Bar - Part I..mp4
05:57
17.1 01-Formulas bar II start.xlsx
17.2 02-Formulas bar II final.xlsx
17. Formulas Bar - Part II..mp4
04:50
18.1 01-Formula auditing start.xlsx
18.2 02-Formula auditing final.xlsx
18. Formula Auditing.mp4
06:37
19.1 01-Error checking and the Watch window I start.xlsx
19.2 02-Error checking and the Watch window I final.xlsx
19. Error Checking and the Watch Window - Part I..mp4
04:22
20.1 01-Error checking and the Watch window II start.xlsx
20.2 02-Error checking and the Watch window II final.xlsx
20. Error Checking and the Watch Window - Part II..mp4
04:33
21. Self check.html
1.1 01-AVERAGE start.xlsx
1.2 02-AVERAGE final.xlsx
1. AVERAGE.mp4
02:17
2.1 01-MIN start.xlsx
2.2 02-MIN final.xlsx
2. MIN.mp4
01:25
3.1 01-MAX start.xlsx
3.2 02-MAX final.xlsx
3. MAX.mp4
01:26
4.1 01-COUNT start.xlsx
4.2 02-COUNT final.xlsx
4. COUNT.mp4
02:16
5. Self check.html
1.1 01-Number formatting I start.xlsx
1.2 02-Number formatting II final.xlsx
1. Number Formatting - Part I..mp4
03:28
2.1 01-Number formatting II start.xlsx
2.2 02-Number formatting II final.xlsx
2. Number Formatting - Part II..mp4
05:27
3.1 01-Number formatting III start.xlsx
3.2 02-Number formatting III final.xlsx
3. Number Formatting - Part III..mp4
03:21
4.1 01-Number formatting IV start.xlsx
4.2 02-Number formatting IV final.xlsx
4. Number Formatting - Part IV..mp4
03:34
5.1 01-Date formatting start.xlsx
5.2 02-Date formatting final.xlsx
5. Date Formatting - Part I..mp4
05:20
6.1 01-Date formatting II start.xlsx
6.2 02-Date formatting II final.xlsx
6. Date Formatting - Part II..mp4
06:13
7.1 01-Epoch start.xlsx
7.2 02-Epoch final.xlsx
7.3 More about Epoch.html
7. Epoch.mp4
03:18
8.1 01-Percentages start.xlsx
8.2 02-Percentages final.xlsx
8. Percentages.mp4
08:03
9.1 01-Currencies I start.xlsx
9.2 02-Currencies I final.xlsx
9. Currencies - Part I..mp4
05:41
10.1 01-Currencies II start.xlsx
10.2 02-Currencies II final.xlsx
10. Currencies - Part II..mp4
05:50
11.1 01-Fractions start.xlsx
11.2 02-Fractions final.xlsx
11. Fractions.mp4
04:12
12. Self check.html
13.1 01-Text start.xlsx
13.2 02-Text final.xlsx
13. Text - Part I..mp4
05:06
14. Text - Part II - Character set.mp4
01:15
15. Text - Part III - Numbers formatted as text.mp4
05:40
16.1 01-Formatting the table start.xlsx
16.2 02-Formatting the table final.xlsx
16. Formatting The Table - Part I - Text Filters I.mp4
04:48
17.1 01-Formatting the table II start.xlsx
17. Formatting The Table - Part II - Text Filters II.mp4
05:24
18.1 01-Formatting the table III start.xlsx
18.2 02-Formatting the table III final.xlsx
18. Formatting The Table - Part III - Text Filters III.mp4
06:11
19.1 01-Formatting the table IV start.xlsx
19.2 02-Formatting the table IV final.xlsx
19. Formatting The Table - Part IV - Number Filters I.mp4
04:23
20.1 01-Formatting the table V start.xlsx
20.2 02-Formatting the table V final.xlsx
20. Formatting The Table - Part V - Number Filters II.mp4
02:29
21.1 01-Formatting the table VI start.xlsx
21.2 02-Formatting the table VI final.xlsx
21. Formatting The Table - Part VI - Color filters.mp4
04:41
22.1 01-Formatting the table VII start.xlsx
22.2 02-Formatting the table VII final.xlsx
22. Formatting The Table - Part VII - Date Filters.mp4
04:32
23.1 01-Formatting the table VIII start.xlsx
23.2 02-Formatting the table VIII final.xlsx
23. Formatting The Table - Part VIII - Sorting.mp4
06:00
24.1 01-Formatting the table IX start.xlsx
24.2 02-Formatting the table IX final.xlsx
24. Formatting The Table - Part IX - Multi-level sorting.mp4
07:03
25.1 01-Formatting the table X start.xlsx
25.2 02-Formatting the table X final.xlsx
25. Formatting The Table - Part X - Autofitting.mp4
06:29
26.1 01-Formatting the table XI start.xlsx
26.2 02-Formatting the table XI final.xlsx
26. Formatting The Table - Part XI - Wrapping text.mp4
06:28
27.1 01-Formatting the table XII start.xlsx
27.2 02-Formatting the table XII final.xlsx
27. Formatting The Table - Part XII - Freeze Panes.mp4
04:41
28.1 01-Formatting the table XIII start.xlsx
28.2 02-Formatting the table XIII final.xlsx
28. Formatting The Table - Part XIII - Cut-copy rows and columns.mp4
02:39
29.1 01-Named ranges I start.xlsx
29.2 02-Named ranges I final.xlsx
29. Named Ranges - Part I.mp4
07:21
30.1 01-Named ranges II start.xlsx
30.2 02-Named ranges II final.xlsx
30. Named Ranges - Part II.mp4
06:59
31.1 01-Inserted tables start.xlsx
31.2 02-Inserted tables final.xlsx
31. Inserted Tables - Part I.mp4
07:35
32.1 01-Inserted tables II start.xlsx
32.2 02-Inserted tables II final.xlsx
32. Inserted Tables - Part II.mp4
10:35
33. Self check.html
1.1 01-INDEX start.xlsx
1.2 02-INDEX final.xlsx
1. The INDEX Function - Part I.mp4
07:41
2.1 01-INDEX II start.xlsx
2.2 02-INDEX II final.xlsx
2. The INDEX Function - Part II.mp4
05:32
3.1 01-INDEX III start.xlsx
3.2 02-INDEX III final.xlsx
3. The INDEX Function - Part III.mp4
04:53
4.1 01-SUM combined with INDEX start.xlsx
4.2 02-SUM combined with INDEX final.xlsx
4. The SUM Function Combined With the INDEX Function.mp4
05:51
5.1 01-VLOOKUP start.xlsx
5.2 02-VLOOKUP final.xlsx
5. The VLOOKUP Function - Part I.mp4
10:27
6. A Quick Detour The Search Functionality.mp4
02:08
7.1 01-VLOOKUP 2 start.xlsx
7.2 02-VLOOKUP 2 final.xlsx
7. The VLOOKUP Function - Part II.mp4
06:47
8.1 01-VLOOKUP 3 start.xlsx
8.2 02-VLOOKUP 3 final.xlsx
8. The VLOOKUP Function - Part III.mp4
03:35
9.1 01-VLOOKUP Approximate match numbers start.xlsx
9.2 02-VLOOKUP Approximate match numbers final.xlsx
9. The VLOOKUP Function - Part IV.mp4
05:17
10.1 01-VLOOKUP Approximate match numbers II start.xlsx
10.2 02-VLOOKUP Approximate match numbers II final.xlsx
10. The VLOOKUP Function - Part V.mp4
06:10
11.1 01-VLOOKUP Approximate match strings start.xlsx
11.2 02-VLOOKUP Approximate match strings final.xlsx
11. The VLOOKUP Function - Part VI.mp4
03:23
12. Self check.html
1.1 01-IFERROR start.xlsx
1.2 02-IFERROR final.xlsx
1. The IFERROR function - Part I.mp4
06:59
2. The IFERROR function - Part II.mp4
02:52
3.1 01-NAME error start.xlsx
3.2 02-NAME error final.xlsx
3. The NAME Error.mp4
01:47
4.1 01-VALUE error start.xlsx
4.2 02-VALUE error final.xlsx
4. The VALUE Error.mp4
03:39
5.1 01-REF error start.xlsx
5.2 02-REF error final.xlsx
5. The REF Error.mp4
04:06
6. The NUM Error.mp4
01:34
7. The DIV0 Error.mp4
00:58
8. The NULL Error.mp4
01:48
9. Self check.html
1.1 01-TRIM start.xlsx
1.2 02-TRIM final.xlsx
1. TRIM - Part I.mp4
04:47
2.1 01-TRIM II start.xlsx
2.2 02-TRIM II final.xlsx
2. TRIM - Part II - LEN.mp4
05:59
3.1 01-TRIM III start.xlsx
3.2 02-TRIM III final.xlsx
3. TRIM - Part III - Checking for equality.mp4
06:32
4.1 01-Removing blank rows start.xlsx
4.2 02-Removing blank rows final.xlsx
4. Removing Blank Rows.mp4
02:24
5.1 01-Hiding and unhiding rows and columns start.xlsx
5.2 02-Hiding and unhiding rows and columns final.xlsx
5. Hiding and Unhiding Rows and Columns.mp4
05:14
6.1 01-Dropdown lists start.xlsx
6.2 02-Dropdown lists final.xlsx
6. Dropdown Lists - Part I.mp4
06:40
7.1 01-Dropdown lists II start.xlsx
7.2 02-Dropdown lists II final.xlsx
7. Dropdown Lists - Part II.mp4
04:46
8.1 01-Dropdown lists III start.xlsx
8.2 02-Dropdown lists III final.xlsx
8. Dropdown Lists - Part III.mp4
06:15
9. Self check.html
1.1 01-IF start.xlsx
1.2 02-IF final.xlsx
1. IF - Part I.mp4
04:39
2.1 01-IF II start.xlsx
2.2 02-IF II final.xlsx
2. IF - Part II.mp4
05:07
3.1 01-IFS start.xlsx
3.2 02-IFS final.xlsx
3. The IFS - Part I.mp4
05:30
4.1 01-IFS II start.xlsx
4.2 02-IFS II final.xlsx
4. The IFS - Part II.mp4
05:23
5.1 01-IFS III start.xlsx
5.2 02-IFS III final.xlsx
5. The IFS - Part III.mp4
04:49
6.1 01-AND start.xlsx
6.2 02-AND final.xlsx
6. AND - Part I.mp4
05:16
7.1 01-AND II start.xlsx
7.2 02-AND II final.xlsx
7. AND - Part II.mp4
04:18
8.1 01-OR start.xlsx
8.2 02-OR final.xlsx
8. OR - Part I.mp4
04:24
9.1 01-OR ii start.xlsx
9.2 02-OR ii final.xlsx
9. OR - Part II.mp4
02:15
10. Self check.html
11.1 01-COUNTIF start.xlsx
11.2 02-COUNTIF final.xlsx
11. COUNTIF - Part I.mp4
04:46
12.1 01-COUNTIF ii start.xlsx
12.2 02-COUNTIF ii final.xlsx
12. COUNTIF - Part II.mp4
02:32
13.1 01-COUNTIFS ii start.xlsx
13.2 02-COUNTIFS ii final.xlsx
13. COUNTIFS.mp4
04:59
14.1 01-SUMIF start.xlsx
14.2 02-SUMIF final.xlsx
14. SUMIF - Part I.mp4
04:19
15.1 01-SUMIF II start.xlsx
15.2 02-SUMIF II final.xlsx
15. SUMIF - Part II.mp4
01:56
16.1 01-SUMIFS start.xlsx
16.2 02-SUMIFS final.xlsx
16. SUMIFS.mp4
03:39
17.1 Conditional formatting I start.xlsx
17. Conditional Formatting - Part I.mp4
06:01
18.1 01-Conditional formatting II start.xlsx
18.2 02-Conditional formatting II final.xlsx
18. Conditional Formatting - Part II.mp4
04:41
19.1 01-Conditional formatting 3 start.xlsx
19.2 02-Conditional formatting 3 final.xlsx
19. Conditional Formatting - Part III.mp4
07:46
20.1 01-Conditional formatting 4 start.xlsx
20.2 02-Conditional formatting 4 final.xlsx
20. Conditional Formatting - Part IV.mp4
07:25
21.1 01-Conditional formatting 5 start.xlsx
21.2 02-Conditional formatting 5 final.xlsx
21. Conditional Formatting - Part V.mp4
06:38
22.1 01-Conditional formatting 6 start.xlsx
22.2 02-Conditional formatting 6 final.xlsx
22. Conditional Formatting - Part VI.mp4
03:50
23. Self check.html
1.1 01-Cell references 1 start.xlsx
1.2 02-Cell references 1 final.xlsx
1. Cell References - Part I.mp4
04:24
2.1 01-Cell references 2 start.xlsx
2.2 02-Cell references 2 final.xlsx
2. Cell References - Part II.mp4
06:52
3.1 01-Cell references 3 start.xlsx
3.2 02-Cell references 3 final.xlsx
3. Cell References - Part III.mp4
08:34
4.1 01-Cell references 4 start.xlsx
4.2 02-Cell references 4 final.xlsx
4. Cell References - Part IV.mp4
08:02
5.1 01-Cell references 5 start.xlsx
5.2 02-Cell references 5 final.xlsx
5. Cell References - Part V.mp4
10:17
6.1 01-Referencing other worksheets start.xlsx
6.2 01-Referencing other worksheets start.xlsx
6.3 02-Referencing other worksheets final.xlsx
6.4 02-Referencing other worksheets final.xlsx
6. Referencing Other Worksheets - Part I.mp4
04:22
7.1 01-Referencing other worksheets II start.xlsx
7.2 02-Referencing other worksheets II final.xlsx
7. Referencing Other Worksheets - Part II.mp4
03:32
8. Referencing Other Workbooks - Part I.mp4
05:30
9. Referencing Other Workbooks - Part II.mp4
04:22
1.1 01-MATCH start.xlsx
1.2 02-MATCH final.xlsx
1. MATCH.mp4
07:21
2.1 01-INDEX recap start.xlsx
2.2 02-INDEX recap final.xlsx
2. INDEX Recap.mp4
04:59
3.1 01-INDEX MATCH start.xlsx
3.2 02-INDEX MATCH final.xlsx
3. INDEX MATCH.mp4
06:24
4.1 01-INDEX MATCH MATCH start.xlsx
4.2 02-INDEX MATCH MATCH final.xlsx
4. INDEX MATCH MATCH.mp4
04:18
1.1 01-Working with multiple values new start.xlsx
1.2 02-Working with multiple values new final.xlsx
1. Working With Multiple Values - Part I.mp4
07:04
2.1 01-Working with multiple values II new start.xlsx
2.2 02-Working with multiple values II new final.xlsx
2. Working With Multiple Values - Part II.mp4
05:25
3.1 01-Working with multiple values III new start.xlsx
3.2 02-Working with multiple values III new final.xlsx
3. Working With Multiple Values - Part III.mp4
06:33
4.1 01-Basic Array Formula Example 1 start.xlsx
4.2 02-Basic Array Formula Example 1 final.xlsx
4. Basic Array Formula Example.mp4
08:36
5.1 01-Conditional array fromula start.xlsx
5.2 02-Conditional array fromula final.xlsx
5. Conditional Array Formula.mp4
06:58
6.1 01-Single result array formula start.xlsx
6.2 02-Single result array formula final.xlsx
6. Single Result Array Formula.mp4
07:02
7.1 01-UNIQUE start.xlsx
7.2 02-UNIQUE final.xlsx
7. The UNIQUE Function.mp4
04:10
8.1 01-Array formula for finding unique values start.xlsx
8.2 02-Array formula for finding unique values final.xlsx
8. Array Formula for Finding Unique Values - Part I.mp4
05:37
9.1 01-Array formula for finding unique values 2 start.xlsx
9.2 02-Array formula for finding unique values 2 final.xlsx
9. Array Formula for Finding Unique Values - Part II.mp4
04:56
10.1 01-Array formula for finding unique values 3 start.xlsx
10.2 02-Array formula for finding unique values 3 final.xlsx
10. Array Formula for Finding Unique Values - Part III.mp4
05:50
11.1 01-Array formula for finding unique values 4 start.xlsx
11.2 02-Array formula for finding unique values 4 final.xlsx
11. Array Formula for Finding Unique Values - Part IV.mp4
10:01
12.1 01-Returning first distinct value start.xlsx
12.2 02-Returning first distinct value final.xlsx
12. Returning First Distinct Value.mp4
01:42
13.1 01-Returning non duplicates start.xlsx
13.2 02-Returning non duplicates final.xlsx
13. Returning Non-duplicates.mp4
03:31
1.1 Charts Intro.xlsx
1. Introduction to Charts.mp4
07:00
2.1 01-Bar chart start.xlsx
2.2 02-Bar chart final.xlsx
2. Bar Chart - Part I.mp4
05:45
3.1 01-Bar chart 2 start.xlsx
3.2 02-Bar chart 2 final.xlsx
3. Bar Chart - Part II.mp4
06:56
4.1 01-Bar chart 3 start.xlsx
4.2 02-Bar chart 3 final.xlsx
4. Bar Chart - Part III.mp4
08:41
5.1 01-Bar chart 4 start.xlsx
5.2 02-Bar chart 4 final.xlsx
5. Bar Chart - Part IV.mp4
11:13
6.1 01-Bar chart 5 start.xlsx
6.2 02-Bar chart 5 final.xlsx
6. Bar Chart - Part V.mp4
08:52
7.1 01-Column chart start.xlsx
7.2 02-Column chart final.xlsx
7. Column Chart - Part I.mp4
07:03
8.1 01-Column chart 2 start.xlsx
8.2 02-Column chart 2 final.xlsx
8. Column Chart - Part II.mp4
04:40
9. Column Chart - Part III.mp4
00:27
10.1 01-Column chart for comparison start.xlsx
10.2 02-Column chart for comparison final.xlsx
10. Column Chart - Part IV.mp4
06:26
11.1 01-Adding more data start.xlsx
11.2 02-Adding more data final.xlsx
11. Column Chart - Part V.mp4
05:01
12.1 01-Pie chart start.xlsx
12.2 02-Pie chart final.xlsx
12. Pie Chart - Part I.mp4
08:31
13.1 01-Pie chart 3D start.xlsx
13.2 02-Pie chart 3D final.xlsx
13. Pie Chart - Part II.mp4
06:37
14.1 01-Doughnut chart start.xlsx
14.2 02-Doughnut chart final.xlsx
14. Pie Chart - Part III.mp4
06:26
15.1 01-Pie chart explosion start.xlsx
15.2 02-Pie chart explosion final.xlsx
15. Pie Chart - Part IV.mp4
07:12
16.1 01-Line chart start.xlsx
16.2 02-Line chart final.xlsx
16. Line Chart - Part I.mp4
07:53
17.1 01-Secondary axis start.xlsx
17.2 02-Secondary axis final.xlsx
17. Line Chart - Part II.mp4
08:56
18.1 01-Combo chart start.xlsx
18.2 02-Combo chart final.xlsx
18. Combo Chart.mp4
10:43
19.1 01-Moving and copying charts start.xlsx
19.2 02-Moving and copying charts final.xlsx
19. Moving and Copying Charts.mp4
12:37
20.1 01-Sparklines start.xlsx
20.2 02-Sparklines final.xlsx
20. Sparklines - Part I.mp4
10:57
21.1 01-Sparklines style and grouping start.xlsx
21.2 02-Sparklines style and grouping final.xlsx
21. Sparklines - Part II.mp4
08:45
22.1 01-Sparklines style and grouping 2 start.xlsx
22.2 02-Sparklines style and grouping 2 final.xlsx
22. Sparklines - Part III.mp4
07:46
23.1 01-Column sparklines start.xlsx
23.2 02-Column sparklines final.xlsx
23. Sparklines - Part IV.mp4
06:50
24.1 01-Win loss sparkline start.xlsx
24.2 02-Win loss sparkline final.xlsx
24. Sparklines - Part V.mp4
06:26
25.1 01-People Graph start.xlsx
25.2 02-People Graph final.xlsx
25. People Graph.mp4
11:16
1.1 01-Pivot table start.xlsx
1.2 02-Pivot table final.xlsx
1. Pivot Table - Part I.mp4
12:04
2.1 01-Pivot table 2 start.xlsx
2.2 02-Pivot table 2 final.xlsx
2. Pivot Table - Part II.mp4
04:14
3.1 01-Pivot table 3 start.xlsx
3.2 02-Pivot table 3 final.xlsx
3. Pivot Table - Part III.mp4
10:24
4.1 01-Pivot table 4 start.xlsx
4.2 02-Pivot table 4 final.xlsx
4. Pivot Table - Part IV.mp4
05:29
5.1 01-Pivot table 5 start.xlsx
5.2 02-Pivot table 5 final.xlsx
5. Pivot Table - Part V.mp4
06:56
6.1 01-Pivot table 6 start.xlsx
6.2 02-Pivot table 6 final.xlsx
6. Pivot Table - Part VI.mp4
11:50
7.1 01-Pivot table 7 start.xlsx
7.2 02-Pivot table 7 final.xlsx
7. Pivot Table - Part VII.mp4
10:48
8.1 01-Pivot table 8 start.xlsx
8.2 02-Pivot table 8 final.xlsx
8. Pivot Table - Part VIII.mp4
13:05
9.1 01-Pivot table 9 start.xlsx
9.2 02-Pivot table 9 final.xlsx
9. Pivot Table - Part IX.mp4
04:10
10.1 01-Pivot table 10 start.xlsx
10.2 02-Pivot table 10 final.xlsx
10. Pivot Table - Part X.mp4
13:20
11.1 01-Multiple value fields start.xlsx
11.2 02-Multiple value fields final.xlsx
11. Pivot Table - Part XI.mp4
06:26
12.1 01-Multiple value fields 2 start.xlsx
12.2 02-Multiple value fields 2 final.xlsx
12. Pivot Table - Part XII.mp4
08:25
13.1 01-Multiple value fields 3 start.xlsx
13.2 02-Multiple value fields 3 final.xlsx
13. Pivot Table - Part XIII.mp4
07:18
14.1 01-Manual sorting start.xlsx
14.2 02-Manual sorting final.xlsx
14. Pivot Table - Part XIV.mp4
02:50
15.1 Pivot from multiple tables start.xlsx
15. Pivot Table - Part XVa.mp4
06:19
16.1 01-Pivot from multiple tables 2 start.xlsx
16.2 02-Pivot from multiple tables 2 final.xlsx
16. Pivot Table - Part XVb.mp4
10:46
17.1 01-Pivot table distinct count start.xlsx
17.2 02-Pivot table distinct count final.xlsx
17. Pivot Table - Part XVI.mp4
08:50
18.1 01-Filtered totals start.xlsx
18.2 02-Filtered totals final.xlsx
18. Pivot Table - Part XVII.mp4
07:33
19.1 01-Calculated field start.xlsx
19.2 02-Calculated field final.xlsx
19. Pivot Table - Part XVIII.mp4
06:53
20.1 01-Calculated item start.xlsx
20.2 02-Calculated item final.xlsx
20. Pivot Table - Part XIX.mp4
05:48
21.1 Pivot cache start.xlsx
21.2 Unsharing Pivot Cache.html
21. Pivot Table - Part XX - Pivot cache I.mp4
06:13
22.1 01-Pivot cache 2 start.xlsx
22.2 02-Pivot cache 2 final.xlsx
22. Pivot Table - Part XX - Pivot cache II.mp4
10:32
23.1 01-Pivot cache 3 start.xlsx
23.2 02-Pivot cache 3 final.xlsx
23. Pivot Table - Part XX - Pivot cache III.mp4
05:14
24.1 01-Pivot table with dates start.xlsx
24.2 02-Pivot table with dates final.xlsx
24. Pivot Table with Dates.mp4
09:54
25.1 01-Pivot charts start.xlsx
25.2 02-Pivot charts final.xlsx
25. Pivot Charts.mp4
19:28
1.1 01-Worksheet operations start.xlsx
1.2 02-Worksheet operations final.xlsx
1. Useful Worksheet Operations.mp4
11:35
1.1 Comments and Notes start.xlsx
1. Comments and Notes.mp4
07:19
2.1 01-Copy-paste start.xlsx
2.2 02-Copy-paste final.xlsx
2. Copy & Paste - Part I.mp4
07:36
3.1 01-Copy-paste 2 start.xlsx
3.2 02-Copy-paste 2 final.xlsx
3. Copy & Paste - Part II.mp4
07:13
4.1 01-Copy-paste 3 start.xlsx
4.2 02-Copy-paste 3 final.xlsx
4. Copy & Paste - Part III.mp4
07:06
5.1 01-Copy-paste 4 start.xlsx
5.2 02-Copy-paste 4 final.xlsx
5. Copy & Paste - Part IV.mp4
06:17
6.1 01-Cut-paste start.xlsx
6.2 02-Cut-paste final.xlsx
6. Copy & Paste - Part V.mp4
03:56
7.1 01-Filling cells start.xlsx
7.2 02-Filling cells final.xlsx
7. Filling Cells.mp4
02:47
8.1 Find and replace start.xlsx
8. Find and Replace - Part I.mp4
08:06
9. Find and Replace - Part II.mp4
03:28
10.1 01-Find and replace 3 start.xlsx
10.2 02-Find and replace 3 final.xlsx
10. Find and Replace - Part III.mp4
07:41
11.1 Find and replace 4 start.xlsx
11. Find and Replace - Part IV.mp4
02:43
12.1 01-Grouping start.xlsx
12.2 02-Grouping final.xlsx
12. Grouping.mp4
07:31
13.1 Importing external data.xlsx
13.2 sales numbers with headers.txt
13.3 sales numbers with headers.xlsx
13.4 sales numbers.txt
13.5 sales numbers.xlsx
13. Importing External Data.mp4
08:15
14.1 01-Merging cells start.xlsx
14.2 02-Merging cells final.xlsx
14. Merging Cells.mp4
04:16
15.1 file 1.xlsx
15.2 file 2.xlsx
15. Opening Multiple Excel Files.mp4
00:55
16.1 Printing start.xlsx
16. Printing.mp4
13:04
1.1 01-Swap names start.xlsx
1.2 02-Swap names final.xlsx
1. Swap Names - Part I.mp4
06:26
2.1 01-Swap names 2 start.xlsx
2.2 02-Swap names 2 final.xlsx
2. Swap Names - Part II.mp4
06:30
3.1 01-Swap names 3 start.xlsx
3.2 02-Swap names 3 final.xlsx
3. Swap Names - Part III.mp4
04:11
4.1 01-Swap names 4 start.xlsx
4.2 02-Swap names 4 final.xlsx
4. Swap Names - Part IV.mp4
05:08
5.1 01-Swap names 5 start.xlsx
5.2 02-Swap names 5 final.xlsx
5. Swap Names - Part V.mp4
05:39
1.1 seat planning start.zip
1. Seat Planning - Part I.mp4
09:27
2.1 seat planning 2 start.zip
2. Seat Planning - Part II.mp4
05:44
3.1 seat planning 3 start.zip
3. Seat Planning - Part III.mp4
12:01
4.1 01-seat planning 4 start.zip
4.2 02-seat planning 4 final.zip
4. Seat Planning - Part IV.mp4
09:29
5.1 01-seat planning 5 start.zip
5.2 02-seat planning 5 final.zip
5. Seat Planning - Part V.mp4
04:33
6.1 01-seat planning 6 start.zip
6.2 02-seat planning 6 final.zip
6. Seat Planning - Part VI.mp4
10:05
7.1 01-seat planning 7 start.zip
7.2 02-seat planning 7 final.zip
7. Seat Planning - Part VII.mp4
04:53
1.1 vba intro.zip
1.2 VBA Intro.xlsx
1. Intro.mp4
04:43
2. Visual Basic Editor.mp4
07:43
1. Our First Subroutine.mp4
07:46
2. Compiling.mp4
04:42
3. Saving a Macro Enabled Workbook.mp4
01:49
4.1 Macro has been blocked.html
4. UPDATE 2023.02.02 Unblocking a macro-enabled Workbook.mp4
03:09
5. Enabling Macros.mp4
01:24
6.1 01-integer variables start.zip
6.2 02-integer variables final.zip
6. Integer Variables - Part I.mp4
07:38
7.1 01-integer variables 2 start.zip
7.2 02-integer variables 2 final.zip
7.3 VBA Documentation.html
7. Integer Variables - Part II.mp4
10:18
8.1 01-string variables start.zip
8.2 02-string variables final.zip
8. String Variables - Part I.mp4
05:26
9.1 01-string variables 2 start.zip
9.2 02-string variables 2 final.zip
9. String Variables - Part II.mp4
09:01
10.1 01-cells and ranges start.zip
10.2 02-cells and ranges final.zip
10. Cells and Ranges.mp4
08:03
11.1 01-working with numbers start.zip
11.2 02-working with numbers final.zip
11. Working With Numbers - Part I.mp4
07:17
12.1 01-working with numbers 2 start.zip
12.2 02-working with numbers 2 final.zip
12. Working With Numbers - Part II.mp4
13:23
13.1 01-working with numbers 3 start.zip
13.2 02-working with numbers 3 final.zip
13. Working With Numbers - Part III.mp4
06:55
14.1 01-working with numbers 4 start.zip
14.2 02-working with numbers 4 final.zip
14. Working With Numbers - Part IV.mp4
04:18
15.1 01-working with numbers 5 start.zip
15.2 02-working with numbers 5 final.zip
15. Working With Numbers - Part V.mp4
01:29
16.1 About bits and bytes.docx
16.2 about bits and bytes.zip
16. About Bits and Bytes.mp4
10:00
1.1 01-modules start.zip
1.2 02-modules final.zip
1. Modules.mp4
05:17
2.1 01-if start.zip
2.2 02-if final.zip
2. IF - Part I.mp4
06:16
3.1 01-if 2 start.zip
3.2 02-if 2 final.zip
3. IF - Part II.mp4
02:39
4.1 01-if 3 start.zip
4.2 02-if 3 final.zip
4. IF - Part III.mp4
07:22
5.1 01-if 4 start.zip
5.2 02-if 4 final.zip
5. IF - Part IV.mp4
07:16
6.1 01-select case start.zip
6.2 02-select case final.zip
6. Select Case - Part I.mp4
05:28
7.1 01-select case 2 start.zip
7.2 02-select case 2 final.zip
7. Select Case - Part II.mp4
04:30
8.1 01-select case 3 start.zip
8.2 02-select case 3 final.zip
8. Select Case - Part III.mp4
04:37
9.1 01-arrays start.zip
9.2 02-arrays final.zip
9. Arrays - Part I.mp4
05:36
10.1 01-arrays 2 start.zip
10.2 02-arrays 2 final.zip
10. Arrays - Part II.mp4
03:38
11.1 01-dynamic arrays start.zip
11.2 02-dynamic arrays final.zip
11. Dynamic Arrays.mp4
08:22
12.1 01-range to array start.zip
12.2 02-range to array final.zip
12. Range to Array - Part I.mp4
08:15
13.1 01-range to array 2 start.zip
13.2 02-range to array 2 final.zip
13. Range to Array - Part II.mp4
06:12
14.1 01-for loop start.zip
14.2 02-for loop final.zip
14. The FOR Loop - Part I.mp4
09:16
15.1 01-for loop 2 start.zip
15.2 02-for loop 2 final.zip
15. The FOR Loop - Part II.mp4
02:09
16.1 for loop 3 start.zip
16. The FOR Loop - Part III.mp4
05:41
17.1 for loop 4 start.zip
17. The FOR Loop - Part IV.mp4
02:11
18.1 01-for loop with 2-dimensional array start.zip
18.2 02-for loop with 2-dimensional array final.zip
18. The FOR Loop - Part V.mp4
09:30
19.1 looping by columns start.zip
19. The FOR Loop - Part VI.mp4
08:46
20.1 for each loop start.zip
20. The FOR EACH Loop.mp4
04:26
21.1 do loop until start.zip
21. The DO LOOP - Part I.mp4
08:18
22.1 do until loop start.zip
22. The DO LOOP - Part II.mp4
03:17
23.1 exit do start.zip
23. The DO LOOP - Part III.mp4
09:22
24.1 do loop while start.zip
24. The DO LOOP - Part IV.mp4
03:30
25.1 do while loop start.zip
25. The DO LOOP - Part V.mp4
02:34
26.1 while wend loop start.zip
26. The WHILE WEND Loop.mp4
15:08
1.1 01-collections start.zip
1.2 02-collections final.zip
1. Collections - Part I.mp4
08:28
2.1 01-collections 2 start.zip
2.2 02-collections 2 final.zip
2. Collections - Part II.mp4
08:14
3.1 01-collections 3 start.zip
3.2 02-collections 3 final.zip
3. Collections - Part III.mp4
06:11
4.1 collections 4 start.zip
4. Collections - Part IV.mp4
05:14
5.1 activesheet start.zip
5. The ActiveSheet Object.mp4
07:44
6.1 01-range object start.zip
6.2 02-range object final.zip
6. Range Object - Part I.mp4
07:03
7.1 01-range object 2 start.zip
7.2 02-range object 2 final.zip
7.3 Object Properties.html
7. Range Object - Part II.mp4
06:25
8.1 01-range object 3 start.zip
8.2 02-range object 3 final.zip
8. Range Object - Part III.mp4
08:05
9.1 01-range object 4 start.zip
9.2 02-range object 4 final.zip
9.3 Bold font.html
9.4 Colors.html
9. Range Object - Part IV.mp4
13:09
10.1 01-worksheet object start.zip
10.2 02-worksheet object final.zip
10. Worksheet Object - Part I.mp4
08:33
11.1 01-worksheet object 2 start.zip
11.2 02-worksheet object 2 final.zip
11. Worksheet Object - Part II.mp4
06:10
12.1 Excel Worksheet.html
12.2 worksheet object 3 start.zip
12. Worksheet Object - Part III.mp4
04:31
13.1 Workbook Object Test.xlsx
13. Workbook Object - Part I.mp4
06:04
14.1 workbook object final.zip
14.2 Workbook Object Test.xlsx
14. Workbook Object - Part II.mp4
08:32
15.1 nothing keyword final.zip
15.2 nothing keyword start.zip
15. The NOTHING Keyword.mp4
07:56
16.1 object and non-object variables start.zip
16. Object and Non-object Variables - Part I.mp4
09:25
17.1 object and non-object variables start.zip
17. Object and Non-object Variables - Part II.mp4
04:58
1.1 running a macro from quick access final.zip
1.2 running a macro from quick access start.zip
1. Part I.mp4
05:58
2.1 create a button for a macro final.zip
2.2 create a button for a macro start.zip
2. Part II.mp4
05:41
3.1 keyboard shortcut for macro final.zip
3.2 keyboard shortcut for macro start.zip
3. Part III.mp4
03:33
1.1 application object final.zip
1.2 application object start.zip
1. Application Object.mp4
10:57
2.1 functions final.zip
2.2 functions start.zip
2. Functions.mp4
08:07
3.1 option explicit final.zip
3.2 option explicit start.zip
3. Option Explicit.mp4
03:54
4.1 arguments start.zip
4. Arguments.mp4
08:29
5.1 byval and byref final.zip
5.2 byval and byref start.zip
5. ByVal and ByRef - Part I.mp4
06:44
6.1 byval and byref 2 final.zip
6.2 byval and byref 2 start.zip
6. ByVal and ByRef - Part II.mp4
04:32
7.1 getlastrow start.zip
7. GetLastRow - Part I.mp4
09:04
8.1 getlastrow start.zip
8. GetLastRow - Part II.mp4
05:47
9.1 getlastcolumn start.zip
9. GetLastColumn.mp4
08:23
10.1 01-getcolumnletterperindex start.zip
10.2 02-getcolumnletterperindex final.zip
10. GetColumnLetterPerIndex.mp4
07:26
11.1 calling with named arguments final.zip
11.2 calling with named arguments start.zip
11. Calling With Named Arguments.mp4
04:53
12.1 declaring arguments final.zip
12.2 declaring arguments start.zip
12. Declaring Arguments.mp4
04:25
13.1 optional arguments final.zip
13.2 optional arguments start.zip
13. Optional Arguments.mp4
05:12
14.1 ways of calling functions and subs start.zip
14. Ways of Calling Functions and Subs.mp4
03:11
15.1 data type conversion start.zip
15.2 data type conversion start.zip
15. Data Type Conversion - Part I.mp4
08:30
16.1 data type conversion start.zip
16. Data Type Conversion - Part II.mp4
06:19
17.1 worksheet functions start.zip
17. Worksheet Functions.mp4
05:53
18.1 vartype start.zip
18. VarType.mp4
04:18
19.1 constants start.zip
19. Constants.mp4
07:27
20.1 module level variables and constants start.zip
20. Module Level Variables and Constants.mp4
07:19
21.1 global variables and constants start.zip
21. Global Variables and Constants.mp4
03:37
1.1 recording macro with absolute reference final.zip
1.2 recording macro with absolute reference start.zip
1. Recording Macro with Absolute Reference - Part I.mp4
07:40
2.1 recording macro with absolute reference 2 final.zip
2.2 recording macro with absolute reference 2 start.zip
2. Recording Macro with Absolute Reference - Part II.mp4
09:08
3.1 running a macro with relative references final.zip
3.2 running a macro with relative references start.zip
3. Running a Macro with Relative References.mp4
02:43
4.1 copy paste macro final.zip
4.2 copy paste macro start.zip
4. Copy Paste Macros - Part I.mp4
07:37
5.1 copy paste macro 2 start.zip
5. Copy Paste Macros - Part II.mp4
08:41
1.1 error handling final.zip
1.2 error handling start.zip
1. Part 1.mp4
06:38
2.1 error handling 2 final.zip
2.2 error handling 2 start.zip
2. Part 2.mp4
07:25
3.1 error handling 3 final.zip
3.2 error handling 3 start.zip
3. Part 3.mp4
09:12
4.1 error handling 4 final.zip
4.2 error handling 4 start.zip
4. Part 4.mp4
08:36
1.1 getting user input inputbox start.zip
1. Getting User Input - InputBox.mp4
02:56
2.1 getting user input msgbox start.zip
2. Getting User Input - MsgBox.mp4
03:13
3.1 opening a new workbook start.zip
3. Opening a New Workbook.mp4
03:29
4.1 opening an existing workbook start.zip
4.2 Test workbook.xlsx
4. Opening an Existing Workbook.mp4
03:41
5.1 closing a workbook start.zip
5.2 Test workbook.xlsx
5. Closing a Workbook.mp4
06:14
6.1 saving a workbook start.zip
6.2 Test workbook.xlsx
6. Saving a Workbook.mp4
07:06
1.1 workbook events start.zip
1. Workbook Events - Part I.mp4
05:51
2.1 workbook events start.zip
2. Workbook Events - Part II.mp4
07:45
3.1 worksheet events start.zip
3. Worksheet Events.mp4
04:15
1.1 exporting and importing modules start.zip
1. Exporting and Importing Modules.mp4
02:25
2.1 calling a function or sub of another workbook start.zip
2.2 test workbook 2.zip
2.3 test workbook.zip
2. Calling a Function or Sub of Another Workbook.mp4
05:07
3.1 personal macro workbook start.zip
3. Personal Macro Workbook.mp4
08:54
1.1 intro to object based programming.zip
1.2 Test workbook.xlsx
1. Intro to Object-based Programming - Part I.mp4
05:46
2.1 intro to object based programming.zip
2.2 Test workbook.xlsx
2. Intro to Object-based Programming - Part II.mp4
02:33
3.1 class modules final.zip
3.2 class modules start.zip
3. Class Modules.mp4
08:17
4.1 private member variables final.zip
4.2 private member variables start.zip
4. Private Member Variables.mp4
10:19
5.1 properties final.zip
5.2 properties start.zip
5. Properties.mp4
10:37
6.1 init final.zip
6.2 init start.zip
6. Init.mp4
02:40
7.1 order object start.zip
7. Order Object.mp4
03:55
8.1 car object start.zip
8. Car Object.mp4
10:39
9.1 associate an order with a car start.zip
9. Associate an Order With a Car.mp4
06:44
10.1 calculating the order price start.zip
10. Calculating the Order Price.mp4
05:54
11.1 private subs and functions start.zip
11. Private and Public keywords in Subs and Functions.mp4
02:33
1.1 seat planning automation vba updated 2023 09 17.zip
1.2 seat planning automation vba.zip
1. Seat Planning Overview.mp4
04:21
2.1 seat planning automation vba updated 2023 09 17.zip
2.2 seat planning automation vba.zip
2. Check Worksheets.mp4
08:35
3.1 seat planning automation vba updated 2023 09 17.zip
3.2 seat planning automation vba.zip
3. DeleteWs.mp4
04:19
4.1 seat planning automation vba updated 2023 09 17.zip
4.2 seat planning automation vba.zip
4. Delete Data.mp4
01:19
5.1 seat planning automation vba updated 2023 09 17.zip
5.2 seat planning automation vba.zip
5. Add Employee Data.mp4
10:50
6.1 seat planning automation vba updated 2023 09 17.zip
6.2 seat planning automation vba.zip
6. Copy Employee Data.mp4
01:20
7.1 seat planning automation vba updated 2023 09 17.zip
7.2 seat planning automation vba.zip
7. Add Location Formula.mp4
06:04
8.1 seat planning automation vba updated 2023 09 17.zip
8.2 seat planning automation vba.zip
8. Add Free Seats Formulas.mp4
03:26
9.1 seat planning automation vba updated 2023 09 17.zip
9.2 seat planning automation vba.zip
9. Create Pivot Table Macro - Part I.mp4
08:42
10.1 seat planning automation vba updated 2023 09 17.zip
10.2 seat planning automation vba.zip
10. Create Pivot Table Macro - Part II.mp4
05:26
1. What are SQL and Databases.mp4
06:35
2.1 Download Xampp.html
2. Installing Xampp.mp4
03:42
3. Setting Database Password.mp4
06:10
4. Stopping MariaDB.mp4
00:43
1. Creating a Database and a Database Table.mp4
05:30
2. Adding Rows to Tables.mp4
03:06
3. Our First Query.mp4
04:03
1.1 Download ODBC Driver.html
1. Installing OBDC Driver.mp4
03:43
2.1 setting up vba for sql.zip
2. Setting Up VBA for SQL - Part I.mp4
05:05
3.1 setting up vba for sql.zip
3. Setting Up VBA for SQL - Part II.mp4
00:58
4.1 setting up vba for sql.zip
4. Setting Up VBA for SQL - Part III.mp4
06:27
1.1 where.zip
1. WHERE.mp4
06:03
2.1 Data to insert.txt
2. Adding More data.mp4
02:58
3.1 order by final.zip
3.2 order by.zip
3. ORDER BY.mp4
04:28
4.1 and final.zip
4.2 and start.zip
4. AND.mp4
04:16
5.1 or final.zip
5.2 or start.zip
5. OR.mp4
03:37
6.1 combining and and or final.zip
6.2 combining and and or start.zip
6. Combining AND and OR.mp4
04:14
7.1 not.zip
7. NOT.mp4
02:36
8.1 where field is not null.zip
8. WHERE field is NOT NULL.mp4
04:00
9.1 as.zip
9. AS.mp4
03:06
10.1 no records returned.zip
10. No Records Returned.mp4
03:18
11.1 between.zip
11. BETWEEN.mp4
03:54
12.1 like.zip
12. LIKE.mp4
05:12
13.1 in.zip
13. IN.mp4
02:18
14.1 select distinct.zip
14. SELECT DISTINCT.mp4
02:17
1. Changing The Table.mp4
07:59
2. Insert Ignore Into - Part I.mp4
05:59
3.1 insert ignore into.zip
3. Insert Ignore Into - Part II.mp4
06:41
4.1 update.zip
4. UPDATE.mp4
04:55
5.1 delete.zip
5. DELETE.mp4
04:17
1.1 insert ignore into for reinsert.zip
1. Reinserting The Data.mp4
01:07
2. Exporting a Database.mp4
04:52
3.1 CREATE TABLE query.docx
3. SQL for Creating a Table.mp4
08:21
4.1 create table if not exists final.zip
4.2 create table if not exists.zip
4. Create a Table Using SQL.mp4
07:51
5.1 alter table add column.zip
5. ALTER TABLE ADD Column.mp4
04:41
6.1 alter table modify column.zip
6. ALTER TABLE MODIFY Column.mp4
03:37
7.1 alter table drop column.zip
7. ALTER TABLE DROP Column.mp4
02:37
8.1 drop table.zip
8. DROP TABLE.mp4
02:12
9.1 unique.zip
9. UNIQUE.mp4
09:46
1.1 limit.zip
1. LIMIT.mp4
03:28
1.1 inner join 1.zip
1. Inner Join - Part I.mp4
12:26
2.1 inner join 2.zip
2.2 sql to run in phpmyadmin.txt
2. Inner Join - Part II.mp4
05:30
3.1 left join.zip
3. Left Join.mp4
03:58
1.1 min.zip
1. The MIN Function.mp4
03:32
2.1 max.zip
2. The MAX Function.mp4
02:37
3.1 count.zip
3. The COUNT Function.mp4
05:19
4.1 group by.zip
4. The GROUP BY Function.mp4
03:12
5.1 avg.zip
5. The AVG Function - Part I.mp4
01:58
6.1 avg 2.zip
6. The AVG Function - Part II.mp4
07:25
7.1 sum.zip
7. The SUM Function.mp4
01:28
8.1 having.zip
8. The HAVING Keyword.mp4
08:21
1.1 seat planning automation vba and sql updated 2023 09 17.zip
1.2 seat planning automation vba and sql.zip
1.3 sql for employee data.txt
1. Seat Planning Automation VBA and SQL.mp4
06:49
1. Important Notice.mp4
00:54
2. What is Google Sheets.mp4
03:52
3. Registering a Google account.mp4
01:21
4. Google Sheets and other software.mp4
02:05
5. Creating a new Spreadsheet.mp4
02:21
6. A brief intro to the Worksheet.mp4
06:15
7. Renaming the Spreadsheet.mp4
01:55
8. Brief discussion of some features.mp4
03:15
9. A brief overview of the File menu.mp4
03:55
10. A brief overview of the Edit menu.mp4
01:32
11. The Undo and Redo commands.mp4
02:53
12. A brief overview of the View menu.mp4
03:32
13. A brief overview of the Insert menu.mp4
01:08
14. A brief overview of the Format menu.mp4
02:21
15. A brief overview of the Data menu.mp4
01:40
16. A brief overview of the Tools menu.mp4
00:49
17. A brief overview of the Extensions menu.mp4
01:51
18. A brief overview of the Help menu.mp4
01:32
19. A brief overview of the Toolbar or Command Strip.mp4
01:41
20. Saving your work.mp4
00:54
21. Adding more data.mp4
02:49
22. The problem with one dimensional data.mp4
03:21
23. Tabular Data.mp4
05:11
24. Adding a header.mp4
03:52
25. End of introduction.mp4
00:39
1.1 01 - Starter.html
1.2 02 - Final.html
1. How to use the resource files.mp4
02:44
2.1 01 - Starter.html
2.2 02 - Final.html
2. Column widths and autofitting.mp4
06:16
3.1 01 - Starter.html
3.2 02 - Final.html
3. Overflowing cell contents.mp4
06:57
4.1 01 - Starter.html
4. Row heights and autofitting.mp4
02:51
5.1 01 - Starter.html
5.2 02 - Final.html
5. Adding borders and fill to cells.mp4
10:19
1. Intro to formulas.mp4
03:12
2. Addition.mp4
01:48
3. Referring to cells.mp4
04:41
4.1 Starter.html
4. Subtraction.mp4
01:25
5.1 Multiplication Starter.html
5. Multiplication.mp4
01:03
6. Operator precedence.mp4
02:20
7.1 Division Starter.html
7. Division.mp4
02:39
8.1 SUM function end.html
8.2 SUM function start.html
8. The SUM function.mp4
05:57
9. The importance of the locale.mp4
03:21
10. The importance of the display language.mp4
02:45
11. The formula help.mp4
05:20
12.1 Range End.html
12.2 Range Start.html
12. Range.mp4
06:21
13.1 Dynamic Cell References Start.html
13. Dynamic cell references - Part 1.mp4
04:27
14.1 Dynamic Cell References End.html
14. Dynamic cell references - Part 2.mp4
04:05
15. Sometimes we dont even need a formula.mp4
01:46
16. Formula Suggestions.mp4
02:36
17. Where to find more functions.mp4
02:03
1. Overview of the dashboard.mp4
05:09
2. Moving spreadsheets.mp4
02:56
3. Starring spreadsheets.mp4
01:36
4. Opening a spreadsheet from Google drive.mp4
01:31
1. CTRL SHIFT RIGHT or LEFT ARROW.mp4
03:50
2. CTRL SHIFT UP or DOWN ARROW.mp4
01:32
3. CTRL A.mp4
02:08
4. SHIFT and cursor.mp4
00:34
5. CTRL cursor.mp4
01:55
6. Named ranges.mp4
06:21
7.1 Changing a named range end.html
7.2 Changing a named range start.html
7. Changing a named range.mp4
01:04
8.1 Deleting a named range end.html
8.2 Deleting a named range start.html
8. Deleting a named range.mp4
02:51
9.1 Number format 1 end.html
9.2 Number format 1 start.html
9. Number format 1.mp4
09:10
10.1 Number format 2 end.html
10.2 Number format 2 start.html
10. Number format 2.mp4
06:13
11.1 Data Types 3 End.html
11.2 Data Types 3 Start.html
11.3 Explanation of Scientific notation from Microsoft.html
11. Scientific notation.mp4
10:23
12.1 Data Types 4 End.html
12.2 Data Types 4 Start.html
12. Accounting format.mp4
02:23
13.1 Data Types 5 End.html
13.2 Data Types 5 Start.html
13. Financial format.mp4
01:06
14.1 Data Types 6 End.html
14.2 Data Types 6 Start.html
14. Currency format.mp4
03:05
15.1 Data Types 7 End.html
15.2 Data Types 7 Start.html
15. Changing the currency - Part 1.mp4
03:40
16.1 Data Types 8 End.html
16.2 Data Types 8 Start.html
16. Changing the currency - Part 2.mp4
03:58
17.1 Color Palette.html
17.2 Data Types 9 End.html
17.3 Data Types 9 Start.html
17.4 Developer docs.html
17.5 Google Sheets Help Center.html
17. Custom number format.mp4
08:22
18.1 Data Types 10 End.html
18.2 Data Types 10 Start.html
18. Percent.mp4
02:13
19.1 Data Types 11 End.html
19.2 Data Types 11 Start.html
19. Text.mp4
03:06
20.1 Data Types 12 End.html
20.2 Data Types 12 Start.html
20. Dates.mp4
05:07
21.1 Data Types 13 End.html
21.2 Data Types 13 Start.html
21. Custom date format.mp4
04:53
22.1 Data Types 14 End.html
22.2 Data Types 14 Start.html
22. Date Time.mp4
02:35
23.1 Data Types 15 End.html
23.2 Data Types 15 Start.html
23. Time.mp4
01:50
24.1 Data Types 16 End.html
24.2 Data Types 16 Start.html
24. Duration.mp4
01:21
1.1 Math Functions Start.html
1. Average.mp4
03:27
2. Min.mp4
00:40
3. Max.mp4
00:46
4.1 Math Functions End.html
4. Count.mp4
03:09
1.1 String Manipulation 1 End.html
1.2 String Manipulation 1 Start.html
1. UPPER.mp4
01:46
2. LOWER.mp4
01:43
3. CONCATENATE.mp4
02:04
4. LEN.mp4
01:02
5. FIND and SEARCH.mp4
03:25
6. LEFT.mp4
05:16
7. RIGHT.mp4
04:36
8. MID.mp4
05:13
9. Swapping names 1.mp4
03:17
10. Swapping names 2.mp4
02:35
11. Improving the readability of long formulas.mp4
01:58
12.1 String Manipulation 1 Start.html
12. Avoiding repetition with LET.mp4
08:34
13.1 String manipulation 2 end.html
13.2 String manipulation 2 start.html
13. TRIM.mp4
02:12
14.1 String manipulation 2 end.html
14. REPLACE.mp4
03:27
15.1 String manipulation 2 end.html
15. SUBSTITUTE.mp4
02:33
16.1 String manipulation 2 end.html
16. SPLIT.mp4
03:02
1.1 Dates Start.html
1. DATE.mp4
02:03
2. DATEDIF.mp4
03:10
3. TODAY.mp4
00:51
4. NOW.mp4
00:45
5. Calculation Settings.mp4
05:14
6. Changing the timezone.mp4
02:04
7.1 End.html
7. Version history.mp4
03:07
1.1 Conditional logic 1 end.html
1.2 Conditional logic 1 start.html
1. Conditional logic.mp4
07:22
2.1 Conditional logic 2 end.html
2.2 Conditional logic 2 start.html
2. IF.mp4
03:43
3.1 Conditional logic 2 end.html
3.2 Conditional logic 2 start.html
3. IFS - Part 1.mp4
04:55
4.1 Conditional logic 2 end.html
4.2 Conditional logic 2 start.html
4. IFS - Part 2.mp4
02:09
5.1 Conditional logic 2 end.html
5.2 Conditional logic 2 start.html
5. OR.mp4
01:41
6.1 Conditional logic 2 end.html
6.2 Conditional logic 2 start.html
6. IF combined with OR.mp4
02:19
7.1 Conditional logic 2 end.html
7.2 Conditional logic 2 start.html
7. AND.mp4
02:10
8.1 Conditional logic 2 end.html
8.2 Conditional logic 2 start.html
8. IF combined with AND.mp4
01:50
9.1 Conditional logic 2 end.html
9.2 Conditional logic 2 start.html
9. A challenge with IF OR AND.mp4
03:55
10.1 SUMIF and SUMIFS end.html
10.2 SUMIF and SUMIFS start.html
10. SUMIF and SUMIFS.mp4
06:09
11.1 COUNTIF and COUNTIFS end.html
11.2 COUNTIF and COUNTIFS start.html
11. COUNTIF and COUNTIFS.mp4
04:09
1.1 Sorting and filters start workbook.html
1. Sorting data - Part 1.mp4
03:41
2. Sorting data - Part 2.mp4
04:34
3. Sorting data - Part 3.mp4
04:57
4. Filters - Part 1.mp4
03:01
5. Filters - Part 2.mp4
03:12
6. Filters - Part 3.mp4
05:12
7. Filters - Part 4.mp4
01:48
8. Filters - Part 5.mp4
02:03
9. Filter Views.mp4
03:24
10. Slicers.mp4
02:51
1. Useful Excel Shortcuts.mp4
06:09
2.1 copyonlyvisiblecells end.zip
2.2 copyonlyvisiblecells start.zip
2. Copy only visible cells - Part 1 of 2.mp4
11:23
3.1 copyonlyvisiblecellswithmacro.zip
3. Copy only visible cells - Part 2 of 2.mp4
06:28
4.1 Circular reference example start.xlsx
4. Iterative calculation - Part 1 of 14 - Circular references.mp4
04:12
5. Iterative calculation - Part 2 of 14 - Enabling iterative calculation.mp4
02:42
6. Iterative calculation - Part 3 of 14 - Formulas without circular references.mp4
01:08
7. Iterative calculation - Part 4 of 14 - Looking at each iteration.mp4
03:06
8. Iterative calculation - Part 5 of 14 - The problem with Automatic calculations.mp4
02:36
9. Iterative calculation - Part 6 of 14 - Switching to Manual calculation.mp4
02:52
10.1 Iterative calculation 1 start.xlsx
10. Iterative calculation - Part 7 of 14 - A more meaningful example.mp4
02:02
11. Iterative calculation - Part 8 of 14 - Calculating interest without circular ref.mp4
01:45
12. Iterative calculation - Part 9 of 14 - Calculating interest with circular ref.mp4
04:43
13.1 Iterative calculation 2 start.xlsx
13. Iterative calculation - Part 10 of 14 - The Kryptonite example.mp4
02:06
14. Iterative calculation - 11 of 14 - Calculating amortization without circular ref.mp4
01:06
15. Iterative calculation - 12 of 14 - Calculating amortization with circular ref.mp4
03:19
16. Iterative calculation - 13 of 14 - The Maximum Change condition.mp4
03:13
17. Iterative calculation - 14 of 14 - Is iterative calculation useful.mp4
02:18
18. Will chatGPT take our Excel jobs.mp4
09:59
Description
Learn valuable Excel, VBA, SQL and Programming Skills! Go from beginner to expert and get a Competitive job!
What You'll Learn?
- Learn Microsoft Excel from Beginner to Advanced
- VBA programming
- Learn a large number of Excel functions
- Master advanced Excel functions
- Work with charts and pivot tables
- Learn how to execute SQL statements in Excel
- Task-based learning
- Help from me with real life experience who works with Excel every day
Who is this for?
What You Need to Know?
More details
DescriptionHello!
Thank you for visiting our course page.
Do you want to become the go-to person at your company for Microsoft Excel problems? Do you want to nail your next job interview? Or just want a new skill? If yes, then this course is for you.
Watch the FREE video lectures to see how the course is structured and delivered!
Join the course risk-free thanks to the 30-day no questions asked money-back guarantee! If you decide it's not for you, just ask for a refund.
I'm Mark and I will be your instructor. I have worked at companies like IBM, Morgan Stanley, and Siemens, so believe me, I know what skills these companies need! I'm a self-taught software developer, who will teach you how to use Excel like a pro, but we will not stop there! I'll also teach you how to write clean and professional VBA code to automate Excel tasks! And on top of that, you'll also learn the SQL programming language, so by the end of the course, you'll know how to work with an actual database!
This course is made up of 3 different courses, and packed with over 40 hours of video lectures.
*** UPDATE! Google Sheets course is being added to this course! ***
1. EXCEL
The first part is dealing with Excel itself. It takes you from the VERYÂ BASICS to EXPERT level. If you already have some Excel knowledge, you can skip the introductory parts!
By the end of this part you will use Excel confidently, and be able to handle advanced tasks. You will learn the ins and outs of functions, formulas, charts, pivot tables, conditional formatting and a lot more.
At the end of this part we will have a live project also.
2. VBA
The VBA sections of this course will enhance your Microsoft Excel knowledge even further and will introduce you to programming. VBA stands for Visual Basic for Applications. Excel VBA is Microsoft's programming language for Excel. It is used to automate tasks and perform several other functions beyond creating and organizing spreadsheets.
In the VBA sections of this course you will learn for example
Subroutines, variables, data types
Core VBA programming concepts
VBA functions and more challenging concepts
Macros, recordings and enhancing them
Debugging and error handling
Essential VBA operations
Events
Managing your VBA code
Classes and Object-based programming
3. SQL
In this part of the course you will learn how to work with a database and execute SQL statements within Excel.
In the SQL part of the course you will:
learn SQL and how to set up your database
learn about data types
learn basic operations
learn how to set up VBA for SQL
learn how to query data
learn about basic statements
learn how to work with a table
learn about joins
learn about SQL functions and security
So what are you waiting for? Enroll now and become an EXCEL expert!
4. Google Sheets
This part of the course is currently being created! New lessons are added on a weekly basis!
The Google Sheets sections start from the very beginning, assuming that the learner is an absolute beginner. If you have some knowledge of Google Sheets, you can skip the introductory parts.
Who this course is for:
- Complete beginners
- Anyone who already knows a little bit about Excel
- Anyone who wants to deepen their Excel knowledge
- Office workers, data analysts
Hello!
Thank you for visiting our course page.
Do you want to become the go-to person at your company for Microsoft Excel problems? Do you want to nail your next job interview? Or just want a new skill? If yes, then this course is for you.
Watch the FREE video lectures to see how the course is structured and delivered!
Join the course risk-free thanks to the 30-day no questions asked money-back guarantee! If you decide it's not for you, just ask for a refund.
I'm Mark and I will be your instructor. I have worked at companies like IBM, Morgan Stanley, and Siemens, so believe me, I know what skills these companies need! I'm a self-taught software developer, who will teach you how to use Excel like a pro, but we will not stop there! I'll also teach you how to write clean and professional VBA code to automate Excel tasks! And on top of that, you'll also learn the SQL programming language, so by the end of the course, you'll know how to work with an actual database!
This course is made up of 3 different courses, and packed with over 40 hours of video lectures.
*** UPDATE! Google Sheets course is being added to this course! ***
1. EXCEL
The first part is dealing with Excel itself. It takes you from the VERYÂ BASICS to EXPERT level. If you already have some Excel knowledge, you can skip the introductory parts!
By the end of this part you will use Excel confidently, and be able to handle advanced tasks. You will learn the ins and outs of functions, formulas, charts, pivot tables, conditional formatting and a lot more.
At the end of this part we will have a live project also.
2. VBA
The VBA sections of this course will enhance your Microsoft Excel knowledge even further and will introduce you to programming. VBA stands for Visual Basic for Applications. Excel VBA is Microsoft's programming language for Excel. It is used to automate tasks and perform several other functions beyond creating and organizing spreadsheets.
In the VBA sections of this course you will learn for example
Subroutines, variables, data types
Core VBA programming concepts
VBA functions and more challenging concepts
Macros, recordings and enhancing them
Debugging and error handling
Essential VBA operations
Events
Managing your VBA code
Classes and Object-based programming
3. SQL
In this part of the course you will learn how to work with a database and execute SQL statements within Excel.
In the SQL part of the course you will:
learn SQL and how to set up your database
learn about data types
learn basic operations
learn how to set up VBA for SQL
learn how to query data
learn about basic statements
learn how to work with a table
learn about joins
learn about SQL functions and security
So what are you waiting for? Enroll now and become an EXCEL expert!
4. Google Sheets
This part of the course is currently being created! New lessons are added on a weekly basis!
The Google Sheets sections start from the very beginning, assuming that the learner is an absolute beginner. If you have some knowledge of Google Sheets, you can skip the introductory parts.
Who this course is for:
- Complete beginners
- Anyone who already knows a little bit about Excel
- Anyone who wants to deepen their Excel knowledge
- Office workers, data analysts
User Reviews
Rating
average 0
Focused display
Category
Mark Lengyel
Instructor's CoursesMark Lengyel is a self-taught Programmer, currently working as a Senior Software Developer at Siemens. He has been programming since 2013 and has experience in Reporting Automation and Web Development as well. He has also been the co-founder and Lead Backend Developer (Laravel) at TM Sonic. Mark's main experties lie in PHP and C#, however, he also has vast experience with VBA and VBScript.As a busy programmer, always looking for new challenges, the little free-time he has left after a long day of coding is devoted to his family.
Udemy
View courses UdemyStudents take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
- language english
- Training sessions 538
- duration 47:35:28
- English subtitles has
- Release Date 2024/03/11
