FreeAllCourse Com Udemy Microsoft Excel from Beginner to Advanced

FreeAllCourse Com Udemy Microsoft Excel from Beginner to Advanced

Name	[FreeAllCourse.Com] Udemy - Microsoft Excel - Excel from Beginner to Advanced	DOWNLOAD Copy Link
Total Size	7.2 GB
Total Files	431
Hash	C907462F660499C1A5F2B5E0E7ACF001623E0630

/1. Microsoft Excel 101 Course Introduction/
1. Ask Questions.mp4	74.8 MB
1. Ask Questions.srt	6.6 KB
2. Course Exercise Files.mp4	63.3 MB
2. Course Exercise Files.srt	5.1 KB
2.1 MonthlyBudget-BasicFormulas-01.xlsx.xlsx	14.0 KB
2.10 MonthlyBudget-Count-01.xlsx.xlsx	14.6 KB
2.11 MonthlyBudget-ReferenceTypes-01.xlsx.xlsx	14.0 KB
2.2 MonthlyBudget-Headers-01.xlsx.xlsx	14.0 KB
2.3 MonthlyBudget-Template-01.xlsx.xlsx	14.9 KB
2.4 MonthlyBudget-SUMFunction-01.xlsx.xlsx	14.1 KB
2.5 MonthlyBudget-01.xlsx.xlsx	14.6 KB
2.6 MonthlyBudget-MIN-MAXFunctions-01.xlsx.xlsx	14.4 KB
2.7 MonthlyBudget-AutoSUM-01.xlsx.xlsx	14.5 KB
2.8 MonthlyBudget-AverageFunction-01.xlsx.xlsx	14.4 KB
2.9 MonthlyBudget-AutoFill-01.xlsx.xlsx	14.2 KB
3. Certificate of Completion.mp4	41.6 MB
3. Certificate of Completion.srt	3.6 KB
/10. Working with Excel Templates/
1. Intro to Excel Templates.mp4	5.6 MB
1. Intro to Excel Templates.srt	2.2 KB
2. Opening an Existing Template.mp4	23.4 MB
2. Opening an Existing Template.srt	8.8 KB
3. Creating a Custom Template.mp4	17.1 MB
3. Creating a Custom Template.srt	7.2 KB
/11. Congratulations! You've Built a Solid Microsoft Excel Foundation/
1. Congratulations!.mp4	5.8 MB
1. Congratulations!.srt	1.3 KB
/12. Microsoft Excel 102 Course Introduction/
1. Course Exercise Files - Download these First!.html	0.3 KB
1.1 Excel102Exercises.xlsx.xlsx	139.3 KB
1.2 Excel102Exercises.txt.txt	26.1 KB
1.3 NorthwindDB.zip.zip	401.7 KB
/13. Working with an Excel List/
1. Understanding Excel List Structure.mp4	30.8 MB
1. Understanding Excel List Structure.srt	8.7 KB
2. Sorting a List Using Single Level Sort.mp4	21.3 MB
2. Sorting a List Using Single Level Sort.srt	5.7 KB
3. Sorting a List Using Multi-Level Sorts.mp4	21.4 MB
3. Sorting a List Using Multi-Level Sorts.srt	5.4 KB
4. Using Custom Sorts in an Excel List.mp4	21.5 MB
4. Using Custom Sorts in an Excel List.srt	6.8 KB
5. Filter an Excel List Using the AutoFilter Tool.mp4	21.8 MB
5. Filter an Excel List Using the AutoFilter Tool.srt	7.5 KB
6. Creating Subtotals in a List.mp4	41.6 MB
6. Creating Subtotals in a List.srt	10.6 KB
7. Format a List as a Table.mp4	44.8 MB
7. Format a List as a Table.srt	11.9 KB
8. Using Conditional Formatting to Find Duplicates.mp4	24.0 MB
8. Using Conditional Formatting to Find Duplicates.srt	5.6 KB
9. Removing Duplicates.mp4	24.0 MB
9. Removing Duplicates.srt	6.2 KB
/14. Excel List Functions/
1. Excel Function DSUM().mp4	41.5 MB
1. Excel Function DSUM().srt	9.6 KB
2. Excel Function DAVERAGE().mp4	18.4 MB
2. Excel Function DAVERAGE().srt	4.1 KB
3. Excel Function DCOUNT().mp4	20.2 MB
3. Excel Function DCOUNT().srt	4.6 KB
4. Excel Function SUBTOTAL().mp4	42.6 MB
4. Excel Function SUBTOTAL().srt	9.5 KB
/15. Excel Data Validation/
1. Understanding the Need for Data Validation.mp4	23.8 MB
1. Understanding the Need for Data Validation.srt	7.6 KB
2. Creating a Validation List.mp4	27.2 MB
2. Creating a Validation List.srt	8.3 KB
3. Adding a Custom Validation Error.mp4	21.6 MB
3. Adding a Custom Validation Error.srt	6.5 KB
4. Dynamic Formulas by Using Validation Techniques.mp4	23.6 MB
4. Dynamic Formulas by Using Validation Techniques.srt	6.1 KB
/16. Importing and Exporting Data/
1. Importing Data from Text Files.mp4	20.0 MB
1. Importing Data from Text Files.srt	8.4 KB
2. Importing Data from Microsoft Access.mp4	17.7 MB
2. Importing Data from Microsoft Access.srt	6.3 KB
3. Exporting Data to a Text File.mp4	23.6 MB
3. Exporting Data to a Text File.srt	6.3 KB
/17. Excel PivotTables/
1. Understanding Excel PivotTables.mp4	24.4 MB
1. Understanding Excel PivotTables.srt	5.5 KB
2. Creating an Excel PivotTable.mp4	31.5 MB
2. Creating an Excel PivotTable.srt	9.5 KB
3. Modifying Excel PivotTable Calculations.mp4	27.8 MB
3. Modifying Excel PivotTable Calculations.srt	10.4 KB
4. Grouping PivotTable Data.mp4	18.0 MB
4. Grouping PivotTable Data.srt	7.3 KB
5. Formatting PivotTable Data.mp4	20.5 MB
5. Formatting PivotTable Data.srt	7.2 KB
6. Drilling Down into PivotTable Data.mp4	22.1 MB
6. Drilling Down into PivotTable Data.srt	5.0 KB
7. Creating PivotCharts.mp4	23.6 MB
7. Creating PivotCharts.srt	6.9 KB
8. Filtering PivotTable Data.mp4	18.0 MB
8. Filtering PivotTable Data.srt	5.9 KB
9. Filtering with the Slicer Tool.mp4	18.9 MB
9. Filtering with the Slicer Tool.srt	5.1 KB
/18. Working with Excel's PowerPivot Tools/
1. Why PowerPivot.mp4	34.2 MB
1. Why PowerPivot.srt	6.7 KB
2. Activating the Excel PowerPivot AddIn.mp4	8.5 MB
2. Activating the Excel PowerPivot AddIn.srt	3.5 KB
3. Creating Data Models with PowerPivot.mp4	48.1 MB
3. Creating Data Models with PowerPivot.srt	9.7 KB
4. Creating PivotTables based on Data Models.mp4	21.4 MB
4. Creating PivotTables based on Data Models.srt	5.8 KB
5. PowerPivot Calculated Fields.mp4	25.2 MB
5. PowerPivot Calculated Fields.srt	5.5 KB
6. PowerPivot KPIs.mp4	37.6 MB
6. PowerPivot KPIs.srt	10.4 KB
/19. Working with Large Sets of Excel Data/
1. Using the Freeze Panes Tool.mp4	23.5 MB
1. Using the Freeze Panes Tool.srt	5.7 KB
2. Grouping Data (Columns andor Rows).mp4	28.9 MB
2. Grouping Data (Columns andor Rows).srt	6.1 KB
3. Print Options for Large Sets of Data.mp4	43.0 MB
3. Print Options for Large Sets of Data.srt	11.6 KB
4. Linking Worksheets (3D Formulas).mp4	12.6 MB
4. Linking Worksheets (3D Formulas).srt	5.6 KB
5. Consolidating Data from Multiple Worksheets.mp4	19.0 MB
5. Consolidating Data from Multiple Worksheets.srt	8.0 KB
/2. Microsoft Excel Fundamentals/
1. Launching Excel.mp4	35.3 MB
1. Launching Excel.srt	2.8 KB
10. Excel Fundamentals Quiz.html	0.2 KB
2. Microsoft Excel Startup Screen.mp4	65.6 MB
2. Microsoft Excel Startup Screen.srt	4.8 KB
3. Introduction to the Excel Interface.mp4	122.0 MB
3. Introduction to the Excel Interface.srt	11.5 KB
4. Customizing the Excel Quick Access Toolbar.mp4	57.8 MB
4. Customizing the Excel Quick Access Toolbar.srt	4.4 KB
5. More on the Excel Interface.mp4	57.4 MB
5. More on the Excel Interface.srt	5.6 KB
6. Understanding the Structure of an Excel Workbook.mp4	82.3 MB
6. Understanding the Structure of an Excel Workbook.srt	6.2 KB
7. Saving an Excel Document.mp4	78.4 MB
7. Saving an Excel Document.srt	6.2 KB
8. Opening an Existing Excel Document.mp4	30.6 MB
8. Opening an Existing Excel Document.srt	2.5 KB
9. Common Excel Shortcut Keys.mp4	51.6 MB
9. Common Excel Shortcut Keys.srt	4.0 KB
9.1 CommonExcelWindowsShortcuts-01.pdf.pdf	146.1 KB
/20. Congratulations! You're an Intermediate Excel User/
1. Congratulations!.mp4	9.1 MB
1. Congratulations!.srt	0.9 KB
/21. Microsoft Excel 103 Course Introduction/
1. Course Excerise Files - Download this Excel File First!.html	0.4 KB
1.1 Excel103-AdvancedExercises.xlsx.xlsx	64.5 KB
/22. Working with Excel's Conditional Functions/
1. Working with Excel Name Ranges.mp4	23.4 MB
1. Working with Excel Name Ranges.srt	7.5 KB
2. Using Excel's IF() Function.mp4	28.2 MB
2. Using Excel's IF() Function.srt	9.2 KB
3. Nesting Functions.mp4	36.6 MB
3. Nesting Functions.srt	10.8 KB
4. Using Excel's COUNTIF() Function.mp4	20.0 MB
4. Using Excel's COUNTIF() Function.srt	5.6 KB
5. Using Excel's SUMIF() Function.mp4	30.6 MB
5. Using Excel's SUMIF() Function.srt	8.5 KB
6. Using Excel's IFERROR() Function.mp4	24.1 MB
6. Using Excel's IFERROR() Function.srt	8.7 KB
/23. Working with Excel's Lookup Functions/
1. Using Excel's VLOOKUP() Function.mp4	37.5 MB
1. Using Excel's VLOOKUP() Function.srt	11.5 KB
2. Using Excel's HLOOKUP() Function.mp4	18.6 MB
2. Using Excel's HLOOKUP() Function.srt	6.1 KB
3. Using Excel's INDEX() and MATCH() Functions.mp4	67.1 MB
3. Using Excel's INDEX() and MATCH() Functions.srt	19.7 KB
/24. Working with Excel's Text Based Functions/
1. Using Excel's LEFT(), RIGHT() and MID() Functions.mp4	31.8 MB
1. Using Excel's LEFT(), RIGHT() and MID() Functions.srt	9.3 KB
2. Using Excel's LEN() Function.mp4	39.0 MB
2. Using Excel's LEN() Function.srt	9.1 KB
3. Using Excel's SEARCH() Function.mp4	43.9 MB
3. Using Excel's SEARCH() Function.srt	18.3 KB
4. Using Excel's CONCATENATE() Function.mp4	12.4 MB
4. Using Excel's CONCATENATE() Function.srt	4.4 KB
/25. Auditing an Excel Worksheet/
1. Tracing Precendents in Excel Formulas.mp4	20.6 MB
1. Tracing Precendents in Excel Formulas.srt	6.0 KB
2. Tracing Dependents in Excel Formulas.mp4	14.8 MB
2. Tracing Dependents in Excel Formulas.srt	4.0 KB
3. Working with the Watch Window.mp4	16.0 MB
3. Working with the Watch Window.srt	6.0 KB
4. Showing Formulas.mp4	13.5 MB
4. Showing Formulas.srt	4.4 KB
/26. Protecting Excel Worksheets and Workbooks/
1. Protecting Specific Cells in a Worksheet.mp4	41.5 MB
1. Protecting Specific Cells in a Worksheet.srt	11.8 KB
2. Protecting the Structure of a Workbook.mp4	12.9 MB
2. Protecting the Structure of a Workbook.srt	5.9 KB
3. Adding a Workbook Password.mp4	15.0 MB
3. Adding a Workbook Password.srt	4.6 KB
/27. Mastering Excel's What If Tools/
1. Working with Excel's Goal Seek Tool.mp4	25.1 MB
1. Working with Excel's Goal Seek Tool.srt	11.7 KB
2. Working with Excel's Solver Tool.mp4	198.0 MB
2. Working with Excel's Solver Tool.srt	16.3 KB
3. Building Effective Data Tables in Excel.mp4	20.3 MB
3. Building Effective Data Tables in Excel.srt	8.2 KB
4. Creating Scenarios in Excel.mp4	37.3 MB
4. Creating Scenarios in Excel.srt	11.5 KB
/28. Automating Repetitive Tasks in Excel with Macros/
1. Understanding Excel Macros.mp4	24.1 MB
1. Understanding Excel Macros.srt	5.5 KB
2. Activating the Developer Tab in Excel.mp4	10.8 MB
2. Activating the Developer Tab in Excel.srt	2.2 KB
3. Creating a Macro with the Macro Recorder.mp4	48.7 MB
3. Creating a Macro with the Macro Recorder.srt	11.9 KB
4. Editing a Macro with VBA.mp4	26.6 MB
4. Editing a Macro with VBA.srt	8.0 KB
5. Creating Buttons to Run Macros.mp4	20.7 MB
5. Creating Buttons to Run Macros.srt	19.2 MB
/29. Congratulations!/
1. Congratulations on Competing the Microsoft Excel 103.mp4	3.6 MB
1. Congratulations on Competing the Microsoft Excel 103.srt	1.6 KB
/3. Entering and Editing Text and Formulas/
1. Entering Text to Create Spreadsheet Titles.mp4	155.3 MB
1. Entering Text to Create Spreadsheet Titles.srt	12.8 KB
2. Working with Numeric Data in Excel.mp4	158.0 MB
2. Working with Numeric Data in Excel.srt	12.2 KB
3. Entering Date Values in Excel.mp4	158.0 MB
3. Entering Date Values in Excel.srt	13.2 KB
4. Working with Cell References.mp4	106.5 MB
4. Working with Cell References.srt	8.6 KB
5. Creating Basic Formulas in Excel.mp4	153.4 MB
5. Creating Basic Formulas in Excel.srt	13.5 KB
6. Relative Versus Absolute Cell References in Formulas.mp4	223.0 MB
6. Relative Versus Absolute Cell References in Formulas.srt	17.4 KB
7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4	181.7 MB
7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).srt	15.1 KB
7.1 OrderOfOperation-01.xlsx.xlsx	9.5 KB
8. Entering and Editing Text and Formulas Quiz.html	0.2 KB
/30. Microsoft Excel Macros and VBA Course Introduction/
1. Welcome to the Course.mp4	33.8 MB
1. Welcome to the Course.srt	8.5 KB
2. Understanding the Why and How Behind Excel Macros.mp4	15.6 MB
2. Understanding the Why and How Behind Excel Macros.srt	7.5 KB
3. Course Exercise Files - Download these First!.html	0.4 KB
3.1 AutomateSumFunction.xlsx.xlsx	20.3 KB
3.2 AutomateFormulas.xlsx.xlsx	19.3 KB
3.3 SortingRecords.xlsm.xlsm	22.3 KB
3.4 SortingRecords.xlsx.xlsx	16.9 KB
3.5 QuarterlyReportForm-01.xlsm.xlsm	30.4 KB
3.6 InsertingAndFormattingText.xlsx.xlsx	17.8 KB
3.7 CleaningUpData.xlsx.xlsx	21.3 KB
3.8 QuarterlyReport.xlsm.xlsm	27.1 KB
/31. Project #1 Using Excel's Macro Recorder Tool/
1. Introduction to Project #1 Inserting and Formatting Text.mp4	13.7 MB
1. Introduction to Project #1 Inserting and Formatting Text.srt	2.8 KB
2. Project #1 Start Recording!.mp4	51.6 MB
2. Project #1 Start Recording!.srt	11.1 KB
2.1 InsertingAndFormattingText.xlsx.xlsx	17.8 KB
3. Running A Macro.mp4	9.0 MB
3. Running A Macro.srt	4.1 KB
4. Project #1 Running a Macro with a Button.mp4	22.8 MB
4. Project #1 Running a Macro with a Button.srt	5.4 KB
5. Project #1 Opps! I Need to Edit My Macro.mp4	29.2 MB
5. Project #1 Opps! I Need to Edit My Macro.srt	6.2 KB
6. Practical Uses of Excel Macros.mp4	19.4 MB
6. Practical Uses of Excel Macros.srt	3.4 KB
/32. Excel VBA Concepts/
1. Excel VBA Concepts.mp4	23.2 MB
1. Excel VBA Concepts.srt	4.8 KB
2. The Visual Basic Editor (VBE).mp4	9.9 MB
2. The Visual Basic Editor (VBE).srt	5.0 KB
3. Excel VBA Modules.mp4	5.6 MB
3. Excel VBA Modules.srt	2.6 KB
4. Creating an Excel VBA Procedure.mp4	45.1 MB
4. Creating an Excel VBA Procedure.srt	10.7 KB
5. Adding Code to a VBA Procedure.mp4	24.3 MB
5. Adding Code to a VBA Procedure.srt	5.2 KB
6. Understanding Excel VBA Variables.mp4	39.2 MB
6. Understanding Excel VBA Variables.srt	8.9 KB
7. Building Logic with an IF Statement.mp4	37.1 MB
7. Building Logic with an IF Statement.srt	8.1 KB
8. Working with Excel VBA Loops to Repeat Blocks of Code.mp4	29.0 MB
8. Working with Excel VBA Loops to Repeat Blocks of Code.srt	13.5 KB
/33. Project #2 Moving Beyond the Basics and into VBA/
1. Introduction to Project #2 Interacting with the User.mp4	19.0 MB
1. Introduction to Project #2 Interacting with the User.srt	3.9 KB
2. Project #2 Breaking Down the VBA Code.mp4	12.6 MB
2. Project #2 Breaking Down the VBA Code.srt	4.8 KB
2.1 SortingRecords.xlsm.xlsm	17.1 KB
3. Project #2 Prompting the User for Information.mp4	21.6 MB
3. Project #2 Prompting the User for Information.srt	9.3 KB
4. Continue Excel VBA InputBox.mp4	40.8 MB
4. Continue Excel VBA InputBox.srt	9.1 KB
5. Project #2 Building Logic into Your Macros.mp4	15.5 MB
5. Project #2 Building Logic into Your Macros.srt	5.7 KB
6. Project #2 Alerting the User of Errors.mp4	35.4 MB
6. Project #2 Alerting the User of Errors.srt	13.7 KB
7. Other Practical Uses of Message and Input Boxes.mp4	25.6 MB
7. Other Practical Uses of Message and Input Boxes.srt	4.9 KB
/34. Project #3 Preparing and Cleaning Up Data with a Little VBA/
1. Introduction to Project #3 Cleaning Up and Formatting Data.mp4	11.2 MB
1. Introduction to Project #3 Cleaning Up and Formatting Data.srt	4.8 KB
2. Project #3 Preparing to the Use the Macro Recorder.mp4	10.0 MB
2. Project #3 Preparing to the Use the Macro Recorder.srt	4.2 KB
3. Project #3 Inserting the Headers.mp4	23.2 MB
3. Project #3 Inserting the Headers.srt	5.7 KB
4. Project #3 Formatting the Headers.mp4	7.8 MB
4. Project #3 Formatting the Headers.srt	3.5 KB
5. Project #3 Putting it all Together with a Little VBA.mp4	37.6 MB
5. Project #3 Putting it all Together with a Little VBA.srt	14.8 KB
6. Running the Loop.mp4	19.9 MB
6. Running the Loop.srt	4.5 KB
/35. Project #4 Using VBA to Automate Excel Formulas/
1. Introduction to Project #4 Automate Excel Formulas.mp4	7.8 MB
1. Introduction to Project #4 Automate Excel Formulas.srt	3.1 KB
2. Project #4 Automate the SUM() Function through Code.mp4	26.8 MB
2. Project #4 Automate the SUM() Function through Code.srt	10.9 KB
2.1 AutomateSumFunction.xlsx.xlsx	20.3 KB
3. Continue Automate SUM Function.mp4	18.4 MB
3. Continue Automate SUM Function.srt	8.1 KB
4. Test the SUM Function.mp4	13.0 MB
4. Test the SUM Function.srt	5.4 KB
5. Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4	21.1 MB
5. Project #4 Loop the SUM() Function Over Multiple Worksheets.srt	8.7 KB
/36. Project #5 Bringing it All Together and a Weekly Report/
1. Introduction to Project #5 Creating the Final Report.mp4	11.5 MB
1. Introduction to Project #5 Creating the Final Report.srt	5.0 KB
2. Project #5 Creating the Final Report Loop.mp4	49.6 MB
2. Project #5 Creating the Final Report Loop.srt	12.2 KB
3. Project #5 - Copying and Pasting Data with VBA.mp4	57.4 MB
3. Project #5 - Copying and Pasting Data with VBA.srt	13.3 KB
4. Project #5 - Running the Final Report Procedure.mp4	20.9 MB
4. Project #5 - Running the Final Report Procedure.srt	4.4 KB
/37. Project #6 Working with Excel VBA User Forms/
1. Introduction to Project #6 Working with Excel VBA User Forms.mp4	9.2 MB
1. Introduction to Project #6 Working with Excel VBA User Forms.srt	4.3 KB
1.1 QuarterlyReportForm-01.xlsm.xlsm	25.1 KB
2. Project #6 Creating an Excel User Form.mp4	15.8 MB
2. Project #6 Creating an Excel User Form.srt	7.8 KB
3. Project #6 Adding Controls to the Form.mp4	12.2 MB
3. Project #6 Adding Controls to the Form.srt	5.4 KB
4. Project #6 Adding VBA Code to the Initialize Event.mp4	25.5 MB
4. Project #6 Adding VBA Code to the Initialize Event.srt	11.8 KB
5. Project #6 Adding VBA Code to the ComboBox Change Event.mp4	25.4 MB
5. Project #6 Adding VBA Code to the ComboBox Change Event.srt	6.3 KB
6. Project #6 Adding VBA Code to the Add Worksheet Button.mp4	10.6 MB
6. Project #6 Adding VBA Code to the Add Worksheet Button.srt	5.1 KB
7. Change Worksheet Name.mp4	12.3 MB
7. Change Worksheet Name.srt	5.8 KB
8. Project #6 Adding VBA Code to the Create Report Button.mp4	28.8 MB
8. Project #6 Adding VBA Code to the Create Report Button.srt	12.7 KB
9. Project #6 Showing the Form.mp4	13.0 MB
9. Project #6 Showing the Form.srt	5.4 KB
/38. Project #7 Importing Data from Text Files/
1. Project #7 Opening a Text File for Import.mp4	27.3 MB
1. Project #7 Opening a Text File for Import.srt	4.2 KB
1.1 May2015Sales.txt.txt	1.3 KB
1.2 Jan2015Sales.txt.txt	1.3 KB
1.3 April2015Sales.txt.txt	1.8 KB
1.4 Dec2015Sales.txt.txt	1.1 KB
1.5 Feb2015Sales.txt.txt	1.2 KB
1.6 Mar2015Sales.txt.txt	1.2 KB
1.7 Nov2015Sales.txt.txt	1.3 KB
2. Project #7 Opening a Text File for Import.mp4	44.3 MB
2. Project #7 Opening a Text File for Import.srt	9.4 KB
3. Project #7 Get Data from Text File.mp4	34.2 MB
3. Project #7 Get Data from Text File.srt	8.4 KB
4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4	68.8 MB
4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.srt	12.8 KB
5. Project #7 Creating a Loop to Read Each File.mp4	59.6 MB
5. Project #7 Creating a Loop to Read Each File.srt	11.4 KB
6. Project #7 Adding a New Sheet for Imported Data.mp4	25.0 MB
6. Project #7 Adding a New Sheet for Imported Data.srt	3.5 KB
7. Project #7 Clear the Clipboard.mp4	33.6 MB
7. Project #7 Clear the Clipboard.srt	5.5 KB
8. Project #7 Working with the ScreenUpdating Property.mp4	36.2 MB
8. Project #7 Working with the ScreenUpdating Property.srt	5.2 KB
9. Project #7 Creating Reusable Code with a VBA Function.mp4	64.0 MB
9. Project #7 Creating Reusable Code with a VBA Function.srt	11.0 KB
/39. Course Wrap Up/
1. Congratulations! You're an Excel MacroVBA Master.mp4	19.0 MB
1. Congratulations! You're an Excel MacroVBA Master.srt	1.3 KB
2. BONUS! - Special Offer! Discount on Any of my Courses!.html	2.1 KB
/4. Working with Basic Excel Functions/
1. The structure of an Excel Function.mp4	169.8 MB
1. The structure of an Excel Function.srt	15.1 KB
1.1 EXCEL FUNCTIONS.pptx.pptx	89.2 KB
10. Basic Excel Functions Quiz.html	0.2 KB
2. Working with the SUM() Function.mp4	119.3 MB
2. Working with the SUM() Function.srt	10.7 KB
3. Working with the MIN() and MAX() Functions.mp4	106.8 MB
3. Working with the MIN() and MAX() Functions.srt	10.3 KB
4. Working with the AVERAGE() Function.mp4	49.5 MB
4. Working with the AVERAGE() Function.srt	4.5 KB
5. Working with the COUNT() Function.mp4	49.9 MB
5. Working with the COUNT() Function.srt	4.5 KB
6. Adjacent Cells Error in Excel Calculations.mp4	63.0 MB
6. Adjacent Cells Error in Excel Calculations.srt	6.0 KB
7. Using the AutoSum Command.mp4	117.4 MB
7. Using the AutoSum Command.srt	10.8 KB
8. Excel's AutoSum Shortcut Key.mp4	38.6 MB
8. Excel's AutoSum Shortcut Key.srt	3.2 KB
9. Using the AutoFill Command to Copy Formulas.mp4	76.6 MB
9. Using the AutoFill Command to Copy Formulas.srt	6.8 KB
/5. Modifying an Excel Worksheet/
1. Moving and Copying Data in an Excel Worksheet.mp4	117.1 MB
1. Moving and Copying Data in an Excel Worksheet.srt	9.0 KB
2. Inserting and Deleting Rows and Columns.mp4	125.6 MB
2. Inserting and Deleting Rows and Columns.srt	11.1 KB
3. Changing the Width and Height of Cells.mp4	88.8 MB
3. Changing the Width and Height of Cells.srt	7.9 KB
4. Hiding and Unhiding Excel Rows and Columns.mp4	90.2 MB
4. Hiding and Unhiding Excel Rows and Columns.srt	8.1 KB
5. Renaming an Excel Worksheet.mp4	48.9 MB
5. Renaming an Excel Worksheet.srt	4.5 KB
6. Deleting an Excel Worksheet.mp4	82.8 MB
6. Deleting an Excel Worksheet.srt	6.9 KB
7. Moving and Copying an Excel Worksheet.mp4	94.0 MB
7. Moving and Copying an Excel Worksheet.srt	7.7 KB
8. Modifying Worksheets Quiz.html	0.2 KB
/6. Formatting Data in an Excel Worksheet/
1. Working with Font Formatting Commands.mp4	12.3 MB
1. Working with Font Formatting Commands.srt	6.3 KB
10. Formatting Data Quiz.html	0.2 KB
2. Changing the Background Color of a Cell.mp4	9.0 MB
2. Changing the Background Color of a Cell.srt	4.7 KB
3. Adding Borders to Cells.mp4	11.0 MB
3. Adding Borders to Cells.srt	5.4 KB
4. Formatting Data as Currency Values.mp4	17.3 MB
4. Formatting Data as Currency Values.srt	8.1 KB
5. Formatting Percentages.mp4	7.4 MB
5. Formatting Percentages.srt	3.4 KB
6. Using Excel's Format Painter.mp4	9.4 MB
6. Using Excel's Format Painter.srt	4.4 KB
7. Creating Styles to Format Data.mp4	30.5 MB
7. Creating Styles to Format Data.srt	12.8 KB
8. Merging and Centering Cells.mp4	10.3 MB
8. Merging and Centering Cells.srt	3.8 KB
9. Using Conditional Formatting.mp4	16.0 MB
9. Using Conditional Formatting.srt	6.7 KB
/7. Inserting Images and Shapes into an Excel Worksheet/
1. Inserting Images.mp4	14.9 MB
1. Inserting Images.srt	6.8 KB
2. Inserting Excel Shapes.mp4	13.9 MB
2. Inserting Excel Shapes.srt	5.9 KB
3. Formatting Excel Shapes.mp4	16.1 MB
3. Formatting Excel Shapes.srt	7.8 KB
4. Working with Excel SmartArt.mp4	20.2 MB
4. Working with Excel SmartArt.srt	9.8 KB
/8. Creating Basic Charts in Excel/
1. Creating an Excel Column Chart.mp4	17.8 MB
1. Creating an Excel Column Chart.srt	7.5 KB
2. Working with the Excel Chart Ribbon.mp4	16.4 MB
2. Working with the Excel Chart Ribbon.srt	8.1 KB
3. Adding and Modifying Data on an Excel Chart.mp4	12.9 MB
3. Adding and Modifying Data on an Excel Chart.srt	5.0 KB
4. Formatting an Excel Chart.mp4	14.5 MB
4. Formatting an Excel Chart.srt	7.7 KB
5. Moving a Chart to another Worksheet.mp4	7.8 MB
5. Moving a Chart to another Worksheet.srt	3.8 KB
6. Working with Excel Pie Charts.mp4	17.7 MB
6. Working with Excel Pie Charts.srt	8.1 KB
7. Working with Excel Charts Quiz.html	0.2 KB
/9. Printing an Excel Worksheet/
1. Viewing your Document in Print Preview.mp4	6.2 MB
1. Viewing your Document in Print Preview.srt	3.4 KB
2. Changing the Margins, Scaling and Orientation.mp4	22.0 MB
2. Changing the Margins, Scaling and Orientation.srt	14.3 KB
3. Working with Page Layout View.mp4	14.6 MB
3. Working with Page Layout View.srt	6.5 KB
4. Adding Header and Footer Content.mp4	15.1 MB
4. Adding Header and Footer Content.srt	7.2 KB
5. Printing a Specific Range of Cells.mp4	11.0 MB
5. Printing a Specific Range of Cells.srt	4.6 KB
6. Printing and Excel Worksheet Quiz.html	0.2 KB
/
[FreeAllCourse.Com].URL	0.2 KB
Total files 431