种子简介

种子名称： [FreeAllCourse.Com] Udemy - Microsoft Excel - Excel from Beginner to Advanced
文件类型： 视频
文件数目： 191个文件
文件大小： 6.73 GB
收录时间： 2020-2-23 19:40
已经下载： 3次
资源热度： 106
最近下载： 2024-12-24 15:33

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:c907462f660499c1a5f2b5e0e7acf001623e0630&dn=[FreeAllCourse.Com] Udemy - Microsoft Excel - Excel from Beginner to Advanced 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeAllCourse.Com] Udemy - Microsoft Excel - Excel from Beginner to Advanced.torrent

1. Microsoft Excel 101 Course Introduction/1. Ask Questions.mp471.33MB

1. Microsoft Excel 101 Course Introduction/2. Course Exercise Files.mp460.34MB

1. Microsoft Excel 101 Course Introduction/3. Certificate of Completion.mp439.66MB

10. Working with Excel Templates/1. Intro to Excel Templates.mp45.39MB

10. Working with Excel Templates/2. Opening an Existing Template.mp422.27MB

10. Working with Excel Templates/3. Creating a Custom Template.mp416.34MB

11. Congratulations! You've Built a Solid Microsoft Excel Foundation/1. Congratulations!.mp45.56MB

13. Working with an Excel List/1. Understanding Excel List Structure.mp429.38MB

13. Working with an Excel List/2. Sorting a List Using Single Level Sort.mp420.27MB

13. Working with an Excel List/3. Sorting a List Using Multi-Level Sorts.mp420.4MB

13. Working with an Excel List/4. Using Custom Sorts in an Excel List.mp420.46MB

13. Working with an Excel List/5. Filter an Excel List Using the AutoFilter Tool.mp420.79MB

13. Working with an Excel List/6. Creating Subtotals in a List.mp439.64MB

13. Working with an Excel List/7. Format a List as a Table.mp442.73MB

13. Working with an Excel List/8. Using Conditional Formatting to Find Duplicates.mp422.84MB

13. Working with an Excel List/9. Removing Duplicates.mp422.86MB

14. Excel List Functions/1. Excel Function DSUM().mp439.62MB

14. Excel List Functions/2. Excel Function DAVERAGE().mp417.58MB

14. Excel List Functions/3. Excel Function DCOUNT().mp419.3MB

14. Excel List Functions/4. Excel Function SUBTOTAL().mp440.63MB

15. Excel Data Validation/1. Understanding the Need for Data Validation.mp422.73MB

15. Excel Data Validation/2. Creating a Validation List.mp425.97MB

15. Excel Data Validation/3. Adding a Custom Validation Error.mp420.64MB

15. Excel Data Validation/4. Dynamic Formulas by Using Validation Techniques.mp422.51MB

16. Importing and Exporting Data/1. Importing Data from Text Files.mp419.08MB

16. Importing and Exporting Data/2. Importing Data from Microsoft Access.mp416.92MB

16. Importing and Exporting Data/3. Exporting Data to a Text File.mp422.48MB

17. Excel PivotTables/1. Understanding Excel PivotTables.mp423.29MB

17. Excel PivotTables/2. Creating an Excel PivotTable.mp430MB

17. Excel PivotTables/3. Modifying Excel PivotTable Calculations.mp426.56MB

17. Excel PivotTables/4. Grouping PivotTable Data.mp417.15MB

17. Excel PivotTables/5. Formatting PivotTable Data.mp419.5MB

17. Excel PivotTables/6. Drilling Down into PivotTable Data.mp421.07MB

17. Excel PivotTables/7. Creating PivotCharts.mp422.54MB

17. Excel PivotTables/8. Filtering PivotTable Data.mp417.17MB

17. Excel PivotTables/9. Filtering with the Slicer Tool.mp418.06MB

18. Working with Excel's PowerPivot Tools/1. Why PowerPivot.mp432.63MB

18. Working with Excel's PowerPivot Tools/2. Activating the Excel PowerPivot AddIn.mp48.09MB

18. Working with Excel's PowerPivot Tools/3. Creating Data Models with PowerPivot.mp445.84MB

18. Working with Excel's PowerPivot Tools/4. Creating PivotTables based on Data Models.mp420.42MB

18. Working with Excel's PowerPivot Tools/5. PowerPivot Calculated Fields.mp424.02MB

18. Working with Excel's PowerPivot Tools/6. PowerPivot KPIs.mp435.88MB

19. Working with Large Sets of Excel Data/1. Using the Freeze Panes Tool.mp422.39MB

19. Working with Large Sets of Excel Data/2. Grouping Data (Columns andor Rows).mp427.54MB

19. Working with Large Sets of Excel Data/3. Print Options for Large Sets of Data.mp440.97MB

19. Working with Large Sets of Excel Data/4. Linking Worksheets (3D Formulas).mp411.98MB

19. Working with Large Sets of Excel Data/5. Consolidating Data from Multiple Worksheets.mp418.14MB

2. Microsoft Excel Fundamentals/1. Launching Excel.mp433.7MB

2. Microsoft Excel Fundamentals/2. Microsoft Excel Startup Screen.mp462.59MB

2. Microsoft Excel Fundamentals/3. Introduction to the Excel Interface.mp4116.39MB

2. Microsoft Excel Fundamentals/4. Customizing the Excel Quick Access Toolbar.mp455.15MB

2. Microsoft Excel Fundamentals/5. More on the Excel Interface.mp454.7MB

2. Microsoft Excel Fundamentals/6. Understanding the Structure of an Excel Workbook.mp478.53MB

2. Microsoft Excel Fundamentals/7. Saving an Excel Document.mp474.77MB

2. Microsoft Excel Fundamentals/8. Opening an Existing Excel Document.mp429.18MB

2. Microsoft Excel Fundamentals/9. Common Excel Shortcut Keys.mp449.18MB

20. Congratulations! You're an Intermediate Excel User/1. Congratulations!.mp48.64MB

22. Working with Excel's Conditional Functions/1. Working with Excel Name Ranges.mp422.31MB

22. Working with Excel's Conditional Functions/2. Using Excel's IF() Function.mp426.93MB

22. Working with Excel's Conditional Functions/3. Nesting Functions.mp434.94MB

22. Working with Excel's Conditional Functions/4. Using Excel's COUNTIF() Function.mp419.11MB

22. Working with Excel's Conditional Functions/5. Using Excel's SUMIF() Function.mp429.18MB

22. Working with Excel's Conditional Functions/6. Using Excel's IFERROR() Function.mp423MB

23. Working with Excel's Lookup Functions/1. Using Excel's VLOOKUP() Function.mp435.73MB

23. Working with Excel's Lookup Functions/2. Using Excel's HLOOKUP() Function.mp417.74MB

23. Working with Excel's Lookup Functions/3. Using Excel's INDEX() and MATCH() Functions.mp463.96MB

24. Working with Excel's Text Based Functions/1. Using Excel's LEFT(), RIGHT() and MID() Functions.mp430.37MB

24. Working with Excel's Text Based Functions/2. Using Excel's LEN() Function.mp437.16MB

24. Working with Excel's Text Based Functions/3. Using Excel's SEARCH() Function.mp441.86MB

24. Working with Excel's Text Based Functions/4. Using Excel's CONCATENATE() Function.mp411.86MB

25. Auditing an Excel Worksheet/1. Tracing Precendents in Excel Formulas.mp419.62MB

25. Auditing an Excel Worksheet/2. Tracing Dependents in Excel Formulas.mp414.12MB

25. Auditing an Excel Worksheet/3. Working with the Watch Window.mp415.26MB

25. Auditing an Excel Worksheet/4. Showing Formulas.mp412.9MB

26. Protecting Excel Worksheets and Workbooks/1. Protecting Specific Cells in a Worksheet.mp439.54MB

26. Protecting Excel Worksheets and Workbooks/2. Protecting the Structure of a Workbook.mp412.34MB

26. Protecting Excel Worksheets and Workbooks/3. Adding a Workbook Password.mp414.34MB

27. Mastering Excel's What If Tools/1. Working with Excel's Goal Seek Tool.mp423.93MB

27. Mastering Excel's What If Tools/2. Working with Excel's Solver Tool.mp4188.79MB

27. Mastering Excel's What If Tools/3. Building Effective Data Tables in Excel.mp419.38MB

27. Mastering Excel's What If Tools/4. Creating Scenarios in Excel.mp435.53MB

28. Automating Repetitive Tasks in Excel with Macros/1. Understanding Excel Macros.mp422.97MB

28. Automating Repetitive Tasks in Excel with Macros/2. Activating the Developer Tab in Excel.mp410.34MB

28. Automating Repetitive Tasks in Excel with Macros/3. Creating a Macro with the Macro Recorder.mp446.4MB

28. Automating Repetitive Tasks in Excel with Macros/4. Editing a Macro with VBA.mp425.39MB

28. Automating Repetitive Tasks in Excel with Macros/5. Creating Buttons to Run Macros.mp419.75MB

29. Congratulations!/1. Congratulations on Competing the Microsoft Excel 103.mp43.4MB

3. Entering and Editing Text and Formulas/1. Entering Text to Create Spreadsheet Titles.mp4148.09MB

3. Entering and Editing Text and Formulas/2. Working with Numeric Data in Excel.mp4150.64MB

3. Entering and Editing Text and Formulas/3. Entering Date Values in Excel.mp4150.69MB

3. Entering and Editing Text and Formulas/4. Working with Cell References.mp4101.61MB

3. Entering and Editing Text and Formulas/5. Creating Basic Formulas in Excel.mp4146.34MB

3. Entering and Editing Text and Formulas/6. Relative Versus Absolute Cell References in Formulas.mp4212.7MB

3. Entering and Editing Text and Formulas/7. Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4173.33MB

30. Microsoft Excel Macros and VBA Course Introduction/1. Welcome to the Course.mp432.2MB

30. Microsoft Excel Macros and VBA Course Introduction/2. Understanding the Why and How Behind Excel Macros.mp414.88MB

31. Project #1 Using Excel's Macro Recorder Tool/1. Introduction to Project #1 Inserting and Formatting Text.mp413.09MB

31. Project #1 Using Excel's Macro Recorder Tool/2. Project #1 Start Recording!.mp449.21MB

31. Project #1 Using Excel's Macro Recorder Tool/3. Running A Macro.mp48.57MB

31. Project #1 Using Excel's Macro Recorder Tool/4. Project #1 Running a Macro with a Button.mp421.78MB

31. Project #1 Using Excel's Macro Recorder Tool/5. Project #1 Opps! I Need to Edit My Macro.mp427.86MB

31. Project #1 Using Excel's Macro Recorder Tool/6. Practical Uses of Excel Macros.mp418.54MB

32. Excel VBA Concepts/1. Excel VBA Concepts.mp422.17MB

32. Excel VBA Concepts/2. The Visual Basic Editor (VBE).mp49.42MB

32. Excel VBA Concepts/3. Excel VBA Modules.mp45.38MB

32. Excel VBA Concepts/4. Creating an Excel VBA Procedure.mp443.03MB

32. Excel VBA Concepts/5. Adding Code to a VBA Procedure.mp423.2MB

32. Excel VBA Concepts/6. Understanding Excel VBA Variables.mp437.37MB

32. Excel VBA Concepts/7. Building Logic with an IF Statement.mp435.39MB

32. Excel VBA Concepts/8. Working with Excel VBA Loops to Repeat Blocks of Code.mp427.66MB

33. Project #2 Moving Beyond the Basics and into VBA/1. Introduction to Project #2 Interacting with the User.mp418.14MB

33. Project #2 Moving Beyond the Basics and into VBA/2. Project #2 Breaking Down the VBA Code.mp411.97MB

33. Project #2 Moving Beyond the Basics and into VBA/3. Project #2 Prompting the User for Information.mp420.58MB

33. Project #2 Moving Beyond the Basics and into VBA/4. Continue Excel VBA InputBox.mp438.87MB

33. Project #2 Moving Beyond the Basics and into VBA/5. Project #2 Building Logic into Your Macros.mp414.76MB

33. Project #2 Moving Beyond the Basics and into VBA/6. Project #2 Alerting the User of Errors.mp433.72MB

33. Project #2 Moving Beyond the Basics and into VBA/7. Other Practical Uses of Message and Input Boxes.mp424.42MB

34. Project #3 Preparing and Cleaning Up Data with a Little VBA/1. Introduction to Project #3 Cleaning Up and Formatting Data.mp410.71MB

34. Project #3 Preparing and Cleaning Up Data with a Little VBA/2. Project #3 Preparing to the Use the Macro Recorder.mp49.5MB

34. Project #3 Preparing and Cleaning Up Data with a Little VBA/3. Project #3 Inserting the Headers.mp422.12MB

34. Project #3 Preparing and Cleaning Up Data with a Little VBA/4. Project #3 Formatting the Headers.mp47.46MB

34. Project #3 Preparing and Cleaning Up Data with a Little VBA/5. Project #3 Putting it all Together with a Little VBA.mp435.83MB

34. Project #3 Preparing and Cleaning Up Data with a Little VBA/6. Running the Loop.mp418.93MB

35. Project #4 Using VBA to Automate Excel Formulas/1. Introduction to Project #4 Automate Excel Formulas.mp47.47MB

35. Project #4 Using VBA to Automate Excel Formulas/2. Project #4 Automate the SUM() Function through Code.mp425.55MB

35. Project #4 Using VBA to Automate Excel Formulas/3. Continue Automate SUM Function.mp417.54MB

35. Project #4 Using VBA to Automate Excel Formulas/4. Test the SUM Function.mp412.37MB

35. Project #4 Using VBA to Automate Excel Formulas/5. Project #4 Loop the SUM() Function Over Multiple Worksheets.mp420.08MB

36. Project #5 Bringing it All Together and a Weekly Report/1. Introduction to Project #5 Creating the Final Report.mp410.99MB

36. Project #5 Bringing it All Together and a Weekly Report/2. Project #5 Creating the Final Report Loop.mp447.28MB

36. Project #5 Bringing it All Together and a Weekly Report/3. Project #5 - Copying and Pasting Data with VBA.mp454.76MB

36. Project #5 Bringing it All Together and a Weekly Report/4. Project #5 - Running the Final Report Procedure.mp419.95MB

37. Project #6 Working with Excel VBA User Forms/1. Introduction to Project #6 Working with Excel VBA User Forms.mp48.79MB

37. Project #6 Working with Excel VBA User Forms/2. Project #6 Creating an Excel User Form.mp415.05MB

37. Project #6 Working with Excel VBA User Forms/3. Project #6 Adding Controls to the Form.mp411.65MB

37. Project #6 Working with Excel VBA User Forms/4. Project #6 Adding VBA Code to the Initialize Event.mp424.35MB

37. Project #6 Working with Excel VBA User Forms/5. Project #6 Adding VBA Code to the ComboBox Change Event.mp424.22MB

37. Project #6 Working with Excel VBA User Forms/6. Project #6 Adding VBA Code to the Add Worksheet Button.mp410.11MB

37. Project #6 Working with Excel VBA User Forms/7. Change Worksheet Name.mp411.7MB

37. Project #6 Working with Excel VBA User Forms/8. Project #6 Adding VBA Code to the Create Report Button.mp427.43MB

37. Project #6 Working with Excel VBA User Forms/9. Project #6 Showing the Form.mp412.39MB

38. Project #7 Importing Data from Text Files/1. Project #7 Opening a Text File for Import.mp426.03MB

38. Project #7 Importing Data from Text Files/2. Project #7 Opening a Text File for Import.mp442.26MB

38. Project #7 Importing Data from Text Files/3. Project #7 Get Data from Text File.mp432.64MB

38. Project #7 Importing Data from Text Files/4. Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp465.62MB

38. Project #7 Importing Data from Text Files/5. Project #7 Creating a Loop to Read Each File.mp456.87MB

38. Project #7 Importing Data from Text Files/6. Project #7 Adding a New Sheet for Imported Data.mp423.83MB

38. Project #7 Importing Data from Text Files/7. Project #7 Clear the Clipboard.mp432.06MB

38. Project #7 Importing Data from Text Files/8. Project #7 Working with the ScreenUpdating Property.mp434.5MB

38. Project #7 Importing Data from Text Files/9. Project #7 Creating Reusable Code with a VBA Function.mp461.05MB

39. Course Wrap Up/1. Congratulations! You're an Excel MacroVBA Master.mp418.1MB

4. Working with Basic Excel Functions/1. The structure of an Excel Function.mp4161.97MB

4. Working with Basic Excel Functions/2. Working with the SUM() Function.mp4113.76MB

4. Working with Basic Excel Functions/3. Working with the MIN() and MAX() Functions.mp4101.81MB

4. Working with Basic Excel Functions/4. Working with the AVERAGE() Function.mp447.22MB

4. Working with Basic Excel Functions/5. Working with the COUNT() Function.mp447.57MB

4. Working with Basic Excel Functions/6. Adjacent Cells Error in Excel Calculations.mp460.08MB

4. Working with Basic Excel Functions/7. Using the AutoSum Command.mp4111.96MB

4. Working with Basic Excel Functions/8. Excel's AutoSum Shortcut Key.mp436.81MB

4. Working with Basic Excel Functions/9. Using the AutoFill Command to Copy Formulas.mp473.03MB

5. Modifying an Excel Worksheet/1. Moving and Copying Data in an Excel Worksheet.mp4111.68MB

5. Modifying an Excel Worksheet/2. Inserting and Deleting Rows and Columns.mp4119.78MB

5. Modifying an Excel Worksheet/3. Changing the Width and Height of Cells.mp484.73MB

5. Modifying an Excel Worksheet/4. Hiding and Unhiding Excel Rows and Columns.mp485.99MB

5. Modifying an Excel Worksheet/5. Renaming an Excel Worksheet.mp446.67MB

5. Modifying an Excel Worksheet/6. Deleting an Excel Worksheet.mp478.95MB

5. Modifying an Excel Worksheet/7. Moving and Copying an Excel Worksheet.mp489.61MB

6. Formatting Data in an Excel Worksheet/1. Working with Font Formatting Commands.mp411.78MB

6. Formatting Data in an Excel Worksheet/2. Changing the Background Color of a Cell.mp48.63MB

6. Formatting Data in an Excel Worksheet/3. Adding Borders to Cells.mp410.49MB

6. Formatting Data in an Excel Worksheet/4. Formatting Data as Currency Values.mp416.45MB

6. Formatting Data in an Excel Worksheet/5. Formatting Percentages.mp47.03MB

6. Formatting Data in an Excel Worksheet/6. Using Excel's Format Painter.mp48.95MB

6. Formatting Data in an Excel Worksheet/7. Creating Styles to Format Data.mp429.08MB

6. Formatting Data in an Excel Worksheet/8. Merging and Centering Cells.mp49.87MB

6. Formatting Data in an Excel Worksheet/9. Using Conditional Formatting.mp415.28MB

7. Inserting Images and Shapes into an Excel Worksheet/1. Inserting Images.mp414.2MB

7. Inserting Images and Shapes into an Excel Worksheet/2. Inserting Excel Shapes.mp413.25MB

7. Inserting Images and Shapes into an Excel Worksheet/3. Formatting Excel Shapes.mp415.36MB

7. Inserting Images and Shapes into an Excel Worksheet/4. Working with Excel SmartArt.mp419.24MB

8. Creating Basic Charts in Excel/1. Creating an Excel Column Chart.mp416.95MB

8. Creating Basic Charts in Excel/2. Working with the Excel Chart Ribbon.mp415.68MB

8. Creating Basic Charts in Excel/3. Adding and Modifying Data on an Excel Chart.mp412.3MB

8. Creating Basic Charts in Excel/4. Formatting an Excel Chart.mp413.81MB

8. Creating Basic Charts in Excel/5. Moving a Chart to another Worksheet.mp47.42MB

8. Creating Basic Charts in Excel/6. Working with Excel Pie Charts.mp416.89MB

9. Printing an Excel Worksheet/1. Viewing your Document in Print Preview.mp45.92MB

9. Printing an Excel Worksheet/2. Changing the Margins, Scaling and Orientation.mp421.01MB

9. Printing an Excel Worksheet/3. Working with Page Layout View.mp413.96MB

9. Printing an Excel Worksheet/4. Adding Header and Footer Content.mp414.39MB

9. Printing an Excel Worksheet/5. Printing a Specific Range of Cells.mp410.52MB