Download Udemy - Microsoft Excel - Excel from Beginner to Advanced [TP] Torrent

Torrent Contents Size: 6.74 GB

Udemy - Microsoft Excel - Excel from Beginner to Advanced [TP]

▼ show more 416 files

1. Microsoft Excel 101 Course Introduction

1. Ask Questions.mp4	MP4	71.32 MB
1. Ask Questions.vtt	VTT	6.06 KB
2. Course Exercise Files.mp4	MP4	60.33 MB
2. Course Exercise Files.vtt	VTT	4.48 KB
2.1 MonthlyBudget-01.xlsx.xlsx	XLSX	14.28 KB
2.10 MonthlyBudget-SUMFunction-01.xlsx.xlsx	XLSX	13.77 KB
2.11 MonthlyBudget-MIN-MAXFunctions-01.xlsx.xlsx	XLSX	14.03 KB
2.2 MonthlyBudget-Headers-01.xlsx.xlsx	XLSX	13.68 KB
2.3 MonthlyBudget-AutoFill-01.xlsx.xlsx	XLSX	13.82 KB
2.4 MonthlyBudget-BasicFormulas-01.xlsx.xlsx	XLSX	13.68 KB
2.5 MonthlyBudget-AutoSUM-01.xlsx.xlsx	XLSX	14.12 KB
2.6 MonthlyBudget-ReferenceTypes-01.xlsx.xlsx	XLSX	13.67 KB
2.7 MonthlyBudget-AverageFunction-01.xlsx.xlsx	XLSX	14.1 KB
2.8 MonthlyBudget-Template-01.xlsx.xlsx	XLSX	14.53 KB
2.9 MonthlyBudget-Count-01.xlsx.xlsx	XLSX	14.31 KB
3. Certificate of Completion.mp4	MP4	39.65 MB
3. Certificate of Completion.vtt	VTT	3.01 KB

10. Working with Excel Templates

1. Intro to Excel Templates.mp4	MP4	5.39 MB
1. Intro to Excel Templates.vtt	VTT	1.96 KB
2. Opening an Existing Template.mp4	MP4	22.27 MB
2. Opening an Existing Template.vtt	VTT	7.65 KB
3. Creating a Custom Template.mp4	MP4	16.34 MB
3. Creating a Custom Template.vtt	VTT	6.21 KB

11. Congratulations! You've Built a Solid Microsoft Excel Foundation

	1. Congratulations!.mp4	MP4	5.55 MB
	1. Congratulations!.vtt	VTT	1.17 KB

12. Microsoft Excel 102 Course Introduction

1. Course Exercise Files - Download these First!.html	HTML	281 B
1.1 NorthwindDB.zip.zip	ZIP	392.26 KB
1.2 Excel102Exercises.txt.txt	TXT	25.89 KB
1.3 Excel102Exercises.xlsx.xlsx	XLSX	136.02 KB

13. Working with an Excel List

1. Understanding Excel List Structure.mp4	MP4	29.38 MB
1. Understanding Excel List Structure.vtt	VTT	7.57 KB
2. Sorting a List Using Single Level Sort.mp4	MP4	20.27 MB
2. Sorting a List Using Single Level Sort.vtt	VTT	4.94 KB
3. Sorting a List Using Multi-Level Sorts.mp4	MP4	20.4 MB
3. Sorting a List Using Multi-Level Sorts.vtt	VTT	4.66 KB
4. Using Custom Sorts in an Excel List.mp4	MP4	20.46 MB
4. Using Custom Sorts in an Excel List.vtt	VTT	5.86 KB
5. Filter an Excel List Using the AutoFilter Tool.mp4	MP4	20.78 MB
5. Filter an Excel List Using the AutoFilter Tool.vtt	VTT	6.51 KB
6. Creating Subtotals in a List.mp4	MP4	39.64 MB
6. Creating Subtotals in a List.vtt	VTT	9.13 KB
7. Format a List as a Table.mp4	MP4	42.73 MB
7. Format a List as a Table.vtt	VTT	10.24 KB
8. Using Conditional Formatting to Find Duplicates.mp4	MP4	22.83 MB
8. Using Conditional Formatting to Find Duplicates.vtt	VTT	4.9 KB
9. Removing Duplicates.mp4	MP4	22.86 MB
9. Removing Duplicates.vtt	VTT	5.34 KB

14. Excel List Functions

1. Excel Function DSUM().mp4	MP4	39.62 MB
1. Excel Function DSUM().vtt	VTT	8.34 KB
2. Excel Function DAVERAGE().mp4	MP4	17.59 MB
2. Excel Function DAVERAGE().vtt	VTT	3.57 KB
3. Excel Function DCOUNT().mp4	MP4	19.3 MB
3. Excel Function DCOUNT().vtt	VTT	3.96 KB
4. Excel Function SUBTOTAL().mp4	MP4	40.63 MB
4. Excel Function SUBTOTAL().vtt	VTT	8.25 KB

15. Excel Data Validation

1. Understanding the Need for Data Validation.mp4	MP4	22.72 MB
1. Understanding the Need for Data Validation.vtt	VTT	6.66 KB
2. Creating a Validation List.mp4	MP4	25.96 MB
2. Creating a Validation List.vtt	VTT	7.18 KB
3. Adding a Custom Validation Error.mp4	MP4	20.63 MB
3. Adding a Custom Validation Error.vtt	VTT	5.71 KB
4. Dynamic Formulas by Using Validation Techniques.mp4	MP4	22.5 MB
4. Dynamic Formulas by Using Validation Techniques.vtt	VTT	5.37 KB

16. Importing and Exporting Data

1. Importing Data from Text Files.mp4	MP4	19.08 MB
1. Importing Data from Text Files.vtt	VTT	7.34 KB
2. Importing Data from Microsoft Access.mp4	MP4	16.91 MB
2. Importing Data from Microsoft Access.vtt	VTT	5.51 KB
3. Exporting Data to a Text File.mp4	MP4	22.48 MB
3. Exporting Data to a Text File.vtt	VTT	5.51 KB

17. Excel PivotTables

1. Understanding Excel PivotTables.mp4	MP4	23.29 MB
1. Understanding Excel PivotTables.vtt	VTT	4.77 KB
2. Creating an Excel PivotTable.mp4	MP4	30 MB
2. Creating an Excel PivotTable.vtt	VTT	8.26 KB
3. Modifying Excel PivotTable Calculations.mp4	MP4	26.56 MB
3. Modifying Excel PivotTable Calculations.vtt	VTT	8.95 KB
4. Grouping PivotTable Data.mp4	MP4	17.15 MB
4. Grouping PivotTable Data.vtt	VTT	17.17 MB
5. Formatting PivotTable Data.mp4	MP4	19.51 MB
5. Formatting PivotTable Data.vtt	VTT	6.24 KB
6. Drilling Down into PivotTable Data.mp4	MP4	21.08 MB
6. Drilling Down into PivotTable Data.vtt	VTT	4.43 KB
7. Creating PivotCharts.mp4	MP4	22.53 MB
7. Creating PivotCharts.vtt	VTT	6.04 KB
8. Filtering PivotTable Data.mp4	MP4	17.17 MB
8. Filtering PivotTable Data.vtt	VTT	5.1 KB
9. Filtering with the Slicer Tool.mp4	MP4	18.07 MB
9. Filtering with the Slicer Tool.vtt	VTT	4.47 KB

18. Working with Excel's PowerPivot Tools

1. Why PowerPivot.mp4	MP4	32.62 MB
1. Why PowerPivot.vtt	VTT	5.86 KB
2. Activating the Excel PowerPivot AddIn.mp4	MP4	8.08 MB
2. Activating the Excel PowerPivot AddIn.vtt	VTT	3.06 KB
3. Creating Data Models with PowerPivot.mp4	MP4	45.84 MB
3. Creating Data Models with PowerPivot.vtt	VTT	8.41 KB
4. Creating PivotTables based on Data Models.mp4	MP4	20.42 MB
4. Creating PivotTables based on Data Models.vtt	VTT	5.06 KB
5. PowerPivot Calculated Fields.mp4	MP4	24.02 MB
5. PowerPivot Calculated Fields.vtt	VTT	4.86 KB
6. PowerPivot KPIs.mp4	MP4	35.88 MB
6. PowerPivot KPIs.vtt	VTT	8.99 KB

19. Working with Large Sets of Excel Data

1. Using the Freeze Panes Tool.mp4	MP4	22.4 MB
1. Using the Freeze Panes Tool.vtt	VTT	4.98 KB
2. Grouping Data (Columns andor Rows).mp4	MP4	27.54 MB
2. Grouping Data (Columns andor Rows).vtt	VTT	5.4 KB
3. Print Options for Large Sets of Data.mp4	MP4	40.97 MB
3. Print Options for Large Sets of Data.vtt	VTT	10.07 KB
4. Linking Worksheets (3D Formulas).mp4	MP4	11.98 MB
4. Linking Worksheets (3D Formulas).vtt	VTT	4.91 KB
5. Consolidating Data from Multiple Worksheets.mp4	MP4	18.14 MB
5. Consolidating Data from Multiple Worksheets.vtt	VTT	6.93 KB

2. Microsoft Excel Fundamentals

1. Launching Excel.mp4	MP4	33.7 MB
1. Launching Excel.vtt	VTT	2.51 KB
10. Excel Fundamentals Quiz.html	HTML	167 B
2. Microsoft Excel Startup Screen.mp4	MP4	62.58 MB
2. Microsoft Excel Startup Screen.vtt	VTT	4.31 KB
3. Introduction to the Excel Interface.mp4	MP4	116.39 MB
3. Introduction to the Excel Interface.vtt	VTT	10.21 KB
4. Customizing the Excel Quick Access Toolbar.mp4	MP4	55.14 MB
4. Customizing the Excel Quick Access Toolbar.vtt	VTT	4.03 KB
5. More on the Excel Interface.mp4	MP4	54.7 MB
5. More on the Excel Interface.vtt	VTT	5.08 KB
6. Understanding the Structure of an Excel Workbook.mp4	MP4	78.53 MB
6. Understanding the Structure of an Excel Workbook.vtt	VTT	5.41 KB
7. Saving an Excel Document.mp4	MP4	74.77 MB
7. Saving an Excel Document.vtt	VTT	5.5 KB
8. Opening an Existing Excel Document.mp4	MP4	29.18 MB
8. Opening an Existing Excel Document.vtt	VTT	2.19 KB
9. Common Excel Shortcut Keys.mp4	MP4	49.18 MB
9. Common Excel Shortcut Keys.vtt	VTT	3.6 KB
9.1 CommonExcelWindowsShortcuts-01.pdf.pdf	PDF	142.71 KB

20. Congratulations! You're an Intermediate Excel User

	1. Congratulations!.mp4	MP4	8.64 MB
	1. Congratulations!.vtt	VTT	828 B

21. Microsoft Excel 103 Course Introduction

	1. Course Excerise Files - Download this Excel File First!.html	HTML	387 B
	1.1 Excel103-AdvancedExercises.xlsx.xlsx	XLSX	62.98 KB

22. Working with Excel's Conditional Functions

1. Working with Excel Name Ranges.mp4	MP4	22.31 MB
1. Working with Excel Name Ranges.vtt	VTT	6.55 KB
2. Using Excel's IF() Function.mp4	MP4	26.93 MB
2. Using Excel's IF() Function.vtt	VTT	7.97 KB
3. Nesting Functions.mp4	MP4	34.94 MB
3. Nesting Functions.vtt	VTT	9.3 KB
4. Using Excel's COUNTIF() Function.mp4	MP4	19.11 MB
4. Using Excel's COUNTIF() Function.vtt	VTT	4.89 KB
5. Using Excel's SUMIF() Function.mp4	MP4	29.18 MB
5. Using Excel's SUMIF() Function.vtt	VTT	7.34 KB
6. Using Excel's IFERROR() Function.mp4	MP4	23 MB
6. Using Excel's IFERROR() Function.vtt	VTT	7.59 KB

23. Working with Excel's Lookup Functions

1. Using Excel's VLOOKUP() Function.mp4	MP4	35.73 MB
1. Using Excel's VLOOKUP() Function.vtt	VTT	9.92 KB
2. Using Excel's HLOOKUP() Function.mp4	MP4	17.73 MB
2. Using Excel's HLOOKUP() Function.vtt	VTT	5.31 KB
3. Using Excel's INDEX() and MATCH() Functions.mp4	MP4	63.96 MB
3. Using Excel's INDEX() and MATCH() Functions.vtt	VTT	16.99 KB

24. Working with Excel's Text Based Functions

1. Using Excel's LEFT(), RIGHT() and MID() Functions.mp4	MP4	30.36 MB
1. Using Excel's LEFT(), RIGHT() and MID() Functions.vtt	VTT	8.01 KB
2. Using Excel's LEN() Function.mp4	MP4	37.15 MB
2. Using Excel's LEN() Function.vtt	VTT	7.86 KB
3. Using Excel's SEARCH() Function.mp4	MP4	41.86 MB
3. Using Excel's SEARCH() Function.vtt	VTT	15.78 KB
4. Using Excel's CONCATENATE() Function.mp4	MP4	11.86 MB
4. Using Excel's CONCATENATE() Function.vtt	VTT	3.79 KB

25. Auditing an Excel Worksheet

1. Tracing Precendents in Excel Formulas.mp4	MP4	19.62 MB
1. Tracing Precendents in Excel Formulas.vtt	VTT	5.16 KB
2. Tracing Dependents in Excel Formulas.mp4	MP4	14.13 MB
2. Tracing Dependents in Excel Formulas.vtt	VTT	3.52 KB
3. Working with the Watch Window.mp4	MP4	15.25 MB
3. Working with the Watch Window.vtt	VTT	5.27 KB
4. Showing Formulas.mp4	MP4	12.91 MB
4. Showing Formulas.vtt	VTT	3.85 KB

26. Protecting Excel Worksheets and Workbooks

1. Protecting Specific Cells in a Worksheet.mp4	MP4	39.54 MB
1. Protecting Specific Cells in a Worksheet.vtt	VTT	10.22 KB
2. Protecting the Structure of a Workbook.mp4	MP4	12.35 MB
2. Protecting the Structure of a Workbook.vtt	VTT	5.09 KB
3. Adding a Workbook Password.mp4	MP4	14.33 MB
3. Adding a Workbook Password.vtt	VTT	3.97 KB

27. Mastering Excel's What If Tools

1. Working with Excel's Goal Seek Tool.mp4	MP4	23.93 MB
1. Working with Excel's Goal Seek Tool.vtt	VTT	10.14 KB
2. Working with Excel's Solver Tool.mp4	MP4	188.78 MB
2. Working with Excel's Solver Tool.vtt	VTT	14.42 KB
3. Building Effective Data Tables in Excel.mp4	MP4	19.38 MB
3. Building Effective Data Tables in Excel.vtt	VTT	7.22 KB
4. Creating Scenarios in Excel.mp4	MP4	35.53 MB
4. Creating Scenarios in Excel.vtt	VTT	10.02 KB

28. Automating Repetitive Tasks in Excel with Macros

1. Understanding Excel Macros.mp4	MP4	22.97 MB
1. Understanding Excel Macros.vtt	VTT	4.78 KB
2. Activating the Developer Tab in Excel.mp4	MP4	10.33 MB
2. Activating the Developer Tab in Excel.vtt	VTT	1.97 KB
3. Creating a Macro with the Macro Recorder.mp4	MP4	46.39 MB
3. Creating a Macro with the Macro Recorder.vtt	VTT	10.26 KB
4. Editing a Macro with VBA.mp4	MP4	25.39 MB
4. Editing a Macro with VBA.vtt	VTT	6.98 KB
5. Creating Buttons to Run Macros.mp4	MP4	19.76 MB
5. Creating Buttons to Run Macros.vtt	VTT	4.16 KB

29. Congratulations!

	1. Congratulations on Competing the Microsoft Excel 103.mp4	MP4	3.4 MB
	1. Congratulations on Competing the Microsoft Excel 103.vtt	VTT	1.42 KB

3. Entering and Editing Text and Formulas

1. Entering Text to Create Spreadsheet Titles.mp4	MP4	148.09 MB
1. Entering Text to Create Spreadsheet Titles.vtt	VTT	11.67 KB
2. Working with Numeric Data in Excel.mp4	MP4	150.64 MB
2. Working with Numeric Data in Excel.vtt	VTT	10.74 KB
3. Entering Date Values in Excel.mp4	MP4	150.69 MB
3. Entering Date Values in Excel.vtt	VTT	11.74 KB
4. Working with Cell References.mp4	MP4	101.61 MB
4. Working with Cell References.vtt	VTT	7.6 KB
5. Creating Basic Formulas in Excel.mp4	MP4	146.33 MB
5. Creating Basic Formulas in Excel.vtt	VTT	12.02 KB
6. Relative Versus Absolute Cell References in Formulas.mp4	MP4	212.69 MB
6. Relative Versus Absolute Cell References in Formulas.vtt	VTT	15.36 KB
7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4	MP4	173.33 MB
7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).vtt	VTT	13.34 KB
7.1 OrderOfOperation-01.xlsx.xlsx	XLSX	9.25 KB
8. Entering and Editing Text and Formulas Quiz.html	HTML	167 B

30. Microsoft Excel Macros and VBA Course Introduction

1. Welcome to the Course.mp4	MP4	32.2 MB
1. Welcome to the Course.vtt	VTT	7.83 KB
2. Understanding the Why and How Behind Excel Macros.mp4	MP4	14.87 MB
2. Understanding the Why and How Behind Excel Macros.vtt	VTT	7.02 KB
3. Course Exercise Files - Download these First!.html	HTML	387 B
3.1 CleaningUpData.xlsx.xlsx	XLSX	20.76 KB
3.2 SortingRecords.xlsm.xlsm	XLSM	21.77 KB
3.3 SortingRecords.xlsx.xlsx	XLSX	16.46 KB
3.4 AutomateFormulas.xlsx.xlsx	XLSX	18.89 KB
3.5 QuarterlyReportForm-01.xlsm.xlsm	XLSM	29.71 KB
3.6 InsertingAndFormattingText.xlsx.xlsx	XLSX	17.38 KB
3.7 QuarterlyReport.xlsm.xlsm	XLSM	26.49 KB
3.8 AutomateSumFunction.xlsx.xlsx	XLSX	19.83 KB

31. Project #1 Using Excel's Macro Recorder Tool

1. Introduction to Project #1 Inserting and Formatting Text.mp4	MP4	13.09 MB
1. Introduction to Project #1 Inserting and Formatting Text.vtt	VTT	2.57 KB
2. Project #1 Start Recording!.mp4	MP4	49.21 MB
2. Project #1 Start Recording!.vtt	VTT	10.1 KB
2.1 InsertingAndFormattingText.xlsx.xlsx	XLSX	17.38 KB
3. Running A Macro.mp4	MP4	8.58 MB
3. Running A Macro.vtt	VTT	3.67 KB
4. Project #1 Running a Macro with a Button.mp4	MP4	21.78 MB
4. Project #1 Running a Macro with a Button.vtt	VTT	4.91 KB
5. Project #1 Opps! I Need to Edit My Macro.mp4	MP4	27.86 MB
5. Project #1 Opps! I Need to Edit My Macro.vtt	VTT	5.6 KB
6. Practical Uses of Excel Macros.mp4	MP4	18.54 MB
6. Practical Uses of Excel Macros.vtt	VTT	2.96 KB

32. Excel VBA Concepts

1. Excel VBA Concepts.mp4	MP4	22.16 MB
1. Excel VBA Concepts.vtt	VTT	4.38 KB
2. The Visual Basic Editor (VBE).mp4	MP4	9.42 MB
2. The Visual Basic Editor (VBE).vtt	VTT	4.51 KB
3. Excel VBA Modules.mp4	MP4	5.39 MB
3. Excel VBA Modules.vtt	VTT	2.35 KB
4. Creating an Excel VBA Procedure.mp4	MP4	43.02 MB
4. Creating an Excel VBA Procedure.vtt	VTT	9.7 KB
5. Adding Code to a VBA Procedure.mp4	MP4	23.19 MB
5. Adding Code to a VBA Procedure.vtt	VTT	4.77 KB
6. Understanding Excel VBA Variables.mp4	MP4	37.36 MB
6. Understanding Excel VBA Variables.vtt	VTT	8.19 KB
7. Building Logic with an IF Statement.mp4	MP4	35.38 MB
7. Building Logic with an IF Statement.vtt	VTT	7.41 KB
8. Working with Excel VBA Loops to Repeat Blocks of Code.mp4	MP4	27.66 MB
8. Working with Excel VBA Loops to Repeat Blocks of Code.vtt	VTT	12.13 KB

33. Project #2 Moving Beyond the Basics and into VBA

1. Introduction to Project #2 Interacting with the User.mp4	MP4	18.14 MB
1. Introduction to Project #2 Interacting with the User.vtt	VTT	3.78 KB
2. Project #2 Breaking Down the VBA Code.mp4	MP4	11.98 MB
2. Project #2 Breaking Down the VBA Code.vtt	VTT	4.34 KB
2.1 SortingRecords.xlsm.xlsm	XLSM	16.71 KB
3. Project #2 Prompting the User for Information.mp4	MP4	20.58 MB
3. Project #2 Prompting the User for Information.vtt	VTT	8.55 KB
4. Continue Excel VBA InputBox.mp4	MP4	38.86 MB
4. Continue Excel VBA InputBox.vtt	VTT	8.39 KB
5. Project #2 Building Logic into Your Macros.mp4	MP4	14.76 MB
5. Project #2 Building Logic into Your Macros.vtt	VTT	5.43 KB
6. Project #2 Alerting the User of Errors.mp4	MP4	33.72 MB
6. Project #2 Alerting the User of Errors.vtt	VTT	12.53 KB
7. Other Practical Uses of Message and Input Boxes.mp4	MP4	24.42 MB
7. Other Practical Uses of Message and Input Boxes.vtt	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	MP4	10.72 MB
1. Introduction to Project #3 Cleaning Up and Formatting Data.vtt	VTT	4.24 KB
2. Project #3 Preparing to the Use the Macro Recorder.mp4	MP4	9.51 MB
2. Project #3 Preparing to the Use the Macro Recorder.vtt	VTT	3.86 KB
3. Project #3 Inserting the Headers.mp4	MP4	22.12 MB
3. Project #3 Inserting the Headers.vtt	VTT	5.09 KB
4. Project #3 Formatting the Headers.mp4	MP4	7.47 MB
4. Project #3 Formatting the Headers.vtt	VTT	3.12 KB
5. Project #3 Putting it all Together with a Little VBA.mp4	MP4	35.83 MB
5. Project #3 Putting it all Together with a Little VBA.vtt	VTT	13.3 KB
6. Running the Loop.mp4	MP4	18.93 MB
6. Running the Loop.vtt	VTT	3.94 KB

35. Project #4 Using VBA to Automate Excel Formulas

1. Introduction to Project #4 Automate Excel Formulas.mp4	MP4	7.47 MB
1. Introduction to Project #4 Automate Excel Formulas.vtt	VTT	2.73 KB
2. Project #4 Automate the SUM() Function through Code.mp4	MP4	25.55 MB
2. Project #4 Automate the SUM() Function through Code.vtt	VTT	9.68 KB
2.1 AutomateSumFunction.xlsx.xlsx	XLSX	19.83 KB
3. Continue Automate SUM Function.mp4	MP4	17.55 MB
3. Continue Automate SUM Function.vtt	VTT	7.1 KB
4. Test the SUM Function.mp4	MP4	12.37 MB
4. Test the SUM Function.vtt	VTT	4.89 KB
5. Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4	MP4	20.07 MB
5. Project #4 Loop the SUM() Function Over Multiple Worksheets.vtt	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	MP4	11 MB
1. Introduction to Project #5 Creating the Final Report.vtt	VTT	4.4 KB
2. Project #5 Creating the Final Report Loop.mp4	MP4	47.28 MB
2. Project #5 Creating the Final Report Loop.vtt	VTT	10.82 KB
3. Project #5 - Copying and Pasting Data with VBA.mp4	MP4	54.75 MB
3. Project #5 - Copying and Pasting Data with VBA.vtt	VTT	11.71 KB
4. Project #5 - Running the Final Report Procedure.mp4	MP4	19.95 MB
4. Project #5 - Running the Final Report Procedure.vtt	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	MP4	8.79 MB
1. Introduction to Project #6 Working with Excel VBA User Forms.vtt	VTT	4.07 KB
1.1 QuarterlyReportForm-01.xlsm.xlsm	XLSM	24.47 KB
2. Project #6 Creating an Excel User Form.mp4	MP4	15.05 MB
2. Project #6 Creating an Excel User Form.vtt	VTT	7.07 KB
3. Project #6 Adding Controls to the Form.mp4	MP4	11.65 MB
3. Project #6 Adding Controls to the Form.vtt	VTT	4.96 KB
4. Project #6 Adding VBA Code to the Initialize Event.mp4	MP4	24.36 MB
4. Project #6 Adding VBA Code to the Initialize Event.vtt	VTT	10.81 KB
5. Project #6 Adding VBA Code to the ComboBox Change Event.mp4	MP4	24.22 MB
5. Project #6 Adding VBA Code to the ComboBox Change Event.vtt	VTT	5.58 KB
6. Project #6 Adding VBA Code to the Add Worksheet Button.mp4	MP4	10.11 MB
6. Project #6 Adding VBA Code to the Add Worksheet Button.vtt	VTT	4.59 KB
7. Change Worksheet Name.mp4	MP4	11.7 MB
7. Change Worksheet Name.vtt	VTT	5.08 KB
8. Project #6 Adding VBA Code to the Create Report Button.mp4	MP4	27.42 MB
8. Project #6 Adding VBA Code to the Create Report Button.vtt	VTT	11.32 KB
9. Project #6 Showing the Form.mp4	MP4	12.39 MB
9. Project #6 Showing the Form.vtt	VTT	4.86 KB

38. Project #7 Importing Data from Text Files

1. Project #7 Opening a Text File for Import.mp4	MP4	26.03 MB
1. Project #7 Opening a Text File for Import.vtt	VTT	3.71 KB
1.1 Nov2015Sales.txt.txt	TXT	1.26 KB
1.2 Feb2015Sales.txt.txt	TXT	1.16 KB
1.3 Jan2015Sales.txt.txt	TXT	1.25 KB
1.4 April2015Sales.txt.txt	TXT	1.77 KB
1.5 Dec2015Sales.txt.txt	TXT	1.13 KB
1.6 Mar2015Sales.txt.txt	TXT	1.2 KB
1.7 May2015Sales.txt.txt	TXT	1.24 KB
2. Project #7 Opening a Text File for Import.mp4	MP4	42.26 MB
2. Project #7 Opening a Text File for Import.vtt	VTT	8.39 KB
3. Project #7 Get Data from Text File.mp4	MP4	32.64 MB
3. Project #7 Get Data from Text File.vtt	VTT	7.43 KB
4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4	MP4	65.62 MB
4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.vtt	VTT	11.32 KB
5. Project #7 Creating a Loop to Read Each File.mp4	MP4	56.87 MB
5. Project #7 Creating a Loop to Read Each File.vtt	VTT	10.09 KB
6. Project #7 Adding a New Sheet for Imported Data.mp4	MP4	23.83 MB
6. Project #7 Adding a New Sheet for Imported Data.vtt	VTT	3.08 KB
7. Project #7 Clear the Clipboard.mp4	MP4	32.06 MB
7. Project #7 Clear the Clipboard.vtt	VTT	4.85 KB
8. Project #7 Working with the ScreenUpdating Property.mp4	MP4	34.5 MB
8. Project #7 Working with the ScreenUpdating Property.vtt	VTT	4.52 KB
9. Project #7 Creating Reusable Code with a VBA Function.mp4	MP4	61.05 MB
9. Project #7 Creating Reusable Code with a VBA Function.vtt	VTT	9.92 KB

39. Course Wrap Up

1. Congratulations! You're an Excel MacroVBA Master.mp4	MP4	18.09 MB
1. Congratulations! You're an Excel MacroVBA Master.vtt	VTT	1.16 KB
2. BONUS! - Special Offer! Discount on Any of my Courses!.html	HTML	2.05 KB

4. Working with Basic Excel Functions

1. The structure of an Excel Function.mp4	MP4	161.97 MB
1. The structure of an Excel Function.vtt	VTT	13.74 KB
1.1 EXCEL FUNCTIONS.pptx.pptx	PPTX	87.12 KB
10. Basic Excel Functions Quiz.html	HTML	167 B
2. Working with the SUM() Function.mp4	MP4	113.75 MB
2. Working with the SUM() Function.vtt	VTT	9.54 KB
3. Working with the MIN() and MAX() Functions.mp4	MP4	101.81 MB
3. Working with the MIN() and MAX() Functions.vtt	VTT	8.93 KB
4. Working with the AVERAGE() Function.mp4	MP4	47.21 MB
4. Working with the AVERAGE() Function.vtt	VTT	3.99 KB
5. Working with the COUNT() Function.mp4	MP4	47.56 MB
5. Working with the COUNT() Function.vtt	VTT	4.01 KB
6. Adjacent Cells Error in Excel Calculations.mp4	MP4	60.08 MB
6. Adjacent Cells Error in Excel Calculations.vtt	VTT	5.49 KB
7. Using the AutoSum Command.mp4	MP4	111.96 MB
7. Using the AutoSum Command.vtt	VTT	9.73 KB
8. Excel's AutoSum Shortcut Key.mp4	MP4	36.81 MB
8. Excel's AutoSum Shortcut Key.vtt	VTT	3.05 KB
9. Using the AutoFill Command to Copy Formulas.mp4	MP4	73.02 MB
9. Using the AutoFill Command to Copy Formulas.vtt	VTT	6.13 KB

5. Modifying an Excel Worksheet

1. Moving and Copying Data in an Excel Worksheet.mp4	MP4	111.67 MB
1. Moving and Copying Data in an Excel Worksheet.vtt	VTT	8.66 KB
2. Inserting and Deleting Rows and Columns.mp4	MP4	119.78 MB
2. Inserting and Deleting Rows and Columns.vtt	VTT	10.09 KB
3. Changing the Width and Height of Cells.mp4	MP4	84.72 MB
3. Changing the Width and Height of Cells.vtt	VTT	7.05 KB
4. Hiding and Unhiding Excel Rows and Columns.mp4	MP4	85.98 MB
4. Hiding and Unhiding Excel Rows and Columns.vtt	VTT	7.48 KB
5. Renaming an Excel Worksheet.mp4	MP4	46.67 MB
5. Renaming an Excel Worksheet.vtt	VTT	4.15 KB
6. Deleting an Excel Worksheet.mp4	MP4	78.94 MB
6. Deleting an Excel Worksheet.vtt	VTT	6.41 KB
7. Moving and Copying an Excel Worksheet.mp4	MP4	89.61 MB
7. Moving and Copying an Excel Worksheet.vtt	VTT	7.18 KB
8. Modifying Worksheets Quiz.html	HTML	167 B

6. Formatting Data in an Excel Worksheet

1. Working with Font Formatting Commands.mp4	MP4	11.78 MB
1. Working with Font Formatting Commands.vtt	VTT	5.46 KB
10. Formatting Data Quiz.html	HTML	167 B
2. Changing the Background Color of a Cell.mp4	MP4	8.64 MB
2. Changing the Background Color of a Cell.vtt	VTT	4.05 KB
3. Adding Borders to Cells.mp4	MP4	10.49 MB
3. Adding Borders to Cells.vtt	VTT	4.71 KB
4. Formatting Data as Currency Values.mp4	MP4	16.46 MB
4. Formatting Data as Currency Values.vtt	VTT	7.08 KB
5. Formatting Percentages.mp4	MP4	7.03 MB
5. Formatting Percentages.vtt	VTT	2.96 KB
6. Using Excel's Format Painter.mp4	MP4	8.96 MB
6. Using Excel's Format Painter.vtt	VTT	3.77 KB
7. Creating Styles to Format Data.mp4	MP4	29.07 MB
7. Creating Styles to Format Data.vtt	VTT	11 KB
8. Merging and Centering Cells.mp4	MP4	9.87 MB
8. Merging and Centering Cells.vtt	VTT	3.38 KB
9. Using Conditional Formatting.mp4	MP4	15.27 MB
9. Using Conditional Formatting.vtt	VTT	5.85 KB

7. Inserting Images and Shapes into an Excel Worksheet

1. Inserting Images.mp4	MP4	14.2 MB
1. Inserting Images.vtt	VTT	5.96 KB
2. Inserting Excel Shapes.mp4	MP4	13.25 MB
2. Inserting Excel Shapes.vtt	VTT	5.15 KB
3. Formatting Excel Shapes.mp4	MP4	15.35 MB
3. Formatting Excel Shapes.vtt	VTT	6.76 KB
4. Working with Excel SmartArt.mp4	MP4	19.24 MB
4. Working with Excel SmartArt.vtt	VTT	8.5 KB

8. Creating Basic Charts in Excel

1. Creating an Excel Column Chart.mp4	MP4	16.96 MB
1. Creating an Excel Column Chart.vtt	VTT	6.52 KB
2. Working with the Excel Chart Ribbon.mp4	MP4	15.69 MB
2. Working with the Excel Chart Ribbon.vtt	VTT	7.08 KB
3. Adding and Modifying Data on an Excel Chart.mp4	MP4	12.3 MB
3. Adding and Modifying Data on an Excel Chart.vtt	VTT	4.32 KB
4. Formatting an Excel Chart.mp4	MP4	13.81 MB
4. Formatting an Excel Chart.vtt	VTT	6.67 KB
5. Moving a Chart to another Worksheet.mp4	MP4	7.43 MB
5. Moving a Chart to another Worksheet.vtt	VTT	3.3 KB
6. Working with Excel Pie Charts.mp4	MP4	16.89 MB
6. Working with Excel Pie Charts.vtt	VTT	6.93 KB
7. Working with Excel Charts Quiz.html	HTML	167 B

9. Printing an Excel Worksheet

1. Viewing your Document in Print Preview.mp4	MP4	5.92 MB
1. Viewing your Document in Print Preview.vtt	VTT	3.02 KB
2. Changing the Margins, Scaling and Orientation.mp4	MP4	21.01 MB
2. Changing the Margins, Scaling and Orientation.vtt	VTT	12.33 KB
3. Working with Page Layout View.mp4	MP4	13.95 MB
3. Working with Page Layout View.vtt	VTT	5.6 KB
4. Adding Header and Footer Content.mp4	MP4	14.38 MB
4. Adding Header and Footer Content.vtt	VTT	6.32 KB
5. Printing a Specific Range of Cells.mp4	MP4	10.52 MB
5. Printing a Specific Range of Cells.vtt	VTT	4.01 KB
6. Printing and Excel Worksheet Quiz.html	HTML	167 B

[Tutorialsplanet.NET].url

URL

128 B

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Udemy - Microsoft Purview Data Loss Prevention Posted by freecoursewb in Other Posted in Other 9 1.9 GB 3 months ago freecoursewb	Size 1.9 GB	Files 11	Age 3 months ago	Seeds 9	Leechs 7	Source
Udemy - Microsoft Outlook and Microsoft Teams - 2 in 1 Bundle Posted by freecoursewb in Other Posted in Other 11 2.3 GB 3 months ago freecoursewb	Size 2.3 GB	Files 14	Age 3 months ago	Seeds 11	Leechs 7	Source
Udemy - Microsoft Excel Formulas and Functions - Learn Fast and Smart Posted by freecoursewb in Other Posted in Other 23 1.9 GB 3 months ago freecoursewb	Size 1.9 GB	Files 39	Age 3 months ago	Seeds 23	Leechs 5	Source
Udemy - AZ-900 - Microsoft Azure Fundamentals Exam 2026 Posted by freecoursewb in Other Posted in Other 21 491.7 MB 3 months ago freecoursewb	Size 491.7 MB	Files 8	Age 3 months ago	Seeds 21	Leechs 6	Source
Udemy - Microsoft Powerpoint Mastery Course Using Chatgpt Posted by freecoursewb in Other Posted in Other 13 581 MB 4 months ago freecoursewb	Size 581 MB	Files 13	Age 4 months ago	Seeds 13	Leechs 3	Source

Udemy - Microsoft Excel - Excel from Beginner to Advanced [TP]

Torrent Contents Size: 6.74 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags