资源详情

返回首页 | 相关搜索
Lynda.com - Excel 2010 Essential Training
大小 470.07 MB
文件数 81
Info Hash: 53B85F223C316F8A2A97C7EA863A9B1D159FBC8F
收录时间 2025-12-12 22:30:48
更新时间 2025-12-20 05:12:38
文件列表 (81)
00 Introduction/0001 Welcome.mov
7.26 MB
00 Introduction/0002 Using the exercise files.mov
756.53 KB
01 Getting Started/0101 Exploring three common uses for Excel.mov
3.27 MB
01 Getting Started/0102 Touring the interface.mov
7.18 MB
01 Getting Started/0103 Finding the commands you need.mov
5 MB
01 Getting Started/0104 Using Backstage view or the File tab.mov
3.92 MB
01 Getting Started/0105 Maintaining file compatibility.mov
7.16 MB
02 Worksheet Basics/0201 Creating a worksheet.mov
5.38 MB
02 Worksheet Basics/0202 Techniques for copying and pasting.mov
4.3 MB
02 Worksheet Basics/0203 Entering data automatically with Auto Fill.mov
5.76 MB
02 Worksheet Basics/0204 Targeting large data groups.mov
6.07 MB
02 Worksheet Basics/0205 Changing a worksheet's structure.mov
3.68 MB
03 Excel Formula Basics/0301 Understanding formulas and functions.mov
4.63 MB
03 Excel Formula Basics/0302 Entering data in a worksheet.mov
3.33 MB
03 Excel Formula Basics/0303 Adding numbers manually.mov
4.86 MB
03 Excel Formula Basics/0304 Adding numbers using Sum and AutoSum.mov
6.72 MB
03 Excel Formula Basics/0305 Adding a whole worksheet.mov
1.86 MB
03 Excel Formula Basics/0306 Working with numbers in columns.mov
5.11 MB
03 Excel Formula Basics/0307 Preventing errors using absolute references.mov
6.07 MB
03 Excel Formula Basics/0308 Working with times and dates.mov
3.38 MB
03 Excel Formula Basics/0309 Using IF.mov
4.83 MB
03 Excel Formula Basics/0310 Using SUMIF and AVERAGEIF.mov
5.55 MB
03 Excel Formula Basics/0311 Naming and using cell ranges.mov
4.11 MB
04 Essential Formatting/0401 Formatting numbers and dates.mov
7.81 MB
04 Essential Formatting/0402 Applying fonts, background colors, and borders.mov
5.38 MB
04 Essential Formatting/0403 Adjusting columns, rows, and text.mov
5.59 MB
04 Essential Formatting/0404 Using conditional formatting.mov
5.5 MB
04 Essential Formatting/0405 Using custom conditional formatting.mov
7.72 MB
04 Essential Formatting/0406 Adding pictures and shapes.mov
9.81 MB
05 Advanced Formatting/0501 Inserting SmartArt.mov
8.56 MB
05 Advanced Formatting/0502 Coordinating a look using themes.mov
4.82 MB
05 Advanced Formatting/0503 Applying built-in styles.mov
4.68 MB
05 Advanced Formatting/0504 Creating and sharing styles.mov
7.31 MB
05 Advanced Formatting/0505 Using templates.mov
4.56 MB
05 Advanced Formatting/0506 Creating and using original templates.mov
3.06 MB
06 Printing Preparation/0601 Making the pieces fit.mov
6.11 MB
06 Printing Preparation/0602 Inserting headers and footers.mov
4.43 MB
06 Printing Preparation/0603 Printing and PDFs.mov
5.13 MB
07 Large Excel Projects/0701 Finding and replacing data.mov
3.97 MB
07 Large Excel Projects/0702 Freezing panes.mov
4.86 MB
07 Large Excel Projects/0703 Repeating row and column titles.mov
4.34 MB
07 Large Excel Projects/0704 Creating multiple custom worksheet views.mov
8.78 MB
07 Large Excel Projects/0705 Hiding or grouping rows and columns.mov
7.51 MB
07 Large Excel Projects/0706 Managing worksheets.mov
7.79 MB
07 Large Excel Projects/0707 Calculating formulas across worksheets.mov
7.06 MB
08 Collaborating with Others/0801 Importing and exporting data in Excel.mov
10.1 MB
08 Collaborating with Others/0802 Setting workbook permissions.mov
7.35 MB
08 Collaborating with Others/0803 Inserting and editing comments.mov
8.46 MB
08 Collaborating with Others/0804 Sharing a workbook.mov
1.76 MB
08 Collaborating with Others/0805 Tracking changes.mov
3.65 MB
08 Collaborating with Others/0806 Saving files in shared locations.mov
12.08 MB
09 Exploring Excel's Database Features/0901 Splitting cell data into multiple cells.mov
3 MB
09 Exploring Excel's Database Features/0902 Joining data from multiple cells.mov
5.18 MB
09 Exploring Excel's Database Features/0903 Basic and multi-field sorting.mov
8.32 MB
09 Exploring Excel's Database Features/0904 Using tables to sort and filter data.mov
6.67 MB
09 Exploring Excel's Database Features/0905 Inserting automatic subtotals.mov
4.69 MB
09 Exploring Excel's Database Features/0906 Creating lookup tables.mov
6.78 MB
10 Analyzing Data/1001 Using auditing to diagram.mov
7.07 MB
10 Analyzing Data/1002 Using evaluation in Excel.mov
2.24 MB
10 Analyzing Data/1003 Working with Goal Seek.mov
5.8 MB
10 Analyzing Data/1004 Using data tables in formulas.mov
6.51 MB
10 Analyzing Data/1005 Using scenarios in formulas.mov
5.94 MB
10 Analyzing Data/1006 Exploring the Analysis Toolpak.mov
8.96 MB
11 Advanced Analysis with PivotTables/1101 Discovering PivotTables.mov
2.28 MB
11 Advanced Analysis with PivotTables/1102 Creating a basic PivotTable.mov
3.03 MB
11 Advanced Analysis with PivotTables/1103 Modifying a PivotTable.mov
7.64 MB
11 Advanced Analysis with PivotTables/1104 Creating and modifying a PivotChart.mov
7.14 MB
12 Creating and Using Charts/1201 Choosing chart types.mov
1.73 MB
12 Creating and Using Charts/1202 Inserting Sparklines.mov
4.52 MB
12 Creating and Using Charts/1203 Creating a column chart.mov
3.66 MB
12 Creating and Using Charts/1204 Modifying a column chart.mov
6.84 MB
12 Creating and Using Charts/1205 Creating and modifying a pie chart.mov
8.13 MB
12 Creating and Using Charts/1206 Placing Excel charts into other Office applications.mov
5.83 MB
13 Creating and Using Macros/1301 Understanding macros.mov
2.8 MB
13 Creating and Using Macros/1302 Recording and using a simple macro.mov
14.08 MB
13 Creating and Using Macros/1303 Editing a macro.mov
7.21 MB
14 Customizing Excel/1401 Customizing the Quick Access toolbar.mov
4.31 MB
14 Customizing Excel/1402 Customizing the Ribbon bar.mov
13.18 MB
14 Customizing Excel/1403 Setting Excel options.mov
9.69 MB
15 Conclusion/1501 Goodbye.mov
244.38 KB
Exercise Files/Ex_Files_Excel2010_EssT.zip
8.23 MB
相关资源

免责声明

本网站仅提供DHT网络资源索引服务，不存储任何资源文件。所有资源均来自DHT网络，本站无法控制其内容。请遵守当地法律法规，合理使用网络资源。如涉及版权问题，请联系 fuckatgfw@protonmail.com。

© 2025 鹿鹿堂