Udemy - Microsoft Excel - Excel from Beginner to Advanced 2022-7

mp4   Hot：19   Size：8.49 GB   Created：2024-01-22 15:54:49   Update：2024-02-06 00:19:18  

Download link

小提示：当迅雷提示“下载出错”或“无法下载”等字样时，并非资源有问题，请更换 bitcomet(比特彗星) 即可下载，或者使用迅雷5。

File List

  • 01 - Microsoft Excel 101 Course Introduction/001 Ask Questions.mp4 36.44 MB
    01 - Microsoft Excel 101 Course Introduction/001 Ask Questions_en.srt 2.97 KB
    01 - Microsoft Excel 101 Course Introduction/002 Course Exercise Files.mp4 27.33 MB
    01 - Microsoft Excel 101 Course Introduction/002 Course Exercise Files_en.srt 2.24 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-01.xlsx 14.28 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-AutoFill-01.xlsx 13.82 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-AutoSUM-01.xlsx 14.12 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-AverageFunction-01.xlsx 14.1 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-BasicFormulas-01.xlsx 13.68 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-Count-01.xlsx 14.31 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-Headers-01.xlsx 13.68 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-MIN-MAXFunctions-01.xlsx 14.03 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-ReferenceTypes-01.xlsx 13.67 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-SUMFunction-01.xlsx 13.77 KB
    01 - Microsoft Excel 101 Course Introduction/002 MonthlyBudget-Template-01.xlsx 14.53 KB
    01 - Microsoft Excel 101 Course Introduction/003 Certificate of Completion.mp4 23.34 MB
    01 - Microsoft Excel 101 Course Introduction/003 Certificate of Completion_en.srt 1.77 KB
    02 - Microsoft Excel Fundamentals/001 Launching Excel.mp4 33.08 MB
    02 - Microsoft Excel Fundamentals/001 Launching Excel_en.srt 2.84 KB
    02 - Microsoft Excel Fundamentals/002 Microsoft Excel Startup Screen.mp4 33.59 MB
    02 - Microsoft Excel Fundamentals/002 Microsoft Excel Startup Screen_en.srt 4.9 KB
    02 - Microsoft Excel Fundamentals/003 Introduction to the Excel Interface.mp4 112.91 MB
    02 - Microsoft Excel Fundamentals/003 Introduction to the Excel Interface_en.srt 11.49 KB
    02 - Microsoft Excel Fundamentals/004 Customizing the Excel Quick Access Toolbar.mp4 13.68 MB
    02 - Microsoft Excel Fundamentals/004 Customizing the Excel Quick Access Toolbar_en.srt 4.85 KB
    02 - Microsoft Excel Fundamentals/005 More on the Excel Interface.mp4 30.31 MB
    02 - Microsoft Excel Fundamentals/005 More on the Excel Interface_en.srt 5.68 KB
    02 - Microsoft Excel Fundamentals/006 Understanding the Structure of an Excel Workbook.mp4 13.04 MB
    02 - Microsoft Excel Fundamentals/006 Understanding the Structure of an Excel Workbook_en.srt 6.28 KB
    02 - Microsoft Excel Fundamentals/007 Saving an Excel Document.mp4 40.79 MB
    02 - Microsoft Excel Fundamentals/007 Saving an Excel Document_en.srt 6.14 KB
    02 - Microsoft Excel Fundamentals/008 Opening an Existing Excel Document.mp4 22.77 MB
    02 - Microsoft Excel Fundamentals/008 Opening an Existing Excel Document_en.srt 2.7 KB
    02 - Microsoft Excel Fundamentals/009 Common Excel Shortcut Keys.mp4 11.55 MB
    02 - Microsoft Excel Fundamentals/009 Common Excel Shortcut Keys_en.srt 3.99 KB
    02 - Microsoft Excel Fundamentals/009 CommonExcelWindowsShortcuts-01.pdf 141.5 KB
    03 - Entering and Editing Text and Formulas/001 Entering Text to Create Spreadsheet Titles.mp4 36.87 MB
    03 - Entering and Editing Text and Formulas/001 Entering Text to Create Spreadsheet Titles_en.srt 13.9 KB
    03 - Entering and Editing Text and Formulas/002 Working with Numeric Data in Excel.mp4 38.12 MB
    03 - Entering and Editing Text and Formulas/002 Working with Numeric Data in Excel_en.srt 12.96 KB
    03 - Entering and Editing Text and Formulas/003 Entering Date Values in Excel.mp4 38.63 MB
    03 - Entering and Editing Text and Formulas/003 Entering Date Values in Excel_en.srt 14.43 KB
    03 - Entering and Editing Text and Formulas/004 Working with Cell References.mp4 57.67 MB
    03 - Entering and Editing Text and Formulas/004 Working with Cell References_en.srt 9.12 KB
    03 - Entering and Editing Text and Formulas/005 Creating Basic Formulas in Excel.mp4 27.72 MB
    03 - Entering and Editing Text and Formulas/005 Creating Basic Formulas in Excel_en.srt 14.39 KB
    03 - Entering and Editing Text and Formulas/006 Relative Versus Absolute Cell References in Formulas.mp4 55.77 MB
    03 - Entering and Editing Text and Formulas/006 Relative Versus Absolute Cell References in Formulas_en.srt 18.54 KB
    03 - Entering and Editing Text and Formulas/007 OrderOfOperation-01.xlsx 9.25 KB
    03 - Entering and Editing Text and Formulas/007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4 33.53 MB
    03 - Entering and Editing Text and Formulas/007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)_en.srt 15.13 KB
    04 - Working with Basic Excel Functions/001 EXCEL-FUNCTIONS.pptx 87.12 KB
    04 - Working with Basic Excel Functions/001 The structure of an Excel Function.mp4 154.67 MB
    04 - Working with Basic Excel Functions/001 The structure of an Excel Function_en.srt 15.5 KB
    04 - Working with Basic Excel Functions/002 Working with the SUM() Function.mp4 30.78 MB
    04 - Working with Basic Excel Functions/002 Working with the SUM() Function_en.srt 11.87 KB
    04 - Working with Basic Excel Functions/003 Working with the MIN() and MAX() Functions.mp4 20.53 MB
    04 - Working with Basic Excel Functions/003 Working with the MIN() and MAX() Functions_en.srt 10.19 KB
    04 - Working with Basic Excel Functions/004 Working with the AVERAGE() Function.mp4 9.4 MB
    04 - Working with Basic Excel Functions/004 Working with the AVERAGE() Function_en.srt 4.6 KB
    04 - Working with Basic Excel Functions/005 Working with the COUNT() Function.mp4 9.46 MB
    04 - Working with Basic Excel Functions/005 Working with the COUNT() Function_en.srt 4.56 KB
    04 - Working with Basic Excel Functions/006 Adjacent Cells Error in Excel Calculations.mp4 16.46 MB
    04 - Working with Basic Excel Functions/006 Adjacent Cells Error in Excel Calculations_en.srt 6.59 KB
    04 - Working with Basic Excel Functions/007 Using the AutoSum Command.mp4 30.65 MB
    04 - Working with Basic Excel Functions/007 Using the AutoSum Command_en.srt 11.22 KB
    04 - Working with Basic Excel Functions/008 Excel's AutoSum Shortcut Key.mp4 9.98 MB
    04 - Working with Basic Excel Functions/008 Excel's AutoSum Shortcut Key_en.srt 3.74 KB
    04 - Working with Basic Excel Functions/009 Using the AutoFill Command to Copy Formulas.mp4 19.83 MB
    04 - Working with Basic Excel Functions/009 Using the AutoFill Command to Copy Formulas_en.srt 6.86 KB
    05 - Modifying an Excel Worksheet/001 Moving and Copying Data in an Excel Worksheet.mp4 36.99 MB
    05 - Modifying an Excel Worksheet/001 Moving and Copying Data in an Excel Worksheet_en.srt 10.01 KB
    05 - Modifying an Excel Worksheet/002 Inserting and Deleting Rows and Columns.mp4 23.91 MB
    05 - Modifying an Excel Worksheet/002 Inserting and Deleting Rows and Columns_en.srt 11.49 KB
    05 - Modifying an Excel Worksheet/003 Changing the Width and Height of Cells.mp4 17.54 MB
    05 - Modifying an Excel Worksheet/003 Changing the Width and Height of Cells_en.srt 8.42 KB
    05 - Modifying an Excel Worksheet/004 Hiding and Unhiding Excel Rows and Columns.mp4 23.18 MB
    05 - Modifying an Excel Worksheet/004 Hiding and Unhiding Excel Rows and Columns_en.srt 8.56 KB
    05 - Modifying an Excel Worksheet/005 Renaming an Excel Worksheet.mp4 12.72 MB
    05 - Modifying an Excel Worksheet/005 Renaming an Excel Worksheet_en.srt 4.6 KB
    05 - Modifying an Excel Worksheet/006 Deleting an Excel Worksheet.mp4 25.64 MB
    05 - Modifying an Excel Worksheet/006 Deleting an Excel Worksheet_en.srt 7.45 KB
    05 - Modifying an Excel Worksheet/007 Moving and Copying an Excel Worksheet.mp4 23.46 MB
    05 - Modifying an Excel Worksheet/007 Moving and Copying an Excel Worksheet_en.srt 7.93 KB
    06 - Formatting Data in an Excel Worksheet/001 Working with Font Formatting Commands.mp4 33.74 MB
    06 - Formatting Data in an Excel Worksheet/001 Working with Font Formatting Commands_en.srt 12 KB
    06 - Formatting Data in an Excel Worksheet/002 Changing the Background Color of a Cell.mp4 14.42 MB
    06 - Formatting Data in an Excel Worksheet/002 Changing the Background Color of a Cell_en.srt 5.17 KB
    06 - Formatting Data in an Excel Worksheet/003 Adding Borders to Cells.mp4 11.11 MB
    06 - Formatting Data in an Excel Worksheet/003 Adding Borders to Cells_en.srt 3.76 KB
    06 - Formatting Data in an Excel Worksheet/004 Excel Cell Borders Continued.mp4 14.88 MB
    06 - Formatting Data in an Excel Worksheet/004 Excel Cell Borders Continued_en.srt 5.12 KB
    06 - Formatting Data in an Excel Worksheet/005 Formatting Data as Currency Values.mp4 20.79 MB
    06 - Formatting Data in an Excel Worksheet/005 Formatting Data as Currency Values_en.srt 6.92 KB
    06 - Formatting Data in an Excel Worksheet/006 Formatting Percentages.mp4 13.23 MB
    06 - Formatting Data in an Excel Worksheet/006 Formatting Percentages_en.srt 4.33 KB
    06 - Formatting Data in an Excel Worksheet/007 Using Excel's Format Painter.mp4 18.47 MB
    06 - Formatting Data in an Excel Worksheet/007 Using Excel's Format Painter_en.srt 6.89 KB
    06 - Formatting Data in an Excel Worksheet/008 Creating Styles to Format Data.mp4 137.18 MB
    06 - Formatting Data in an Excel Worksheet/008 Creating Styles to Format Data_en.srt 12.06 KB
    06 - Formatting Data in an Excel Worksheet/009 Merging and Centering Cells.mp4 15.09 MB
    06 - Formatting Data in an Excel Worksheet/009 Merging and Centering Cells_en.srt 5.18 KB
    06 - Formatting Data in an Excel Worksheet/010 Using Conditional Formatting.mp4 20.44 MB
    06 - Formatting Data in an Excel Worksheet/010 Using Conditional Formatting_en.srt 7.15 KB
    06 - Formatting Data in an Excel Worksheet/011 Editing Excel Conditional Formatting.mp4 11.27 MB
    06 - Formatting Data in an Excel Worksheet/011 Editing Excel Conditional Formatting_en.srt 4.23 KB
    07 - Inserting Images and Shapes into an Excel Worksheet/001 Inserting Images.mp4 42.49 MB
    07 - Inserting Images and Shapes into an Excel Worksheet/001 Inserting Images_en.srt 6.86 KB
    07 - Inserting Images and Shapes into an Excel Worksheet/002 Inserting Excel Shapes.mp4 11.37 MB
    07 - Inserting Images and Shapes into an Excel Worksheet/002 Inserting Excel Shapes_en.srt 4.7 KB
    07 - Inserting Images and Shapes into an Excel Worksheet/003 Formatting Excel Shapes.mp4 16.62 MB
    07 - Inserting Images and Shapes into an Excel Worksheet/003 Formatting Excel Shapes_en.srt 6.65 KB
    07 - Inserting Images and Shapes into an Excel Worksheet/004 Working with Excel SmartArt.mp4 49.93 MB
    07 - Inserting Images and Shapes into an Excel Worksheet/004 Working with Excel SmartArt_en.srt 14.9 KB
    08 - Creating Basic Charts in Excel/001 Creating an Excel Column Chart.mp4 15.96 MB
    08 - Creating Basic Charts in Excel/001 Creating an Excel Column Chart_en.srt 5.78 KB
    08 - Creating Basic Charts in Excel/002 Working with the Excel Chart Ribbon.mp4 12.66 MB
    08 - Creating Basic Charts in Excel/002 Working with the Excel Chart Ribbon_en.srt 4.15 KB
    08 - Creating Basic Charts in Excel/003 Adding and Modifying Data on an Excel Chart.mp4 25.04 MB
    08 - Creating Basic Charts in Excel/003 Adding and Modifying Data on an Excel Chart_en.srt 8.9 KB
    08 - Creating Basic Charts in Excel/004 Formatting an Excel Chart.mp4 30.75 MB
    08 - Creating Basic Charts in Excel/004 Formatting an Excel Chart_en.srt 11.04 KB
    08 - Creating Basic Charts in Excel/005 Moving a Chart to another Worksheet.mp4 16.51 MB
    08 - Creating Basic Charts in Excel/005 Moving a Chart to another Worksheet_en.srt 5.5 KB
    08 - Creating Basic Charts in Excel/006 Working with Excel Pie Charts.mp4 33.04 MB
    08 - Creating Basic Charts in Excel/006 Working with Excel Pie Charts_en.srt 11.73 KB
    09 - Printing an Excel Worksheet/001 Viewing your Document in Print Preview.mp4 12.44 MB
    09 - Printing an Excel Worksheet/001 Viewing your Document in Print Preview_en.srt 6.28 KB
    09 - Printing an Excel Worksheet/002 Changing the Margins, Scaling and Orientation.mp4 161.5 MB
    09 - Printing an Excel Worksheet/002 Changing the Margins, Scaling and Orientation_en.srt 14.04 KB
    09 - Printing an Excel Worksheet/003 Excel Worksheet Margins.mp4 13.4 MB
    09 - Printing an Excel Worksheet/003 Excel Worksheet Margins_en.srt 4.95 KB
    09 - Printing an Excel Worksheet/004 Working with Page Layout View.mp4 20.1 MB
    09 - Printing an Excel Worksheet/004 Working with Page Layout View_en.srt 5.33 KB
    09 - Printing an Excel Worksheet/005 Adding Header and Footer Content.mp4 60.93 MB
    09 - Printing an Excel Worksheet/005 Adding Header and Footer Content_en.srt 9.28 KB
    09 - Printing an Excel Worksheet/006 Printing a Specific Range of Cells.mp4 58.11 MB
    09 - Printing an Excel Worksheet/006 Printing a Specific Range of Cells_en.srt 5.19 KB
    10 - Working with Excel Templates/001 Intro to Excel Templates.mp4 64.3 MB
    10 - Working with Excel Templates/001 Intro to Excel Templates_en.srt 4.56 KB
    10 - Working with Excel Templates/002 Opening an Existing Template.mp4 89.98 MB
    10 - Working with Excel Templates/002 Opening an Existing Template_en.srt 14.47 KB
    10 - Working with Excel Templates/003 Creating a Custom Template.mp4 36.96 MB
    10 - Working with Excel Templates/003 Creating a Custom Template_en.srt 10.1 KB
    11 - Excel 101 - Practice What You've Learned (DOWNLOAD)/001 Excel 101 - Practice What You've Learned (DOWNLOAD).html 259 B
    11 - Excel 101 - Practice What You've Learned (DOWNLOAD)/001 Excel101ExtraPractice-01.xlsx 46.31 KB
    12 - Congratulations! You've Built a Solid Microsoft Excel Foundation/001 Congratulations!.mp4 22.78 MB
    12 - Congratulations! You've Built a Solid Microsoft Excel Foundation/001 Congratulations!_en.srt 2.77 KB
    13 - Microsoft Excel 102 Course Introduction/001 Excel 102 Course Exercise Files -- DOWNLOAD.mp4 4.11 MB
    13 - Microsoft Excel 102 Course Introduction/001 Excel 102 Course Exercise Files -- DOWNLOAD_en.srt 1.84 KB
    13 - Microsoft Excel 102 Course Introduction/001 Excel102Exercises.xlsx 123.54 KB
    13 - Microsoft Excel 102 Course Introduction/001 NorthwindDB-IMPORT.zip 467.8 KB
    13 - Microsoft Excel 102 Course Introduction/001 SalesData-TEXT-IMPORT.txt 25.89 KB
    14 - Working with an Excel List/001 Understanding Excel List Structure.mp4 53 MB
    14 - Working with an Excel List/001 Understanding Excel List Structure_en.srt 8.17 KB
    14 - Working with an Excel List/002 Sorting a List Using Single Level Sort.mp4 34.58 MB
    14 - Working with an Excel List/002 Sorting a List Using Single Level Sort_en.srt 5.31 KB
    14 - Working with an Excel List/003 Sorting a List Using Multi-Level Sorts.mp4 26.16 MB
    14 - Working with an Excel List/003 Sorting a List Using Multi-Level Sorts_en.srt 5.02 KB
    14 - Working with an Excel List/004 Using Custom Sorts in an Excel List.mp4 14.19 MB
    14 - Working with an Excel List/004 Using Custom Sorts in an Excel List_en.srt 6.36 KB
    14 - Working with an Excel List/005 Filter an Excel List Using the AutoFilter Tool.mp4 22.15 MB
    14 - Working with an Excel List/005 Filter an Excel List Using the AutoFilter Tool_en.srt 7.04 KB
    14 - Working with an Excel List/006 Creating Subtotals in a List.mp4 45.43 MB
    14 - Working with an Excel List/006 Creating Subtotals in a List_en.srt 9.93 KB
    14 - Working with an Excel List/007 Format a List as a Table.mp4 52.94 MB
    14 - Working with an Excel List/007 Format a List as a Table_en.srt 11.15 KB
    14 - Working with an Excel List/008 Using Conditional Formatting to Find Duplicates.mp4 27.73 MB
    14 - Working with an Excel List/008 Using Conditional Formatting to Find Duplicates_en.srt 5.27 KB
    14 - Working with an Excel List/009 Removing Duplicates.mp4 29.09 MB
    14 - Working with an Excel List/009 Removing Duplicates_en.srt 5.76 KB
    15 - Excel List Functions/001 Introduction to Excels Function DSUM().mp4 26.26 MB
    15 - Excel List Functions/001 Introduction to Excels Function DSUM()_en.srt 8.44 KB
    15 - Excel List Functions/002 Excel DSUM Function Single Criteria Continued.mp4 22.79 MB
    15 - Excel List Functions/002 Excel DSUM Function Single Criteria Continued_en.srt 6.96 KB
    15 - Excel List Functions/003 Excel DSUM Function with OR Criteria.mp4 12.2 MB
    15 - Excel List Functions/003 Excel DSUM Function with OR Criteria_en.srt 3.76 KB
    15 - Excel List Functions/004 Excel DSUM Function with AND Criteria.mp4 26.45 MB
    15 - Excel List Functions/004 Excel DSUM Function with AND Criteria_en.srt 7.77 KB
    15 - Excel List Functions/005 Excel Function DAVERAGE().mp4 23.41 MB
    15 - Excel List Functions/005 Excel Function DAVERAGE()_en.srt 7.23 KB
    15 - Excel List Functions/006 Excel Function DCOUNT().mp4 30.85 MB
    15 - Excel List Functions/006 Excel Function DCOUNT()_en.srt 9.7 KB
    15 - Excel List Functions/007 Excel Function SUBTOTAL().mp4 36.48 MB
    15 - Excel List Functions/007 Excel Function SUBTOTAL()_en.srt 11.48 KB
    16 - Excel Data Validation/001 Understanding the Need for Excel Data Validation.mp4 103.31 MB
    16 - Excel Data Validation/001 Understanding the Need for Excel Data Validation_en.srt 7.46 KB
    16 - Excel Data Validation/002 Creating an Excel Data Validation List.mp4 25.84 MB
    16 - Excel Data Validation/002 Creating an Excel Data Validation List_en.srt 8.17 KB
    16 - Excel Data Validation/003 Excel Decimal Data Validation.mp4 20.35 MB
    16 - Excel Data Validation/003 Excel Decimal Data Validation_en.srt 6.05 KB
    16 - Excel Data Validation/004 Adding a Custom Excel Data Validation Error.mp4 23.16 MB
    16 - Excel Data Validation/004 Adding a Custom Excel Data Validation Error_en.srt 7.82 KB
    16 - Excel Data Validation/005 Dynamic Formulas by Using Excel Data Validation Techniques.mp4 22.05 MB
    16 - Excel Data Validation/005 Dynamic Formulas by Using Excel Data Validation Techniques_en.srt 7.28 KB
    17 - Importing and Exporting Data/001 Importing Data Into Microsoft Excel.mp4 5.65 MB
    17 - Importing and Exporting Data/001 Importing Data Into Microsoft Excel_en.srt 2.48 KB
    17 - Importing and Exporting Data/002 Importing Data from Text Files.mp4 19.14 MB
    17 - Importing and Exporting Data/002 Importing Data from Text Files_en.srt 7.91 KB
    17 - Importing and Exporting Data/003 Importing Data from Microsoft Access.mp4 22.98 MB
    17 - Importing and Exporting Data/003 Importing Data from Microsoft Access_en.srt 5.92 KB
    17 - Importing and Exporting Data/004 NEW VERSION -- Import Data From Text Files into Excel.mp4 129.28 MB
    17 - Importing and Exporting Data/004 NEW VERSION -- Import Data From Text Files into Excel_en.srt 12.26 KB
    17 - Importing and Exporting Data/005 NEW VERSION -- Import Data From a Database into Excel.mp4 67.98 MB
    17 - Importing and Exporting Data/005 NEW VERSION -- Import Data From a Database into Excel_en.srt 9.39 KB
    17 - Importing and Exporting Data/006 Microsoft Excel Legacy Import Options for New Excel Versions.mp4 21.35 MB
    17 - Importing and Exporting Data/006 Microsoft Excel Legacy Import Options for New Excel Versions_en.srt 2.86 KB
    17 - Importing and Exporting Data/007 Exporting Data to a Text File.mp4 65.93 MB
    17 - Importing and Exporting Data/007 Exporting Data to a Text File_en.srt 9.85 KB
    18 - Excel PivotTables/001 Understanding Excel PivotTables.mp4 70.07 MB
    18 - Excel PivotTables/001 Understanding Excel PivotTables_en.srt 5.92 KB
    18 - Excel PivotTables/002 Creating an Excel PivotTable.mp4 70.44 MB
    18 - Excel PivotTables/002 Creating an Excel PivotTable_en.srt 10.35 KB
    18 - Excel PivotTables/003 Modifying Excel PivotTable Calculations.mp4 63.87 MB
    18 - Excel PivotTables/003 Modifying Excel PivotTable Calculations_en.srt 9.45 KB
    18 - Excel PivotTables/004 Grouping PivotTable Data.mp4 75.73 MB
    18 - Excel PivotTables/004 Grouping PivotTable Data_en.srt 12.04 KB
    18 - Excel PivotTables/005 Formatting PivotTable Data.mp4 17.37 MB
    18 - Excel PivotTables/005 Formatting PivotTable Data_en.srt 6.56 KB
    18 - Excel PivotTables/006 Modifying PivotTable Calculations.mp4 33.3 MB
    18 - Excel PivotTables/006 Modifying PivotTable Calculations_en.srt 14.41 KB
    18 - Excel PivotTables/007 Drilling Down into PivotTable Data.mp4 61.49 MB
    18 - Excel PivotTables/007 Drilling Down into PivotTable Data_en.srt 6.52 KB
    18 - Excel PivotTables/008 Creating PivotCharts.mp4 39.77 MB
    18 - Excel PivotTables/008 Creating PivotCharts_en.srt 5.89 KB
    18 - Excel PivotTables/009 Filtering PivotTable Data.mp4 11.69 MB
    18 - Excel PivotTables/009 Filtering PivotTable Data_en.srt 4.55 KB
    18 - Excel PivotTables/010 Filtering with the Slicer Tool.mp4 13.29 MB
    18 - Excel PivotTables/010 Filtering with the Slicer Tool_en.srt 4.87 KB
    19 - Working with Excel's PowerPivot Tools/001 Introduction to Excel Power Pivot.mp4 14.09 MB
    19 - Working with Excel's PowerPivot Tools/001 Introduction to Excel Power Pivot_en.srt 6.73 KB
    19 - Working with Excel's PowerPivot Tools/002 Why PowerPivot.mp4 150.86 MB
    19 - Working with Excel's PowerPivot Tools/002 Why PowerPivot_en.srt 11.53 KB
    19 - Working with Excel's PowerPivot Tools/003 Activating the Excel PowerPivot AddIn.mp4 20.32 MB
    19 - Working with Excel's PowerPivot Tools/003 Activating the Excel PowerPivot AddIn_en.srt 5.14 KB
    19 - Working with Excel's PowerPivot Tools/004 Creating Data Models with PowerPivot.mp4 74.3 MB
    19 - Working with Excel's PowerPivot Tools/004 Creating Data Models with PowerPivot_en.srt 6.92 KB
    19 - Working with Excel's PowerPivot Tools/005 Excel Power Pivot Data Model Relationships.mp4 51.89 MB
    19 - Working with Excel's PowerPivot Tools/005 Excel Power Pivot Data Model Relationships_en.srt 7.12 KB
    19 - Working with Excel's PowerPivot Tools/006 Creating PivotTables based on Data Models.mp4 25.35 MB
    19 - Working with Excel's PowerPivot Tools/006 Creating PivotTables based on Data Models_en.srt 9.63 KB
    19 - Working with Excel's PowerPivot Tools/007 Excel Power Pivot KPIs.mp4 99.02 MB
    19 - Working with Excel's PowerPivot Tools/007 Excel Power Pivot KPIs_en.srt 16.11 KB
    20 - Working with Large Sets of Excel Data/001 Using the Freeze Panes Tool.mp4 25.75 MB
    20 - Working with Large Sets of Excel Data/001 Using the Freeze Panes Tool_en.srt 5.38 KB
    20 - Working with Large Sets of Excel Data/002 Grouping Data (Columns andor Rows).mp4 31.27 MB
    20 - Working with Large Sets of Excel Data/002 Grouping Data (Columns andor Rows)_en.srt 5.78 KB
    20 - Working with Large Sets of Excel Data/003 Print Options for Large Sets of Data.mp4 33.72 MB
    20 - Working with Large Sets of Excel Data/003 Print Options for Large Sets of Data_en.srt 10.91 KB
    20 - Working with Large Sets of Excel Data/004 Linking Worksheets (3D Formulas).mp4 13 MB
    20 - Working with Large Sets of Excel Data/004 Linking Worksheets (3D Formulas)_en.srt 5.29 KB
    20 - Working with Large Sets of Excel Data/005 Consolidating Data from Multiple Worksheets.mp4 18.6 MB
    20 - Working with Large Sets of Excel Data/005 Consolidating Data from Multiple Worksheets_en.srt 7.46 KB
    21 - Excel 102 Additional Practice Exercises/001 COMPLETED-Excel102ExtraPractice-01.xlsx 247.81 KB
    21 - Excel 102 Additional Practice Exercises/001 Excel 102 - Practice What You've Learned (DOWNLOAD).html 259 B
    21 - Excel 102 Additional Practice Exercises/001 Excel102ExtraPractice-01.xlsx 234.48 KB
    22 - Congratulations! You're an Intermediate Excel User/001 Congratulations!.mp4 18.3 MB
    22 - Congratulations! You're an Intermediate Excel User/001 Congratulations!_en.srt 2.25 KB
    23 - Microsoft Excel 103 Course Introduction/001 Excel 103 Course Exercise Files -- DOWNLOAD.mp4 6.28 MB
    23 - Microsoft Excel 103 Course Introduction/001 Excel 103 Course Exercise Files -- DOWNLOAD_en.srt 2.03 KB
    23 - Microsoft Excel 103 Course Introduction/001 Excel103-AdvancedExercises.xlsx 63.59 KB
    24 - Working with Excel's Conditional Functions/001 Working with Excel Name Ranges.mp4 13.9 MB
    24 - Working with Excel's Conditional Functions/001 Working with Excel Name Ranges_en.srt 6.72 KB
    24 - Working with Excel's Conditional Functions/002 Advantages and Disadvantages of Excel Name Ranges.mp4 24.01 MB
    24 - Working with Excel's Conditional Functions/002 Advantages and Disadvantages of Excel Name Ranges_en.srt 8.26 KB
    24 - Working with Excel's Conditional Functions/003 Editing an Excel Name Range.mp4 8.03 MB
    24 - Working with Excel's Conditional Functions/003 Editing an Excel Name Range_en.srt 4.2 KB
    24 - Working with Excel's Conditional Functions/004 Using Excel's IF() Function.mp4 16.6 MB
    24 - Working with Excel's Conditional Functions/004 Using Excel's IF() Function_en.srt 8.07 KB
    24 - Working with Excel's Conditional Functions/005 Excel's IF() Function with a Name Range.mp4 17.19 MB
    24 - Working with Excel's Conditional Functions/005 Excel's IF() Function with a Name Range_en.srt 8.54 KB
    24 - Working with Excel's Conditional Functions/006 Nesting Functions with Excel.mp4 156.93 MB
    24 - Working with Excel's Conditional Functions/006 Nesting Functions with Excel_en.srt 12.61 KB
    24 - Working with Excel's Conditional Functions/007 Nesting Excels AND() Function within the IF() Function.mp4 14.96 MB
    24 - Working with Excel's Conditional Functions/007 Nesting Excels AND() Function within the IF() Function_en.srt 6.39 KB
    24 - Working with Excel's Conditional Functions/008 Using Excel's COUNTIF() Function.mp4 8.06 MB
    24 - Working with Excel's Conditional Functions/008 Using Excel's COUNTIF() Function_en.srt 3.68 KB
    24 - Working with Excel's Conditional Functions/009 Using Excel's SUMIF() Function.mp4 70.6 MB
    24 - Working with Excel's Conditional Functions/009 Using Excel's SUMIF() Function_en.srt 9.66 KB
    24 - Working with Excel's Conditional Functions/010 Using Excel's IFERROR() Function.mp4 52.29 MB
    24 - Working with Excel's Conditional Functions/010 Using Excel's IFERROR() Function_en.srt 7.74 KB
    25 - Working with Excel's Lookup Functions/001 Microsoft Excel VLOOKUP() Function.mp4 98.02 MB
    25 - Working with Excel's Lookup Functions/001 Microsoft Excel VLOOKUP() Function_en.srt 15.7 KB
    25 - Working with Excel's Lookup Functions/002 Microsoft Excel HLOOKUP() Function.mp4 30.14 MB
    25 - Working with Excel's Lookup Functions/002 Microsoft Excel HLOOKUP() Function_en.srt 8.94 KB
    25 - Working with Excel's Lookup Functions/003 Microsoft Excel INDEX() Function.mp4 96.26 MB
    25 - Working with Excel's Lookup Functions/003 Microsoft Excel INDEX() Function_en.srt 15.51 KB
    25 - Working with Excel's Lookup Functions/004 Microsoft Excel MATCH() Function.mp4 83.03 MB
    25 - Working with Excel's Lookup Functions/004 Microsoft Excel MATCH() Function_en.srt 7.38 KB
    25 - Working with Excel's Lookup Functions/005 Microsoft Excel INDEX() and MATCH() Function Combined.mp4 68.69 MB
    25 - Working with Excel's Lookup Functions/005 Microsoft Excel INDEX() and MATCH() Function Combined_en.srt 10.77 KB
    25 - Working with Excel's Lookup Functions/006 Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4 88.84 MB
    25 - Working with Excel's Lookup Functions/006 Microsoft Excel INDEX() and MATCH() Function Combined Continued_en.srt 14.6 KB
    25 - Working with Excel's Lookup Functions/007 Creating a Dynamic HLOOKUP() with the MATCH() Function.mp4 39.07 MB
    25 - Working with Excel's Lookup Functions/007 Creating a Dynamic HLOOKUP() with the MATCH() Function_en.srt 10.97 KB
    26 - Working with Excel's Text Based Functions/001 Using Excel's LEFT(), RIGHT() and MID() Functions.mp4 39.45 MB
    26 - Working with Excel's Text Based Functions/001 Using Excel's LEFT(), RIGHT() and MID() Functions_en.srt 8.68 KB
    26 - Working with Excel's Text Based Functions/002 Using Excel's LEN() Function.mp4 29.55 MB
    26 - Working with Excel's Text Based Functions/002 Using Excel's LEN() Function_en.srt 8.49 KB
    26 - Working with Excel's Text Based Functions/003 Using Excel's SEARCH() Function.mp4 40.48 MB
    26 - Working with Excel's Text Based Functions/003 Using Excel's SEARCH() Function_en.srt 17.16 KB
    26 - Working with Excel's Text Based Functions/004 Using Excel's CONCATENATE() Function.mp4 10.69 MB
    26 - Working with Excel's Text Based Functions/004 Using Excel's CONCATENATE() Function_en.srt 4.08 KB
    27 - Auditing an Excel Worksheet/001 Tracing Precedents in Excel Formulas.mp4 15.44 MB
    27 - Auditing an Excel Worksheet/001 Tracing Precedents in Excel Formulas_en.srt 5.58 KB
    27 - Auditing an Excel Worksheet/002 Tracing Dependents in Excel Formulas.mp4 11.08 MB
    27 - Auditing an Excel Worksheet/002 Tracing Dependents in Excel Formulas_en.srt 3.77 KB
    27 - Auditing an Excel Worksheet/003 Working with the Watch Window.mp4 25.42 MB
    27 - Auditing an Excel Worksheet/003 Working with the Watch Window_en.srt 5.65 KB
    27 - Auditing an Excel Worksheet/004 Showing Formulas.mp4 9.94 MB
    27 - Auditing an Excel Worksheet/004 Showing Formulas_en.srt 4.16 KB
    28 - Protecting Excel Worksheets and Workbooks/001 Protecting Specific Cells in a Worksheet.mp4 31.08 MB
    28 - Protecting Excel Worksheets and Workbooks/001 Protecting Specific Cells in a Worksheet_en.srt 11.08 KB
    28 - Protecting Excel Worksheets and Workbooks/002 Protecting the Structure of a Workbook.mp4 12.49 MB
    28 - Protecting Excel Worksheets and Workbooks/002 Protecting the Structure of a Workbook_en.srt 5.49 KB
    28 - Protecting Excel Worksheets and Workbooks/003 Adding a Workbook Password.mp4 18.55 MB
    28 - Protecting Excel Worksheets and Workbooks/003 Adding a Workbook Password_en.srt 4.27 KB
    29 - Mastering Excel's What If Tools/001 Working with Excel's Goal Seek Tool.mp4 24.08 MB
    29 - Mastering Excel's What If Tools/001 Working with Excel's Goal Seek Tool_en.srt 10.98 KB
    29 - Mastering Excel's What If Tools/002 Working with Excel's Solver Tool.mp4 109.08 MB
    29 - Mastering Excel's What If Tools/002 Working with Excel's Solver Tool_en.srt 16.82 KB
    29 - Mastering Excel's What If Tools/003 Building Effective Data Tables in Excel.mp4 20.32 MB
    29 - Mastering Excel's What If Tools/003 Building Effective Data Tables in Excel_en.srt 7.74 KB
    29 - Mastering Excel's What If Tools/004 Creating Scenarios in Excel.mp4 48.15 MB
    29 - Mastering Excel's What If Tools/004 Creating Scenarios in Excel_en.srt 10.78 KB
    30 - Automating Repetitive Tasks in Excel with Macros/001 Understanding Excel Macros.mp4 19.32 MB
    30 - Automating Repetitive Tasks in Excel with Macros/001 Understanding Excel Macros_en.srt 5.13 KB
    30 - Automating Repetitive Tasks in Excel with Macros/002 Activating the Developer Tab in Excel.mp4 11.86 MB
    30 - Automating Repetitive Tasks in Excel with Macros/002 Activating the Developer Tab in Excel_en.srt 2.09 KB
    30 - Automating Repetitive Tasks in Excel with Macros/003 Creating a Macro with the Macro Recorder.mp4 72.65 MB
    30 - Automating Repetitive Tasks in Excel with Macros/003 Creating a Macro with the Macro Recorder_en.srt 11.12 KB
    30 - Automating Repetitive Tasks in Excel with Macros/004 Editing a Macro with VBA.mp4 31.68 MB
    30 - Automating Repetitive Tasks in Excel with Macros/004 Editing a Macro with VBA_en.srt 7.52 KB
    30 - Automating Repetitive Tasks in Excel with Macros/005 Creating Buttons to Run Macros.mp4 32.54 MB
    30 - Automating Repetitive Tasks in Excel with Macros/005 Creating Buttons to Run Macros_en.srt 4.45 KB
    31 - Excel 103 Additional Practice Exercises/001 COMPLETED-Excel103ExtraPractice-01.xlsx 95.25 KB
    31 - Excel 103 Additional Practice Exercises/001 Excel 103 - Practice What You've Learned (DOWNLOAD).html 259 B
    31 - Excel 103 Additional Practice Exercises/001 Excel103ExtraPractice-01.xlsx 92.6 KB
    32 - Congratulations!/001 Congratulations on Completing the Microsoft Excel 103.mp4 19.56 MB
    32 - Congratulations!/001 Congratulations on Completing the Microsoft Excel 103_en.srt 2.27 KB
    33 - Microsoft Excel Macros and VBA Course Introduction/001 Welcome to the Course.mp4 106.61 MB
    33 - Microsoft Excel Macros and VBA Course Introduction/001 Welcome to the Course_en.srt 8.65 KB
    33 - Microsoft Excel Macros and VBA Course Introduction/002 Understanding the Why and How Behind Excel Macros.mp4 15.38 MB
    33 - Microsoft Excel Macros and VBA Course Introduction/002 Understanding the Why and How Behind Excel Macros_en.srt 7.93 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/001 Introduction to Project #1 Inserting and Formatting Text.mp4 76.39 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/001 Introduction to Project #1 Inserting and Formatting Text_en.srt 5.48 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/002 COM-InsertingAndFormattingText.xlsm 20.06 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/002 InsertingAndFormattingText.xlsx 11.46 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/002 Project #1 Section Exercise Files (DOWNLOAD).html 500 B
    34 - Project #1 Using Excel's Macro Recorder Tool/003 Activating the Excel Developer Tab.mp4 11.07 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/003 Activating the Excel Developer Tab_en.srt 3.33 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/004 InsertingAndFormattingText.xlsx 17.38 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/004 Project #1 Start Recording!.mp4 53.55 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/004 Project #1 Start Recording!_en.srt 16.64 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/005 Running a Microsoft Excel Macro.mp4 20.3 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/005 Running a Microsoft Excel Macro_en.srt 6.64 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/006 Project #1 Running an Excel Macro with a Button.mp4 36.28 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/006 Project #1 Running an Excel Macro with a Button_en.srt 8.83 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/007 BONUS - Create a Custom Button Using Excel Shapes.mp4 25.03 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/007 BONUS - Create a Custom Button Using Excel Shapes_en.srt 6.42 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/008 Adding the Excel Macro to the Quick Access Toolbar.mp4 19.25 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/008 Adding the Excel Macro to the Quick Access Toolbar_en.srt 6.14 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/009 Project #1 Editing the VBA Recorded by the Macro Recorder.mp4 135.16 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/009 Project #1 Editing the VBA Recorded by the Macro Recorder_en.srt 18.28 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/010 Save a Workbook with a MacroVBA Code.mp4 12.2 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/010 Save a Workbook with a MacroVBA Code_en.srt 3.42 KB
    34 - Project #1 Using Excel's Macro Recorder Tool/011 Practical Uses of Excel Macros.mp4 13.96 MB
    34 - Project #1 Using Excel's Macro Recorder Tool/011 Practical Uses of Excel Macros_en.srt 3.39 KB
    35 - Excel VBA Concepts/001 Intro to Excel VBA Concepts.mp4 22.06 MB
    35 - Excel VBA Concepts/001 Intro to Excel VBA Concepts_en.srt 9.15 KB
    35 - Excel VBA Concepts/002 Intro to Excel VBA Object Oriented Programming Concepts.mp4 15.94 MB
    35 - Excel VBA Concepts/002 Intro to Excel VBA Object Oriented Programming Concepts_en.srt 6.22 KB
    35 - Excel VBA Concepts/003 COM-IntroToExcelVBACode-01.xlsm 15.33 KB
    35 - Excel VBA Concepts/003 ExcelMacrosAndVBA-PP.pptx 264.22 KB
    35 - Excel VBA Concepts/003 Intro to Excel VBA Exercise Files (DOWNLOAD).html 513 B
    35 - Excel VBA Concepts/004 The Visual Basic Editor (VBE).mp4 15.84 MB
    35 - Excel VBA Concepts/004 The Visual Basic Editor (VBE)_en.srt 7.42 KB
    35 - Excel VBA Concepts/005 Introduction to the Excel VBA Immediate Window.mp4 41.9 MB
    35 - Excel VBA Concepts/005 Introduction to the Excel VBA Immediate Window_en.srt 17.49 KB
    35 - Excel VBA Concepts/006 Excel VBA Modules.mp4 11.61 MB
    35 - Excel VBA Concepts/006 Excel VBA Modules_en.srt 5.22 KB
    35 - Excel VBA Concepts/007 Creating an Excel VBA Procedure.mp4 19.58 MB
    35 - Excel VBA Concepts/007 Creating an Excel VBA Procedure_en.srt 8.85 KB
    35 - Excel VBA Concepts/008 Adding Code to a VBA Procedure.mp4 22.03 MB
    35 - Excel VBA Concepts/008 Adding Code to a VBA Procedure_en.srt 6.48 KB
    35 - Excel VBA Concepts/009 Including Excel VBA Comments.mp4 9.28 MB
    35 - Excel VBA Concepts/009 Including Excel VBA Comments_en.srt 3.76 KB
    35 - Excel VBA Concepts/010 Excel VBA MSGBOX Function.mp4 24.96 MB
    35 - Excel VBA Concepts/010 Excel VBA MSGBOX Function_en.srt 10.89 KB
    35 - Excel VBA Concepts/011 Excel VBA MsgBox Microsoft Help Information.mp4 12.4 MB
    35 - Excel VBA Concepts/011 Excel VBA MsgBox Microsoft Help Information_en.srt 2.98 KB
    35 - Excel VBA Concepts/012 Understanding and Working with Excel VBA Variables.mp4 188.87 MB
    35 - Excel VBA Concepts/012 Understanding and Working with Excel VBA Variables_en.srt 23.9 KB
    35 - Excel VBA Concepts/013 REMINDER Saving an Excel Workbook with VBA Code.mp4 11.82 MB
    35 - Excel VBA Concepts/013 REMINDER Saving an Excel Workbook with VBA Code_en.srt 3.28 KB
    36 - Working with Excel VBA Logic Statements/001 COM-ExcelVBALoops.xlsm 16.12 KB
    36 - Working with Excel VBA Logic Statements/001 ExcelVBALoops.xlsx 8.94 KB
    36 - Working with Excel VBA Logic Statements/001 Working with Excel VBA Logic Exercise Files (DOWNLOAD).html 488 B
    36 - Working with Excel VBA Logic Statements/002 Building Logic with an Excel VBA IF Statement.mp4 98.82 MB
    36 - Working with Excel VBA Logic Statements/002 Building Logic with an Excel VBA IF Statement_en.srt 12.35 KB
    36 - Working with Excel VBA Logic Statements/003 Including an Else Statement in the VBA IF Statement.mp4 5.44 MB
    36 - Working with Excel VBA Logic Statements/003 Including an Else Statement in the VBA IF Statement_en.srt 2.32 KB
    36 - Working with Excel VBA Logic Statements/004 Expanding the IF Logic with Multiple ElseIf Statements.mp4 10.28 MB
    36 - Working with Excel VBA Logic Statements/004 Expanding the IF Logic with Multiple ElseIf Statements_en.srt 4.36 KB
    36 - Working with Excel VBA Logic Statements/005 Working with Excel VBA Select Case Statements.mp4 17.13 MB
    36 - Working with Excel VBA Logic Statements/005 Working with Excel VBA Select Case Statements_en.srt 7.29 KB
    36 - Working with Excel VBA Logic Statements/006 Working with an Excel VBA Do While Loop.mp4 40.88 MB
    36 - Working with Excel VBA Logic Statements/006 Working with an Excel VBA Do While Loop_en.srt 18.05 KB
    36 - Working with Excel VBA Logic Statements/007 Excel VBA Do While Loop Dynamic Condition.mp4 20.57 MB
    36 - Working with Excel VBA Logic Statements/007 Excel VBA Do While Loop Dynamic Condition_en.srt 9.76 KB
    36 - Working with Excel VBA Logic Statements/008 Working with an Excel VBA For Each Loop.mp4 21.36 MB
    36 - Working with Excel VBA Logic Statements/008 Working with an Excel VBA For Each Loop_en.srt 8.91 KB
    36 - Working with Excel VBA Logic Statements/009 Working with an Excel VBA For Next Loop.mp4 26.91 MB
    36 - Working with Excel VBA Logic Statements/009 Working with an Excel VBA For Next Loop_en.srt 11.52 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/001 Introduction to Project #2 Interacting with the User.mp4 11.34 MB
    37 - Project #2 Moving Beyond the Basics and into VBA/001 Introduction to Project #2 Interacting with the User_en.srt 3.21 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/002 Beyond the Basics Sort Project Exercise Files (DOWNLOAD).html 492 B
    37 - Project #2 Moving Beyond the Basics and into VBA/002 COM-SortingRecords.xlsm 22.24 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/002 SortingRecords.xlsx 11.11 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/003 Project #2 Introduction to the Excel VBA Range.Sort Method.mp4 15.36 MB
    37 - Project #2 Moving Beyond the Basics and into VBA/003 Project #2 Introduction to the Excel VBA Range.Sort Method_en.srt 6.75 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/003 SortingRecords.xlsm 16.71 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/004 Creating the Excel VBA Sort Procedures for this Project.mp4 102.19 MB
    37 - Project #2 Moving Beyond the Basics and into VBA/004 Creating the Excel VBA Sort Procedures for this Project_en.srt 13.89 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/005 Project #2 Prompting the User for Information.mp4 59 MB
    37 - Project #2 Moving Beyond the Basics and into VBA/005 Project #2 Prompting the User for Information_en.srt 14.99 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/006 Continue Excel VBA InputBox.mp4 56.6 MB
    37 - Project #2 Moving Beyond the Basics and into VBA/006 Continue Excel VBA InputBox_en.srt 12.86 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/007 Project #2 Building Logic into Your Macros.mp4 25.66 MB
    37 - Project #2 Moving Beyond the Basics and into VBA/007 Project #2 Building Logic into Your Macros_en.srt 6.59 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/008 Project #2 Alerting the User of Errors.mp4 60.06 MB
    37 - Project #2 Moving Beyond the Basics and into VBA/008 Project #2 Alerting the User of Errors_en.srt 15.42 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/009 Using Excel VBA Error Control Statements.mp4 22.01 MB
    37 - Project #2 Moving Beyond the Basics and into VBA/009 Using Excel VBA Error Control Statements_en.srt 6.65 KB
    37 - Project #2 Moving Beyond the Basics and into VBA/010 Create a Button to Run the Sort Procedure and Save.mp4 10.46 MB
    37 - Project #2 Moving Beyond the Basics and into VBA/010 Create a Button to Run the Sort Procedure and Save_en.srt 3.71 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/001 Introduction to Project #3 Cleaning Up and Formatting Data.mp4 11.99 MB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/001 Introduction to Project #3 Cleaning Up and Formatting Data_en.srt 3.49 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/002 CleaningUpData.xlsx 15.54 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/002 COM-CleaningUpData-01.xlsm 28 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/002 Project #3 Exercise Files (DOWNLOAD).html 460 B
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/003 Project #3 Preparing to the Use the Macro Recorder.mp4 15.62 MB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/003 Project #3 Preparing to the Use the Macro Recorder_en.srt 4.54 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/004 Project #3 Inserting the Headers.mp4 23.66 MB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/004 Project #3 Inserting the Headers_en.srt 7.66 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/005 Project #3 Formatting the Headers.mp4 20.97 MB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/005 Project #3 Formatting the Headers_en.srt 6.23 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/006 Project #3 Testing the Macros.mp4 15.59 MB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/006 Project #3 Testing the Macros_en.srt 3.74 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/007 Project #3 Using an Excel VBA Loop to Loop through all Worksheets.mp4 48.17 MB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/007 Project #3 Using an Excel VBA Loop to Loop through all Worksheets_en.srt 14.65 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/008 Project #3 Testing the Excel VBA Loop.mp4 19.51 MB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/008 Project #3 Testing the Excel VBA Loop_en.srt 5.39 KB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/009 Project #3 Adding Logic to an Excel VBA Loop.mp4 86.44 MB
    38 - Project #3 Preparing and Cleaning Up Data with Excel VBA/009 Project #3 Adding Logic to an Excel VBA Loop_en.srt 10.72 KB
    39 - Project #4 Using VBA to Automate Excel Formulas/001 Introduction to Project #4 Automate Excel Formulas.mp4 11.21 MB
    39 - Project #4 Using VBA to Automate Excel Formulas/001 Introduction to Project #4 Automate Excel Formulas_en.srt 2.72 KB
    39 - Project #4 Using VBA to Automate Excel Formulas/002 AutomateSumFunction.xlsx 15.23 KB
    39 - Project #4 Using VBA to Automate Excel Formulas/002 COM-AutomateSumFunction-01.xlsm 22.55 KB
    39 - Project #4 Using VBA to Automate Excel Formulas/002 Project #4 Automate Sum Function Exercise Files (DOWNLOAD).html 470 B
    39 - Project #4 Using VBA to Automate Excel Formulas/003 AutomateSumFunction.xlsx 19.83 KB
    39 - Project #4 Using VBA to Automate Excel Formulas/003 Project #4 Start the Procedure to Automate the SUM Function.mp4 111.09 MB
    39 - Project #4 Using VBA to Automate Excel Formulas/003 Project #4 Start the Procedure to Automate the SUM Function_en.srt 9.65 KB
    39 - Project #4 Using VBA to Automate Excel Formulas/004 Working with the Range Address Property.mp4 25.79 MB
    39 - Project #4 Using VBA to Automate Excel Formulas/004 Working with the Range Address Property_en.srt 7.42 KB
    39 - Project #4 Using VBA to Automate Excel Formulas/005 Creating the SUM Function in VBA.mp4 69.26 MB
    39 - Project #4 Using VBA to Automate Excel Formulas/005 Creating the SUM Function in VBA_en.srt 8.06 KB
    39 - Project #4 Using VBA to Automate Excel Formulas/006 Run the Excel VBA Procedure to SUM Records.mp4 32.39 MB
    39 - Project #4 Using VBA to Automate Excel Formulas/006 Run the Excel VBA Procedure to SUM Records_en.srt 4.36 KB
    39 - Project #4 Using VBA to Automate Excel Formulas/007 Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4 59.73 MB
    39 - Project #4 Using VBA to Automate Excel Formulas/007 Project #4 Loop the SUM() Function Over Multiple Worksheets_en.srt 8.81 KB
    40 - Project #5 Bringing it All Together and a Weekly Report/001 Introduction to Project #5 Creating the Final Report.mp4 10.21 MB
    40 - Project #5 Bringing it All Together and a Weekly Report/001 Introduction to Project #5 Creating the Final Report_en.srt 2.95 KB
    40 - Project #5 Bringing it All Together and a Weekly Report/002 COM-QuarterlyReport-01.xlsm 34.32 KB
    40 - Project #5 Bringing it All Together and a Weekly Report/002 Project #5 Final Report Loop Exercise Files (DOWNLOAD).html 462 B
    40 - Project #5 Bringing it All Together and a Weekly Report/002 QuarterlyReport.xlsm 23.07 KB
    40 - Project #5 Bringing it All Together and a Weekly Report/003 Project #5 Creating the Final Report Excel VBA Loop.mp4 23.82 MB
    40 - Project #5 Bringing it All Together and a Weekly Report/003 Project #5 Creating the Final Report Excel VBA Loop_en.srt 7.08 KB
    40 - Project #5 Bringing it All Together and a Weekly Report/004 Project #5 - Copying Content with Excel VBA.mp4 27.51 MB
    40 - Project #5 Bringing it All Together and a Weekly Report/004 Project #5 - Copying Content with Excel VBA_en.srt 8.26 KB
    40 - Project #5 Bringing it All Together and a Weekly Report/005 Project #5 - Pasting Content with Excel VBA.mp4 23.22 MB
    40 - Project #5 Bringing it All Together and a Weekly Report/005 Project #5 - Pasting Content with Excel VBA_en.srt 7.02 KB
    40 - Project #5 Bringing it All Together and a Weekly Report/006 Cleaning Up the Final Report VBA Loop Code.mp4 25.56 MB
    40 - Project #5 Bringing it All Together and a Weekly Report/006 Cleaning Up the Final Report VBA Loop Code_en.srt 6.99 KB
    40 - Project #5 Bringing it All Together and a Weekly Report/007 Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet.mp4 35.73 MB
    40 - Project #5 Bringing it All Together and a Weekly Report/007 Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet_en.srt 8.2 KB
    40 - Project #5 Bringing it All Together and a Weekly Report/008 Project #5 - Running the Final Report Procedure.mp4 12.49 MB
    40 - Project #5 Bringing it All Together and a Weekly Report/008 Project #5 - Running the Final Report Procedure_en.srt 3.48 KB
    41 - Project #6 Working with Excel VBA User Forms/001 Introduction to Project #6 Working with Excel VBA User Forms.mp4 17.6 MB
    41 - Project #6 Working with Excel VBA User Forms/001 Introduction to Project #6 Working with Excel VBA User Forms_en.srt 4.23 KB
    41 - Project #6 Working with Excel VBA User Forms/001 QuarterlyReportForm-01.xlsm 24.47 KB
    41 - Project #6 Working with Excel VBA User Forms/002 COM-QuarterlyReportForm-01.xlsm 44.48 KB
    41 - Project #6 Working with Excel VBA User Forms/002 Project #6 Working with Excel VBA User Forms Exercise Files (DOWNLOAD).html 473 B
    41 - Project #6 Working with Excel VBA User Forms/002 QuarterlyReportForm-01.xlsm 31.66 KB
    41 - Project #6 Working with Excel VBA User Forms/003 Project #6 Creating an Excel User Form.mp4 25.99 MB
    41 - Project #6 Working with Excel VBA User Forms/003 Project #6 Creating an Excel User Form_en.srt 8.12 KB
    41 - Project #6 Working with Excel VBA User Forms/004 Project #6 Working with Form and Control Properties.mp4 31.45 MB
    41 - Project #6 Working with Excel VBA User Forms/004 Project #6 Working with Form and Control Properties_en.srt 9.89 KB
    41 - Project #6 Working with Excel VBA User Forms/005 Project #6 Formatting Excel VBA User Form Controls.mp4 15.78 MB
    41 - Project #6 Working with Excel VBA User Forms/005 Project #6 Formatting Excel VBA User Form Controls_en.srt 5.63 KB
    41 - Project #6 Working with Excel VBA User Forms/006 Project #6 Adding VBA Code to the Initialize Event.mp4 45.12 MB
    41 - Project #6 Working with Excel VBA User Forms/006 Project #6 Adding VBA Code to the Initialize Event_en.srt 13.75 KB
    41 - Project #6 Working with Excel VBA User Forms/007 Project #6 Using the AddItem Method within a Loop.mp4 47.84 MB
    41 - Project #6 Working with Excel VBA User Forms/007 Project #6 Using the AddItem Method within a Loop_en.srt 15.11 KB
    41 - Project #6 Working with Excel VBA User Forms/008 Project #6 Adding VBA Code to the ComboBox Change Event.mp4 18.46 MB
    41 - Project #6 Working with Excel VBA User Forms/008 Project #6 Adding VBA Code to the ComboBox Change Event_en.srt 5.44 KB
    41 - Project #6 Working with Excel VBA User Forms/009 Project #6 Adding VBA Code to the Add Worksheet Button.mp4 18.3 MB
    41 - Project #6 Working with Excel VBA User Forms/009 Project #6 Adding VBA Code to the Add Worksheet Button_en.srt 5.98 KB
    41 - Project #6 Working with Excel VBA User Forms/010 Project #6 Change Worksheet Name.mp4 11.13 MB
    41 - Project #6 Working with Excel VBA User Forms/010 Project #6 Change Worksheet Name_en.srt 4.88 KB
    41 - Project #6 Working with Excel VBA User Forms/011 Project #6 Catch Errors When Adding a Worksheet.mp4 13.34 MB
    41 - Project #6 Working with Excel VBA User Forms/011 Project #6 Catch Errors When Adding a Worksheet_en.srt 4.06 KB
    41 - Project #6 Working with Excel VBA User Forms/012 Add Sheet Procedure Catch Errors.html 1.14 KB
    41 - Project #6 Working with Excel VBA User Forms/012 AddSheetError-Solution-01.txt 890 B
    41 - Project #6 Working with Excel VBA User Forms/013 Project #6 Additional Conditions on the Loop.mp4 67.48 MB
    41 - Project #6 Working with Excel VBA User Forms/013 Project #6 Additional Conditions on the Loop_en.srt 8.72 KB
    41 - Project #6 Working with Excel VBA User Forms/014 Project #6 Running the Final Report Procedure.mp4 32.42 MB
    41 - Project #6 Working with Excel VBA User Forms/014 Project #6 Running the Final Report Procedure_en.srt 5.53 KB
    41 - Project #6 Working with Excel VBA User Forms/015 Project #6 Showing the VBA User Form On Workbook Open.mp4 42.88 MB
    41 - Project #6 Working with Excel VBA User Forms/015 Project #6 Showing the VBA User Form On Workbook Open_en.srt 5.89 KB
    42 - Project #7 Importing Data from Text Files/001 April2015Sales.txt 1.77 KB
    42 - Project #7 Importing Data from Text Files/001 Dec2015Sales.txt 1.13 KB
    42 - Project #7 Importing Data from Text Files/001 Feb2015Sales.txt 1.16 KB
    42 - Project #7 Importing Data from Text Files/001 Jan2015Sales.txt 1.25 KB
    42 - Project #7 Importing Data from Text Files/001 Mar2015Sales.txt 1.2 KB
    42 - Project #7 Importing Data from Text Files/001 May2015Sales.txt 1.24 KB
    42 - Project #7 Importing Data from Text Files/001 Nov2015Sales.txt 1.26 KB
    42 - Project #7 Importing Data from Text Files/001 Project #7 Opening a Text File for Import.mp4 20.49 MB
    42 - Project #7 Importing Data from Text Files/001 Project #7 Opening a Text File for Import_en.srt 4.26 KB
    42 - Project #7 Importing Data from Text Files/002 Project #7 Opening a Text File for Import.mp4 30.76 MB
    42 - Project #7 Importing Data from Text Files/002 Project #7 Opening a Text File for Import_en.srt 9.82 KB
    42 - Project #7 Importing Data from Text Files/003 Project #7 Get Data from Text File.mp4 21.05 MB
    42 - Project #7 Importing Data from Text Files/003 Project #7 Get Data from Text File_en.srt 8.96 KB
    42 - Project #7 Importing Data from Text Files/004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4 41.97 MB
    42 - Project #7 Importing Data from Text Files/004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method_en.srt 13.58 KB
    42 - Project #7 Importing Data from Text Files/005 Project #7 Creating a Loop to Read Each File.mp4 22.62 MB
    42 - Project #7 Importing Data from Text Files/005 Project #7 Creating a Loop to Read Each File_en.srt 12.17 KB
    42 - Project #7 Importing Data from Text Files/006 Project #7 Adding a New Sheet for Imported Data.mp4 14.92 MB
    42 - Project #7 Importing Data from Text Files/006 Project #7 Adding a New Sheet for Imported Data_en.srt 4 KB
    42 - Project #7 Importing Data from Text Files/007 Project #7 Clear the Clipboard.mp4 19.84 MB
    42 - Project #7 Importing Data from Text Files/007 Project #7 Clear the Clipboard_en.srt 6.01 KB
    42 - Project #7 Importing Data from Text Files/008 Project #7 Working with the ScreenUpdating Property.mp4 12.25 MB
    42 - Project #7 Importing Data from Text Files/008 Project #7 Working with the ScreenUpdating Property_en.srt 5.54 KB
    42 - Project #7 Importing Data from Text Files/009 Project #7 Creating Reusable Code with a VBA Function.mp4 47.84 MB
    42 - Project #7 Importing Data from Text Files/009 Project #7 Creating Reusable Code with a VBA Function_en.srt 11.97 KB
    43 - Course Wrap Up/001 Congratulations! You're an Excel MacroVBA Master.mp4 2.95 MB
    43 - Course Wrap Up/001 Congratulations! You're an Excel MacroVBA Master_en.srt 1.24 KB

Download Info

  • Tips

    “Udemy - Microsoft Excel - Excel from Beginner to Advanced 2022-7” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.

  • DMCA Notice and Takedown Procedure

    If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.