[Tutorialsplanet.NET] Udemy - Microsoft Excel - Excel from Beginner to Advanced
大小
6.74 GB
文件数
431
Info Hash:
96B476F40E0BA5C812601CA47772CFD54340ADEA
收录时间
2025-12-17 05:18:50
更新时间
2025-12-17 00:01:49
文件列表 (431)
1. Microsoft Excel 101 Course Introduction/1. Ask Questions.mp4
71.32 MB
1. Microsoft Excel 101 Course Introduction/1. Ask Questions.vtt
6.06 KB
1. Microsoft Excel 101 Course Introduction/2. Course Exercise Files.mp4
60.33 MB
1. Microsoft Excel 101 Course Introduction/2. Course Exercise Files.vtt
4.48 KB
1. Microsoft Excel 101 Course Introduction/2.1 MonthlyBudget-01.xlsx.xlsx
14.28 KB
1. Microsoft Excel 101 Course Introduction/2.10 MonthlyBudget-SUMFunction-01.xlsx.xlsx
13.77 KB
1. Microsoft Excel 101 Course Introduction/2.11 MonthlyBudget-MIN-MAXFunctions-01.xlsx.xlsx
14.03 KB
1. Microsoft Excel 101 Course Introduction/2.2 MonthlyBudget-Headers-01.xlsx.xlsx
13.68 KB
1. Microsoft Excel 101 Course Introduction/2.3 MonthlyBudget-AutoFill-01.xlsx.xlsx
13.82 KB
1. Microsoft Excel 101 Course Introduction/2.4 MonthlyBudget-BasicFormulas-01.xlsx.xlsx
13.68 KB
1. Microsoft Excel 101 Course Introduction/2.5 MonthlyBudget-AutoSUM-01.xlsx.xlsx
14.12 KB
1. Microsoft Excel 101 Course Introduction/2.6 MonthlyBudget-ReferenceTypes-01.xlsx.xlsx
13.67 KB
1. Microsoft Excel 101 Course Introduction/2.7 MonthlyBudget-AverageFunction-01.xlsx.xlsx
14.1 KB
1. Microsoft Excel 101 Course Introduction/2.8 MonthlyBudget-Template-01.xlsx.xlsx
14.53 KB
1. Microsoft Excel 101 Course Introduction/2.9 MonthlyBudget-Count-01.xlsx.xlsx
14.31 KB
1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.mp4
39.65 MB
1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.vtt
3.01 KB
10. Working with Excel Templates/1. Intro to Excel Templates.mp4
5.39 MB
10. Working with Excel Templates/1. Intro to Excel Templates.vtt
1.96 KB
10. Working with Excel Templates/2. Opening an Existing Template.mp4
22.27 MB
10. Working with Excel Templates/2. Opening an Existing Template.vtt
7.65 KB
10. Working with Excel Templates/3. Creating a Custom Template.mp4
16.34 MB
10. Working with Excel Templates/3. Creating a Custom Template.vtt
6.21 KB
11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.mp4
5.55 MB
11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.vtt
1.17 KB
12. Microsoft Excel 102 Course Introduction/1. Course Exercise Files - Download these First!.html
281 B
12. Microsoft Excel 102 Course Introduction/1.1 NorthwindDB.zip.zip
392.26 KB
12. Microsoft Excel 102 Course Introduction/1.2 Excel102Exercises.txt.txt
25.89 KB
12. Microsoft Excel 102 Course Introduction/1.3 Excel102Exercises.xlsx.xlsx
136.02 KB
13. Working with an Excel List/1. Understanding Excel List Structure.mp4
29.38 MB
13. Working with an Excel List/1. Understanding Excel List Structure.vtt
7.57 KB
13. Working with an Excel List/2. Sorting a List Using Single Level Sort.mp4
20.27 MB
13. Working with an Excel List/2. Sorting a List Using Single Level Sort.vtt
4.94 KB
13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.mp4
20.4 MB
13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.vtt
4.66 KB
13. Working with an Excel List/4. Using Custom Sorts in an Excel List.mp4
20.46 MB
13. Working with an Excel List/4. Using Custom Sorts in an Excel List.vtt
5.86 KB
13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.mp4
20.78 MB
13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.vtt
6.51 KB
13. Working with an Excel List/6. Creating Subtotals in a List.mp4
39.64 MB
13. Working with an Excel List/6. Creating Subtotals in a List.vtt
9.13 KB
13. Working with an Excel List/7. Format a List as a Table.mp4
42.73 MB
13. Working with an Excel List/7. Format a List as a Table.vtt
10.24 KB
13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.mp4
22.83 MB
13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.vtt
4.9 KB
13. Working with an Excel List/9. Removing Duplicates.mp4
22.86 MB
13. Working with an Excel List/9. Removing Duplicates.vtt
5.34 KB
14. Excel List Functions/1. Excel Function DSUM().mp4
39.62 MB
14. Excel List Functions/1. Excel Function DSUM().vtt
8.34 KB
14. Excel List Functions/2. Excel Function DAVERAGE().mp4
17.59 MB
14. Excel List Functions/2. Excel Function DAVERAGE().vtt
3.57 KB
14. Excel List Functions/3. Excel Function DCOUNT().mp4
19.3 MB
14. Excel List Functions/3. Excel Function DCOUNT().vtt
3.96 KB
14. Excel List Functions/4. Excel Function SUBTOTAL().mp4
40.63 MB
14. Excel List Functions/4. Excel Function SUBTOTAL().vtt
8.25 KB
15. Excel Data Validation/1. Understanding the Need for Data Validation.mp4
22.72 MB
15. Excel Data Validation/1. Understanding the Need for Data Validation.vtt
6.66 KB
15. Excel Data Validation/2. Creating a Validation List.mp4
25.96 MB
15. Excel Data Validation/2. Creating a Validation List.vtt
7.18 KB
15. Excel Data Validation/3. Adding a Custom Validation Error.mp4
20.63 MB
15. Excel Data Validation/3. Adding a Custom Validation Error.vtt
5.71 KB
15. Excel Data Validation/4. Dynamic Formulas by Using Validation Techniques.mp4
22.5 MB
15. Excel Data Validation/4. Dynamic Formulas by Using Validation Techniques.vtt
5.37 KB
16. Importing and Exporting Data/1. Importing Data from Text Files.mp4
19.08 MB
16. Importing and Exporting Data/1. Importing Data from Text Files.vtt
7.34 KB
16. Importing and Exporting Data/2. Importing Data from Microsoft Access.mp4
16.91 MB
16. Importing and Exporting Data/2. Importing Data from Microsoft Access.vtt
5.51 KB
16. Importing and Exporting Data/3. Exporting Data to a Text File.mp4
22.48 MB
16. Importing and Exporting Data/3. Exporting Data to a Text File.vtt
5.51 KB
17. Excel PivotTables/1. Understanding Excel PivotTables.mp4
23.29 MB
17. Excel PivotTables/1. Understanding Excel PivotTables.vtt
4.77 KB
17. Excel PivotTables/2. Creating an Excel PivotTable.mp4
30 MB
17. Excel PivotTables/2. Creating an Excel PivotTable.vtt
8.26 KB
17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.mp4
26.56 MB
17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.vtt
8.95 KB
17. Excel PivotTables/4. Grouping PivotTable Data.mp4
17.15 MB
17. Excel PivotTables/4. Grouping PivotTable Data.vtt
17.17 MB
17. Excel PivotTables/5. Formatting PivotTable Data.mp4
19.51 MB
17. Excel PivotTables/5. Formatting PivotTable Data.vtt
6.24 KB
17. Excel PivotTables/6. Drilling Down into PivotTable Data.mp4
21.08 MB
17. Excel PivotTables/6. Drilling Down into PivotTable Data.vtt
4.43 KB
17. Excel PivotTables/7. Creating PivotCharts.mp4
22.53 MB
17. Excel PivotTables/7. Creating PivotCharts.vtt
6.04 KB
17. Excel PivotTables/8. Filtering PivotTable Data.mp4
17.17 MB
17. Excel PivotTables/8. Filtering PivotTable Data.vtt
5.1 KB
17. Excel PivotTables/9. Filtering with the Slicer Tool.mp4
18.07 MB
17. Excel PivotTables/9. Filtering with the Slicer Tool.vtt
4.47 KB
18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.mp4
32.62 MB
18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.vtt
5.86 KB
18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.mp4
8.08 MB
18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.vtt
3.06 KB
18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.mp4
45.84 MB
18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.vtt
8.41 KB
18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.mp4
20.42 MB
18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.vtt
5.06 KB
18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.mp4
24.02 MB
18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.vtt
4.86 KB
18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.mp4
35.88 MB
18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.vtt
8.99 KB
19. Working with Large Sets of Excel Data/1. Using the Freeze Panes Tool.mp4
22.4 MB
19. Working with Large Sets of Excel Data/1. Using the Freeze Panes Tool.vtt
4.98 KB
19. Working with Large Sets of Excel Data/2. Grouping Data (Columns andor Rows).mp4
27.54 MB
19. Working with Large Sets of Excel Data/2. Grouping Data (Columns andor Rows).vtt
5.4 KB
19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.mp4
40.97 MB
19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.vtt
10.07 KB
19. Working with Large Sets of Excel Data/4. Linking Worksheets (3D Formulas).mp4
11.98 MB
19. Working with Large Sets of Excel Data/4. Linking Worksheets (3D Formulas).vtt
4.91 KB
19. Working with Large Sets of Excel Data/5. Consolidating Data from Multiple Worksheets.mp4
18.14 MB
19. Working with Large Sets of Excel Data/5. Consolidating Data from Multiple Worksheets.vtt
6.93 KB
2. Microsoft Excel Fundamentals/1. Launching Excel.mp4
33.7 MB
2. Microsoft Excel Fundamentals/1. Launching Excel.vtt
2.51 KB
2. Microsoft Excel Fundamentals/10. Excel Fundamentals Quiz.html
167 B
2. Microsoft Excel Fundamentals/2. Microsoft Excel Startup Screen.mp4
62.58 MB
2. Microsoft Excel Fundamentals/2. Microsoft Excel Startup Screen.vtt
4.31 KB
2. Microsoft Excel Fundamentals/3. Introduction to the Excel Interface.mp4
116.39 MB
2. Microsoft Excel Fundamentals/3. Introduction to the Excel Interface.vtt
10.21 KB
2. Microsoft Excel Fundamentals/4. Customizing the Excel Quick Access Toolbar.mp4
55.14 MB
2. Microsoft Excel Fundamentals/4. Customizing the Excel Quick Access Toolbar.vtt
4.03 KB
2. Microsoft Excel Fundamentals/5. More on the Excel Interface.mp4
54.7 MB
2. Microsoft Excel Fundamentals/5. More on the Excel Interface.vtt
5.08 KB
2. Microsoft Excel Fundamentals/6. Understanding the Structure of an Excel Workbook.mp4
78.53 MB
2. Microsoft Excel Fundamentals/6. Understanding the Structure of an Excel Workbook.vtt
5.41 KB
2. Microsoft Excel Fundamentals/7. Saving an Excel Document.mp4
74.77 MB
2. Microsoft Excel Fundamentals/7. Saving an Excel Document.vtt
5.5 KB
2. Microsoft Excel Fundamentals/8. Opening an Existing Excel Document.mp4
29.18 MB
2. Microsoft Excel Fundamentals/8. Opening an Existing Excel Document.vtt
2.19 KB
2. Microsoft Excel Fundamentals/9. Common Excel Shortcut Keys.mp4
49.18 MB
2. Microsoft Excel Fundamentals/9. Common Excel Shortcut Keys.vtt
3.6 KB
2. Microsoft Excel Fundamentals/9.1 CommonExcelWindowsShortcuts-01.pdf.pdf
142.71 KB
20. Congratulations! You're an Intermediate Excel User/1. Congratulations!.mp4
8.64 MB
20. Congratulations! You're an Intermediate Excel User/1. Congratulations!.vtt
828 B
21. Microsoft Excel 103 Course Introduction/1. Course Excerise Files - Download this Excel File First!.html
387 B
21. Microsoft Excel 103 Course Introduction/1.1 Excel103-AdvancedExercises.xlsx.xlsx
62.98 KB
22. Working with Excel's Conditional Functions/1. Working with Excel Name Ranges.mp4
22.31 MB
22. Working with Excel's Conditional Functions/1. Working with Excel Name Ranges.vtt
6.55 KB
22. Working with Excel's Conditional Functions/2. Using Excel's IF() Function.mp4
26.93 MB
22. Working with Excel's Conditional Functions/2. Using Excel's IF() Function.vtt
7.97 KB
22. Working with Excel's Conditional Functions/3. Nesting Functions.mp4
34.94 MB
22. Working with Excel's Conditional Functions/3. Nesting Functions.vtt
9.3 KB
22. Working with Excel's Conditional Functions/4. Using Excel's COUNTIF() Function.mp4
19.11 MB
22. Working with Excel's Conditional Functions/4. Using Excel's COUNTIF() Function.vtt
4.89 KB
22. Working with Excel's Conditional Functions/5. Using Excel's SUMIF() Function.mp4
29.18 MB
22. Working with Excel's Conditional Functions/5. Using Excel's SUMIF() Function.vtt
7.34 KB
22. Working with Excel's Conditional Functions/6. Using Excel's IFERROR() Function.mp4
23 MB
22. Working with Excel's Conditional Functions/6. Using Excel's IFERROR() Function.vtt
7.59 KB
23. Working with Excel's Lookup Functions/1. Using Excel's VLOOKUP() Function.mp4
35.73 MB
23. Working with Excel's Lookup Functions/1. Using Excel's VLOOKUP() Function.vtt
9.92 KB
23. Working with Excel's Lookup Functions/2. Using Excel's HLOOKUP() Function.mp4
17.73 MB
23. Working with Excel's Lookup Functions/2. Using Excel's HLOOKUP() Function.vtt
5.31 KB
23. Working with Excel's Lookup Functions/3. Using Excel's INDEX() and MATCH() Functions.mp4
63.96 MB
23. Working with Excel's Lookup Functions/3. Using Excel's INDEX() and MATCH() Functions.vtt
16.99 KB
24. Working with Excel's Text Based Functions/1. Using Excel's LEFT(), RIGHT() and MID() Functions.mp4
30.36 MB
24. Working with Excel's Text Based Functions/1. Using Excel's LEFT(), RIGHT() and MID() Functions.vtt
8.01 KB
24. Working with Excel's Text Based Functions/2. Using Excel's LEN() Function.mp4
37.15 MB
24. Working with Excel's Text Based Functions/2. Using Excel's LEN() Function.vtt
7.86 KB
24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.mp4
41.86 MB
24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.vtt
15.78 KB
24. Working with Excel's Text Based Functions/4. Using Excel's CONCATENATE() Function.mp4
11.86 MB
24. Working with Excel's Text Based Functions/4. Using Excel's CONCATENATE() Function.vtt
3.79 KB
25. Auditing an Excel Worksheet/1. Tracing Precendents in Excel Formulas.mp4
19.62 MB
25. Auditing an Excel Worksheet/1. Tracing Precendents in Excel Formulas.vtt
5.16 KB
25. Auditing an Excel Worksheet/2. Tracing Dependents in Excel Formulas.mp4
14.13 MB
25. Auditing an Excel Worksheet/2. Tracing Dependents in Excel Formulas.vtt
3.52 KB
25. Auditing an Excel Worksheet/3. Working with the Watch Window.mp4
15.25 MB
25. Auditing an Excel Worksheet/3. Working with the Watch Window.vtt
5.27 KB
25. Auditing an Excel Worksheet/4. Showing Formulas.mp4
12.91 MB
25. Auditing an Excel Worksheet/4. Showing Formulas.vtt
3.85 KB
26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.mp4
39.54 MB
26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.vtt
10.22 KB
26. Protecting Excel Worksheets and Workbooks/2. Protecting the Structure of a Workbook.mp4
12.35 MB
26. Protecting Excel Worksheets and Workbooks/2. Protecting the Structure of a Workbook.vtt
5.09 KB
26. Protecting Excel Worksheets and Workbooks/3. Adding a Workbook Password.mp4
14.33 MB
26. Protecting Excel Worksheets and Workbooks/3. Adding a Workbook Password.vtt
3.97 KB
27. Mastering Excel's What If Tools/1. Working with Excel's Goal Seek Tool.mp4
23.93 MB
27. Mastering Excel's What If Tools/1. Working with Excel's Goal Seek Tool.vtt
10.14 KB
27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.mp4
188.78 MB
27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.vtt
14.42 KB
27. Mastering Excel's What If Tools/3. Building Effective Data Tables in Excel.mp4
19.38 MB
27. Mastering Excel's What If Tools/3. Building Effective Data Tables in Excel.vtt
7.22 KB
27. Mastering Excel's What If Tools/4. Creating Scenarios in Excel.mp4
35.53 MB
27. Mastering Excel's What If Tools/4. Creating Scenarios in Excel.vtt
10.02 KB
28. Automating Repetitive Tasks in Excel with Macros/1. Understanding Excel Macros.mp4
22.97 MB
28. Automating Repetitive Tasks in Excel with Macros/1. Understanding Excel Macros.vtt
4.78 KB
28. Automating Repetitive Tasks in Excel with Macros/2. Activating the Developer Tab in Excel.mp4
10.33 MB
28. Automating Repetitive Tasks in Excel with Macros/2. Activating the Developer Tab in Excel.vtt
1.97 KB
28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.mp4
46.39 MB
28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.vtt
10.26 KB
28. Automating Repetitive Tasks in Excel with Macros/4. Editing a Macro with VBA.mp4
25.39 MB
28. Automating Repetitive Tasks in Excel with Macros/4. Editing a Macro with VBA.vtt
6.98 KB
28. Automating Repetitive Tasks in Excel with Macros/5. Creating Buttons to Run Macros.mp4
19.76 MB
28. Automating Repetitive Tasks in Excel with Macros/5. Creating Buttons to Run Macros.vtt
4.16 KB
29. Congratulations!/1. Congratulations on Competing the Microsoft Excel 103.mp4
3.4 MB
29. Congratulations!/1. Congratulations on Competing the Microsoft Excel 103.vtt
1.42 KB
3. Entering and Editing Text and Formulas/1. Entering Text to Create Spreadsheet Titles.mp4
148.09 MB
3. Entering and Editing Text and Formulas/1. Entering Text to Create Spreadsheet Titles.vtt
11.67 KB
3. Entering and Editing Text and Formulas/2. Working with Numeric Data in Excel.mp4
150.64 MB
3. Entering and Editing Text and Formulas/2. Working with Numeric Data in Excel.vtt
10.74 KB
3. Entering and Editing Text and Formulas/3. Entering Date Values in Excel.mp4
150.69 MB
3. Entering and Editing Text and Formulas/3. Entering Date Values in Excel.vtt
11.74 KB
3. Entering and Editing Text and Formulas/4. Working with Cell References.mp4
101.61 MB
3. Entering and Editing Text and Formulas/4. Working with Cell References.vtt
7.6 KB
3. Entering and Editing Text and Formulas/5. Creating Basic Formulas in Excel.mp4
146.33 MB
3. Entering and Editing Text and Formulas/5. Creating Basic Formulas in Excel.vtt
12.02 KB
3. Entering and Editing Text and Formulas/6. Relative Versus Absolute Cell References in Formulas.mp4
212.69 MB
3. Entering and Editing Text and Formulas/6. Relative Versus Absolute Cell References in Formulas.vtt
15.36 KB
3. Entering and Editing Text and Formulas/7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4
173.33 MB
3. Entering and Editing Text and Formulas/7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).vtt
13.34 KB
3. Entering and Editing Text and Formulas/7.1 OrderOfOperation-01.xlsx.xlsx
9.25 KB
3. Entering and Editing Text and Formulas/8. Entering and Editing Text and Formulas Quiz.html
167 B
30. Microsoft Excel Macros and VBA Course Introduction/1. Welcome to the Course.mp4
32.2 MB
30. Microsoft Excel Macros and VBA Course Introduction/1. Welcome to the Course.vtt
7.83 KB
30. Microsoft Excel Macros and VBA Course Introduction/2. Understanding the Why and How Behind Excel Macros.mp4
14.87 MB
30. Microsoft Excel Macros and VBA Course Introduction/2. Understanding the Why and How Behind Excel Macros.vtt
7.02 KB
30. Microsoft Excel Macros and VBA Course Introduction/3. Course Exercise Files - Download these First!.html
387 B
30. Microsoft Excel Macros and VBA Course Introduction/3.1 CleaningUpData.xlsx.xlsx
20.76 KB
30. Microsoft Excel Macros and VBA Course Introduction/3.2 SortingRecords.xlsm.xlsm
21.77 KB
30. Microsoft Excel Macros and VBA Course Introduction/3.3 SortingRecords.xlsx.xlsx
16.46 KB
30. Microsoft Excel Macros and VBA Course Introduction/3.4 AutomateFormulas.xlsx.xlsx
18.89 KB
30. Microsoft Excel Macros and VBA Course Introduction/3.5 QuarterlyReportForm-01.xlsm.xlsm
29.71 KB
30. Microsoft Excel Macros and VBA Course Introduction/3.6 InsertingAndFormattingText.xlsx.xlsx
17.38 KB
30. Microsoft Excel Macros and VBA Course Introduction/3.7 QuarterlyReport.xlsm.xlsm
26.49 KB
30. Microsoft Excel Macros and VBA Course Introduction/3.8 AutomateSumFunction.xlsx.xlsx
19.83 KB
31. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 Inserting and Formatting Text.mp4
13.09 MB
31. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 Inserting and Formatting Text.vtt
2.57 KB
31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.mp4
49.21 MB
31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.vtt
10.1 KB
31. Project #1 Using Excel's Macro Recorder Tool/2.1 InsertingAndFormattingText.xlsx.xlsx
17.38 KB
31. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.mp4
8.58 MB
31. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.vtt
3.67 KB
31. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 Running a Macro with a Button.mp4
21.78 MB
31. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 Running a Macro with a Button.vtt
4.91 KB
31. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 Opps! I Need to Edit My Macro.mp4
27.86 MB
31. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 Opps! I Need to Edit My Macro.vtt
5.6 KB
31. Project #1 Using Excel's Macro Recorder Tool/6. Practical Uses of Excel Macros.mp4
18.54 MB
31. Project #1 Using Excel's Macro Recorder Tool/6. Practical Uses of Excel Macros.vtt
2.96 KB
32. Excel VBA Concepts/1. Excel VBA Concepts.mp4
22.16 MB
32. Excel VBA Concepts/1. Excel VBA Concepts.vtt
4.38 KB
32. Excel VBA Concepts/2. The Visual Basic Editor (VBE).mp4
9.42 MB
32. Excel VBA Concepts/2. The Visual Basic Editor (VBE).vtt
4.51 KB
32. Excel VBA Concepts/3. Excel VBA Modules.mp4
5.39 MB
32. Excel VBA Concepts/3. Excel VBA Modules.vtt
2.35 KB
32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.mp4
43.02 MB
32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.vtt
9.7 KB
32. Excel VBA Concepts/5. Adding Code to a VBA Procedure.mp4
23.19 MB
32. Excel VBA Concepts/5. Adding Code to a VBA Procedure.vtt
4.77 KB
32. Excel VBA Concepts/6. Understanding Excel VBA Variables.mp4
37.36 MB
32. Excel VBA Concepts/6. Understanding Excel VBA Variables.vtt
8.19 KB
32. Excel VBA Concepts/7. Building Logic with an IF Statement.mp4
35.38 MB
32. Excel VBA Concepts/7. Building Logic with an IF Statement.vtt
7.41 KB
32. Excel VBA Concepts/8. Working with Excel VBA Loops to Repeat Blocks of Code.mp4
27.66 MB
32. Excel VBA Concepts/8. Working with Excel VBA Loops to Repeat Blocks of Code.vtt
12.13 KB
33. Project #2 Moving Beyond the Basics and into VBA/1. Introduction to Project #2 Interacting with the User.mp4
18.14 MB
33. Project #2 Moving Beyond the Basics and into VBA/1. Introduction to Project #2 Interacting with the User.vtt
3.78 KB
33. Project #2 Moving Beyond the Basics and into VBA/2. Project #2 Breaking Down the VBA Code.mp4
11.98 MB
33. Project #2 Moving Beyond the Basics and into VBA/2. Project #2 Breaking Down the VBA Code.vtt
4.34 KB
33. Project #2 Moving Beyond the Basics and into VBA/2.1 SortingRecords.xlsm.xlsm
16.71 KB
33. Project #2 Moving Beyond the Basics and into VBA/3. Project #2 Prompting the User for Information.mp4
20.58 MB
33. Project #2 Moving Beyond the Basics and into VBA/3. Project #2 Prompting the User for Information.vtt
8.55 KB
33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.mp4
38.86 MB
33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.vtt
8.39 KB
33. Project #2 Moving Beyond the Basics and into VBA/5. Project #2 Building Logic into Your Macros.mp4
14.76 MB
33. Project #2 Moving Beyond the Basics and into VBA/5. Project #2 Building Logic into Your Macros.vtt
5.43 KB
33. Project #2 Moving Beyond the Basics and into VBA/6. Project #2 Alerting the User of Errors.mp4
33.72 MB
33. Project #2 Moving Beyond the Basics and into VBA/6. Project #2 Alerting the User of Errors.vtt
12.53 KB
33. Project #2 Moving Beyond the Basics and into VBA/7. Other Practical Uses of Message and Input Boxes.mp4
24.42 MB
33. Project #2 Moving Beyond the Basics and into VBA/7. Other Practical Uses of Message and Input Boxes.vtt
4.35 KB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/1. Introduction to Project #3 Cleaning Up and Formatting Data.mp4
10.72 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/1. Introduction to Project #3 Cleaning Up and Formatting Data.vtt
4.24 KB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/2. Project #3 Preparing to the Use the Macro Recorder.mp4
9.51 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/2. Project #3 Preparing to the Use the Macro Recorder.vtt
3.86 KB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/3. Project #3 Inserting the Headers.mp4
22.12 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/3. Project #3 Inserting the Headers.vtt
5.09 KB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/4. Project #3 Formatting the Headers.mp4
7.47 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/4. Project #3 Formatting the Headers.vtt
3.12 KB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/5. Project #3 Putting it all Together with a Little VBA.mp4
35.83 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/5. Project #3 Putting it all Together with a Little VBA.vtt
13.3 KB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/6. Running the Loop.mp4
18.93 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/6. Running the Loop.vtt
3.94 KB
35. Project #4 Using VBA to Automate Excel Formulas/1. Introduction to Project #4 Automate Excel Formulas.mp4
7.47 MB
35. Project #4 Using VBA to Automate Excel Formulas/1. Introduction to Project #4 Automate Excel Formulas.vtt
2.73 KB
35. Project #4 Using VBA to Automate Excel Formulas/2. Project #4 Automate the SUM() Function through Code.mp4
25.55 MB
35. Project #4 Using VBA to Automate Excel Formulas/2. Project #4 Automate the SUM() Function through Code.vtt
9.68 KB
35. Project #4 Using VBA to Automate Excel Formulas/2.1 AutomateSumFunction.xlsx.xlsx
19.83 KB
35. Project #4 Using VBA to Automate Excel Formulas/3. Continue Automate SUM Function.mp4
17.55 MB
35. Project #4 Using VBA to Automate Excel Formulas/3. Continue Automate SUM Function.vtt
7.1 KB
35. Project #4 Using VBA to Automate Excel Formulas/4. Test the SUM Function.mp4
12.37 MB
35. Project #4 Using VBA to Automate Excel Formulas/4. Test the SUM Function.vtt
4.89 KB
35. Project #4 Using VBA to Automate Excel Formulas/5. Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4
20.07 MB
35. Project #4 Using VBA to Automate Excel Formulas/5. Project #4 Loop the SUM() Function Over Multiple Worksheets.vtt
7.84 KB
36. Project #5 Bringing it All Together and a Weekly Report/1. Introduction to Project #5 Creating the Final Report.mp4
11 MB
36. Project #5 Bringing it All Together and a Weekly Report/1. Introduction to Project #5 Creating the Final Report.vtt
4.4 KB
36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.mp4
47.28 MB
36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.vtt
10.82 KB
36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.mp4
54.75 MB
36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.vtt
11.71 KB
36. Project #5 Bringing it All Together and a Weekly Report/4. Project #5 - Running the Final Report Procedure.mp4
19.95 MB
36. Project #5 Bringing it All Together and a Weekly Report/4. Project #5 - Running the Final Report Procedure.vtt
4.02 KB
37. Project #6 Working with Excel VBA User Forms/1. Introduction to Project #6 Working with Excel VBA User Forms.mp4
8.79 MB
37. Project #6 Working with Excel VBA User Forms/1. Introduction to Project #6 Working with Excel VBA User Forms.vtt
4.07 KB
37. Project #6 Working with Excel VBA User Forms/1.1 QuarterlyReportForm-01.xlsm.xlsm
24.47 KB
37. Project #6 Working with Excel VBA User Forms/2. Project #6 Creating an Excel User Form.mp4
15.05 MB
37. Project #6 Working with Excel VBA User Forms/2. Project #6 Creating an Excel User Form.vtt
7.07 KB
37. Project #6 Working with Excel VBA User Forms/3. Project #6 Adding Controls to the Form.mp4
11.65 MB
37. Project #6 Working with Excel VBA User Forms/3. Project #6 Adding Controls to the Form.vtt
4.96 KB
37. Project #6 Working with Excel VBA User Forms/4. Project #6 Adding VBA Code to the Initialize Event.mp4
24.36 MB
37. Project #6 Working with Excel VBA User Forms/4. Project #6 Adding VBA Code to the Initialize Event.vtt
10.81 KB
37. Project #6 Working with Excel VBA User Forms/5. Project #6 Adding VBA Code to the ComboBox Change Event.mp4
24.22 MB
37. Project #6 Working with Excel VBA User Forms/5. Project #6 Adding VBA Code to the ComboBox Change Event.vtt
5.58 KB
37. Project #6 Working with Excel VBA User Forms/6. Project #6 Adding VBA Code to the Add Worksheet Button.mp4
10.11 MB
37. Project #6 Working with Excel VBA User Forms/6. Project #6 Adding VBA Code to the Add Worksheet Button.vtt
4.59 KB
37. Project #6 Working with Excel VBA User Forms/7. Change Worksheet Name.mp4
11.7 MB
37. Project #6 Working with Excel VBA User Forms/7. Change Worksheet Name.vtt
5.08 KB
37. Project #6 Working with Excel VBA User Forms/8. Project #6 Adding VBA Code to the Create Report Button.mp4
27.42 MB
37. Project #6 Working with Excel VBA User Forms/8. Project #6 Adding VBA Code to the Create Report Button.vtt
11.32 KB
37. Project #6 Working with Excel VBA User Forms/9. Project #6 Showing the Form.mp4
12.39 MB
37. Project #6 Working with Excel VBA User Forms/9. Project #6 Showing the Form.vtt
4.86 KB
38. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.mp4
26.03 MB
38. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.vtt
3.71 KB
38. Project #7 Importing Data from Text Files/1.1 Nov2015Sales.txt.txt
1.26 KB
38. Project #7 Importing Data from Text Files/1.2 Feb2015Sales.txt.txt
1.16 KB
38. Project #7 Importing Data from Text Files/1.3 Jan2015Sales.txt.txt
1.25 KB
38. Project #7 Importing Data from Text Files/1.4 April2015Sales.txt.txt
1.77 KB
38. Project #7 Importing Data from Text Files/1.5 Dec2015Sales.txt.txt
1.13 KB
38. Project #7 Importing Data from Text Files/1.6 Mar2015Sales.txt.txt
1.2 KB
38. Project #7 Importing Data from Text Files/1.7 May2015Sales.txt.txt
1.24 KB
38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.mp4
42.26 MB
38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.vtt
8.39 KB
38. Project #7 Importing Data from Text Files/3. Project #7 Get Data from Text File.mp4
32.64 MB
38. Project #7 Importing Data from Text Files/3. Project #7 Get Data from Text File.vtt
7.43 KB
38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4
65.62 MB
38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.vtt
11.32 KB
38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.mp4
56.87 MB
38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.vtt
10.09 KB
38. Project #7 Importing Data from Text Files/6. Project #7 Adding a New Sheet for Imported Data.mp4
23.83 MB
38. Project #7 Importing Data from Text Files/6. Project #7 Adding a New Sheet for Imported Data.vtt
3.08 KB
38. Project #7 Importing Data from Text Files/7. Project #7 Clear the Clipboard.mp4
32.06 MB
38. Project #7 Importing Data from Text Files/7. Project #7 Clear the Clipboard.vtt
4.85 KB
38. Project #7 Importing Data from Text Files/8. Project #7 Working with the ScreenUpdating Property.mp4
34.5 MB
38. Project #7 Importing Data from Text Files/8. Project #7 Working with the ScreenUpdating Property.vtt
4.52 KB
38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.mp4
61.05 MB
38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.vtt
9.92 KB
39. Course Wrap Up/1. Congratulations! You're an Excel MacroVBA Master.mp4
18.09 MB
39. Course Wrap Up/1. Congratulations! You're an Excel MacroVBA Master.vtt
1.16 KB
39. Course Wrap Up/2. BONUS! - Special Offer! Discount on Any of my Courses!.html
2.05 KB
4. Working with Basic Excel Functions/1. The structure of an Excel Function.mp4
161.97 MB
4. Working with Basic Excel Functions/1. The structure of an Excel Function.vtt
13.74 KB
4. Working with Basic Excel Functions/1.1 EXCEL FUNCTIONS.pptx.pptx
87.12 KB
4. Working with Basic Excel Functions/10. Basic Excel Functions Quiz.html
167 B
4. Working with Basic Excel Functions/2. Working with the SUM() Function.mp4
113.75 MB
4. Working with Basic Excel Functions/2. Working with the SUM() Function.vtt
9.54 KB
4. Working with Basic Excel Functions/3. Working with the MIN() and MAX() Functions.mp4
101.81 MB
4. Working with Basic Excel Functions/3. Working with the MIN() and MAX() Functions.vtt
8.93 KB
4. Working with Basic Excel Functions/4. Working with the AVERAGE() Function.mp4
47.21 MB
4. Working with Basic Excel Functions/4. Working with the AVERAGE() Function.vtt
3.99 KB
4. Working with Basic Excel Functions/5. Working with the COUNT() Function.mp4
47.56 MB
4. Working with Basic Excel Functions/5. Working with the COUNT() Function.vtt
4.01 KB
4. Working with Basic Excel Functions/6. Adjacent Cells Error in Excel Calculations.mp4
60.08 MB
4. Working with Basic Excel Functions/6. Adjacent Cells Error in Excel Calculations.vtt
5.49 KB
4. Working with Basic Excel Functions/7. Using the AutoSum Command.mp4
111.96 MB
4. Working with Basic Excel Functions/7. Using the AutoSum Command.vtt
9.73 KB
4. Working with Basic Excel Functions/8. Excel's AutoSum Shortcut Key.mp4
36.81 MB
4. Working with Basic Excel Functions/8. Excel's AutoSum Shortcut Key.vtt
3.05 KB
4. Working with Basic Excel Functions/9. Using the AutoFill Command to Copy Formulas.mp4
73.02 MB
4. Working with Basic Excel Functions/9. Using the AutoFill Command to Copy Formulas.vtt
6.13 KB
5. Modifying an Excel Worksheet/1. Moving and Copying Data in an Excel Worksheet.mp4
111.67 MB
5. Modifying an Excel Worksheet/1. Moving and Copying Data in an Excel Worksheet.vtt
8.66 KB
5. Modifying an Excel Worksheet/2. Inserting and Deleting Rows and Columns.mp4
119.78 MB
5. Modifying an Excel Worksheet/2. Inserting and Deleting Rows and Columns.vtt
10.09 KB
5. Modifying an Excel Worksheet/3. Changing the Width and Height of Cells.mp4
84.72 MB
5. Modifying an Excel Worksheet/3. Changing the Width and Height of Cells.vtt
7.05 KB
5. Modifying an Excel Worksheet/4. Hiding and Unhiding Excel Rows and Columns.mp4
85.98 MB
5. Modifying an Excel Worksheet/4. Hiding and Unhiding Excel Rows and Columns.vtt
7.48 KB
5. Modifying an Excel Worksheet/5. Renaming an Excel Worksheet.mp4
46.67 MB
5. Modifying an Excel Worksheet/5. Renaming an Excel Worksheet.vtt
4.15 KB
5. Modifying an Excel Worksheet/6. Deleting an Excel Worksheet.mp4
78.94 MB
5. Modifying an Excel Worksheet/6. Deleting an Excel Worksheet.vtt
6.41 KB
5. Modifying an Excel Worksheet/7. Moving and Copying an Excel Worksheet.mp4
89.61 MB
5. Modifying an Excel Worksheet/7. Moving and Copying an Excel Worksheet.vtt
7.18 KB
5. Modifying an Excel Worksheet/8. Modifying Worksheets Quiz.html
167 B
6. Formatting Data in an Excel Worksheet/1. Working with Font Formatting Commands.mp4
11.78 MB
6. Formatting Data in an Excel Worksheet/1. Working with Font Formatting Commands.vtt
5.46 KB
6. Formatting Data in an Excel Worksheet/10. Formatting Data Quiz.html
167 B
6. Formatting Data in an Excel Worksheet/2. Changing the Background Color of a Cell.mp4
8.64 MB
6. Formatting Data in an Excel Worksheet/2. Changing the Background Color of a Cell.vtt
4.05 KB
6. Formatting Data in an Excel Worksheet/3. Adding Borders to Cells.mp4
10.49 MB
6. Formatting Data in an Excel Worksheet/3. Adding Borders to Cells.vtt
4.71 KB
6. Formatting Data in an Excel Worksheet/4. Formatting Data as Currency Values.mp4
16.46 MB
6. Formatting Data in an Excel Worksheet/4. Formatting Data as Currency Values.vtt
7.08 KB
6. Formatting Data in an Excel Worksheet/5. Formatting Percentages.mp4
7.03 MB
6. Formatting Data in an Excel Worksheet/5. Formatting Percentages.vtt
2.96 KB
6. Formatting Data in an Excel Worksheet/6. Using Excel's Format Painter.mp4
8.96 MB
6. Formatting Data in an Excel Worksheet/6. Using Excel's Format Painter.vtt
3.77 KB
6. Formatting Data in an Excel Worksheet/7. Creating Styles to Format Data.mp4
29.07 MB
6. Formatting Data in an Excel Worksheet/7. Creating Styles to Format Data.vtt
11 KB
6. Formatting Data in an Excel Worksheet/8. Merging and Centering Cells.mp4
9.87 MB
6. Formatting Data in an Excel Worksheet/8. Merging and Centering Cells.vtt
3.38 KB
6. Formatting Data in an Excel Worksheet/9. Using Conditional Formatting.mp4
15.27 MB
6. Formatting Data in an Excel Worksheet/9. Using Conditional Formatting.vtt
5.85 KB
7. Inserting Images and Shapes into an Excel Worksheet/1. Inserting Images.mp4
14.2 MB
7. Inserting Images and Shapes into an Excel Worksheet/1. Inserting Images.vtt
5.96 KB
7. Inserting Images and Shapes into an Excel Worksheet/2. Inserting Excel Shapes.mp4
13.25 MB
7. Inserting Images and Shapes into an Excel Worksheet/2. Inserting Excel Shapes.vtt
5.15 KB
7. Inserting Images and Shapes into an Excel Worksheet/3. Formatting Excel Shapes.mp4
15.35 MB
7. Inserting Images and Shapes into an Excel Worksheet/3. Formatting Excel Shapes.vtt
6.76 KB
7. Inserting Images and Shapes into an Excel Worksheet/4. Working with Excel SmartArt.mp4
19.24 MB
7. Inserting Images and Shapes into an Excel Worksheet/4. Working with Excel SmartArt.vtt
8.5 KB
8. Creating Basic Charts in Excel/1. Creating an Excel Column Chart.mp4
16.96 MB
8. Creating Basic Charts in Excel/1. Creating an Excel Column Chart.vtt
6.52 KB
8. Creating Basic Charts in Excel/2. Working with the Excel Chart Ribbon.mp4
15.69 MB
8. Creating Basic Charts in Excel/2. Working with the Excel Chart Ribbon.vtt
7.08 KB
8. Creating Basic Charts in Excel/3. Adding and Modifying Data on an Excel Chart.mp4
12.3 MB
8. Creating Basic Charts in Excel/3. Adding and Modifying Data on an Excel Chart.vtt
4.32 KB
8. Creating Basic Charts in Excel/4. Formatting an Excel Chart.mp4
13.81 MB
8. Creating Basic Charts in Excel/4. Formatting an Excel Chart.vtt
6.67 KB
8. Creating Basic Charts in Excel/5. Moving a Chart to another Worksheet.mp4
7.43 MB
8. Creating Basic Charts in Excel/5. Moving a Chart to another Worksheet.vtt
3.3 KB
8. Creating Basic Charts in Excel/6. Working with Excel Pie Charts.mp4
16.89 MB
8. Creating Basic Charts in Excel/6. Working with Excel Pie Charts.vtt
6.93 KB
8. Creating Basic Charts in Excel/7. Working with Excel Charts Quiz.html
167 B
9. Printing an Excel Worksheet/1. Viewing your Document in Print Preview.mp4
5.92 MB
9. Printing an Excel Worksheet/1. Viewing your Document in Print Preview.vtt
3.02 KB
9. Printing an Excel Worksheet/2. Changing the Margins, Scaling and Orientation.mp4
21.01 MB
9. Printing an Excel Worksheet/2. Changing the Margins, Scaling and Orientation.vtt
12.33 KB
9. Printing an Excel Worksheet/3. Working with Page Layout View.mp4
13.95 MB
9. Printing an Excel Worksheet/3. Working with Page Layout View.vtt
5.6 KB
9. Printing an Excel Worksheet/4. Adding Header and Footer Content.mp4
14.38 MB
9. Printing an Excel Worksheet/4. Adding Header and Footer Content.vtt
6.32 KB
9. Printing an Excel Worksheet/5. Printing a Specific Range of Cells.mp4
10.52 MB
9. Printing an Excel Worksheet/5. Printing a Specific Range of Cells.vtt
4.01 KB
9. Printing an Excel Worksheet/6. Printing and Excel Worksheet Quiz.html
167 B
[Tutorialsplanet.NET].url
128 B