Microsoft excel 2013 from beginner to advanced and beyond | CA1D9404BA3BA9994EF4D0196900E597676D1E36

Microsoft excel 2013 from beginner to advanced and beyond

Name	microsoft-excel-2013-from-beginner-to-advanced-and-beyond	DOWNLOAD Copy Link
Total Size	8.9 GB
Total Files	555
Last Seen	2025-02-20 00:10
Hash	CA1D9404BA3BA9994EF4D0196900E597676D1E36

/.../19 - Working with Excel's PowerPivot Tools/
002 Why PowerPivot.mp4	176.1 MB
001 Introduction to Excel Power Pivot.mp4	37.2 MB
001 Introduction to Excel Power Pivot_en.srt	9.0 KB
002 Why PowerPivot_en.srt	13.4 KB
003 Activating the Excel PowerPivot AddIn.mp4	77.0 MB
003 Activating the Excel PowerPivot AddIn_en.srt	5.3 KB
004 Creating Data Models with PowerPivot.mp4	123.2 MB
004 Creating Data Models with PowerPivot_en.srt	8.3 KB
005 Excel Power Pivot Data Model Relationships.mp4	72.4 MB
005 Excel Power Pivot Data Model Relationships_en.srt	8.1 KB
006 Creating PivotTables based on Data Models.mp4	68.9 MB
006 Creating PivotTables based on Data Models_en.srt	9.9 KB
007 Excel Power Pivot KPIs.mp4	115.5 MB
007 Excel Power Pivot KPIs_en.srt	16.5 KB
/
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
[Hello].txt	0.4 KB
/.../01 - Microsoft Excel 101 Course Introduction/
001 Ask Questions.mp4	22.2 MB
001 Ask Questions_en.srt	3.2 KB
002 Course Exercise Files.mp4	9.1 MB
002 Course Exercise Files_en.srt	2.9 KB
002 MonthlyBudget-01.xlsx	14.6 KB
002 MonthlyBudget-AutoFill-01.xlsx	14.2 KB
002 MonthlyBudget-AutoSUM-01.xlsx	14.5 KB
002 MonthlyBudget-AverageFunction-01.xlsx	14.4 KB
002 MonthlyBudget-BasicFormulas-01.xlsx	14.0 KB
002 MonthlyBudget-Count-01.xlsx	14.6 KB
002 MonthlyBudget-Headers-01.xlsx	14.0 KB
002 MonthlyBudget-MIN-MAXFunctions-01.xlsx	14.4 KB
002 MonthlyBudget-ReferenceTypes-01.xlsx	14.0 KB
002 MonthlyBudget-SUMFunction-01.xlsx	14.1 KB
002 MonthlyBudget-Template-01.xlsx	14.9 KB
003 Certificate of Completion.mp4	8.1 MB
003 Certificate of Completion_en.srt	2.2 KB
/.../02 - Microsoft Excel Fundamentals/
001 Launching Excel.mp4	11.0 MB
001 Launching Excel_en.srt	3.6 KB
002 Microsoft Excel Startup Screen.mp4	15.0 MB
002 Microsoft Excel Startup Screen_en.srt	6.2 KB
003 Introduction to the Excel Interface.mp4	27.0 MB
003 Introduction to the Excel Interface_en.srt	13.6 KB
004 Customizing the Excel Quick Access Toolbar.mp4	13.4 MB
004 Customizing the Excel Quick Access Toolbar_en.srt	5.6 KB
005 More on the Excel Interface.mp4	13.1 MB
005 More on the Excel Interface_en.srt	7.0 KB
006 Understanding the Structure of an Excel Workbook.mp4	16.0 MB
006 Understanding the Structure of an Excel Workbook_en.srt	6.9 KB
007 Saving an Excel Document.mp4	19.6 MB
007 Saving an Excel Document_en.srt	7.3 KB
008 Opening an Existing Excel Document.mp4	9.9 MB
008 Opening an Existing Excel Document_en.srt	3.2 KB
009 Common Excel Shortcut Keys.mp4	14.5 MB
009 Common Excel Shortcut Keys_en.srt	4.1 KB
009 CommonExcelWindowsShortcuts-01.pdf	144.9 KB
/.../03 - Entering and Editing Text and Formulas/
001 Entering Text to Create Spreadsheet Titles.mp4	31.5 MB
001 Entering Text to Create Spreadsheet Titles_en.srt	15.4 KB
002 Working with Numeric Data in Excel.mp4	33.1 MB
002 Working with Numeric Data in Excel_en.srt	15.4 KB
003 Entering Date Values in Excel.mp4	33.1 MB
003 Entering Date Values in Excel_en.srt	15.4 KB
004 Working with Cell References.mp4	25.3 MB
004 Working with Cell References_en.srt	10.3 KB
005 Creating Basic Formulas in Excel.mp4	33.6 MB
005 Creating Basic Formulas in Excel_en.srt	14.9 KB
006 Relative Versus Absolute Cell References in Formulas.mp4	49.3 MB
006 Relative Versus Absolute Cell References in Formulas_en.srt	20.7 KB
007 OrderOfOperation-01.xlsx	9.5 KB
007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4	37.8 MB
007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)_en.srt	18.5 KB
/.../04 - Working with Basic Excel Functions/
001 EXCEL-FUNCTIONS.pptx	89.2 KB
001 The structure of an Excel Function.mp4	32.0 MB
001 The structure of an Excel Function_en.srt	18.6 KB
002 Working with the SUM() Function.mp4	26.4 MB
002 Working with the SUM() Function_en.srt	13.0 KB
003 Working with the MIN() and MAX() Functions.mp4	25.2 MB
003 Working with the MIN() and MAX() Functions_en.srt	12.3 KB
004 Working with the AVERAGE() Function.mp4	11.5 MB
004 Working with the AVERAGE() Function_en.srt	5.3 KB
005 Working with the COUNT() Function.mp4	11.9 MB
005 Working with the COUNT() Function_en.srt	4.9 KB
006 Adjacent Cells Error in Excel Calculations.mp4	14.4 MB
006 Adjacent Cells Error in Excel Calculations_en.srt	7.1 KB
007 Using the AutoSum Command.mp4	26.9 MB
007 Using the AutoSum Command_en.srt	13.0 KB
008 Excel's AutoSum Shortcut Key.mp4	9.4 MB
008 Excel's AutoSum Shortcut Key_en.srt	4.2 KB
009 Using the AutoFill Command to Copy Formulas.mp4	17.3 MB
009 Using the AutoFill Command to Copy Formulas_en.srt	7.8 KB
/.../05 - Modifying an Excel Worksheet/
001 Moving and Copying Data in an Excel Worksheet.mp4	29.5 MB
001 Moving and Copying Data in an Excel Worksheet_en.srt	11.4 KB
002 Inserting and Deleting Rows and Columns.mp4	30.4 MB
002 Inserting and Deleting Rows and Columns_en.srt	13.3 KB
003 Changing the Width and Height of Cells.mp4	20.5 MB
003 Changing the Width and Height of Cells_en.srt	9.9 KB
004 Hiding and Unhiding Excel Rows and Columns.mp4	21.2 MB
004 Hiding and Unhiding Excel Rows and Columns_en.srt	9.6 KB
005 Renaming an Excel Worksheet.mp4	11.6 MB
005 Renaming an Excel Worksheet_en.srt	5.6 KB
006 Deleting an Excel Worksheet.mp4	19.2 MB
006 Deleting an Excel Worksheet_en.srt	8.4 KB
007 Moving and Copying an Excel Worksheet.mp4	21.5 MB
007 Moving and Copying an Excel Worksheet_en.srt	10.1 KB
/.../06 - Formatting Data in an Excel Worksheet/
001 Working with Font Formatting Commands.mp4	46.7 MB
001 Working with Font Formatting Commands_en.srt	14.4 KB
002 Changing the Background Color of a Cell.mp4	17.4 MB
002 Changing the Background Color of a Cell_en.srt	6.0 KB
003 Adding Borders to Cells.mp4	13.8 MB
003 Adding Borders to Cells_en.srt	4.5 KB
004 Excel Cell Borders Continued.mp4	18.8 MB
004 Excel Cell Borders Continued_en.srt	6.2 KB
005 Formatting Data as Currency Values.mp4	27.4 MB
005 Formatting Data as Currency Values_en.srt	7.8 KB
006 Formatting Percentages.mp4	16.0 MB
006 Formatting Percentages_en.srt	5.6 KB
007 Using Excel's Format Painter.mp4	34.4 MB
007 Using Excel's Format Painter_en.srt	7.7 KB
008 Creating Styles to Format Data.mp4	65.2 MB
008 Creating Styles to Format Data_en.srt	13.6 KB
009 Merging and Centering Cells.mp4	26.6 MB
009 Merging and Centering Cells_en.srt	6.0 KB
010 Using Conditional Formatting.mp4	35.0 MB
010 Using Conditional Formatting_en.srt	8.3 KB
011 Editing Excel Conditional Formatting.mp4	21.6 MB
011 Editing Excel Conditional Formatting_en.srt	5.1 KB
/.../07 - Inserting Images and Shapes into an Excel Worksheet/
001 Inserting Images.mp4	47.8 MB
001 Inserting Images_en.srt	7.5 KB
002 Inserting Excel Shapes.mp4	21.6 MB
002 Inserting Excel Shapes_en.srt	5.1 KB
003 Formatting Excel Shapes.mp4	30.6 MB
003 Formatting Excel Shapes_en.srt	7.9 KB
004 Working with Excel SmartArt.mp4	83.4 MB
004 Working with Excel SmartArt_en.srt	16.7 KB
/.../08 - Creating Basic Charts in Excel/
001 Creating an Excel Column Chart.mp4	39.5 MB
001 Creating an Excel Column Chart_en.srt	6.8 KB
002 Working with the Excel Chart Ribbon.mp4	30.9 MB
002 Working with the Excel Chart Ribbon_en.srt	5.2 KB
003 Adding and Modifying Data on an Excel Chart.mp4	57.3 MB
003 Adding and Modifying Data on an Excel Chart_en.srt	10.0 KB
004 Formatting an Excel Chart.mp4	62.8 MB
004 Formatting an Excel Chart_en.srt	12.1 KB
005 Moving a Chart to another Worksheet.mp4	41.4 MB
005 Moving a Chart to another Worksheet_en.srt	6.6 KB
006 Working with Excel Pie Charts.mp4	74.1 MB
006 Working with Excel Pie Charts_en.srt	12.1 KB
007 Microsoft Excel Charts Quick Guide (DOWNLOAD).html	0.3 KB
007 PresentingDataEffectivelywithExcelCharts-01.pdf	298.7 KB
/.../09 - Printing an Excel Worksheet/
001 Viewing your Document in Print Preview.mp4	38.6 MB
001 Viewing your Document in Print Preview_en.srt	8.2 KB
002 Changing the Margins, Scaling and Orientation.mp4	85.7 MB
002 Changing the Margins, Scaling and Orientation_en.srt	15.3 KB
003 Excel Worksheet Margins.mp4	32.9 MB
003 Excel Worksheet Margins_en.srt	5.8 KB
004 Working with Page Layout View.mp4	44.6 MB
004 Working with Page Layout View_en.srt	6.1 KB
005 Adding Header and Footer Content.mp4	74.8 MB
005 Adding Header and Footer Content_en.srt	11.8 KB
006 Printing a Specific Range of Cells.mp4	33.1 MB
006 Printing a Specific Range of Cells_en.srt	5.8 KB
/.../10 - Working with Excel Templates/
001 Intro to Excel Templates.mp4	41.4 MB
001 Intro to Excel Templates_en.srt	5.7 KB
002 Opening an Existing Template.mp4	110.8 MB
002 Opening an Existing Template_en.srt	16.4 KB
003 Creating a Custom Template.mp4	72.5 MB
003 Creating a Custom Template_en.srt	11.2 KB
/.../11 - Excel 101 - Practice What You've Learned (DOWNLOAD)/
001 Excel 101 - Practice What You've Learned (DOWNLOAD).html	0.3 KB
001 Excel101ExtraPractice-01.xlsx	47.4 KB
/.../12 - Congratulations! You've Built a Solid Microsoft Excel Foundation/
001 Congratulations!.mp4	23.0 MB
001 Congratulations!_en.srt	3.4 KB
/.../13 - Microsoft Excel 102 Course Introduction/
001 Excel 102 Course Exercise Files -- DOWNLOAD.mp4	7.2 MB
001 Excel 102 Course Exercise Files -- DOWNLOAD_en.srt	2.3 KB
001 Excel102Exercises.xlsx	126.5 KB
001 SalesData-TEXT-IMPORT.txt	26.5 KB
NorthwindDB-IMPORT.accdb	3.0 MB
/.../14 - Working with an Excel List/
001 Understanding Excel List Structure.mp4	17.3 MB
001 Understanding Excel List Structure_en.srt	8.4 KB
002 Sorting a List Using Single Level Sort.mp4	11.9 MB
002 Sorting a List Using Single Level Sort_en.srt	5.4 KB
003 Sorting a List Using Multi-Level Sorts.mp4	13.7 MB
003 Sorting a List Using Multi-Level Sorts_en.srt	5.1 KB
004 Using Custom Sorts in an Excel List.mp4	14.5 MB
004 Using Custom Sorts in an Excel List_en.srt	6.5 KB
005 Filter an Excel List Using the AutoFilter Tool.mp4	15.0 MB
005 Filter an Excel List Using the AutoFilter Tool_en.srt	7.2 KB
006 Creating Subtotals in a List.mp4	28.2 MB
006 Creating Subtotals in a List_en.srt	10.2 KB
007 Format a List as a Table.mp4	32.2 MB
007 Format a List as a Table_en.srt	11.4 KB
008 Using Conditional Formatting to Find Duplicates.mp4	15.9 MB
008 Using Conditional Formatting to Find Duplicates_en.srt	5.4 KB
009 Removing Duplicates.mp4	16.0 MB
009 Removing Duplicates_en.srt	5.9 KB
/.../15 - Excel List Functions/
001 Introduction to Excels Function DSUM().mp4	42.1 MB
001 Introduction to Excels Function DSUM()_en.srt	9.7 KB
002 Excel DSUM Function Single Criteria Continued.mp4	37.2 MB
002 Excel DSUM Function Single Criteria Continued_en.srt	7.1 KB
003 Excel DSUM Function with OR Criteria.mp4	18.8 MB
003 Excel DSUM Function with OR Criteria_en.srt	3.8 KB
004 Excel DSUM Function with AND Criteria.mp4	41.4 MB
004 Excel DSUM Function with AND Criteria_en.srt	10.1 KB
005 Excel Function DAVERAGE().mp4	36.0 MB
005 Excel Function DAVERAGE()_en.srt	8.4 KB
006 Excel Function DCOUNT().mp4	48.9 MB
006 Excel Function DCOUNT()_en.srt	11.2 KB
007 Excel Function SUBTOTAL().mp4	62.2 MB
007 Excel Function SUBTOTAL()_en.srt	13.4 KB
/.../16 - Excel Data Validation/
001 Understanding the Need for Excel Data Validation.mp4	34.2 MB
001 Understanding the Need for Excel Data Validation_en.srt	9.3 KB
002 Creating an Excel Data Validation List.mp4	39.5 MB
002 Creating an Excel Data Validation List_en.srt	9.6 KB
003 Excel Decimal Data Validation.mp4	30.0 MB
003 Excel Decimal Data Validation_en.srt	7.1 KB
004 Adding a Custom Excel Data Validation Error.mp4	34.2 MB
004 Adding a Custom Excel Data Validation Error_en.srt	9.0 KB
005 Dynamic Formulas by Using Excel Data Validation Techniques.mp4	36.3 MB
005 Dynamic Formulas by Using Excel Data Validation Techniques_en.srt	8.1 KB
/.../17 - Importing and Exporting Data/
001 Importing Data Into Microsoft Excel.mp4	8.6 MB
001 Importing Data Into Microsoft Excel_en.srt	3.1 KB
002 Importing Data from Text Files.mp4	14.5 MB
002 Importing Data from Text Files_en.srt	8.1 KB
003 Importing Data from Microsoft Access.mp4	12.9 MB
003 Importing Data from Microsoft Access_en.srt	6.1 KB
004 NEW VERSION -- Import Data From Text Files into Excel.mp4	56.2 MB
004 NEW VERSION -- Import Data From Text Files into Excel_en.srt	14.3 KB
005 NEW VERSION -- Import Data From a Database into Excel.mp4	48.0 MB
005 NEW VERSION -- Import Data From a Database into Excel_en.srt	11.8 KB
006 Microsoft Excel Legacy Import Options for New Excel Versions.mp4	14.6 MB
006 Microsoft Excel Legacy Import Options for New Excel Versions_en.srt	3.5 KB
007 Exporting Data to a Text File.mp4	48.7 MB
007 Exporting Data to a Text File_en.srt	11.7 KB
/.../18 - Excel PivotTables/
001 Understanding Excel PivotTables.mp4	88.5 MB
001 Understanding Excel PivotTables_en.srt	6.9 KB
002 Creating an Excel PivotTable.mp4	151.0 MB
002 Creating an Excel PivotTable_en.srt	12.6 KB
003 Modifying Excel PivotTable Calculations.mp4	41.7 MB
003 Modifying Excel PivotTable Calculations_en.srt	10.6 KB
004 Grouping PivotTable Data.mp4	21.5 MB
004 Grouping PivotTable Data_en.srt	14.7 KB
005 Formatting PivotTable Data.mp4	23.7 MB
005 Formatting PivotTable Data_en.srt	6.7 KB
006 Modifying PivotTable Calculations.mp4	31.5 MB
006 Modifying PivotTable Calculations_en.srt	15.6 KB
007 Drilling Down into PivotTable Data.mp4	62.9 MB
007 Drilling Down into PivotTable Data_en.srt	7.2 KB
008 Creating PivotCharts.mp4	50.0 MB
008 Creating PivotCharts_en.srt	7.1 KB
009 Filtering PivotTable Data.mp4	13.8 MB
009 Filtering PivotTable Data_en.srt	5.5 KB
010 Filtering with the Slicer Tool.mp4	23.6 MB
010 Filtering with the Slicer Tool_en.srt	5.5 KB
/.../20 - Working with Large Sets of Excel Data/
001 Using the Freeze Panes Tool.mp4	18.0 MB
001 Using the Freeze Panes Tool_en.srt	5.5 KB
002 Grouping Data (Columns andor Rows).mp4	19.9 MB
002 Grouping Data (Columns andor Rows)_en.srt	5.9 KB
003 Print Options for Large Sets of Data.mp4	33.5 MB
003 Print Options for Large Sets of Data_en.srt	11.2 KB
004 Linking Worksheets (3D Formulas).mp4	9.6 MB
004 Linking Worksheets (3D Formulas)_en.srt	5.4 KB
005 Consolidating Data from Multiple Worksheets.mp4	14.9 MB
005 Consolidating Data from Multiple Worksheets_en.srt	7.6 KB
006 ManagingAndSummarizingLargeExcelDatasets-01.pdf	278.6 KB
006 Microsoft Excel Managing Large Excel Datasets Quick Guide (DOWNLOAD).html	0.3 KB
/.../21 - Excel 102 Additional Practice Exercises/
001 COMPLETED-Excel102ExtraPractice-01.xlsx	265.1 KB
001 Excel 102 - Practice What You've Learned (DOWNLOAD).html	0.3 KB
001 Excel102ExtraPractice-01.xlsx	249.8 KB
/.../22 - Congratulations! You're an Intermediate Excel User/
001 Congratulations!.mp4	20.0 MB
001 Congratulations!_en.srt	2.3 KB
/.../23 - Microsoft Excel 103 Course Introduction/
001 Excel 103 Course Exercise Files -- DOWNLOAD.mp4	11.6 MB
001 Excel 103 Course Exercise Files -- DOWNLOAD_en.srt	2.5 KB
001 Excel103-AdvancedExercises.xlsx	65.1 KB
/.../24 - Working with Excel's Conditional Functions/
001 Working with Excel Name Ranges.mp4	22.3 MB
001 Working with Excel Name Ranges_en.srt	7.9 KB
002 Advantages and Disadvantages of Excel Name Ranges.mp4	31.0 MB
002 Advantages and Disadvantages of Excel Name Ranges_en.srt	10.1 KB
003 Editing an Excel Name Range.mp4	13.8 MB
003 Editing an Excel Name Range_en.srt	4.7 KB
004 Using Excel's IF() Function.mp4	27.6 MB
004 Using Excel's IF() Function_en.srt	9.0 KB
005 Excel's IF() Function with a Name Range.mp4	27.3 MB
005 Excel's IF() Function with a Name Range_en.srt	9.1 KB
006 Nesting Functions with Excel.mp4	48.4 MB
006 Nesting Functions with Excel_en.srt	12.9 KB
007 Nesting Excels AND() Function within the IF() Function.mp4	25.0 MB
007 Nesting Excels AND() Function within the IF() Function_en.srt	7.5 KB
008 Using Excel's COUNTIF() Function.mp4	13.4 MB
008 Using Excel's COUNTIF() Function_en.srt	4.2 KB
009 Using Excel's SUMIF() Function.mp4	48.0 MB
009 Using Excel's SUMIF() Function_en.srt	10.7 KB
010 Using Excel's IFERROR() Function.mp4	31.8 MB
010 Using Excel's IFERROR() Function_en.srt	7.9 KB
/.../25 - Working with Excel's Lookup Functions/
001 Microsoft Excel VLOOKUP() Function.mp4	56.1 MB
001 Microsoft Excel VLOOKUP() Function_en.srt	17.5 KB
002 Microsoft Excel HLOOKUP() Function.mp4	28.6 MB
002 Microsoft Excel HLOOKUP() Function_en.srt	9.7 KB
003 Microsoft Excel INDEX() Function.mp4	54.9 MB
003 Microsoft Excel INDEX() Function_en.srt	15.9 KB
004 Microsoft Excel MATCH() Function.mp4	28.0 MB
004 Microsoft Excel MATCH() Function_en.srt	8.3 KB
005 Microsoft Excel INDEX() and MATCH() Function Combined.mp4	41.9 MB
005 Microsoft Excel INDEX() and MATCH() Function Combined_en.srt	11.6 KB
006 Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4	49.4 MB
006 Microsoft Excel INDEX() and MATCH() Function Combined Continued_en.srt	14.9 KB
007 Creating a Dynamic HLOOKUP() with the MATCH() Function.mp4	40.1 MB
007 Creating a Dynamic HLOOKUP() with the MATCH() Function_en.srt	12.3 KB
/.../26 - Working with Excel's Text Based Functions/
001 Using Excel's LEFT(), RIGHT() and MID() Functions.mp4	21.4 MB
001 Using Excel's LEFT(), RIGHT() and MID() Functions_en.srt	8.9 KB
002 Using Excel's LEN() Function.mp4	27.4 MB
002 Using Excel's LEN() Function_en.srt	8.7 KB
003 Using Excel's SEARCH() Function.mp4	31.4 MB
003 Using Excel's SEARCH() Function_en.srt	17.6 KB
004 Using Excel's CONCATENATE() Function.mp4	8.6 MB
004 Using Excel's CONCATENATE() Function_en.srt	4.2 KB
005 MasterExcelAdvancedFunctionsFormulas-01.pdf	243.7 KB
005 Microsoft Excel Adv. Functions and Formulas Quick Guide (DOWNLOAD).html	0.3 KB
/.../27 - Auditing an Excel Worksheet/
001 Tracing Precedents in Excel Formulas.mp4	11.7 MB
001 Tracing Precedents in Excel Formulas_en.srt	5.7 KB
002 Tracing Dependents in Excel Formulas.mp4	8.4 MB
002 Tracing Dependents in Excel Formulas_en.srt	3.9 KB
003 Working with the Watch Window.mp4	11.8 MB
003 Working with the Watch Window_en.srt	5.8 KB
004 Showing Formulas.mp4	9.8 MB
004 Showing Formulas_en.srt	4.3 KB
/.../28 - Protecting Excel Worksheets and Workbooks/
001 Protecting Specific Cells in a Worksheet.mp4	26.0 MB
001 Protecting Specific Cells in a Worksheet_en.srt	11.4 KB
002 Protecting the Structure of a Workbook.mp4	9.8 MB
002 Protecting the Structure of a Workbook_en.srt	5.6 KB
003 Adding a Workbook Password.mp4	12.3 MB
003 Adding a Workbook Password_en.srt	4.4 KB
/.../29 - Mastering Excel's What If Tools/
001 Working with Excel's Goal Seek Tool.mp4	19.4 MB
001 Working with Excel's Goal Seek Tool_en.srt	11.2 KB
002 Working with Excel's Solver Tool.mp4	63.1 MB
002 Working with Excel's Solver Tool_en.srt	19.4 KB
003 Building Effective Data Tables in Excel.mp4	15.0 MB
003 Building Effective Data Tables in Excel_en.srt	7.9 KB
004 Creating Scenarios in Excel.mp4	23.9 MB
004 Creating Scenarios in Excel_en.srt	11.0 KB
/.../30 - Automating Repetitive Tasks in Excel with Macros/
001 Understanding Excel Macros.mp4	12.0 MB
001 Understanding Excel Macros_en.srt	5.3 KB
002 Activating the Developer Tab in Excel.mp4	6.4 MB
002 Activating the Developer Tab in Excel_en.srt	2.1 KB
003 Creating a Macro with the Macro Recorder.mp4	28.6 MB
003 Creating a Macro with the Macro Recorder_en.srt	11.4 KB
004 Editing a Macro with VBA.mp4	17.8 MB
004 Editing a Macro with VBA_en.srt	7.7 KB
005 Creating Buttons to Run Macros.mp4	11.0 MB
005 Creating Buttons to Run Macros_en.srt	4.6 KB
/.../31 - Excel 103 Additional Practice Exercises/
001 COMPLETED-Excel103ExtraPractice-01.xlsx	97.5 KB
001 Excel 103 - Practice What You've Learned (DOWNLOAD).html	0.3 KB
001 Excel103ExtraPractice-01.xlsx	94.8 KB
/course-material/32 - Congratulations!/
001 Congratulations on Completing the Microsoft Excel 103.mp4	21.0 MB
001 Congratulations on Completing the Microsoft Excel 103_en.srt	2.7 KB
/.../33 - Microsoft Excel Macros and VBA Course Introduction/
001 Welcome to the Course.mp4	27.3 MB
001 Welcome to the Course_en.srt	11.1 KB
002 Understanding the Why and How Behind Excel Macros.mp4	24.4 MB
002 Understanding the Why and How Behind Excel Macros_en.srt	9.2 KB
/.../34 - Project #1 Using Excel's Macro Recorder Tool/
001 Introduction to Project #1 Inserting and Formatting Text.mp4	32.7 MB
001 Introduction to Project #1 Inserting and Formatting Text_en.srt	6.4 KB
002 COM-InsertingAndFormattingText.xlsm	20.5 KB
002 InsertingAndFormattingText.xlsx	11.7 KB
002 Project #1 Section Exercise Files (DOWNLOAD).html	0.5 KB
003 Activating the Excel Developer Tab.mp4	19.5 MB
003 Activating the Excel Developer Tab_en.srt	4.0 KB
004 InsertingAndFormattingText.xlsx	17.8 KB
004 Project #1 Start Recording!.mp4	92.0 MB
004 Project #1 Start Recording!_en.srt	19.0 KB
005 Running a Microsoft Excel Macro.mp4	35.7 MB
005 Running a Microsoft Excel Macro_en.srt	7.5 KB
006 Project #1 Running an Excel Macro with a Button.mp4	51.1 MB
006 Project #1 Running an Excel Macro with a Button_en.srt	10.0 KB
007 BONUS - Create a Custom Button Using Excel Shapes.mp4	37.3 MB
007 BONUS - Create a Custom Button Using Excel Shapes_en.srt	7.4 KB
008 Adding the Excel Macro to the Quick Access Toolbar.mp4	35.6 MB
008 Adding the Excel Macro to the Quick Access Toolbar_en.srt	8.0 KB
009 Project #1 Editing the VBA Recorded by the Macro Recorder.mp4	127.0 MB
009 Project #1 Editing the VBA Recorded by the Macro Recorder_en.srt	21.1 KB
010 Save a Workbook with a MacroVBA Code.mp4	22.7 MB
010 Save a Workbook with a MacroVBA Code_en.srt	3.7 KB
011 Practical Uses of Excel Macros.mp4	28.6 MB
011 Practical Uses of Excel Macros_en.srt	4.1 KB
/.../35 - Excel VBA Concepts/
001 Intro to Excel VBA Concepts.mp4	44.4 MB
001 Intro to Excel VBA Concepts_en.srt	11.3 KB
002 Intro to Excel VBA Object Oriented Programming Concepts.mp4	31.6 MB
002 Intro to Excel VBA Object Oriented Programming Concepts_en.srt	7.7 KB
003 COM-IntroToExcelVBACode-01.xlsm	15.7 KB
003 ExcelMacrosAndVBA-PP.pptx	270.6 KB
003 Intro to Excel VBA Exercise Files (DOWNLOAD).html	0.5 KB
004 The Visual Basic Editor (VBE).mp4	31.8 MB
004 The Visual Basic Editor (VBE)_en.srt	8.9 KB
005 Introduction to the Excel VBA Immediate Window.mp4	100.1 MB
005 Introduction to the Excel VBA Immediate Window_en.srt	20.5 KB
006 Excel VBA Modules.mp4	23.1 MB
006 Excel VBA Modules_en.srt	6.2 KB
007 Creating an Excel VBA Procedure.mp4	39.4 MB
007 Creating an Excel VBA Procedure_en.srt	11.4 KB
008 Adding Code to a VBA Procedure.mp4	35.9 MB
008 Adding Code to a VBA Procedure_en.srt	7.8 KB
009 Including Excel VBA Comments.mp4	17.9 MB
009 Including Excel VBA Comments_en.srt	4.6 KB
010 Excel VBA MSGBOX Function.mp4	57.5 MB
010 Excel VBA MSGBOX Function_en.srt	12.2 KB
011 Excel VBA MsgBox Microsoft Help Information.mp4	28.3 MB
011 Excel VBA MsgBox Microsoft Help Information_en.srt	3.3 KB
012 Understanding and Working with Excel VBA Variables.mp4	148.6 MB
012 Understanding and Working with Excel VBA Variables_en.srt	26.0 KB
013 REMINDER Saving an Excel Workbook with VBA Code.mp4	19.5 MB
013 REMINDER Saving an Excel Workbook with VBA Code_en.srt	4.0 KB
/.../36 - Working with Excel VBA Logic Statements/
001 COM-ExcelVBALoops.xlsm	16.5 KB
001 ExcelVBALoops.xlsx	9.2 KB
001 Working with Excel VBA Logic Exercise Files (DOWNLOAD).html	0.5 KB
002 Building Logic with an Excel VBA IF Statement.mp4	55.1 MB
002 Building Logic with an Excel VBA IF Statement_en.srt	14.2 KB
003 Including an Else Statement in the VBA IF Statement.mp4	10.6 MB
003 Including an Else Statement in the VBA IF Statement_en.srt	2.3 KB
004 Expanding the IF Logic with Multiple ElseIf Statements.mp4	19.9 MB
004 Expanding the IF Logic with Multiple ElseIf Statements_en.srt	5.1 KB
005 Working with Excel VBA Select Case Statements.mp4	32.7 MB
005 Working with Excel VBA Select Case Statements_en.srt	8.1 KB
006 Working with an Excel VBA Do While Loop.mp4	79.0 MB
006 Working with an Excel VBA Do While Loop_en.srt	19.2 KB
007 Excel VBA Do While Loop Dynamic Condition.mp4	39.2 MB
007 Excel VBA Do While Loop Dynamic Condition_en.srt	10.5 KB
008 Working with an Excel VBA For Each Loop.mp4	41.5 MB
008 Working with an Excel VBA For Each Loop_en.srt	10.0 KB
009 Working with an Excel VBA For Next Loop.mp4	51.1 MB
009 Working with an Excel VBA For Next Loop_en.srt	12.9 KB
/.../37 - Project #2 Moving Beyond the Basics and into VBA/
001 Introduction to Project #2 Interacting with the User.mp4	17.5 MB
001 Introduction to Project #2 Interacting with the User_en.srt	4.0 KB
002 Beyond the Basics Sort Project Exercise Files (DOWNLOAD).html	0.5 KB
002 COM-SortingRecords.xlsm	22.8 KB
002 SortingRecords.xlsx	11.4 KB
003 Project #2 Introduction to the Excel VBA Range.Sort Method.mp4	30.0 MB
003 Project #2 Introduction to the Excel VBA Range.Sort Method_en.srt	8.3 KB
003 SortingRecords.xlsm	17.1 KB
004 Creating the Excel VBA Sort Procedures for this Project.mp4	101.0 MB
004 Creating the Excel VBA Sort Procedures for this Project_en.srt	16.1 KB
005 Project #2 Prompting the User for Information.mp4	89.5 MB
005 Project #2 Prompting the User for Information_en.srt	17.5 KB
006 Continue Excel VBA InputBox.mp4	79.4 MB
006 Continue Excel VBA InputBox_en.srt	15.2 KB
007 Project #2 Building Logic into Your Macros.mp4	45.5 MB
007 Project #2 Building Logic into Your Macros_en.srt	7.2 KB
008 Project #2 Alerting the User of Errors.mp4	97.8 MB
008 Project #2 Alerting the User of Errors_en.srt	17.5 KB
009 Using Excel VBA Error Control Statements.mp4	47.5 MB
009 Using Excel VBA Error Control Statements_en.srt	7.8 KB
010 Create a Button to Run the Sort Procedure and Save.mp4	20.1 MB
010 Create a Button to Run the Sort Procedure and Save_en.srt	4.1 KB
/.../38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/
001 Introduction to Project #3 Cleaning Up and Formatting Data.mp4	23.1 MB
001 Introduction to Project #3 Cleaning Up and Formatting Data_en.srt	4.1 KB
002 CleaningUpData.xlsx	15.9 KB
002 COM-CleaningUpData-01.xlsm	28.7 KB
002 Project #3 Exercise Files (DOWNLOAD).html	0.5 KB
003 Project #3 Preparing to the Use the Macro Recorder.mp4	25.4 MB
003 Project #3 Preparing to the Use the Macro Recorder_en.srt	5.5 KB
004 Project #3 Inserting the Headers.mp4	41.6 MB
004 Project #3 Inserting the Headers_en.srt	8.8 KB
005 Project #3 Formatting the Headers.mp4	39.1 MB
005 Project #3 Formatting the Headers_en.srt	7.4 KB
006 Project #3 Testing the Macros.mp4	21.0 MB
006 Project #3 Testing the Macros_en.srt	4.5 KB
007 Project #3 Using an Excel VBA Loop to Loop through all Worksheets.mp4	89.4 MB
007 Project #3 Using an Excel VBA Loop to Loop through all Worksheets_en.srt	16.5 KB
008 Project #3 Testing the Excel VBA Loop.mp4	29.2 MB
008 Project #3 Testing the Excel VBA Loop_en.srt	5.8 KB
009 Project #3 Adding Logic to an Excel VBA Loop.mp4	76.6 MB
009 Project #3 Adding Logic to an Excel VBA Loop_en.srt	12.2 KB
/.../39 - Project #4 Using VBA to Automate Excel Formulas/
001 Introduction to Project #4 Automate Excel Formulas.mp4	16.7 MB
001 Introduction to Project #4 Automate Excel Formulas_en.srt	3.1 KB
002 AutomateSumFunction.xlsx	15.6 KB
002 COM-AutomateSumFunction-01.xlsm	23.1 KB
002 Project #4 Automate Sum Function Exercise Files (DOWNLOAD).html	0.5 KB
003 AutomateSumFunction.xlsx	20.3 KB
003 Project #4 Start the Procedure to Automate the SUM Function.mp4	72.8 MB
003 Project #4 Start the Procedure to Automate the SUM Function_en.srt	10.7 KB
004 Working with the Range Address Property.mp4	43.7 MB
004 Working with the Range Address Property_en.srt	8.6 KB
005 Creating the SUM Function in VBA.mp4	61.0 MB
005 Creating the SUM Function in VBA_en.srt	9.4 KB
006 Run the Excel VBA Procedure to SUM Records.mp4	29.6 MB
006 Run the Excel VBA Procedure to SUM Records_en.srt	4.7 KB
007 Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4	53.7 MB
007 Project #4 Loop the SUM() Function Over Multiple Worksheets_en.srt	9.4 KB
/.../40 - Project #5 Bringing it All Together and a Weekly Report/
001 Introduction to Project #5 Creating the Final Report.mp4	22.0 MB
001 Introduction to Project #5 Creating the Final Report_en.srt	3.4 KB
002 COM-QuarterlyReport-01.xlsm	35.1 KB
002 Project #5 Final Report Loop Exercise Files (DOWNLOAD).html	0.5 KB
002 QuarterlyReport.xlsm	23.6 KB
003 Project #5 Creating the Final Report Excel VBA Loop.mp4	53.5 MB
003 Project #5 Creating the Final Report Excel VBA Loop_en.srt	8.2 KB
004 Project #5 - Copying Content with Excel VBA.mp4	54.5 MB
004 Project #5 - Copying Content with Excel VBA_en.srt	9.8 KB
005 Project #5 - Pasting Content with Excel VBA.mp4	53.0 MB
005 Project #5 - Pasting Content with Excel VBA_en.srt	8.0 KB
006 Cleaning Up the Final Report VBA Loop Code.mp4	50.8 MB
006 Cleaning Up the Final Report VBA Loop Code_en.srt	8.2 KB
007 Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet.mp4	49.6 MB
007 Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet_en.srt	9.5 KB
008 Project #5 - Running the Final Report Procedure.mp4	23.5 MB
008 Project #5 - Running the Final Report Procedure_en.srt	3.8 KB
/.../41 - Project #6 Working with Excel VBA User Forms/
001 Introduction to Project #6 Working with Excel VBA User Forms.mp4	15.8 MB
001 Introduction to Project #6 Working with Excel VBA User Forms_en.srt	5.3 KB
001 QuarterlyReportForm-01.xlsm	25.1 KB
002 COM-QuarterlyReportForm-01.xlsm	45.5 KB
002 Project #6 Working with Excel VBA User Forms Exercise Files (DOWNLOAD).html	0.5 KB
002 QuarterlyReportForm-01.xlsm	32.4 KB
003 Project #6 Creating an Excel User Form.mp4	50.5 MB
003 Project #6 Creating an Excel User Form_en.srt	9.9 KB
004 Project #6 Working with Form and Control Properties.mp4	52.1 MB
004 Project #6 Working with Form and Control Properties_en.srt	11.4 KB
005 Project #6 Formatting Excel VBA User Form Controls.mp4	28.7 MB
005 Project #6 Formatting Excel VBA User Form Controls_en.srt	6.2 KB
006 Project #6 Adding VBA Code to the Initialize Event.mp4	85.3 MB
006 Project #6 Adding VBA Code to the Initialize Event_en.srt	15.6 KB
007 Project #6 Using the AddItem Method within a Loop.mp4	90.2 MB
007 Project #6 Using the AddItem Method within a Loop_en.srt	16.0 KB
008 Project #6 Adding VBA Code to the ComboBox Change Event.mp4	36.6 MB
008 Project #6 Adding VBA Code to the ComboBox Change Event_en.srt	6.4 KB
009 Project #6 Adding VBA Code to the Add Worksheet Button.mp4	31.0 MB
009 Project #6 Adding VBA Code to the Add Worksheet Button_en.srt	6.6 KB
010 Project #6 Change Worksheet Name.mp4	26.7 MB
010 Project #6 Change Worksheet Name_en.srt	5.8 KB
011 Project #6 Catch Errors When Adding a Worksheet.mp4	23.6 MB
011 Project #6 Catch Errors When Adding a Worksheet_en.srt	4.8 KB
012 Add Sheet Procedure Catch Errors.html	1.2 KB
012 AddSheetError-Solution-01.txt	0.9 KB
013 Project #6 Additional Conditions on the Loop.mp4	58.9 MB
013 Project #6 Additional Conditions on the Loop_en.srt	9.7 KB
014 Project #6 Running the Final Report Procedure.mp4	32.3 MB
014 Project #6 Running the Final Report Procedure_en.srt	5.5 KB
015 Project #6 Showing the VBA User Form On Workbook Open.mp4	39.6 MB
015 Project #6 Showing the VBA User Form On Workbook Open_en.srt	6.5 KB
/.../42 - Project #7 Importing Data from Text Files/
001 April2015Sales.txt	1.8 KB
001 Dec2015Sales.txt	1.2 KB
001 Feb2015Sales.txt	1.2 KB
001 Jan2015Sales.txt	1.3 KB
001 Mar2015Sales.txt	1.2 KB
001 May2015Sales.txt	1.3 KB
001 Nov2015Sales.txt	1.3 KB
001 Project #7 Opening a Text File for Import.mp4	8.9 MB
001 Project #7 Opening a Text File for Import_en.srt	4.8 KB
002 Project #7 Opening a Text File for Import.mp4	17.8 MB
002 Project #7 Opening a Text File for Import_en.srt	11.6 KB
003 Project #7 Get Data from Text File.mp4	12.8 MB
003 Project #7 Get Data from Text File_en.srt	9.9 KB
004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4	23.7 MB
004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method_en.srt	15.6 KB
005 Project #7 Creating a Loop to Read Each File.mp4	22.1 MB
005 Project #7 Creating a Loop to Read Each File_en.srt	13.9 KB
006 Project #7 Adding a New Sheet for Imported Data.mp4	10.0 MB
006 Project #7 Adding a New Sheet for Imported Data_en.srt	4.3 KB
007 Project #7 Clear the Clipboard.mp4	11.9 MB
007 Project #7 Clear the Clipboard_en.srt	6.2 KB
008 Project #7 Working with the ScreenUpdating Property.mp4	11.9 MB
008 Project #7 Working with the ScreenUpdating Property_en.srt	6.4 KB
009 Project #7 Creating Reusable Code with a VBA Function.mp4	23.2 MB
009 Project #7 Creating Reusable Code with a VBA Function_en.srt	13.2 KB
/.../43 - Course Wrap Up/
001 Congratulations! You're an Excel MacroVBA Master.mp4	12.4 MB
001 Congratulations! You're an Excel MacroVBA Master_en.srt	1.3 KB
Total files 555