2021 Microsoft Excel from Beginner To Expert Course | DF8685BB3FEE5F424DBDCE6BF5BB80F2D4771A0D

2021 Microsoft Excel from Beginner To Expert Course

Name	2021 Microsoft Excel from A-Z Beginner To Expert Course	DOWNLOAD Copy Link
Total Size	5.1 GB
Total Files	312
Last Seen	2024-12-20 23:26
Hash	DF8685BB3FEE5F424DBDCE6BF5BB80F2D4771A0D

/.../21. Welcome to Excel VBA!/
3. Recording a Macro.mp4	94.3 MB
1. The Power Behind Excel VBA.mp4	15.4 MB
1. The Power Behind Excel VBA.srt	3.0 KB
1.1 VBA Practice.xlsx	33.4 KB
2. A Look Inside the Visual Basic Editor (VBE).mp4	16.6 MB
2. A Look Inside the Visual Basic Editor (VBE).srt	4.4 KB
3. Recording a Macro.srt	10.4 KB
4. Saving & Opening a Macro-Enabled Workbook.mp4	31.4 MB
4. Saving & Opening a Macro-Enabled Workbook.srt	2.4 KB
/
TutsNode.com.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/.../1. Excel from A-Z Course Introduction/
1. Excel from A-Z Course Section Overview.mp4	18.7 MB
1. Excel from A-Z Course Section Overview.srt	5.2 KB
2. What is Microsoft Excel.mp4	26.8 MB
2. What is Microsoft Excel.srt	6.7 KB
3. Who This Course is For.mp4	20.5 MB
3. Who This Course is For.srt	5.5 KB
4. Microsoft Excel Marketplace.mp4	29.2 MB
4. Microsoft Excel Marketplace.srt	6.7 KB
5. Microsoft Excel Job Opportunities.mp4	18.0 MB
5. Microsoft Excel Job Opportunities.srt	4.2 KB
6. Microsoft Excel Job Types.mp4	25.6 MB
6. Microsoft Excel Job Types.srt	6.5 KB
/.../2. Getting Started with Excel/
1. Finding & Opening Microsoft Excel.mp4	4.6 MB
1. Finding & Opening Microsoft Excel.srt	1.7 KB
2. Excel's Start Screen.mp4	15.4 MB
2. Excel's Start Screen.srt	5.2 KB
3. Explaining the Excel Interface.mp4	14.4 MB
3. Explaining the Excel Interface.srt	4.3 KB
4. Excel Interface Continued.mp4	8.3 MB
4. Excel Interface Continued.srt	1.9 KB
5. Excel Workbook vs Excel Worksheet.mp4	10.5 MB
5. Excel Workbook vs Excel Worksheet.srt	3.2 KB
6. Saving & Opening Excel Documents.mp4	18.7 MB
6. Saving & Opening Excel Documents.srt	4.9 KB
7. Customizing the Excel Quick Access Toolbar.mp4	14.7 MB
7. Customizing the Excel Quick Access Toolbar.srt	3.4 KB
8. Customizing the Excel Ribbon.mp4	20.1 MB
8. Customizing the Excel Ribbon.srt	4.5 KB
9. Excel Shortcut Keys.mp4	8.6 MB
9. Excel Shortcut Keys.srt	2.6 KB
/.../3. Values, Referencing and Formulas/
1. Creating Excel Labels.mp4	11.6 MB
1. Creating Excel Labels.srt	3.5 KB
2. Entering Numeric Values in Excel.mp4	16.5 MB
2. Entering Numeric Values in Excel.srt	4.7 KB
3. Formatting Date Values in Excel.mp4	27.3 MB
3. Formatting Date Values in Excel.srt	7.5 KB
4. Building Basic Formulas in Excel.mp4	23.0 MB
4. Building Basic Formulas in Excel.srt	7.1 KB
5. Order of Operations.mp4	32.9 MB
5. Order of Operations.srt	8.8 KB
6. Relative vs Absolute Cell References.mp4	37.7 MB
6. Relative vs Absolute Cell References.srt	10.4 KB
/.../4. Intro to Excel Functions/
1. Excel Functions Explained.mp4	14.5 MB
1. Excel Functions Explained.srt	4.0 KB
2. The SUM() Function.mp4	40.5 MB
2. The SUM() Function.srt	10.9 KB
3. The MIN() & MAX() Function.mp4	20.9 MB
3. The MIN() & MAX() Function.srt	5.7 KB
4. The AVERAGE() Function.mp4	11.2 MB
4. The AVERAGE() Function.srt	2.6 KB
5. COUNT() Functions.mp4	28.1 MB
5. COUNT() Functions.srt	6.7 KB
/.../5. Adjusting Excel Worksheets/
1. Moving & Copying Data.mp4	47.8 MB
1. Moving & Copying Data.srt	9.0 KB
2. Insert & Delete RowsColumns.mp4	29.6 MB
2. Insert & Delete RowsColumns.srt	6.9 KB
3. Adjusting the Width & Height of Cells.mp4	28.2 MB
3. Adjusting the Width & Height of Cells.srt	6.1 KB
4. Hiding and Unhiding Excel Rows and Columns.mp4	25.6 MB
4. Hiding and Unhiding Excel Rows and Columns.srt	5.8 KB
5. Renaming, Moving & Deleting Excel Worksheets.mp4	29.5 MB
5. Renaming, Moving & Deleting Excel Worksheets.srt	7.6 KB
6. Adding Protection to Specific Cells.mp4	25.1 MB
6. Adding Protection to Specific Cells.srt	6.1 KB
7. Protecting the Structure of a Workbook.mp4	11.2 MB
7. Protecting the Structure of a Workbook.srt	3.0 KB
8. Adding a Workbook Password to Open File.mp4	11.3 MB
8. Adding a Workbook Password to Open File.srt	3.1 KB
/.../6. Visually Pleasing Cell Formatting/
1. Formatting Fonts and Cell Background Color.mp4	27.4 MB
1. Formatting Fonts and Cell Background Color.srt	7.6 KB
2. Adding Cell Borders.mp4	25.5 MB
2. Adding Cell Borders.srt	6.8 KB
3. Formatting Data Appropriately.mp4	31.0 MB
3. Formatting Data Appropriately.srt	7.4 KB
4. The Magic behind Excel's Format Painter.mp4	20.0 MB
4. The Magic behind Excel's Format Painter.srt	4.9 KB
5. Creating Styles for Formatting Efficiency.mp4	36.3 MB
5. Creating Styles for Formatting Efficiency.srt	8.6 KB
6. Merging Cells for a Cleaner Look.mp4	20.8 MB
6. Merging Cells for a Cleaner Look.srt	4.3 KB
7. The Power of Conditional Formatting.mp4	39.3 MB
7. The Power of Conditional Formatting.srt	8.4 KB
/.../7. How to Insert Images and Shapes!/
1. Grab User’s Attention using Illustrations.mp4	61.4 MB
1. Grab User’s Attention using Illustrations.srt	11.1 KB
2. Customizing Icons.mp4	33.0 MB
2. Customizing Icons.srt	6.2 KB
3. Create Compelling Graphics with SmartArt.mp4	37.8 MB
3. Create Compelling Graphics with SmartArt.srt	7.6 KB
/.../8. Visualize Data with Charts/
1. The Commonly used Column Chart.mp4	17.4 MB
1. The Commonly used Column Chart.srt	3.7 KB
2. Changing the Chart Design.mp4	13.3 MB
2. Changing the Chart Design.srt	2.7 KB
3. Formatting Elements of a Chart.mp4	44.1 MB
3. Formatting Elements of a Chart.srt	8.8 KB
4. Modifying the Data, Type & Location of a Chart.mp4	39.8 MB
4. Modifying the Data, Type & Location of a Chart.srt	8.0 KB
5. Little Slice of Pie Charts.mp4	36.5 MB
5. Little Slice of Pie Charts.srt	6.7 KB
/.../9. Excel's Printing Options/
1. Print Preview Options.mp4	22.0 MB
1. Print Preview Options.srt	6.2 KB
2. Excel's Page Layout View.mp4	44.5 MB
2. Excel's Page Layout View.srt	8.7 KB
3. Printing a Specific Range of Cells.mp4	15.2 MB
3. Printing a Specific Range of Cells.srt	3.4 KB
4. Converting Spreadsheets to PDF Files.mp4	14.9 MB
4. Converting Spreadsheets to PDF Files.srt	3.1 KB
/.../10. Benefits of Using Excel Templates/
1. Why Create an Excel Template.mp4	8.8 MB
1. Why Create an Excel Template.srt	1.9 KB
2. How to Create an Excel Template.mp4	28.9 MB
2. How to Create an Excel Template.srt	6.5 KB
/.../11. Working with Excel Datasets/
1. How to Prepare Data for Analysis.mp4	53.0 MB
1. How to Prepare Data for Analysis.srt	4.8 KB
1.1 Excel Practice.xlsx	59.3 KB
2. How to Sort Data in Excel.mp4	17.0 MB
2. How to Sort Data in Excel.srt	3.5 KB
3. Multi-Level Sorting.mp4	17.3 MB
3. Multi-Level Sorting.srt	3.2 KB
4. Custom Sorting Datasets in Excel.mp4	16.8 MB
4. Custom Sorting Datasets in Excel.srt	3.2 KB
5. Applying Filters to Datasets.mp4	28.2 MB
5. Applying Filters to Datasets.srt	6.1 KB
6. Creating Subtotals within a Dataset.mp4	36.9 MB
6. Creating Subtotals within a Dataset.srt	7.2 KB
7. Converting Datasets into Tables.mp4	42.2 MB
7. Converting Datasets into Tables.srt	7.7 KB
8. Finding & Removing Duplicate Values.mp4	89.3 MB
8. Finding & Removing Duplicate Values.srt	9.1 KB
/.../12. Excel Database Functions/
1. The SUMIF() Function.mp4	61.2 MB
1. The SUMIF() Function.srt	10.8 KB
2. The DSUM() Function.mp4	54.9 MB
2. The DSUM() Function.srt	9.6 KB
3. DSUM() Function Cont..mp4	54.1 MB
3. DSUM() Function Cont..srt	8.1 KB
4. The SUBTOTAL() Function.mp4	41.8 MB
4. The SUBTOTAL() Function.srt	7.9 KB
/.../13. Excel Data Validation/
1. What is Excel Data Validation.mp4	10.1 MB
1. What is Excel Data Validation.srt	2.3 KB
2. Creating a Drop Down List with Data Validation.mp4	35.5 MB
2. Creating a Drop Down List with Data Validation.srt	8.8 KB
3. Different Types of Excel Data Validation.mp4	28.2 MB
3. Different Types of Excel Data Validation.srt	6.5 KB
4. Adding Custom Alerts to Data Validation.mp4	34.5 MB
4. Adding Custom Alerts to Data Validation.srt	7.4 KB
5. Creating a Dynamic Drop Down List.mp4	17.0 MB
5. Creating a Dynamic Drop Down List.srt	3.6 KB
6. Complex Validation Dependent Drop Down List!.mp4	44.6 MB
6. Complex Validation Dependent Drop Down List!.srt	10.4 KB
/.../14. Excel PivotTables/
1. Creating an Excel Pivot Table.mp4	45.0 MB
1. Creating an Excel Pivot Table.srt	6.9 KB
2. Modifying Excel PivotTables.mp4	46.7 MB
2. Modifying Excel PivotTables.srt	7.0 KB
3. Grouping & Filtering PivotTable Data.mp4	61.1 MB
3. Grouping & Filtering PivotTable Data.srt	8.0 KB
4. Drilling Down into PivotTable Data.mp4	15.2 MB
4. Drilling Down into PivotTable Data.srt	2.4 KB
5. Creating Pivot Charts & Utilizing Slicers.mp4	74.4 MB
5. Creating Pivot Charts & Utilizing Slicers.srt	9.8 KB
/.../15. Excel's PowerPivot Add-In/
1. What is PowerPivot.mp4	11.8 MB
1. What is PowerPivot.srt	4.4 KB
2. Activating the Excel PowerPivot Add-In.mp4	8.2 MB
2. Activating the Excel PowerPivot Add-In.srt	1.9 KB
3. Creating Relationships between Data Tables.mp4	36.1 MB
3. Creating Relationships between Data Tables.srt	7.4 KB
4. Using Data Models to Create PivotTables.mp4	22.9 MB
4. Using Data Models to Create PivotTables.srt	5.2 KB
5. How to Create PowerPivot KPI’s.mp4	51.1 MB
5. How to Create PowerPivot KPI’s.srt	9.5 KB
/.../16. Excel's Conditional Functions/
1. Excel’s IF() Function.mp4	26.8 MB
1. Excel’s IF() Function.srt	5.7 KB
2. IF() Function with AND() Criteria.mp4	29.5 MB
2. IF() Function with AND() Criteria.srt	5.6 KB
3. IF() Function with OR() Criteria.mp4	29.6 MB
3. IF() Function with OR() Criteria.srt	5.3 KB
4. Nesting Multiple IF() Functions.mp4	36.7 MB
4. Nesting Multiple IF() Functions.srt	7.8 KB
5. The COUNTIF() Function.mp4	22.0 MB
5. The COUNTIF() Function.srt	4.6 KB
6. Key Benefits of Named Ranges.mp4	23.4 MB
6. Key Benefits of Named Ranges.srt	4.6 KB
/.../17. Excel's Lookup Functions/
1. VLOOKUP() Function.mp4	52.0 MB
1. VLOOKUP() Function.srt	10.4 KB
2. The Beauty of Excel’s IFERROR() Function.mp4	21.2 MB
2. The Beauty of Excel’s IFERROR() Function.srt	4.3 KB
3. HLOOKUP() Function.mp4	35.0 MB
3. HLOOKUP() Function.srt	7.3 KB
4. INDEX() Function.mp4	26.8 MB
4. INDEX() Function.srt	5.5 KB
5. MATCH() Function.mp4	32.8 MB
5. MATCH() Function.srt	5.7 KB
6. INDEX() and MATCH() Combined.mp4	30.1 MB
6. INDEX() and MATCH() Combined.srt	6.0 KB
7. Two-Way Lookup with INDEX() and MATCH().mp4	24.5 MB
7. Two-Way Lookup with INDEX() and MATCH().srt	4.9 KB
/.../18. Text Based Functions in Excel/
1. LEFT(), RIGHT() and MID() Function.mp4	39.0 MB
1. LEFT(), RIGHT() and MID() Function.srt	8.5 KB
2. Extracting Specific Text using LEN() & SEARCH().mp4	69.5 MB
2. Extracting Specific Text using LEN() & SEARCH().srt	15.5 KB
3. Combining Text with CONCATENATE().mp4	41.6 MB
3. Combining Text with CONCATENATE().srt	7.2 KB
4. Quick Tips & Other Text Based Functions.mp4	33.2 MB
4. Quick Tips & Other Text Based Functions.srt	7.0 KB
/.../19. Auditing Formulas & Custom Views in Excel/
1. Tracing Precedents & Dependents in Formulas.mp4	27.5 MB
1. Tracing Precedents & Dependents in Formulas.srt	5.2 KB
2. Showing Formulas.mp4	12.3 MB
2. Showing Formulas.srt	2.4 KB
3. Grouping Data.mp4	18.1 MB
3. Grouping Data.srt	3.4 KB
4. 3D Referencing in Formulas.mp4	33.8 MB
4. 3D Referencing in Formulas.srt	6.2 KB
5. Utilizing the Watch Window in Excel.mp4	17.4 MB
5. Utilizing the Watch Window in Excel.srt	3.4 KB
6. How to Freeze Panes in Excel.mp4	40.3 MB
6. How to Freeze Panes in Excel.srt	3.5 KB
/.../20. Excel’s “What If” Tools/
1. Excel’s Scenario Manager Tool.mp4	31.4 MB
1. Excel’s Scenario Manager Tool.srt	7.2 KB
2. Goal Seek in Excel.mp4	31.7 MB
2. Goal Seek in Excel.srt	7.3 KB
3. Compare Results with Excel Data Tables.mp4	23.2 MB
3. Compare Results with Excel Data Tables.srt	5.1 KB
4. Solver Tool.mp4	64.6 MB
4. Solver Tool.srt	12.4 KB
/.../22. The VBA Language/
1. Modules and Procedures.mp4	25.4 MB
1. Modules and Procedures.srt	7.5 KB
2. Objects, Methods and Properties.mp4	34.8 MB
2. Objects, Methods and Properties.srt	6.7 KB
3. Excel VBA Variables.mp4	21.3 MB
3. Excel VBA Variables.srt	5.4 KB
/.../23. Writing VBA Code/
1. Referencing a Range.mp4	84.3 MB
1. Referencing a Range.srt	14.9 KB
2. InputBox & MsgBox.mp4	34.3 MB
2. InputBox & MsgBox.srt	5.5 KB
3. Using Variables in VBA Code.mp4	29.5 MB
3. Using Variables in VBA Code.srt	4.9 KB
4. If Then Else Statement.mp4	72.2 MB
4. If Then Else Statement.srt	11.1 KB
5. Worksheet Functions inside VBA.mp4	53.8 MB
5. Worksheet Functions inside VBA.srt	8.6 KB
6. Creating User Defined Functions.mp4	66.5 MB
6. Creating User Defined Functions.srt	10.5 KB
7. User Defined Functions within VBA Scripts.mp4	45.9 MB
7. User Defined Functions within VBA Scripts.srt	6.9 KB
/.../24. Important VBA Tools and Logic/
1. Find Last Row of Data.mp4	37.9 MB
1. Find Last Row of Data.srt	6.3 KB
2. Find Last Column of Data.mp4	21.3 MB
2. Find Last Column of Data.srt	3.5 KB
3. With Statement.mp4	28.4 MB
3. With Statement.srt	5.4 KB
4. Debugging & Error Handling.mp4	41.3 MB
4. Debugging & Error Handling.srt	7.3 KB
5. Debugging & Error Handling Cont..mp4	44.4 MB
5. Debugging & Error Handling Cont..srt	8.0 KB
/.../25. Excel VBA Loops/
1. For Next Loop.mp4	60.8 MB
1. For Next Loop.srt	10.2 KB
2. Do Until Loop.mp4	41.3 MB
2. Do Until Loop.srt	7.1 KB
3. For Each Loop.mp4	26.9 MB
3. For Each Loop.srt	4.0 KB
/.../26. Triggering Macros/
1. Assigning Macros to Shapes.mp4	29.4 MB
1. Assigning Macros to Shapes.srt	4.4 KB
2. Form Controls vs ActiveX Controls.mp4	61.4 MB
2. Form Controls vs ActiveX Controls.srt	9.8 KB
3. Worksheet Events.mp4	26.5 MB
3. Worksheet Events.srt	4.0 KB
4. Workbook Events.mp4	19.0 MB
4. Workbook Events.srt	3.1 KB
5. Fun with VBA Events!.mp4	72.2 MB
5. Fun with VBA Events!.srt	8.1 KB
/.../27. Excel User Forms/
1. Creating an Excel UserForm.mp4	20.7 MB
1. Creating an Excel UserForm.srt	3.9 KB
2. Adding Controls to UserForms.mp4	72.8 MB
2. Adding Controls to UserForms.srt	12.3 KB
3. How to Show an UserForm.mp4	22.9 MB
3. How to Show an UserForm.srt	3.6 KB
4. Passing TextBox Values to Desired Cells.mp4	41.9 MB
4. Passing TextBox Values to Desired Cells.srt	7.0 KB
5. Passing Option Buttons to Desired Cells.mp4	47.0 MB
5. Passing Option Buttons to Desired Cells.srt	8.0 KB
6. UserForm ComboBoxes.mp4	61.4 MB
6. UserForm ComboBoxes.srt	9.2 KB
7. Clearing Values from UserForm Controls.mp4	24.3 MB
7. Clearing Values from UserForm Controls.srt	3.3 KB
8. How to Close an UserForm.mp4	12.7 MB
8. How to Close an UserForm.srt	1.9 KB
9. UserForms and Protected Sheets.mp4	39.6 MB
9. UserForms and Protected Sheets.srt	5.4 KB
/.../28. Starting a Career in Excel/
1. Creating an Excel Resume.mp4	33.0 MB
1. Creating an Excel Resume.srt	7.7 KB
2. Getting Started with Freelancing.mp4	48.8 MB
2. Getting Started with Freelancing.srt	10.6 KB
3. How to Become an Excel Freelancer.mp4	33.0 MB
3. How to Become an Excel Freelancer.srt	6.3 KB
4. Top Freelance Websites.mp4	31.9 MB
4. Top Freelance Websites.srt	8.8 KB
5. How to Get Your First Client.mp4	50.5 MB
5. How to Get Your First Client.srt	9.7 KB
6. Personal Branding.mp4	54.5 MB
6. Personal Branding.srt	11.3 KB
7. Networking Do's and Don'ts.mp4	28.9 MB
7. Networking Do's and Don'ts.srt	7.1 KB
8. Importance of Having a Website.mp4	25.3 MB
8. Importance of Having a Website.srt	7.2 KB
Total files 312