种子简介

种子名称： Udemy - Microsoft Excel - Excel from Beginner to Advanced
文件类型： 视频
文件数目： 214个文件
文件大小： 12.46 GB
收录时间： 2024-1-21 20:17
已经下载： 3次
资源热度： 25
最近下载： 2024-5-9 10:03

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

Udemy - Microsoft Excel - Excel from Beginner to Advanced.torrent

01 - Microsoft Excel 101 Course Introduction/001 Ask Questions.mp438.01MB

01 - Microsoft Excel 101 Course Introduction/002 Course Exercise Files.mp412.13MB

01 - Microsoft Excel 101 Course Introduction/003 Certificate of Completion.mp410.78MB

02 - Microsoft Excel Fundamentals/001 Launching Excel.mp413.57MB

02 - Microsoft Excel Fundamentals/002 Microsoft Excel Startup Screen.mp454.68MB

02 - Microsoft Excel Fundamentals/003 Introduction to the Excel Interface.mp447.9MB

02 - Microsoft Excel Fundamentals/004 Customizing the Excel Quick Access Toolbar.mp422.52MB

02 - Microsoft Excel Fundamentals/005 More on the Excel Interface.mp451.55MB

02 - Microsoft Excel Fundamentals/006 Understanding the Structure of an Excel Workbook.mp420.68MB

02 - Microsoft Excel Fundamentals/007 Saving an Excel Document.mp467.87MB

02 - Microsoft Excel Fundamentals/008 Opening an Existing Excel Document.mp438.87MB

02 - Microsoft Excel Fundamentals/009 Common Excel Shortcut Keys.mp418.38MB

03 - Entering and Editing Text and Formulas/001 Entering Text to Create Spreadsheet Titles.mp459.66MB

03 - Entering and Editing Text and Formulas/002 Working with Numeric Data in Excel.mp462.24MB

03 - Entering and Editing Text and Formulas/003 Entering Date Values in Excel.mp463.05MB

03 - Entering and Editing Text and Formulas/004 Working with Cell References.mp495.5MB

03 - Entering and Editing Text and Formulas/005 Creating Basic Formulas in Excel.mp443.57MB

03 - Entering and Editing Text and Formulas/006 Relative Versus Absolute Cell References in Formulas.mp488.99MB

03 - Entering and Editing Text and Formulas/007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp451.96MB

04 - Working with Basic Excel Functions/001 The structure of an Excel Function.mp435.56MB

04 - Working with Basic Excel Functions/002 Working with the SUM() Function.mp449.08MB

04 - Working with Basic Excel Functions/003 Working with the MIN() and MAX() Functions.mp432.52MB

04 - Working with Basic Excel Functions/004 Working with the AVERAGE() Function.mp414.91MB

04 - Working with Basic Excel Functions/005 Working with the COUNT() Function.mp415.02MB

04 - Working with Basic Excel Functions/006 Adjacent Cells Error in Excel Calculations.mp426.11MB

04 - Working with Basic Excel Functions/007 Using the AutoSum Command.mp448.47MB

04 - Working with Basic Excel Functions/008 Excel's AutoSum Shortcut Key.mp415.97MB

04 - Working with Basic Excel Functions/009 Using the AutoFill Command to Copy Formulas.mp431.55MB

05 - Modifying an Excel Worksheet/001 Moving and Copying Data in an Excel Worksheet.mp459.76MB

05 - Modifying an Excel Worksheet/002 Inserting and Deleting Rows and Columns.mp438.25MB

05 - Modifying an Excel Worksheet/003 Changing the Width and Height of Cells.mp427.68MB

05 - Modifying an Excel Worksheet/004 Hiding and Unhiding Excel Rows and Columns.mp437.26MB

05 - Modifying an Excel Worksheet/005 Renaming an Excel Worksheet.mp420.47MB

05 - Modifying an Excel Worksheet/006 Deleting an Excel Worksheet.mp441.85MB

05 - Modifying an Excel Worksheet/007 Moving and Copying an Excel Worksheet.mp438.19MB

06 - Formatting Data in an Excel Worksheet/001 Working with Font Formatting Commands.mp459.01MB

06 - Formatting Data in an Excel Worksheet/002 Changing the Background Color of a Cell.mp425.03MB

06 - Formatting Data in an Excel Worksheet/003 Adding Borders to Cells.mp419.3MB

06 - Formatting Data in an Excel Worksheet/004 Excel Cell Borders Continued.mp425.88MB

06 - Formatting Data in an Excel Worksheet/005 Formatting Data as Currency Values.mp436.14MB

06 - Formatting Data in an Excel Worksheet/006 Formatting Percentages.mp422.86MB

06 - Formatting Data in an Excel Worksheet/007 Using Excel's Format Painter.mp434.88MB

06 - Formatting Data in an Excel Worksheet/008 Creating Styles to Format Data.mp4158.29MB

06 - Formatting Data in an Excel Worksheet/009 Merging and Centering Cells.mp428.12MB

06 - Formatting Data in an Excel Worksheet/010 Using Conditional Formatting.mp437.8MB

06 - Formatting Data in an Excel Worksheet/011 Editing Excel Conditional Formatting.mp421.15MB

07 - Inserting Images and Shapes into an Excel Worksheet/001 Inserting Images.mp487.11MB

07 - Inserting Images and Shapes into an Excel Worksheet/002 Inserting Excel Shapes.mp421.49MB

07 - Inserting Images and Shapes into an Excel Worksheet/003 Formatting Excel Shapes.mp431.24MB

07 - Inserting Images and Shapes into an Excel Worksheet/004 Working with Excel SmartArt.mp495.29MB

08 - Creating Basic Charts in Excel/001 Creating an Excel Column Chart.mp430.15MB

08 - Creating Basic Charts in Excel/002 Working with the Excel Chart Ribbon.mp424.1MB

08 - Creating Basic Charts in Excel/003 Adding and Modifying Data on an Excel Chart.mp447.45MB

08 - Creating Basic Charts in Excel/004 Formatting an Excel Chart.mp458MB

08 - Creating Basic Charts in Excel/005 Moving a Chart to another Worksheet.mp431.99MB

08 - Creating Basic Charts in Excel/006 Working with Excel Pie Charts.mp463.06MB

09 - Printing an Excel Worksheet/001 Viewing your Document in Print Preview.mp423.13MB

09 - Printing an Excel Worksheet/002 Changing the Margins, Scaling and Orientation.mp4353.37MB

09 - Printing an Excel Worksheet/003 Excel Worksheet Margins.mp426.45MB

09 - Printing an Excel Worksheet/004 Working with Page Layout View.mp439.32MB

09 - Printing an Excel Worksheet/005 Adding Header and Footer Content.mp4127.39MB

09 - Printing an Excel Worksheet/006 Printing a Specific Range of Cells.mp4128.42MB

10 - Working with Excel Templates/001 Intro to Excel Templates.mp428.87MB

10 - Working with Excel Templates/002 Opening an Existing Template.mp4190.75MB

10 - Working with Excel Templates/003 Creating a Custom Template.mp473.44MB

12 - Congratulations! You've Built a Solid Microsoft Excel Foundation/001 Congratulations!.mp444.84MB

13 - Microsoft Excel 102 Course Introduction/001 Excel 102 Course Exercise Files -- DOWNLOAD.mp46.96MB

14 - Working with an Excel List/001 Understanding Excel List Structure.mp450.4MB

14 - Working with an Excel List/002 Sorting a List Using Single Level Sort.mp471.8MB

14 - Working with an Excel List/003 Sorting a List Using Multi-Level Sorts.mp451.81MB

14 - Working with an Excel List/004 Using Custom Sorts in an Excel List.mp423.84MB

14 - Working with an Excel List/005 Filter an Excel List Using the AutoFilter Tool.mp440.41MB

14 - Working with an Excel List/006 Creating Subtotals in a List.mp489.58MB

14 - Working with an Excel List/007 Format a List as a Table.mp4103.41MB

14 - Working with an Excel List/008 Using Conditional Formatting to Find Duplicates.mp454.61MB

14 - Working with an Excel List/009 Removing Duplicates.mp457.58MB

15 - Excel List Functions/001 Introduction to Excels Function DSUM().mp449.59MB

15 - Excel List Functions/002 Excel DSUM Function Single Criteria Continued.mp442.9MB

15 - Excel List Functions/003 Excel DSUM Function with OR Criteria.mp422.97MB

15 - Excel List Functions/004 Excel DSUM Function with AND Criteria.mp449.41MB

15 - Excel List Functions/005 Excel Function DAVERAGE().mp443.79MB

15 - Excel List Functions/006 Excel Function DCOUNT().mp457.86MB

15 - Excel List Functions/007 Excel Function SUBTOTAL().mp468.15MB

16 - Excel Data Validation/001 Understanding the Need for Excel Data Validation.mp444.54MB

16 - Excel Data Validation/002 Creating an Excel Data Validation List.mp448.12MB

16 - Excel Data Validation/003 Excel Decimal Data Validation.mp437.98MB

16 - Excel Data Validation/004 Adding a Custom Excel Data Validation Error.mp443.11MB

16 - Excel Data Validation/005 Dynamic Formulas by Using Excel Data Validation Techniques.mp441.72MB

17 - Importing and Exporting Data/001 Importing Data Into Microsoft Excel.mp49.94MB

17 - Importing and Exporting Data/002 Importing Data from Text Files.mp433.64MB

17 - Importing and Exporting Data/003 Importing Data from Microsoft Access.mp444.04MB

17 - Importing and Exporting Data/004 NEW VERSION -- Import Data From Text Files into Excel.mp4236.65MB

17 - Importing and Exporting Data/005 NEW VERSION -- Import Data From a Database into Excel.mp4122.59MB

17 - Importing and Exporting Data/006 Microsoft Excel Legacy Import Options for New Excel Versions.mp438.59MB

17 - Importing and Exporting Data/007 Exporting Data to a Text File.mp4119.58MB

18 - Excel PivotTables/001 Understanding Excel PivotTables.mp445.18MB

18 - Excel PivotTables/002 Creating an Excel PivotTable.mp4143.83MB

18 - Excel PivotTables/003 Modifying Excel PivotTable Calculations.mp4128.51MB

18 - Excel PivotTables/004 Grouping PivotTable Data.mp453.88MB

18 - Excel PivotTables/005 Formatting PivotTable Data.mp431.22MB

18 - Excel PivotTables/006 Modifying PivotTable Calculations.mp455.74MB

18 - Excel PivotTables/007 Drilling Down into PivotTable Data.mp4132.9MB

18 - Excel PivotTables/008 Creating PivotCharts.mp481.3MB

18 - Excel PivotTables/009 Filtering PivotTable Data.mp420.32MB

18 - Excel PivotTables/010 Filtering with the Slicer Tool.mp424.52MB

19 - Working with Excel's PowerPivot Tools/001 Introduction to Excel Power Pivot.mp425.72MB

19 - Working with Excel's PowerPivot Tools/002 Why PowerPivot.mp4324.5MB

19 - Working with Excel's PowerPivot Tools/003 Activating the Excel PowerPivot AddIn.mp439.04MB

19 - Working with Excel's PowerPivot Tools/004 Creating Data Models with PowerPivot.mp4158.54MB

19 - Working with Excel's PowerPivot Tools/005 Excel Power Pivot Data Model Relationships.mp4107.02MB

19 - Working with Excel's PowerPivot Tools/006 Creating PivotTables based on Data Models.mp445.59MB

19 - Working with Excel's PowerPivot Tools/007 Excel Power Pivot KPIs.mp4196.57MB

20 - Working with Large Sets of Excel Data/001 Using the Freeze Panes Tool.mp450.58MB

20 - Working with Large Sets of Excel Data/002 Grouping Data (Columns andor Rows).mp462.19MB

20 - Working with Large Sets of Excel Data/003 Print Options for Large Sets of Data.mp459.18MB

20 - Working with Large Sets of Excel Data/004 Linking Worksheets (3D Formulas).mp422.82MB

20 - Working with Large Sets of Excel Data/005 Consolidating Data from Multiple Worksheets.mp432.81MB

22 - Congratulations! You're an Intermediate Excel User/001 Congratulations!.mp436.04MB

23 - Microsoft Excel 103 Course Introduction/001 Excel 103 Course Exercise Files -- DOWNLOAD.mp411.07MB

24 - Working with Excel's Conditional Functions/001 Working with Excel Name Ranges.mp424.09MB

24 - Working with Excel's Conditional Functions/002 Advantages and Disadvantages of Excel Name Ranges.mp441.55MB

24 - Working with Excel's Conditional Functions/003 Editing an Excel Name Range.mp414.15MB

24 - Working with Excel's Conditional Functions/004 Using Excel's IF() Function.mp429.15MB

24 - Working with Excel's Conditional Functions/005 Excel's IF() Function with a Name Range.mp430.06MB

24 - Working with Excel's Conditional Functions/006 Nesting Functions with Excel.mp451.32MB

24 - Working with Excel's Conditional Functions/007 Nesting Excels AND() Function within the IF() Function.mp426.16MB

24 - Working with Excel's Conditional Functions/008 Using Excel's COUNTIF() Function.mp413.9MB

24 - Working with Excel's Conditional Functions/009 Using Excel's SUMIF() Function.mp4122.78MB

24 - Working with Excel's Conditional Functions/010 Using Excel's IFERROR() Function.mp491.96MB

25 - Working with Excel's Lookup Functions/001 Microsoft Excel VLOOKUP() Function.mp4163.98MB

25 - Working with Excel's Lookup Functions/002 Microsoft Excel HLOOKUP() Function.mp449.45MB

25 - Working with Excel's Lookup Functions/003 Microsoft Excel INDEX() Function.mp4162.9MB

25 - Working with Excel's Lookup Functions/004 Microsoft Excel MATCH() Function.mp4145.95MB

25 - Working with Excel's Lookup Functions/005 Microsoft Excel INDEX() and MATCH() Function Combined.mp4116.4MB

25 - Working with Excel's Lookup Functions/006 Microsoft Excel INDEX() and MATCH() Function Combined Continued.mp4146.92MB

25 - Working with Excel's Lookup Functions/007 Creating a Dynamic HLOOKUP() with the MATCH() Function.mp466.35MB

26 - Working with Excel's Text Based Functions/001 Using Excel's LEFT(), RIGHT() and MID() Functions.mp478.04MB

26 - Working with Excel's Text Based Functions/002 Using Excel's LEN() Function.mp452.16MB

26 - Working with Excel's Text Based Functions/003 Using Excel's SEARCH() Function.mp471.12MB

26 - Working with Excel's Text Based Functions/004 Using Excel's CONCATENATE() Function.mp418.66MB

27 - Auditing an Excel Worksheet/001 Tracing Precedents in Excel Formulas.mp426.78MB

27 - Auditing an Excel Worksheet/002 Tracing Dependents in Excel Formulas.mp419.19MB

27 - Auditing an Excel Worksheet/003 Working with the Watch Window.mp449.38MB

27 - Auditing an Excel Worksheet/004 Showing Formulas.mp417.27MB

28 - Protecting Excel Worksheets and Workbooks/001 Protecting Specific Cells in a Worksheet.mp453.79MB

28 - Protecting Excel Worksheets and Workbooks/002 Protecting the Structure of a Workbook.mp421.09MB

28 - Protecting Excel Worksheets and Workbooks/003 Adding a Workbook Password.mp434.84MB

29 - Mastering Excel's What If Tools/001 Working with Excel's Goal Seek Tool.mp442.01MB

29 - Mastering Excel's What If Tools/002 Working with Excel's Solver Tool.mp4178.44MB

29 - Mastering Excel's What If Tools/003 Building Effective Data Tables in Excel.mp435.51MB

29 - Mastering Excel's What If Tools/004 Creating Scenarios in Excel.mp492.81MB

30 - Automating Repetitive Tasks in Excel with Macros/001 Understanding Excel Macros.mp435.02MB

30 - Automating Repetitive Tasks in Excel with Macros/002 Activating the Developer Tab in Excel.mp423.84MB

30 - Automating Repetitive Tasks in Excel with Macros/003 Creating a Macro with the Macro Recorder.mp4137.74MB

30 - Automating Repetitive Tasks in Excel with Macros/004 Editing a Macro with VBA.mp462.6MB

30 - Automating Repetitive Tasks in Excel with Macros/005 Creating Buttons to Run Macros.mp468.4MB

32 - Congratulations!/001 Congratulations on Completing the Microsoft Excel 103.mp438.61MB

33 - Microsoft Excel Macros and VBA Course Introduction/001 Welcome to the Course.mp424.45MB

33 - Microsoft Excel Macros and VBA Course Introduction/002 Understanding the Why and How Behind Excel Macros.mp421.63MB

34 - Project #1 Using Excel's Macro Recorder Tool/001 Introduction to Project #1 Inserting and Formatting Text.mp415.61MB

34 - Project #1 Using Excel's Macro Recorder Tool/002 Project #1 Start Recording!.mp475.16MB

34 - Project #1 Using Excel's Macro Recorder Tool/003 Running A Macro.mp421.11MB

34 - Project #1 Using Excel's Macro Recorder Tool/004 Project #1 Running a Macro with a Button.mp419.64MB

34 - Project #1 Using Excel's Macro Recorder Tool/005 Project #1 Oops! I Need to Edit My Macro.mp476.25MB

34 - Project #1 Using Excel's Macro Recorder Tool/006 Practical Uses of Excel Macros.mp424.69MB

35 - Excel VBA Concepts/001 Excel VBA Concepts.mp418.75MB

35 - Excel VBA Concepts/002 The Visual Basic Editor (VBE).mp423.61MB

35 - Excel VBA Concepts/003 Excel VBA Modules.mp49.18MB

35 - Excel VBA Concepts/004 Creating an Excel VBA Procedure.mp438.63MB

35 - Excel VBA Concepts/005 Adding Code to a VBA Procedure.mp430.24MB

35 - Excel VBA Concepts/006 Understanding Excel VBA Variables.mp449.62MB

35 - Excel VBA Concepts/007 Building Logic with an IF Statement.mp433.99MB

35 - Excel VBA Concepts/008 Working with Excel VBA Loops to Repeat Blocks of Code.mp451.31MB

36 - Project #2 Moving Beyond the Basics and into VBA/001 Introduction to Project #2 Interacting with the User.mp422.81MB

36 - Project #2 Moving Beyond the Basics and into VBA/002 Project #2 Breaking Down the VBA Code.mp459.75MB

36 - Project #2 Moving Beyond the Basics and into VBA/003 Project #2 Prompting the User for Information.mp4214.69MB

36 - Project #2 Moving Beyond the Basics and into VBA/004 Continue Excel VBA InputBox.mp468.5MB

36 - Project #2 Moving Beyond the Basics and into VBA/005 Project #2 Building Logic into Your Macros.mp4139.47MB

36 - Project #2 Moving Beyond the Basics and into VBA/006 Project #2 Alerting the User of Errors.mp4179.07MB

36 - Project #2 Moving Beyond the Basics and into VBA/007 Other Practical Uses of Message and Input Boxes.mp426.41MB

37 - Project #3 Preparing and Cleaning Up Data with a Little VBA/001 Introduction to Project #3 Cleaning Up and Formatting Data.mp430.4MB

37 - Project #3 Preparing and Cleaning Up Data with a Little VBA/002 Project #3 Preparing to the Use the Macro Recorder.mp423.08MB

37 - Project #3 Preparing and Cleaning Up Data with a Little VBA/003 Project #3 Inserting the Headers.mp419.18MB

37 - Project #3 Preparing and Cleaning Up Data with a Little VBA/004 Project #3 Formatting the Headers.mp418.37MB

37 - Project #3 Preparing and Cleaning Up Data with a Little VBA/005 Project #3 Putting it all Together with a Little VBA.mp4185.96MB

37 - Project #3 Preparing and Cleaning Up Data with a Little VBA/006 Running the Loop.mp450.24MB

38 - Project #4 Using VBA to Automate Excel Formulas/001 Introduction to Project #4 Automate Excel Formulas.mp468.84MB

38 - Project #4 Using VBA to Automate Excel Formulas/002 Project #4 Automate the SUM() Function through Code.mp4139.09MB

38 - Project #4 Using VBA to Automate Excel Formulas/003 Continue Automate SUM Function.mp431.46MB

38 - Project #4 Using VBA to Automate Excel Formulas/004 Test the SUM Function.mp465.68MB

38 - Project #4 Using VBA to Automate Excel Formulas/005 Project #4 Loop the SUM() Function Over Multiple Worksheets.mp4196.56MB

39 - Project #5 Bringing it All Together and a Weekly Report/001 Introduction to Project #5 Creating the Final Report.mp497.28MB

39 - Project #5 Bringing it All Together and a Weekly Report/002 Project #5 Creating the Final Report Loop.mp474.37MB

39 - Project #5 Bringing it All Together and a Weekly Report/003 Project #5 - Copying and Pasting Data with VBA.mp489.59MB

39 - Project #5 Bringing it All Together and a Weekly Report/004 Project #5 - Running the Final Report Procedure.mp457.33MB

40 - Project #6 Working with Excel VBA User Forms/001 Introduction to Project #6 Working with Excel VBA User Forms.mp427.02MB

40 - Project #6 Working with Excel VBA User Forms/002 Project #6 Creating an Excel User Form.mp447.93MB

40 - Project #6 Working with Excel VBA User Forms/003 Project #6 Adding Controls to the Form.mp420.98MB

40 - Project #6 Working with Excel VBA User Forms/004 Project #6 Adding VBA Code to the Initialize Event.mp479.05MB

40 - Project #6 Working with Excel VBA User Forms/005 Project #6 Adding VBA Code to the ComboBox Change Event.mp442.57MB

40 - Project #6 Working with Excel VBA User Forms/006 Project #6 Adding VBA Code to the Add Worksheet Button.mp433.09MB

40 - Project #6 Working with Excel VBA User Forms/007 Change Worksheet Name.mp437.71MB

40 - Project #6 Working with Excel VBA User Forms/008 Project #6 Adding VBA Code to the Create Report Button.mp4152.38MB

40 - Project #6 Working with Excel VBA User Forms/009 Project #6 Showing the Form.mp467.79MB

41 - Project #7 Importing Data from Text Files/001 Project #7 Opening a Text File for Import.mp417.55MB

41 - Project #7 Importing Data from Text Files/002 Project #7 Opening a Text File for Import.mp457.89MB

41 - Project #7 Importing Data from Text Files/003 Project #7 Get Data from Text File.mp439.31MB

41 - Project #7 Importing Data from Text Files/004 Project #7 Importing Multiple Text Files with the GetOpenFilename Method.mp479.11MB

41 - Project #7 Importing Data from Text Files/005 Project #7 Creating a Loop to Read Each File.mp440.09MB

41 - Project #7 Importing Data from Text Files/006 Project #7 Adding a New Sheet for Imported Data.mp428.85MB

41 - Project #7 Importing Data from Text Files/007 Project #7 Clear the Clipboard.mp439.25MB

41 - Project #7 Importing Data from Text Files/008 Project #7 Working with the ScreenUpdating Property.mp421.82MB

41 - Project #7 Importing Data from Text Files/009 Project #7 Creating Reusable Code with a VBA Function.mp494.55MB

42 - Course Wrap Up/001 Congratulations! You're an Excel MacroVBA Master.mp45.19MB