zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[FreeAllCourse.Com] Udemy - Microsoft Excel - Excel from Beginner to Advanced
magnet:?xt=urn:btih:c907462f660499c1a5f2b5e0e7acf001623e0630&dn=[FreeAllCourse.Com] Udemy - Microsoft Excel - Excel from Beginner to Advanced
磁力链接详情
Hash值:
c907462f660499c1a5f2b5e0e7acf001623e0630
点击数:
107
文件大小:
6.73 GB
文件数量:
191
创建日期:
2020-2-23 19:40
最后访问:
2024-12-28 09:32
访问标签:
FreeAllCourse
Com
Udemy
-
Microsoft
Excel
-
Excel
from
Beginner
to
Advanced
文件列表详情
1. Microsoft Excel 101 Course Introduction/1. Ask Questions.mp4 71.33 MB
1. Microsoft Excel 101 Course Introduction/2. Course Exercise Files.mp4 60.34 MB
1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.mp4 39.66 MB
10. Working with Excel Templates/1. Intro to Excel Templates.mp4 5.39 MB
10. Working with Excel Templates/2. Opening an Existing Template.mp4 22.27 MB
10. Working with Excel Templates/3. Creating a Custom Template.mp4 16.34 MB
11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.mp4 5.56 MB
13. Working with an Excel List/1. Understanding Excel List Structure.mp4 29.38 MB
13. Working with an Excel List/2. Sorting a List Using Single Level Sort.mp4 20.27 MB
13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.mp4 20.4 MB
13. Working with an Excel List/4. Using Custom Sorts in an Excel List.mp4 20.46 MB
13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.mp4 20.79 MB
13. Working with an Excel List/6. Creating Subtotals in a List.mp4 39.64 MB
13. Working with an Excel List/7. Format a List as a Table.mp4 42.73 MB
13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.mp4 22.84 MB
13. Working with an Excel List/9. Removing Duplicates.mp4 22.86 MB
14. Excel List Functions/1. Excel Function DSUM().mp4 39.62 MB
14. Excel List Functions/2. Excel Function DAVERAGE().mp4 17.58 MB
14. Excel List Functions/3. Excel Function DCOUNT().mp4 19.3 MB
14. Excel List Functions/4. Excel Function SUBTOTAL().mp4 40.63 MB
15. Excel Data Validation/1. Understanding the Need for Data Validation.mp4 22.73 MB
15. Excel Data Validation/2. Creating a Validation List.mp4 25.97 MB
15. Excel Data Validation/3. Adding a Custom Validation Error.mp4 20.64 MB
15. Excel Data Validation/4. Dynamic Formulas by Using Validation Techniques.mp4 22.51 MB
16. Importing and Exporting Data/1. Importing Data from Text Files.mp4 19.08 MB
16. Importing and Exporting Data/2. Importing Data from Microsoft Access.mp4 16.92 MB
16. Importing and Exporting Data/3. Exporting Data to a Text File.mp4 22.48 MB
17. Excel PivotTables/1. Understanding Excel PivotTables.mp4 23.29 MB
17. Excel PivotTables/2. Creating an Excel PivotTable.mp4 30 MB
17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.mp4 26.56 MB
17. Excel PivotTables/4. Grouping PivotTable Data.mp4 17.15 MB
17. Excel PivotTables/5. Formatting PivotTable Data.mp4 19.5 MB
17. Excel PivotTables/6. Drilling Down into PivotTable Data.mp4 21.07 MB
17. Excel PivotTables/7. Creating PivotCharts.mp4 22.54 MB
17. Excel PivotTables/8. Filtering PivotTable Data.mp4 17.17 MB
17. Excel PivotTables/9. Filtering with the Slicer Tool.mp4 18.06 MB
18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.mp4 32.63 MB
18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.mp4 8.09 MB
18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.mp4 45.84 MB
18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.mp4 20.42 MB
18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.mp4 24.02 MB
18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.mp4 35.88 MB
19. Working with Large Sets of Excel Data/1. Using the Freeze Panes Tool.mp4 22.39 MB
19. Working with Large Sets of Excel Data/2. Grouping Data (Columns andor Rows).mp4 27.54 MB
19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.mp4 40.97 MB
19. Working with Large Sets of Excel Data/4. Linking Worksheets (3D Formulas).mp4 11.98 MB
19. Working with Large Sets of Excel Data/5. Consolidating Data from Multiple Worksheets.mp4 18.14 MB
2. Microsoft Excel Fundamentals/1. Launching Excel.mp4 33.7 MB
2. Microsoft Excel Fundamentals/2. Microsoft Excel Startup Screen.mp4 62.59 MB
2. Microsoft Excel Fundamentals/3. Introduction to the Excel Interface.mp4 116.39 MB
2. Microsoft Excel Fundamentals/4. Customizing the Excel Quick Access Toolbar.mp4 55.15 MB
2. Microsoft Excel Fundamentals/5. More on the Excel Interface.mp4 54.7 MB
2. Microsoft Excel Fundamentals/6. Understanding the Structure of an Excel Workbook.mp4 78.53 MB
2. Microsoft Excel Fundamentals/7. Saving an Excel Document.mp4 74.77 MB
2. Microsoft Excel Fundamentals/8. Opening an Existing Excel Document.mp4 29.18 MB
2. Microsoft Excel Fundamentals/9. Common Excel Shortcut Keys.mp4 49.18 MB
20. Congratulations! You're an Intermediate Excel User/1. Congratulations!.mp4 8.64 MB
22. Working with Excel's Conditional Functions/1. Working with Excel Name Ranges.mp4 22.31 MB
22. Working with Excel's Conditional Functions/2. Using Excel's IF() Function.mp4 26.93 MB
22. Working with Excel's Conditional Functions/3. Nesting Functions.mp4 34.94 MB
22. Working with Excel's Conditional Functions/4. Using Excel's COUNTIF() Function.mp4 19.11 MB
22. Working with Excel's Conditional Functions/5. Using Excel's SUMIF() Function.mp4 29.18 MB
22. Working with Excel's Conditional Functions/6. Using Excel's IFERROR() Function.mp4 23 MB
23. Working with Excel's Lookup Functions/1. Using Excel's VLOOKUP() Function.mp4 35.73 MB
23. Working with Excel's Lookup Functions/2. Using Excel's HLOOKUP() Function.mp4 17.74 MB
23. Working with Excel's Lookup Functions/3. Using Excel's INDEX() and MATCH() Functions.mp4 63.96 MB
24. Working with Excel's Text Based Functions/1. Using Excel's LEFT(), RIGHT() and MID() Functions.mp4 30.37 MB
24. Working with Excel's Text Based Functions/2. Using Excel's LEN() Function.mp4 37.16 MB
24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.mp4 41.86 MB
24. Working with Excel's Text Based Functions/4. Using Excel's CONCATENATE() Function.mp4 11.86 MB
25. Auditing an Excel Worksheet/1. Tracing Precendents in Excel Formulas.mp4 19.62 MB
25. Auditing an Excel Worksheet/2. Tracing Dependents in Excel Formulas.mp4 14.12 MB
25. Auditing an Excel Worksheet/3. Working with the Watch Window.mp4 15.26 MB
25. Auditing an Excel Worksheet/4. Showing Formulas.mp4 12.9 MB
26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.mp4 39.54 MB
26. Protecting Excel Worksheets and Workbooks/2. Protecting the Structure of a Workbook.mp4 12.34 MB
26. Protecting Excel Worksheets and Workbooks/3. Adding a Workbook Password.mp4 14.34 MB
27. Mastering Excel's What If Tools/1. Working with Excel's Goal Seek Tool.mp4 23.93 MB
27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.mp4 188.79 MB
27. Mastering Excel's What If Tools/3. Building Effective Data Tables in Excel.mp4 19.38 MB
27. Mastering Excel's What If Tools/4. Creating Scenarios in Excel.mp4 35.53 MB
28. Automating Repetitive Tasks in Excel with Macros/1. Understanding Excel Macros.mp4 22.97 MB
28. Automating Repetitive Tasks in Excel with Macros/2. Activating the Developer Tab in Excel.mp4 10.34 MB
28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.mp4 46.4 MB
28. Automating Repetitive Tasks in Excel with Macros/4. Editing a Macro with VBA.mp4 25.39 MB
28. Automating Repetitive Tasks in Excel with Macros/5. Creating Buttons to Run Macros.mp4 19.75 MB
29. Congratulations!/1. Congratulations on Competing the Microsoft Excel 103.mp4 3.4 MB
3. Entering and Editing Text and Formulas/1. Entering Text to Create Spreadsheet Titles.mp4 148.09 MB
3. Entering and Editing Text and Formulas/2. Working with Numeric Data in Excel.mp4 150.64 MB
3. Entering and Editing Text and Formulas/3. Entering Date Values in Excel.mp4 150.69 MB
3. Entering and Editing Text and Formulas/4. Working with Cell References.mp4 101.61 MB
3. Entering and Editing Text and Formulas/5. Creating Basic Formulas in Excel.mp4 146.34 MB
3. Entering and Editing Text and Formulas/6. Relative Versus Absolute Cell References in Formulas.mp4 212.7 MB
3. Entering and Editing Text and Formulas/7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4 173.33 MB
30. Microsoft Excel Macros and VBA Course Introduction/1. Welcome to the Course.mp4 32.2 MB
30. Microsoft Excel Macros and VBA Course Introduction/2. Understanding the Why and How Behind Excel Macros.mp4 14.88 MB
31. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 Inserting and Formatting Text.mp4 13.09 MB
31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.mp4 49.21 MB
31. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.mp4 8.57 MB
31. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 Running a Macro with a Button.mp4 21.78 MB
31. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 Opps! I Need to Edit My Macro.mp4 27.86 MB
31. Project #1 Using Excel's Macro Recorder Tool/6. Practical Uses of Excel Macros.mp4 18.54 MB
32. Excel VBA Concepts/1. Excel VBA Concepts.mp4 22.17 MB
32. Excel VBA Concepts/2. The Visual Basic Editor (VBE).mp4 9.42 MB
32. Excel VBA Concepts/3. Excel VBA Modules.mp4 5.38 MB
32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.mp4 43.03 MB
32. Excel VBA Concepts/5. Adding Code to a VBA Procedure.mp4 23.2 MB
32. Excel VBA Concepts/6. Understanding Excel VBA Variables.mp4 37.37 MB
32. Excel VBA Concepts/7. Building Logic with an IF Statement.mp4 35.39 MB
32. Excel VBA Concepts/8. Working with Excel VBA Loops to Repeat Blocks of Code.mp4 27.66 MB
33. Project #2 Moving Beyond the Basics and into VBA/1. Introduction to Project #2 Interacting with the User.mp4 18.14 MB
33. Project #2 Moving Beyond the Basics and into VBA/2. Project #2 Breaking Down the VBA Code.mp4 11.97 MB
33. Project #2 Moving Beyond the Basics and into VBA/3. Project #2 Prompting the User for Information.mp4 20.58 MB
33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.mp4 38.87 MB
33. Project #2 Moving Beyond the Basics and into VBA/5. Project #2 Building Logic into Your Macros.mp4 14.76 MB
33. Project #2 Moving Beyond the Basics and into VBA/6. Project #2 Alerting the User of Errors.mp4 33.72 MB
33. Project #2 Moving Beyond the Basics and into VBA/7. Other Practical Uses of Message and Input Boxes.mp4 24.42 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/1. Introduction to Project #3 Cleaning Up and Formatting Data.mp4 10.71 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/2. Project #3 Preparing to the Use the Macro Recorder.mp4 9.5 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/3. Project #3 Inserting the Headers.mp4 22.12 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/4. Project #3 Formatting the Headers.mp4 7.46 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/5. Project #3 Putting it all Together with a Little VBA.mp4 35.83 MB
34. Project #3 Preparing and Cleaning Up Data with a Little VBA/6. Running the Loop.mp4 18.93 MB
35. Project #4 Using VBA to Automate Excel Formulas/1. Introduction to Project #4 Automate Excel Formulas.mp4 7.47 MB
35. Project #4 Using VBA to Automate Excel Formulas/2. Project #4 Automate the SUM() Function through Code.mp4 25.55 MB
35. Project #4 Using VBA to Automate Excel Formulas/3. Continue Automate SUM Function.mp4 17.54 MB
35. Project #4 Using VBA to Automate Excel Formulas/4. Test the SUM Function.mp4 12.37 MB
35. Project #4 Using VBA to Automate Excel Formulas/5. Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4 20.08 MB
36. Project #5 Bringing it All Together and a Weekly Report/1. Introduction to Project #5 Creating the Final Report.mp4 10.99 MB
36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.mp4 47.28 MB
36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.mp4 54.76 MB
36. Project #5 Bringing it All Together and a Weekly Report/4. Project #5 - Running the Final Report Procedure.mp4 19.95 MB
37. Project #6 Working with Excel VBA User Forms/1. Introduction to Project #6 Working with Excel VBA User Forms.mp4 8.79 MB
37. Project #6 Working with Excel VBA User Forms/2. Project #6 Creating an Excel User Form.mp4 15.05 MB
37. Project #6 Working with Excel VBA User Forms/3. Project #6 Adding Controls to the Form.mp4 11.65 MB
37. Project #6 Working with Excel VBA User Forms/4. Project #6 Adding VBA Code to the Initialize Event.mp4 24.35 MB
37. Project #6 Working with Excel VBA User Forms/5. Project #6 Adding VBA Code to the ComboBox Change Event.mp4 24.22 MB
37. Project #6 Working with Excel VBA User Forms/6. Project #6 Adding VBA Code to the Add Worksheet Button.mp4 10.11 MB
37. Project #6 Working with Excel VBA User Forms/7. Change Worksheet Name.mp4 11.7 MB
37. Project #6 Working with Excel VBA User Forms/8. Project #6 Adding VBA Code to the Create Report Button.mp4 27.43 MB
37. Project #6 Working with Excel VBA User Forms/9. Project #6 Showing the Form.mp4 12.39 MB
38. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.mp4 26.03 MB
38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.mp4 42.26 MB
38. Project #7 Importing Data from Text Files/3. Project #7 Get Data from Text File.mp4 32.64 MB
38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp4 65.62 MB
38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.mp4 56.87 MB
38. Project #7 Importing Data from Text Files/6. Project #7 Adding a New Sheet for Imported Data.mp4 23.83 MB
38. Project #7 Importing Data from Text Files/7. Project #7 Clear the Clipboard.mp4 32.06 MB
38. Project #7 Importing Data from Text Files/8. Project #7 Working with the ScreenUpdating Property.mp4 34.5 MB
38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.mp4 61.05 MB
39. Course Wrap Up/1. Congratulations! You're an Excel MacroVBA Master.mp4 18.1 MB
4. Working with Basic Excel Functions/1. The structure of an Excel Function.mp4 161.97 MB
4. Working with Basic Excel Functions/2. Working with the SUM() Function.mp4 113.76 MB
4. Working with Basic Excel Functions/3. Working with the MIN() and MAX() Functions.mp4 101.81 MB
4. Working with Basic Excel Functions/4. Working with the AVERAGE() Function.mp4 47.22 MB
4. Working with Basic Excel Functions/5. Working with the COUNT() Function.mp4 47.57 MB
4. Working with Basic Excel Functions/6. Adjacent Cells Error in Excel Calculations.mp4 60.08 MB
4. Working with Basic Excel Functions/7. Using the AutoSum Command.mp4 111.96 MB
4. Working with Basic Excel Functions/8. Excel's AutoSum Shortcut Key.mp4 36.81 MB
4. Working with Basic Excel Functions/9. Using the AutoFill Command to Copy Formulas.mp4 73.03 MB
5. Modifying an Excel Worksheet/1. Moving and Copying Data in an Excel Worksheet.mp4 111.68 MB
5. Modifying an Excel Worksheet/2. Inserting and Deleting Rows and Columns.mp4 119.78 MB
5. Modifying an Excel Worksheet/3. Changing the Width and Height of Cells.mp4 84.73 MB
5. Modifying an Excel Worksheet/4. Hiding and Unhiding Excel Rows and Columns.mp4 85.99 MB
5. Modifying an Excel Worksheet/5. Renaming an Excel Worksheet.mp4 46.67 MB
5. Modifying an Excel Worksheet/6. Deleting an Excel Worksheet.mp4 78.95 MB
5. Modifying an Excel Worksheet/7. Moving and Copying an Excel Worksheet.mp4 89.61 MB
6. Formatting Data in an Excel Worksheet/1. Working with Font Formatting Commands.mp4 11.78 MB
6. Formatting Data in an Excel Worksheet/2. Changing the Background Color of a Cell.mp4 8.63 MB
6. Formatting Data in an Excel Worksheet/3. Adding Borders to Cells.mp4 10.49 MB
6. Formatting Data in an Excel Worksheet/4. Formatting Data as Currency Values.mp4 16.45 MB
6. Formatting Data in an Excel Worksheet/5. Formatting Percentages.mp4 7.03 MB
6. Formatting Data in an Excel Worksheet/6. Using Excel's Format Painter.mp4 8.95 MB
6. Formatting Data in an Excel Worksheet/7. Creating Styles to Format Data.mp4 29.08 MB
6. Formatting Data in an Excel Worksheet/8. Merging and Centering Cells.mp4 9.87 MB
6. Formatting Data in an Excel Worksheet/9. Using Conditional Formatting.mp4 15.28 MB
7. Inserting Images and Shapes into an Excel Worksheet/1. Inserting Images.mp4 14.2 MB
7. Inserting Images and Shapes into an Excel Worksheet/2. Inserting Excel Shapes.mp4 13.25 MB
7. Inserting Images and Shapes into an Excel Worksheet/3. Formatting Excel Shapes.mp4 15.36 MB
7. Inserting Images and Shapes into an Excel Worksheet/4. Working with Excel SmartArt.mp4 19.24 MB
8. Creating Basic Charts in Excel/1. Creating an Excel Column Chart.mp4 16.95 MB
8. Creating Basic Charts in Excel/2. Working with the Excel Chart Ribbon.mp4 15.68 MB
8. Creating Basic Charts in Excel/3. Adding and Modifying Data on an Excel Chart.mp4 12.3 MB
8. Creating Basic Charts in Excel/4. Formatting an Excel Chart.mp4 13.81 MB
8. Creating Basic Charts in Excel/5. Moving a Chart to another Worksheet.mp4 7.42 MB
8. Creating Basic Charts in Excel/6. Working with Excel Pie Charts.mp4 16.89 MB
9. Printing an Excel Worksheet/1. Viewing your Document in Print Preview.mp4 5.92 MB
9. Printing an Excel Worksheet/2. Changing the Margins, Scaling and Orientation.mp4 21.01 MB
9. Printing an Excel Worksheet/3. Working with Page Layout View.mp4 13.96 MB
9. Printing an Excel Worksheet/4. Adding Header and Footer Content.mp4 14.39 MB
9. Printing an Excel Worksheet/5. Printing a Specific Range of Cells.mp4 10.52 MB
其他位置