种子简介

种子名称： Microsoft Excel- Excel from Beginner to Advanced
文件类型： 视频
文件数目： 176个文件
文件大小： 3.46 GB
收录时间： 2019-2-11 22:07
已经下载： 3次
资源热度： 123
最近下载： 2024-11-8 05:03

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

Microsoft Excel- Excel from Beginner to Advanced.torrent

02 Microsoft Excel 101 Course Introduction/002 Course Exercise Files.mp42.32MB

30 Congratualtions/131 Congratulations on Competing the Microsoft Excel 103.mp43.4MB

06 Modifying an Excel Worksheet/029 Renaming an Excel Worksheet.mp45.33MB

33 Excel VBA Concepts/143 Excel VBA Modules.mp45.38MB

11 Working with Excel Templates/055 Intro to Excel Templates.mp45.39MB

12 Congratulations Youve Built a Solid Microsoft Excel Foundation/058 Congratulations.mp45.55MB

10 Printing an Excel Worksheet/050 Viewing your Document in Print Preview.mp45.91MB

03 Microsoft Excel Fundamentals/008 Opening an Existing Excel Document.mp46.19MB

04 Entering and Editing Text and Formulas/016 Understanding the Order of Operation.mp46.5MB

05 Working with Basic Excel Functions/021 Working with the COUNT() Function.mp46.72MB

07 Formatting Data in an Excel Worksheet/035 Formatting Percentages.mp47.02MB

03 Microsoft Excel Fundamentals/007 Saving an Excel Document.mp47.26MB

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

35 Project 3 Preparing and Cleaning Up Data with a Little VBA/159 Project 3 Formatting the Headers.mp47.46MB

36 Project 4 Using VBA to Automate Excel Formulas/162 Introduction to Project 4 Automate Excel Formulas.mp47.46MB

05 Working with Basic Excel Functions/020 Working with the AVERAGE() Function.mp47.82MB

19 Working with Excels PowerPivot Tools/090 Activating the Excel PowerPivot AddIn.mp48.08MB

06 Modifying an Excel Worksheet/028 Deleting an Excel Worksheet.mp48.11MB

05 Working with Basic Excel Functions/017 The structure of an Excel Function.mp48.11MB

04 Entering and Editing Text and Formulas/011 Working with Numeric Data in Excel.mp48.24MB

06 Modifying an Excel Worksheet/027 Hiding and Unhiding Excel Rows and Columns.mp48.5MB

32 Project 1 Using Excels Macro Recorder Tool/137 Running A Macro.mp48.57MB

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

21 Congratulations Youre an Intermediate Excel User/100 Congratulations.mp48.63MB

38 Project 6 Working with Excel VBA User Forms/171 Introduction to Project 6 Working with Excel VBA User Forms.mp48.79MB

07 Formatting Data in an Excel Worksheet/036 Using Excels Format Painter.mp48.95MB

33 Excel VBA Concepts/142 The Visual Basic Editor (VBE).mp49.42MB

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

05 Working with Basic Excel Functions/023 Using the AutoFill Command to Copy Formulas.mp49.51MB

04 Entering and Editing Text and Formulas/013 Working with Cell References.mp49.59MB

07 Formatting Data in an Excel Worksheet/038 Merging and Centering Cells.mp49.86MB

03 Microsoft Excel Fundamentals/005 Customizing the Excel Quick Access Toolbar.mp49.91MB

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

29 Automating Repetitive Tasks in Excel with Macros/127 Activating the Developer Tab in Excel.mp410.33MB

07 Formatting Data in an Excel Worksheet/033 Adding Borders to Cells.mp410.49MB

10 Printing an Excel Worksheet/054 Printing a Specific Range of Cells.mp410.52MB

35 Project 3 Preparing and Cleaning Up Data with a Little VBA/156 Introduction to Project 3 Cleaning Up and Formatting Data.mp410.71MB

06 Modifying an Excel Worksheet/024 Moving and Copying Data in an Excel Worksheet.mp410.9MB

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

03 Microsoft Excel Fundamentals/003 Launching Excel.mp411.32MB

05 Working with Basic Excel Functions/019 Working with the MIN() and MAX() Functions.mp411.61MB

38 Project 6 Working with Excel VBA User Forms/173 Project 6 Adding Controls to the Form.mp411.65MB

04 Entering and Editing Text and Formulas/010 Entering Text to Create Spreadsheet Titles.mp411.69MB

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

04 Entering and Editing Text and Formulas/012 Entering Date Values in Excel.mp411.75MB

07 Formatting Data in an Excel Worksheet/031 Working with Font Formatting Commands.mp411.78MB

25 Working with Excels Text Based Functions/114 Using Excels CONCATENATE() Function.mp411.86MB

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

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

09 Creating Basic Charts in Excel/046 Adding and Modifying Data on an Excel Chart.mp412.29MB

27 Protecting Excel Worksheets and Workbooks/120 Protecting the Structure of a Workbook.mp412.34MB

03 Microsoft Excel Fundamentals/004 Introduction to the Excel Interface.mp412.34MB

36 Project 4 Using VBA to Automate Excel Formulas/165 Test the SUM Function.mp412.36MB

38 Project 6 Working with Excel VBA User Forms/179 Project 6 Showing the Form.mp412.39MB

06 Modifying an Excel Worksheet/030 Moving and Copying and Excel Worksheet.mp412.78MB

26 Auditing an Excel Worksheet/118 Showing Formulas.mp412.9MB

32 Project 1 Using Excels Macro Recorder Tool/135 Introduction to Project 1 Inserting and Formatting Text.mp413.08MB

08 Inserting Images and Shapes into an Excel Worksheet/041 Inserting Excel Shapes.mp413.24MB

03 Microsoft Excel Fundamentals/006 Understanding the Structure of an Excel Workbook.mp413.74MB

09 Creating Basic Charts in Excel/047 Formatting an Excel Chart.mp413.81MB

05 Working with Basic Excel Functions/018 Working with the SUM() Function.mp413.88MB

10 Printing an Excel Worksheet/052 Working with Page Layout View.mp413.95MB

26 Auditing an Excel Worksheet/116 Tracing Dependents in Excel Formuals.mp414.12MB

08 Inserting Images and Shapes into an Excel Worksheet/040 Inserting Images.mp414.2MB

27 Protecting Excel Worksheets and Workbooks/121 Adding a Workbook Password.mp414.33MB

10 Printing an Excel Worksheet/053 Adding Header and Footer Content.mp414.38MB

34 Project 2 Moving Beyond the Basics and into VBA/153 Project 2 Building Logic into Your Macros.mp414.76MB

31 Microsoft Excel Macros and VBA Course Introduction/133 Understanding the Why and How Behind Excel Macros.mp414.87MB

05 Working with Basic Excel Functions/022 Using the AutoSum Command.mp415.01MB

38 Project 6 Working with Excel VBA User Forms/172 Project 6 Creating an Excel User Form.mp415.05MB

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

07 Formatting Data in an Excel Worksheet/039 Using Conditional Formatting.mp415.27MB

08 Inserting Images and Shapes into an Excel Worksheet/042 Formatting Excel Shapes.mp415.35MB

09 Creating Basic Charts in Excel/045 Working with the Excel Chart Ribbon.mp415.68MB

11 Working with Excel Templates/057 Creating a Custom Template.mp416.34MB

06 Modifying an Excel Worksheet/026 Changing the Width and Height of Cells.mp416.37MB

07 Formatting Data in an Excel Worksheet/034 Formatting Data as Currency Values.mp416.45MB

09 Creating Basic Charts in Excel/049 Working with Excel Pie Charts.mp416.89MB

17 Importing and Exporting Data/078 Importing Data from Microsoft Access.mp416.91MB

09 Creating Basic Charts in Excel/044 Creating an Excel Column Chart.mp416.95MB

18 Excel PivotTables/083 Grouping PivotTable Data.mp417.15MB

18 Excel PivotTables/087 Filtering PivotTable Data.mp417.17MB

06 Modifying an Excel Worksheet/025 Inserting and Deleting Rows and Columns.mp417.35MB

36 Project 4 Using VBA to Automate Excel Formulas/164 Continue Automate SUM Function.mp417.54MB

04 Entering and Editing Text and Formulas/014 Creating Basic Formulas in Excel.mp417.58MB

15 Excel List Functions/070 Excel Function DAVERAGE().mp417.58MB

24 Working with Excels Lookup Functions/109 Using Excels HLOOKUP() Function.mp417.73MB

18 Excel PivotTables/088 Filtering with the Slicer Tool.mp418.06MB

34 Project 2 Moving Beyond the Basics and into VBA/149 Introduction to Project 2 Interacting with the User.mp418.13MB

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

32 Project 1 Using Excels Macro Recorder Tool/140 Practical Uses of Excel Macros.mp418.54MB

35 Project 3 Preparing and Cleaning Up Data with a Little VBA/161 Running the Loop.mp418.93MB

17 Importing and Exporting Data/077 Importing Data from Text Files.mp419.08MB

23 Working with Excels Conditional Functions/105 Using Excels COUNTIF() Function.mp419.11MB

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

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

28 Mastering Excels What If Tools/124 Building Effective Data Tables in Excel.mp419.38MB

18 Excel PivotTables/084 Formatting PivotTable Data.mp419.5MB

26 Auditing an Excel Worksheet/115 Tracing Precendents in Excel Formulas.mp419.62MB

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

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

36 Project 4 Using VBA to Automate Excel Formulas/166 Project 4 Loop the SUM() Function Over Multiple Worksheets.mp420.07MB

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

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

19 Working with Excels PowerPivot Tools/092 Creating PivotTables based on Data Models.mp420.42MB

14 Working with an Excel List/063 Using Custom Sorts in an Excel List.mp420.46MB

34 Project 2 Moving Beyond the Basics and into VBA/151 Project 2 Prompting the User for Information.mp420.58MB

16 Excel Data Validation/075 Adding a Custom Validation Error.mp420.63MB

14 Working with an Excel List/064 Filter an Excel List Using the AutoFilter Tool.mp420.78MB

10 Printing an Excel Worksheet/051 Changing the Margins Scaling and Orientation.mp421MB

18 Excel PivotTables/085 Drilling Down into PivotTable Data.mp421.07MB

32 Project 1 Using Excels Macro Recorder Tool/138 Project 1 Running a Macro with a Button.mp421.77MB

35 Project 3 Preparing and Cleaning Up Data with a Little VBA/158 Project 3 Inserting the Headers.mp422.11MB

33 Excel VBA Concepts/141 Excel VBA Concepts.mp422.16MB

11 Working with Excel Templates/056 Opening an Existing Template.mp422.27MB

23 Working with Excels Conditional Functions/102 Working with Excel Name Ranges.mp422.31MB

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

17 Importing and Exporting Data/079 Exporting Data to a Text File.mp422.48MB

16 Excel Data Validation/076 Dynamic Formulas by Using Validation Techniques.mp422.5MB

18 Excel PivotTables/086 Creating PivotCharts.mp422.53MB

16 Excel Data Validation/073 Understanding the Need for Data Validation.mp422.72MB

14 Working with an Excel List/067 Using Conditional Formatting to Find Duplicates.mp422.83MB

14 Working with an Excel List/068 Removing Duplicates.mp422.86MB

29 Automating Repetitive Tasks in Excel with Macros/126 Understanding Excel Macros.mp422.97MB

23 Working with Excels Conditional Functions/107 Using Excels IFERROR() Function.mp423MB

33 Excel VBA Concepts/145 Adding Code to a VBA Procedure.mp423.19MB

18 Excel PivotTables/080 Understanding Excel PivotTables.mp423.29MB

01 Microsoft Excel Course Introduction/001 Welcome to the Ultimate Microsoft Excel Course.mp423.41MB

28 Mastering Excels What If Tools/122 Working with Excels Goal Seek Tool.mp423.93MB

19 Working with Excels PowerPivot Tools/093 PowerPivot Calculated Fields.mp424.02MB

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

38 Project 6 Working with Excel VBA User Forms/174 Project 6 Adding VBA Code to the Initialize Event.mp424.35MB

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

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

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

16 Excel Data Validation/074 Creating a Validation List.mp425.96MB

18 Excel PivotTables/082 Modifying Excel PivotTable Calculations.mp426.56MB

23 Working with Excels Conditional Functions/103 Using Excels IF() Function.mp426.93MB

38 Project 6 Working with Excel VBA User Forms/178 Project 6 Adding VBA Code to the Create Report Button.mp427.42MB

20 Working with Large Sets of Excel Data/096 Grouping Data (Columns andor Rows).mp427.53MB

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

32 Project 1 Using Excels Macro Recorder Tool/139 Project 1 Opps I Need to Edit My Macro.mp427.86MB

04 Entering and Editing Text and Formulas/015 Relative Versus Absolute Cell References in Formulas.mp429.02MB

07 Formatting Data in an Excel Worksheet/037 Creating Styles to Format Data.mp429.07MB

23 Working with Excels Conditional Functions/106 Using Excels SUMIF() Function.mp429.18MB

14 Working with an Excel List/060 Understanding Excel List Structure.mp429.38MB

18 Excel PivotTables/081 Creating an Excel PivotTable.mp430MB

25 Working with Excels Text Based Functions/111 Using Excels LEFT() RIGHT() and MID() Functions.mp430.36MB

31 Microsoft Excel Macros and VBA Course Introduction/132 Welcome to the Course.mp432.2MB

19 Working with Excels PowerPivot Tools/089 Why PowerPivot.mp432.62MB

34 Project 2 Moving Beyond the Basics and into VBA/154 Project 2 Alerting the User of Errors.mp433.72MB

23 Working with Excels Conditional Functions/104 Nesting Functions.mp434.94MB

33 Excel VBA Concepts/147 Building Logic with an IF Statement.mp435.38MB

28 Mastering Excels What If Tools/125 Creating Scenarios in Excel.mp435.53MB

24 Working with Excels Lookup Functions/108 Using Excels VLOOKUP() Function.mp435.73MB

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

19 Working with Excels PowerPivot Tools/094 PowerPivot KPIs.mp435.88MB

39 Course Wrap Up/180 Congratulations Youre an Excel MacroVBA Master.mp437.06MB

25 Working with Excels Text Based Functions/112 Using Excels LEN() Function.mp437.15MB

33 Excel VBA Concepts/146 Understanding Excel VBA Variables.mp437.36MB

34 Project 2 Moving Beyond the Basics and into VBA/152 Continue Excel VBA InputBox.mp438.86MB

27 Protecting Excel Worksheets and Workbooks/119 Protecting Specific Cells in a Worksheet.mp439.54MB

15 Excel List Functions/069 Excel Function DSUM().mp439.62MB

14 Working with an Excel List/065 Creating Subtotals in a List.mp439.64MB

15 Excel List Functions/072 Excel Function SUBTOTAL().mp440.63MB

20 Working with Large Sets of Excel Data/097 Print Options for Large Sets of Data.mp440.97MB

25 Working with Excels Text Based Functions/113 Using Excels SEARCH() Function.mp441.86MB

14 Working with an Excel List/066 Format a List as a Table.mp442.73MB

33 Excel VBA Concepts/144 Creating an Excel VBA Procedure.mp443.02MB

28 Mastering Excels What If Tools/123 Working with Excels Solver Tool.mp444.76MB

19 Working with Excels PowerPivot Tools/091 Creating Data Models with PowerPivot.mp445.84MB

29 Automating Repetitive Tasks in Excel with Macros/128 Creating a Macro with the Macro Recorder.mp446.39MB

37 Project 5 Bringing it All Together and a Weekly Report/168 Project 5 Creating the Final Report Loop.mp447.28MB

32 Project 1 Using Excels Macro Recorder Tool/136 Project 1 Start Recording.mp449.21MB

37 Project 5 Bringing it All Together and a Weekly Report/169 Project 5 - Copying and Pasting Data with VBA.mp454.75MB

24 Working with Excels Lookup Functions/110 Using Excels INDEX() and MATCH() Functions.mp463.96MB