种子简介

种子名称： Lynda.Excel.3Courses - Team MJY
文件类型： 视频
文件数目： 100个文件
文件大小： 662.99 MB
收录时间： 2016-12-20 09:13
已经下载： 3次
资源热度： 107
最近下载： 2024-5-9 10:42

下载BT种子文件

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

磁力链接下载

magnet:?xt=urn:btih:e46fcea9a7787ff8f0f039cc96b8add3c558175f&dn=Lynda.Excel.3Courses - Team MJY 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Lynda.Excel.3Courses - Team MJY.torrent

Essential Training/00 Introduction/0001 Welcome.mov7.26MB

Essential Training/00 Introduction/0002 Using the exercise files.mov756.53KB

Essential Training/01 Getting Started/0101 Exploring three common uses for Excel.mov3.27MB

Essential Training/01 Getting Started/0102 Touring the interface.mov7.18MB

Essential Training/01 Getting Started/0103 Finding the commands you need.mov5MB

Essential Training/01 Getting Started/0104 Using Backstage view or the File tab.mov3.92MB

Essential Training/01 Getting Started/0105 Maintaining file compatibility.mov7.16MB

Essential Training/02 Worksheet Basics/0201 Creating a worksheet.mov5.38MB

Essential Training/02 Worksheet Basics/0202 Techniques for copying and pasting.mov4.3MB

Essential Training/02 Worksheet Basics/0203 Entering data automatically with Auto Fill.mov5.76MB

Essential Training/02 Worksheet Basics/0204 Targeting large data groups.mov6.07MB

Essential Training/02 Worksheet Basics/0205 Changing a worksheet's structure.mov3.68MB

Essential Training/03 Excel Formula Basics/0301 Understanding formulas and functions.mov4.63MB

Essential Training/03 Excel Formula Basics/0302 Entering data in a worksheet.mov3.33MB

Essential Training/03 Excel Formula Basics/0303 Adding numbers manually.mov4.86MB

Essential Training/03 Excel Formula Basics/0304 Adding numbers using Sum and AutoSum.mov6.72MB

Essential Training/03 Excel Formula Basics/0305 Adding a whole worksheet.mov1.86MB

Essential Training/03 Excel Formula Basics/0306 Working with numbers in columns.mov5.11MB

Essential Training/03 Excel Formula Basics/0307 Preventing errors using absolute references.mov6.07MB

Essential Training/03 Excel Formula Basics/0308 Working with times and dates.mov3.38MB

Essential Training/03 Excel Formula Basics/0309 Using IF.mov4.83MB

Essential Training/03 Excel Formula Basics/0310 Using SUMIF and AVERAGEIF.mov5.55MB

Essential Training/03 Excel Formula Basics/0311 Naming and using cell ranges.mov4.11MB

Essential Training/04 Essential Formatting/0401 Formatting numbers and dates.mov7.81MB

Essential Training/04 Essential Formatting/0402 Applying fonts, background colors, and borders.mov5.38MB

Essential Training/04 Essential Formatting/0403 Adjusting columns, rows, and text.mov5.59MB

Essential Training/04 Essential Formatting/0404 Using conditional formatting.mov5.5MB

Essential Training/04 Essential Formatting/0405 Using custom conditional formatting.mov7.72MB

Essential Training/04 Essential Formatting/0406 Adding pictures and shapes.mov9.81MB

Essential Training/05 Advanced Formatting/0501 Inserting SmartArt.mov8.56MB

Essential Training/05 Advanced Formatting/0502 Coordinating a look using themes.mov4.82MB

Essential Training/05 Advanced Formatting/0503 Applying built-in styles.mov4.68MB

Essential Training/05 Advanced Formatting/0504 Creating and sharing styles.mov7.31MB

Essential Training/05 Advanced Formatting/0505 Using templates.mov4.56MB

Essential Training/05 Advanced Formatting/0506 Creating and using original templates.mov3.06MB

Essential Training/06 Printing Preparation/0601 Making the pieces fit.mov6.11MB

Essential Training/06 Printing Preparation/0602 Inserting headers and footers.mov4.43MB

Essential Training/06 Printing Preparation/0603 Printing and PDFs.mov5.13MB

Essential Training/07 Large Excel Projects/0701 Finding and replacing data.mov3.97MB

Essential Training/07 Large Excel Projects/0702 Freezing panes.mov4.86MB

Essential Training/07 Large Excel Projects/0703 Repeating row and column titles.mov4.34MB

Essential Training/07 Large Excel Projects/0704 Creating multiple custom worksheet views.mov8.78MB

Essential Training/07 Large Excel Projects/0705 Hiding or grouping rows and columns.mov7.51MB

Essential Training/07 Large Excel Projects/0706 Managing worksheets.mov7.79MB

Essential Training/07 Large Excel Projects/0707 Calculating formulas across worksheets.mov7.06MB

Essential Training/08 Collaborating with Others/0801 Importing and exporting data in Excel.mov10.1MB

Essential Training/08 Collaborating with Others/0802 Setting workbook permissions.mov7.35MB

Essential Training/08 Collaborating with Others/0803 Inserting and editing comments.mov8.46MB

Essential Training/08 Collaborating with Others/0804 Sharing a workbook.mov1.76MB

Essential Training/08 Collaborating with Others/0805 Tracking changes.mov3.65MB

Essential Training/08 Collaborating with Others/0806 Saving files in shared locations.mov12.08MB

Essential Training/09 Exploring Excel's Database Features/0901 Splitting cell data into multiple cells.mov3MB

Essential Training/09 Exploring Excel's Database Features/0902 Joining data from multiple cells.mov5.18MB

Essential Training/09 Exploring Excel's Database Features/0903 Basic and multi-field sorting.mov8.32MB

Essential Training/09 Exploring Excel's Database Features/0904 Using tables to sort and filter data.mov6.67MB

Essential Training/09 Exploring Excel's Database Features/0905 Inserting automatic subtotals.mov4.69MB

Essential Training/09 Exploring Excel's Database Features/0906 Creating lookup tables.mov6.78MB

Essential Training/10 Analyzing Data/1001 Using auditing to diagram.mov7.07MB

Essential Training/10 Analyzing Data/1002 Using evaluation in Excel.mov2.24MB

Essential Training/10 Analyzing Data/1003 Working with Goal Seek.mov5.8MB

Essential Training/10 Analyzing Data/1004 Using data tables in formulas.mov6.51MB

Essential Training/10 Analyzing Data/1005 Using scenarios in formulas.mov5.94MB

Essential Training/10 Analyzing Data/1006 Exploring the Analysis Toolpak.mov8.96MB

Essential Training/11 Advanced Analysis with PivotTables/1101 Discovering PivotTables.mov2.28MB

Essential Training/11 Advanced Analysis with PivotTables/1102 Creating a basic PivotTable.mov3.03MB

Essential Training/11 Advanced Analysis with PivotTables/1103 Modifying a PivotTable.mov7.64MB

Essential Training/11 Advanced Analysis with PivotTables/1104 Creating and modifying a PivotChart.mov7.14MB

Essential Training/12 Creating and Using Charts/1201 Choosing chart types.mov1.73MB

Essential Training/12 Creating and Using Charts/1202 Inserting Sparklines.mov4.52MB

Essential Training/12 Creating and Using Charts/1203 Creating a column chart.mov3.66MB

Essential Training/12 Creating and Using Charts/1204 Modifying a column chart.mov6.84MB

Essential Training/12 Creating and Using Charts/1205 Creating and modifying a pie chart.mov8.13MB

Essential Training/12 Creating and Using Charts/1206 Placing Excel charts into other Office applications.mov5.83MB

Essential Training/13 Creating and Using Macros/1301 Understanding macros.mov2.8MB

Essential Training/13 Creating and Using Macros/1302 Recording and using a simple macro.mov14.08MB

Essential Training/13 Creating and Using Macros/1303 Editing a macro.mov7.21MB

Essential Training/14 Customizing Excel/1401 Customizing the Quick Access toolbar.mov4.31MB

Essential Training/14 Customizing Excel/1402 Customizing the Ribbon bar.mov13.18MB

Essential Training/14 Customizing Excel/1403 Setting Excel options.mov9.69MB

Essential Training/15 Conclusion/1501 Goodbye.mov244.38KB

Managing Multiple Worksheets and Workbooks/00 Introduction/0001 Welcome.mov12.33MB

Managing Multiple Worksheets and Workbooks/00 Introduction/0002 Using the exercise files.mov1.36MB

Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0101 Learning basic navigation tips.mov18.34MB

Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0102 Inserting and deleting new sheets.mov8.33MB

Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0103 Copying and moving sheets within a workbook.mov7.55MB

Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0104 Changing tab colors and renaming sheets.mov5.39MB

Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0105 Using the Hide function on worksheet tabs.mov11.09MB

Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0201 Displaying multiple worksheets from the same workbook.mov17.55MB

Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0202 Copying, moving, and inserting data on different sheets.mov5.61MB

Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0203 Applying global changes to worksheets.mov7.37MB

Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0301 Creating linkage formulas.mov6.84MB

Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0302 Creating 3D formulas for worksheets with identical layouts.mov10.32MB

Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov19.51MB

Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0401 Navigating between open workbooks.mov7MB

Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0402 Displaying multiple worksheets from different workbooks.mov9.97MB

Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0403 Copying and moving data and entire worksheets across different workbooks.mov11.98MB

Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0501 Creating formulas that link worksheets in different workbooks.mov7.71MB

Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0502 Locating and managing links between multiple workbooks.mov11.02MB

Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov19.17MB

Managing Multiple Worksheets and Workbooks/06 Conclusion/0601 Final thoughts.mov2.71MB