GetFreeCourses Co Udemy Microsoft Excel from Beginner to Advanced

GetFreeCourses Co Udemy Microsoft Excel from Beginner to Advanced

Name	GetFreeCourses.Co-Udemy-Microsoft Excel - Excel from Beginner to Advanced	DOWNLOAD Copy Link
Total Size	13.4 GB
Total Files	485
Last Seen	2024-07-20 23:44
Hash	1A992D5EF2FDE5E1F4E0062BDCFB0764D08BE58C

/01 - Microsoft Excel 101 Course Introduction/
001 Ask Questions.mp4	39.9 MB
001 Ask Questions_en.srt	2.7 KB
002 Course Exercise Files.mp4	12.7 MB
002 Course Exercise Files_en.srt	2.3 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	11.3 MB
003 Certificate of Completion_en.srt	1.9 KB
/02 - Microsoft Excel Fundamentals/
001 Launching Excel.mp4	14.2 MB
001 Launching Excel_en.srt	2.9 KB
002 Microsoft Excel Startup Screen.mp4	57.3 MB
002 Microsoft Excel Startup Screen_en.srt	5.1 KB
003 Introduction to the Excel Interface.mp4	50.2 MB
003 Introduction to the Excel Interface_en.srt	11.8 KB
004 Customizing the Excel Quick Access Toolbar.mp4	23.6 MB
004 Customizing the Excel Quick Access Toolbar_en.srt	4.7 KB
005 More on the Excel Interface.mp4	54.1 MB
005 More on the Excel Interface_en.srt	5.9 KB
006 Understanding the Structure of an Excel Workbook.mp4	21.7 MB
006 Understanding the Structure of an Excel Workbook_en.srt	6.5 KB
007 Saving an Excel Document.mp4	71.2 MB
007 Saving an Excel Document_en.srt	6.5 KB
008 Opening an Existing Excel Document.mp4	40.8 MB
008 Opening an Existing Excel Document_en.srt	2.6 KB
009 Common Excel Shortcut Keys.mp4	19.3 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	62.6 MB
001 Entering Text to Create Spreadsheet Titles_en.srt	13.9 KB
002 Working with Numeric Data in Excel.mp4	65.3 MB
002 Working with Numeric Data in Excel_en.srt	13.2 KB
003 Entering Date Values in Excel.mp4	66.1 MB
003 Entering Date Values in Excel_en.srt	14.4 KB
004 Working with Cell References.mp4	100.1 MB
004 Working with Cell References_en.srt	9.2 KB
005 Creating Basic Formulas in Excel.mp4	45.7 MB
005 Creating Basic Formulas in Excel_en.srt	13.8 KB
006 Relative Versus Absolute Cell References in Formulas.mp4	93.3 MB
006 Relative Versus Absolute Cell References in Formulas_en.srt	18.0 KB
007 OrderOfOperation-01.xlsx	9.5 KB
007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4	54.5 MB
007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)_en.srt	16.1 KB
/04 - Working with Basic Excel Functions/
001 EXCEL-FUNCTIONS.pptx	89.2 KB
001 The structure of an Excel Function.mp4	37.3 MB
001 The structure of an Excel Function_en.srt	16.3 KB
002 Working with the SUM() Function.mp4	51.5 MB
002 Working with the SUM() Function_en.srt	11.6 KB
003 Working with the MIN() and MAX() Functions.mp4	34.1 MB
003 Working with the MIN() and MAX() Functions_en.srt	10.3 KB
004 Working with the AVERAGE() Function.mp4	15.6 MB
004 Working with the AVERAGE() Function_en.srt	4.4 KB
005 Working with the COUNT() Function.mp4	15.8 MB
005 Working with the COUNT() Function_en.srt	4.5 KB
006 Adjacent Cells Error in Excel Calculations.mp4	27.4 MB
006 Adjacent Cells Error in Excel Calculations_en.srt	6.6 KB
007 Using the AutoSum Command.mp4	50.8 MB
007 Using the AutoSum Command_en.srt	11.2 KB
008 Excel's AutoSum Shortcut Key.mp4	16.7 MB
008 Excel's AutoSum Shortcut Key_en.srt	3.7 KB
009 Using the AutoFill Command to Copy Formulas.mp4	33.1 MB
009 Using the AutoFill Command to Copy Formulas_en.srt	7.2 KB
/05 - Modifying an Excel Worksheet/
001 Moving and Copying Data in an Excel Worksheet.mp4	62.7 MB
001 Moving and Copying Data in an Excel Worksheet_en.srt	10.0 KB
002 Inserting and Deleting Rows and Columns.mp4	40.1 MB
002 Inserting and Deleting Rows and Columns_en.srt	11.6 KB
003 Changing the Width and Height of Cells.mp4	29.0 MB
003 Changing the Width and Height of Cells_en.srt	8.4 KB
004 Hiding and Unhiding Excel Rows and Columns.mp4	39.1 MB
004 Hiding and Unhiding Excel Rows and Columns_en.srt	8.6 KB
005 Renaming an Excel Worksheet.mp4	21.5 MB
005 Renaming an Excel Worksheet_en.srt	4.7 KB
006 Deleting an Excel Worksheet.mp4	43.9 MB
006 Deleting an Excel Worksheet_en.srt	7.4 KB
007 Moving and Copying an Excel Worksheet.mp4	40.0 MB
007 Moving and Copying an Excel Worksheet_en.srt	8.4 KB
/06 - Formatting Data in an Excel Worksheet/
001 Working with Font Formatting Commands.mp4	61.9 MB
001 Working with Font Formatting Commands_en.srt	12.0 KB
002 Changing the Background Color of a Cell.mp4	26.2 MB
002 Changing the Background Color of a Cell_en.srt	5.2 KB
003 Adding Borders to Cells.mp4	20.2 MB
003 Adding Borders to Cells_en.srt	3.9 KB
004 Excel Cell Borders Continued.mp4	27.1 MB
004 Excel Cell Borders Continued_en.srt	5.1 KB
005 Formatting Data as Currency Values.mp4	37.9 MB
005 Formatting Data as Currency Values_en.srt	6.9 KB
006 Formatting Percentages.mp4	24.0 MB
006 Formatting Percentages_en.srt	4.5 KB
007 Using Excel's Format Painter.mp4	36.6 MB
007 Using Excel's Format Painter_en.srt	6.7 KB
008 Creating Styles to Format Data.mp4	166.0 MB
008 Creating Styles to Format Data_en.srt	12.5 KB
009 Merging and Centering Cells.mp4	29.5 MB
009 Merging and Centering Cells_en.srt	5.2 KB
010 Using Conditional Formatting.mp4	39.6 MB
010 Using Conditional Formatting_en.srt	7.2 KB
011 Editing Excel Conditional Formatting.mp4	22.2 MB
011 Editing Excel Conditional Formatting_en.srt	4.2 KB
/07 - Inserting Images and Shapes into an Excel Worksheet/
001 Inserting Images.mp4	91.3 MB
001 Inserting Images_en.srt	6.7 KB
002 Inserting Excel Shapes.mp4	22.5 MB
002 Inserting Excel Shapes_en.srt	4.6 KB
003 Formatting Excel Shapes.mp4	32.8 MB
003 Formatting Excel Shapes_en.srt	6.8 KB
004 Working with Excel SmartArt.mp4	99.9 MB
004 Working with Excel SmartArt_en.srt	15.4 KB
Download Paid Udemy Courses For Free.url	0.1 KB
How can you help GFC.txt	0.3 KB
/08 - Creating Basic Charts in Excel/
001 Creating an Excel Column Chart.mp4	31.6 MB
001 Creating an Excel Column Chart_en.srt	5.8 KB
002 Working with the Excel Chart Ribbon.mp4	25.3 MB
002 Working with the Excel Chart Ribbon_en.srt	4.4 KB
003 Adding and Modifying Data on an Excel Chart.mp4	49.8 MB
003 Adding and Modifying Data on an Excel Chart_en.srt	8.9 KB
004 Formatting an Excel Chart.mp4	60.8 MB
004 Formatting an Excel Chart_en.srt	11.4 KB
005 Moving a Chart to another Worksheet.mp4	33.5 MB
005 Moving a Chart to another Worksheet_en.srt	5.6 KB
006 Working with Excel Pie Charts.mp4	66.1 MB
006 Working with Excel Pie Charts_en.srt	11.4 KB
/09 - Printing an Excel Worksheet/
001 Viewing your Document in Print Preview.mp4	24.2 MB
001 Viewing your Document in Print Preview_en.srt	6.5 KB
002 Changing the Margins, Scaling and Orientation.mp4	370.5 MB
002 Changing the Margins, Scaling and Orientation_en.srt	13.2 KB
003 Excel Worksheet Margins.mp4	27.7 MB
003 Excel Worksheet Margins_en.srt	4.7 KB
004 Working with Page Layout View.mp4	41.2 MB
004 Working with Page Layout View_en.srt	5.0 KB
005 Adding Header and Footer Content.mp4	133.6 MB
005 Adding Header and Footer Content_en.srt	9.4 KB
006 Printing a Specific Range of Cells.mp4	134.7 MB
006 Printing a Specific Range of Cells_en.srt	5.0 KB
/10 - Working with Excel Templates/
001 Intro to Excel Templates.mp4	30.3 MB
001 Intro to Excel Templates_en.srt	4.9 KB
002 Opening an Existing Template.mp4	200.0 MB
002 Opening an Existing Template_en.srt	15.3 KB
003 Creating a Custom Template.mp4	77.0 MB
003 Creating a Custom Template_en.srt	10.0 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	47.0 MB
001 Congratulations!_en.srt	2.8 KB
Download Paid Udemy Courses For Free.url	0.1 KB
How can you help GFC.txt	0.3 KB
/13 - Microsoft Excel 102 Course Introduction/
001 Excel 102 Course Exercise Files -- DOWNLOAD.mp4	7.3 MB
001 Excel 102 Course Exercise Files -- DOWNLOAD_en.srt	1.8 KB
001 Excel102Exercises.xlsx	126.5 KB
001 NorthwindDB-IMPORT.zip	479.0 KB
001 SalesData-TEXT-IMPORT.txt	26.5 KB
/14 - Working with an Excel List/
001 Understanding Excel List Structure.mp4	52.8 MB
001 Understanding Excel List Structure_en.srt	8.4 KB
002 Sorting a List Using Single Level Sort.mp4	75.3 MB
002 Sorting a List Using Single Level Sort_en.srt	5.4 KB
003 Sorting a List Using Multi-Level Sorts.mp4	54.3 MB
003 Sorting a List Using Multi-Level Sorts_en.srt	5.1 KB
004 Using Custom Sorts in an Excel List.mp4	25.0 MB
004 Using Custom Sorts in an Excel List_en.srt	6.5 KB
005 Filter an Excel List Using the AutoFilter Tool.mp4	42.4 MB
005 Filter an Excel List Using the AutoFilter Tool_en.srt	7.2 KB
006 Creating Subtotals in a List.mp4	93.9 MB
006 Creating Subtotals in a List_en.srt	10.2 KB
007 Format a List as a Table.mp4	108.4 MB
007 Format a List as a Table_en.srt	11.4 KB
008 Using Conditional Formatting to Find Duplicates.mp4	57.3 MB
008 Using Conditional Formatting to Find Duplicates_en.srt	5.4 KB
009 Removing Duplicates.mp4	60.4 MB
009 Removing Duplicates_en.srt	5.9 KB
/15 - Excel List Functions/
001 Introduction to Excels Function DSUM().mp4	52.0 MB
001 Introduction to Excels Function DSUM()_en.srt	8.5 KB
002 Excel DSUM Function Single Criteria Continued.mp4	45.0 MB
002 Excel DSUM Function Single Criteria Continued_en.srt	7.2 KB
003 Excel DSUM Function with OR Criteria.mp4	24.1 MB
003 Excel DSUM Function with OR Criteria_en.srt	3.6 KB
004 Excel DSUM Function with AND Criteria.mp4	51.8 MB
004 Excel DSUM Function with AND Criteria_en.srt	7.8 KB
005 Excel Function DAVERAGE().mp4	45.9 MB
005 Excel Function DAVERAGE()_en.srt	7.3 KB
006 Excel Function DCOUNT().mp4	60.7 MB
006 Excel Function DCOUNT()_en.srt	9.6 KB
007 Excel Function SUBTOTAL().mp4	71.5 MB
007 Excel Function SUBTOTAL()_en.srt	11.8 KB
/16 - Excel Data Validation/
001 Understanding the Need for Excel Data Validation.mp4	46.7 MB
001 Understanding the Need for Excel Data Validation_en.srt	7.7 KB
002 Creating an Excel Data Validation List.mp4	50.5 MB
002 Creating an Excel Data Validation List_en.srt	8.5 KB
003 Excel Decimal Data Validation.mp4	39.8 MB
003 Excel Decimal Data Validation_en.srt	6.6 KB
004 Adding a Custom Excel Data Validation Error.mp4	45.2 MB
004 Adding a Custom Excel Data Validation Error_en.srt	8.1 KB
005 Dynamic Formulas by Using Excel Data Validation Techniques.mp4	43.8 MB
005 Dynamic Formulas by Using Excel Data Validation Techniques_en.srt	6.8 KB
/17 - Importing and Exporting Data/
001 Importing Data Into Microsoft Excel.mp4	10.4 MB
001 Importing Data Into Microsoft Excel_en.srt	2.7 KB
002 Importing Data from Text Files.mp4	35.3 MB
002 Importing Data from Text Files_en.srt	8.1 KB
003 Importing Data from Microsoft Access.mp4	46.2 MB
003 Importing Data from Microsoft Access_en.srt	6.1 KB
004 NEW VERSION -- Import Data From Text Files into Excel.mp4	248.1 MB
004 NEW VERSION -- Import Data From Text Files into Excel_en.srt	12.2 KB
005 NEW VERSION -- Import Data From a Database into Excel.mp4	128.5 MB
005 NEW VERSION -- Import Data From a Database into Excel_en.srt	9.4 KB
006 Microsoft Excel Legacy Import Options for New Excel Versions.mp4	40.5 MB
006 Microsoft Excel Legacy Import Options for New Excel Versions_en.srt	2.9 KB
007 Exporting Data to a Text File.mp4	125.4 MB
007 Exporting Data to a Text File_en.srt	9.9 KB
/18 - Excel PivotTables/
001 Understanding Excel PivotTables.mp4	47.4 MB
001 Understanding Excel PivotTables_en.srt	6.0 KB
002 Creating an Excel PivotTable.mp4	150.8 MB
002 Creating an Excel PivotTable_en.srt	10.8 KB
003 Modifying Excel PivotTable Calculations.mp4	134.8 MB
003 Modifying Excel PivotTable Calculations_en.srt	9.0 KB
004 Grouping PivotTable Data.mp4	56.5 MB
004 Grouping PivotTable Data_en.srt	11.9 KB
005 Formatting PivotTable Data.mp4	32.7 MB
005 Formatting PivotTable Data_en.srt	6.5 KB
006 Modifying PivotTable Calculations.mp4	58.5 MB
006 Modifying PivotTable Calculations_en.srt	13.9 KB
007 Drilling Down into PivotTable Data.mp4	139.4 MB
007 Drilling Down into PivotTable Data_en.srt	6.6 KB
008 Creating PivotCharts.mp4	85.2 MB
008 Creating PivotCharts_en.srt	6.1 KB
009 Filtering PivotTable Data.mp4	21.3 MB
009 Filtering PivotTable Data_en.srt	4.6 KB
010 Filtering with the Slicer Tool.mp4	25.7 MB
010 Filtering with the Slicer Tool_en.srt	4.6 KB
/19 - Working with Excel's PowerPivot Tools/
001 Introduction to Excel Power Pivot.mp4	27.0 MB
001 Introduction to Excel Power Pivot_en.srt	6.9 KB
002 Why PowerPivot.mp4	340.3 MB
002 Why PowerPivot_en.srt	11.8 KB
003 Activating the Excel PowerPivot AddIn.mp4	40.9 MB
003 Activating the Excel PowerPivot AddIn_en.srt	5.2 KB
004 Creating Data Models with PowerPivot.mp4	166.2 MB
004 Creating Data Models with PowerPivot_en.srt	6.8 KB
005 Excel Power Pivot Data Model Relationships.mp4	112.2 MB
005 Excel Power Pivot Data Model Relationships_en.srt	7.2 KB
006 Creating PivotTables based on Data Models.mp4	47.8 MB
006 Creating PivotTables based on Data Models_en.srt	9.4 KB
007 Excel Power Pivot KPIs.mp4	206.1 MB
007 Excel Power Pivot KPIs_en.srt	16.4 KB
/20 - Working with Large Sets of Excel Data/
001 Using the Freeze Panes Tool.mp4	53.0 MB
001 Using the Freeze Panes Tool_en.srt	5.5 KB
002 Grouping Data (Columns andor Rows).mp4	65.2 MB
002 Grouping Data (Columns andor Rows)_en.srt	5.9 KB
003 Print Options for Large Sets of Data.mp4	62.1 MB
003 Print Options for Large Sets of Data_en.srt	11.2 KB
004 Linking Worksheets (3D Formulas).mp4	23.9 MB
004 Linking Worksheets (3D Formulas)_en.srt	5.4 KB
005 Consolidating Data from Multiple Worksheets.mp4	34.4 MB
005 Consolidating Data from Multiple Worksheets_en.srt	7.6 KB
/21 - Excel 102 Additional Practice Exercises/
001 COMPLETED-Excel102ExtraPractice-01.xlsx	253.8 KB
001 Excel 102 - Practice What You've Learned (DOWNLOAD).html	0.3 KB
001 Excel102ExtraPractice-01.xlsx	240.1 KB
/22 - Congratulations! You're an Intermediate Excel User/
001 Congratulations!.mp4	37.8 MB
001 Congratulations!_en.srt	2.3 KB
Download Paid Udemy Courses For Free.url	0.1 KB
How can you help GFC.txt	0.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.1 KB
001 Excel103-AdvancedExercises.xlsx	65.1 KB
/24 - Working with Excel's Conditional Functions/
001 Working with Excel Name Ranges.mp4	25.3 MB
001 Working with Excel Name Ranges_en.srt	7.2 KB
002 Advantages and Disadvantages of Excel Name Ranges.mp4	43.6 MB
002 Advantages and Disadvantages of Excel Name Ranges_en.srt	8.3 KB
003 Editing an Excel Name Range.mp4	14.8 MB
003 Editing an Excel Name Range_en.srt	4.2 KB
004 Using Excel's IF() Function.mp4	30.6 MB
004 Using Excel's IF() Function_en.srt	8.2 KB
005 Excel's IF() Function with a Name Range.mp4	31.5 MB
005 Excel's IF() Function with a Name Range_en.srt	8.4 KB
006 Nesting Functions with Excel.mp4	53.8 MB
006 Nesting Functions with Excel_en.srt	12.1 KB
007 Nesting Excels AND() Function within the IF() Function.mp4	27.4 MB
007 Nesting Excels AND() Function within the IF() Function_en.srt	6.2 KB
008 Using Excel's COUNTIF() Function.mp4	14.6 MB
008 Using Excel's COUNTIF() Function_en.srt	3.7 KB
009 Using Excel's SUMIF() Function.mp4	128.7 MB
009 Using Excel's SUMIF() Function_en.srt	9.2 KB
010 Using Excel's IFERROR() Function.mp4	96.4 MB
010 Using Excel's IFERROR() Function_en.srt	7.8 KB
/25 - Working with Excel's Lookup Functions/
001 Microsoft Excel VLOOKUP() Function.mp4	172.0 MB
001 Microsoft Excel VLOOKUP() Function_en.srt	15.9 KB
002 Microsoft Excel HLOOKUP() Function.mp4	51.9 MB
002 Microsoft Excel HLOOKUP() Function_en.srt	8.6 KB
003 Microsoft Excel INDEX() Function.mp4	170.8 MB
003 Microsoft Excel INDEX() Function_en.srt	15.2 KB
004 Microsoft Excel MATCH() Function.mp4	153.0 MB
004 Microsoft Excel MATCH() Function_en.srt	7.2 KB
005 Microsoft Excel INDEX() and MATCH() Function Combined.mp4	122.1 MB
005 Microsoft Excel INDEX() and MATCH() Function Combined_en.srt	10.7 KB
006 Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4	154.1 MB
006 Microsoft Excel INDEX() and MATCH() Function Combined Continued_en.srt	14.2 KB
007 Creating a Dynamic HLOOKUP() with the MATCH() Function.mp4	69.6 MB
007 Creating a Dynamic HLOOKUP() with the MATCH() Function_en.srt	10.7 KB
/26 - Working with Excel's Text Based Functions/
001 Using Excel's LEFT(), RIGHT() and MID() Functions.mp4	81.8 MB
001 Using Excel's LEFT(), RIGHT() and MID() Functions_en.srt	8.9 KB
002 Using Excel's LEN() Function.mp4	54.7 MB
002 Using Excel's LEN() Function_en.srt	8.7 KB
003 Using Excel's SEARCH() Function.mp4	74.6 MB
003 Using Excel's SEARCH() Function_en.srt	17.6 KB
004 Using Excel's CONCATENATE() Function.mp4	19.6 MB
004 Using Excel's CONCATENATE() Function_en.srt	4.2 KB
/27 - Auditing an Excel Worksheet/
001 Tracing Precedents in Excel Formulas.mp4	28.1 MB
001 Tracing Precedents in Excel Formulas_en.srt	5.7 KB
002 Tracing Dependents in Excel Formulas.mp4	20.1 MB
002 Tracing Dependents in Excel Formulas_en.srt	3.9 KB
003 Working with the Watch Window.mp4	51.8 MB
003 Working with the Watch Window_en.srt	5.8 KB
004 Showing Formulas.mp4	18.1 MB
004 Showing Formulas_en.srt	4.3 KB
/28 - Protecting Excel Worksheets and Workbooks/
001 Protecting Specific Cells in a Worksheet.mp4	56.4 MB
001 Protecting Specific Cells in a Worksheet_en.srt	11.3 KB
002 Protecting the Structure of a Workbook.mp4	22.1 MB
002 Protecting the Structure of a Workbook_en.srt	5.6 KB
003 Adding a Workbook Password.mp4	36.5 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	44.0 MB
001 Working with Excel's Goal Seek Tool_en.srt	11.2 KB
002 Working with Excel's Solver Tool.mp4	187.1 MB
002 Working with Excel's Solver Tool_en.srt	17.6 KB
003 Building Effective Data Tables in Excel.mp4	37.2 MB
003 Building Effective Data Tables in Excel_en.srt	7.9 KB
004 Creating Scenarios in Excel.mp4	97.3 MB
004 Creating Scenarios in Excel_en.srt	11.0 KB
Download Paid Udemy Courses For Free.url	0.1 KB
How can you help GFC.txt	0.3 KB
/30 - Automating Repetitive Tasks in Excel with Macros/
001 Understanding Excel Macros.mp4	36.7 MB
001 Understanding Excel Macros_en.srt	5.3 KB
002 Activating the Developer Tab in Excel.mp4	25.0 MB
002 Activating the Developer Tab in Excel_en.srt	2.1 KB
003 Creating a Macro with the Macro Recorder.mp4	144.4 MB
003 Creating a Macro with the Macro Recorder_en.srt	11.4 KB
004 Editing a Macro with VBA.mp4	65.6 MB
004 Editing a Macro with VBA_en.srt	7.7 KB
005 Creating Buttons to Run Macros.mp4	71.7 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.9 KB
/32 - Congratulations!/
001 Congratulations on Completing the Microsoft Excel 103.mp4	40.5 MB
001 Congratulations on Completing the Microsoft Excel 103_en.srt	2.3 KB
/33 - Microsoft Excel Macros and VBA Course Introduction/
001 Welcome to the Course.mp4	25.6 MB
001 Welcome to the Course_en.srt	8.8 KB
002 Understanding the Why and How Behind Excel Macros.mp4	22.7 MB
002 Understanding the Why and How Behind Excel Macros_en.srt	7.9 KB
003 AutomateFormulas.xlsx	19.3 KB
003 AutomateSumFunction.xlsx	20.3 KB
003 CleaningUpData.xlsx	21.3 KB
003 Course Exercise Files - Download these First!.html	0.4 KB
003 InsertingAndFormattingText.xlsx	17.8 KB
003 QuarterlyReport.xlsm	27.1 KB
003 QuarterlyReportForm-01.xlsm	30.4 KB
003 SortingRecords.xlsm	22.3 KB
003 SortingRecords.xlsx	16.9 KB
/34 - Project #1 Using Excel's Macro Recorder Tool/
001 Introduction to Project #1 Inserting and Formatting Text.mp4	16.4 MB
001 Introduction to Project #1 Inserting and Formatting Text_en.srt	3.0 KB
002 InsertingAndFormattingText.xlsx	17.8 KB
002 Project #1 Start Recording!.mp4	78.8 MB
002 Project #1 Start Recording!_en.srt	11.7 KB
003 Running A Macro.mp4	22.1 MB
003 Running A Macro_en.srt	4.0 KB
004 Project #1 Running a Macro with a Button.mp4	20.6 MB
004 Project #1 Running a Macro with a Button_en.srt	5.6 KB
005 Project #1 Oops! I Need to Edit My Macro.mp4	80.0 MB
005 Project #1 Oops! I Need to Edit My Macro_en.srt	6.7 KB
006 Practical Uses of Excel Macros.mp4	25.9 MB
006 Practical Uses of Excel Macros_en.srt	3.2 KB
/35 - Excel VBA Concepts/
001 Excel VBA Concepts.mp4	19.7 MB
001 Excel VBA Concepts_en.srt	4.9 KB
002 The Visual Basic Editor (VBE).mp4	24.8 MB
002 The Visual Basic Editor (VBE)_en.srt	5.3 KB
003 Excel VBA Modules.mp4	9.6 MB
003 Excel VBA Modules_en.srt	2.7 KB
004 Creating an Excel VBA Procedure.mp4	40.5 MB
004 Creating an Excel VBA Procedure_en.srt	11.4 KB
005 Adding Code to a VBA Procedure.mp4	31.7 MB
005 Adding Code to a VBA Procedure_en.srt	5.4 KB
006 Understanding Excel VBA Variables.mp4	52.0 MB
006 Understanding Excel VBA Variables_en.srt	9.2 KB
007 Building Logic with an IF Statement.mp4	35.6 MB
007 Building Logic with an IF Statement_en.srt	8.6 KB
008 Working with Excel VBA Loops to Repeat Blocks of Code.mp4	53.8 MB
008 Working with Excel VBA Loops to Repeat Blocks of Code_en.srt	14.6 KB
/36 - Project #2 Moving Beyond the Basics and into VBA/
001 Introduction to Project #2 Interacting with the User.mp4	23.9 MB
001 Introduction to Project #2 Interacting with the User_en.srt	4.3 KB
002 Project #2 Breaking Down the VBA Code.mp4	62.7 MB
002 Project #2 Breaking Down the VBA Code_en.srt	5.0 KB
002 SortingRecords.xlsm	17.1 KB
003 Project #2 Prompting the User for Information.mp4	225.1 MB
003 Project #2 Prompting the User for Information_en.srt	9.9 KB
004 Continue Excel VBA InputBox.mp4	71.8 MB
004 Continue Excel VBA InputBox_en.srt	9.4 KB
005 Project #2 Building Logic into Your Macros.mp4	146.2 MB
005 Project #2 Building Logic into Your Macros_en.srt	6.0 KB
006 Project #2 Alerting the User of Errors.mp4	187.8 MB
006 Project #2 Alerting the User of Errors_en.srt	14.3 KB
007 Other Practical Uses of Message and Input Boxes.mp4	27.7 MB
007 Other Practical Uses of Message and Input Boxes_en.srt	4.8 KB
/37 - Project #3 Preparing and Cleaning Up Data with a Little VBA/
001 Introduction to Project #3 Cleaning Up and Formatting Data.mp4	31.9 MB
001 Introduction to Project #3 Cleaning Up and Formatting Data_en.srt	5.1 KB
002 Project #3 Preparing to the Use the Macro Recorder.mp4	24.2 MB
002 Project #3 Preparing to the Use the Macro Recorder_en.srt	4.2 KB
003 Project #3 Inserting the Headers.mp4	20.1 MB
003 Project #3 Inserting the Headers_en.srt	5.8 KB
004 Project #3 Formatting the Headers.mp4	19.3 MB
004 Project #3 Formatting the Headers_en.srt	3.8 KB
005 Project #3 Putting it all Together with a Little VBA.mp4	195.0 MB
005 Project #3 Putting it all Together with a Little VBA_en.srt	15.3 KB
006 Running the Loop.mp4	52.7 MB
006 Running the Loop_en.srt	4.6 KB
/38 - Project #4 Using VBA to Automate Excel Formulas/
001 Introduction to Project #4 Automate Excel Formulas.mp4	72.2 MB
001 Introduction to Project #4 Automate Excel Formulas_en.srt	3.2 KB
002 AutomateSumFunction.xlsx	20.3 KB
002 Project #4 Automate the SUM() Function through Code.mp4	145.8 MB
002 Project #4 Automate the SUM() Function through Code_en.srt	12.0 KB
003 Continue Automate SUM Function.mp4	33.0 MB
003 Continue Automate SUM Function_en.srt	8.4 KB
004 Test the SUM Function.mp4	68.9 MB
004 Test the SUM Function_en.srt	6.0 KB
005 Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4	206.1 MB
005 Project #4 Loop the SUM() Function Over Multiple Worksheets_en.srt	9.1 KB
/39 - Project #5 Bringing it All Together and a Weekly Report/
001 Introduction to Project #5 Creating the Final Report.mp4	102.0 MB
001 Introduction to Project #5 Creating the Final Report_en.srt	5.4 KB
002 Project #5 Creating the Final Report Loop.mp4	78.0 MB
002 Project #5 Creating the Final Report Loop_en.srt	12.3 KB
003 Project #5 - Copying and Pasting Data with VBA.mp4	93.9 MB
003 Project #5 - Copying and Pasting Data with VBA_en.srt	13.5 KB
004 Project #5 - Running the Final Report Procedure.mp4	60.1 MB
004 Project #5 - Running the Final Report Procedure_en.srt	4.9 KB
/40 - Project #6 Working with Excel VBA User Forms/
001 Introduction to Project #6 Working with Excel VBA User Forms.mp4	28.3 MB
001 Introduction to Project #6 Working with Excel VBA User Forms_en.srt	4.6 KB
001 QuarterlyReportForm-01.xlsm	25.1 KB
002 Project #6 Creating an Excel User Form.mp4	50.3 MB
002 Project #6 Creating an Excel User Form_en.srt	8.3 KB
003 Project #6 Adding Controls to the Form.mp4	22.0 MB
003 Project #6 Adding Controls to the Form_en.srt	5.4 KB
004 Project #6 Adding VBA Code to the Initialize Event.mp4	82.9 MB
004 Project #6 Adding VBA Code to the Initialize Event_en.srt	12.4 KB
005 Project #6 Adding VBA Code to the ComboBox Change Event.mp4	44.6 MB
005 Project #6 Adding VBA Code to the ComboBox Change Event_en.srt	6.4 KB
006 Project #6 Adding VBA Code to the Add Worksheet Button.mp4	34.7 MB
006 Project #6 Adding VBA Code to the Add Worksheet Button_en.srt	5.3 KB
007 Change Worksheet Name.mp4	39.5 MB
007 Change Worksheet Name_en.srt	5.8 KB
008 Project #6 Adding VBA Code to the Create Report Button.mp4	159.8 MB
008 Project #6 Adding VBA Code to the Create Report Button.vtt	11.2 KB
008 Project #6 Adding VBA Code to the Create Report Button_en.srt	13.2 KB
009 Project #6 Showing the Form.mp4	71.1 MB
009 Project #6 Showing the Form_en.srt	5.7 KB
/41 - 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	18.4 MB
001 Project #7 Opening a Text File for Import_en.srt	4.3 KB
002 Project #7 Opening a Text File for Import.mp4	60.7 MB
002 Project #7 Opening a Text File for Import_en.srt	9.9 KB
003 Project #7 Get Data from Text File.mp4	41.2 MB
003 Project #7 Get Data from Text File_en.srt	9.2 KB
004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4	83.0 MB
004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method_en.srt	13.5 KB
005 Project #7 Creating a Loop to Read Each File.mp4	42.0 MB
005 Project #7 Creating a Loop to Read Each File_en.srt	12.2 KB
006 Project #7 Adding a New Sheet for Imported Data.mp4	30.2 MB
006 Project #7 Adding a New Sheet for Imported Data_en.srt	4.0 KB
007 Project #7 Clear the Clipboard.mp4	41.2 MB
007 Project #7 Clear the Clipboard_en.srt	5.8 KB
008 Project #7 Working with the ScreenUpdating Property.mp4	22.9 MB
008 Project #7 Working with the ScreenUpdating Property_en.srt	5.5 KB
009 Project #7 Creating Reusable Code with a VBA Function.mp4	99.1 MB
009 Project #7 Creating Reusable Code with a VBA Function_en.srt	12.0 KB
/42 - Course Wrap Up/
001 Congratulations! You're an Excel MacroVBA Master.mp4	5.4 MB
001 Congratulations! You're an Excel MacroVBA Master_en.srt	1.3 KB
/
Download Paid Udemy Courses For Free.url	0.1 KB
How can you help GFC.txt	0.3 KB
Total files 485