《Total Training Microsoft Excel 2007 基础教程》（ISO）

DC.Direct · 发表于 2007-10-6 15:50

中文名称：Total Training Microsoft Excel 2007 基础教程 英文名称：Total Training for Microsoft Excel 2007: Essentials 资源类型：ISO 地区：美国 语言：英语 简介：<img alt="" src="http://img.verycd.com/posts/0710/post-508986-1191544044.gif" border="0"/> <div class="msgheader">QUOTE:</div><div class="msgborder">EMULE 资源下载连接：（请先确认安装eMule软件和ffdshow，及klcodec等视频解码）<div class="HtmlCode">Total Training Microsoft Office Excel 2007 Essentials.iso (725.16 MB)</div>`</div>Category: Communication & Office Tools Presenter: Michael Alexander Michael Alexander, a Microsoft Certified Application Developer (MCAD), is the Senior Program Manager for a top Texas technology firm. Michael started his consulting and office development career with the White House Communications Agency and Military Office and later launched a successful private practice. Michael is the author of several books on analysis with Microsoft Access and Excel, and the principal behind DataPigTechnologies.com where he shares Access and Excel tutorials. Platform: Windows Format: DVD-ROM & Online Level: Beginner to Intermediate Description: Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers. This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time! Running Time: 5 Hrs, 1 DVD Project Files: Included Highlights Explore the new user interface in Office Excel 2007 to find powerful tools when you need them. Learn how to import, organize, and explore massive data sets in spreadsheets. Discover how to quickly format cells and tables the way you want. Improve spreadsheet analysis and communicate your findings in professional-looking charts. See how to adjust page margins, and add or edit headers and footers, so your spreadsheet prints exactly as you'd like. Presenter: Michael Alexander Michael Alexander, a Microsoft Certified Application Developer (MCAD), is the Senior Program Manager for a top Texas technology firm. Michael started his consulting and office development career with the White House Communications Agency and Military Office and later launched a successful private practice. Michael is the author of several books on analysis with Microsoft Access and Excel, and the principal behind DataPigTechnologies.com where he shares Access and Excel tutorials. 具体课程表:Category: Communication & Office Tools Presenter: Michael Alexander Michael Alexander, a Microsoft Certified Application Developer (MCAD), is the Senior Program Manager for a top Texas technology firm. Michael started his consulting and office development career with the White House Communications Agency and Military Office and later launched a successful private practice. Michael is the author of several books on analysis with Microsoft Access and Excel, and the principal behind DataPigTechnologies.com where he shares Access and Excel tutorials. Platform: Windows Format: DVD-ROM & Online Level: Beginner to Intermediate Description: Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers. This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time! Running Time: 5 Hrs, 1 DVD Project Files: Included Highlights Explore the new user interface in Office Excel 2007 to find powerful tools when you need them. Learn how to import, organize, and explore massive data sets in spreadsheets. Discover how to quickly format cells and tables the way you want. Improve spreadsheet analysis and communicate your findings in professional-looking charts. See how to adjust page margins, and add or edit headers and footers, so your spreadsheet prints exactly as you'd like. Presenter: Michael Alexander Michael Alexander, a Microsoft Certified Application Developer (MCAD), is the Senior Program Manager for a top Texas technology firm. Michael started his consulting and office development career with the White House Communications Agency and Military Office and later launched a successful private practice. Michael is the author of several books on analysis with Microsoft Access and Excel, and the principal behind DataPigTechnologies.com where he shares Access and Excel tutorials. 具体课程表: Lesson 1: WORKING WITH THE USER INTERFACE (25 min) 1. Introducing the Ribbon User Interface 2. Introducing Workbooks & Worksheets 3. Introducing the Formula Bar 4. Saving with Different File Extensions 5. Customizing the User Interface Lesson 2: ENTERING & MANAGING DATA (47 min) 1. Getting Data into Excel 2. Importing Text Files 3. Using the Freeze Panes Functionality 4. Using the Zoom Functionality 5. Using Hot Keys 6. Managing Rows & Columns 7. Finding Data 8. Matching Case & Entire Cell Contents 9. Replacing Data 10. Finding & Replacing Empty Values 11. Sorting Data 12. Sorting Multiple Columns 13. Filtering Data Lesson 3: USING FORMATTING TECHNIQUES (23 min) 1. Formatting Numbers & Dates 2. Formatting Cells 3. Setting the Font Type, Color & Size 4. Using Borders & Cell Styles 5. Adding Shapes & Pictures 6. Creating WordArt Lesson 4: Formula Basics (34 min) 1. Constants, Formulas & Cell References 2. Understanding the Order of Operations 3. Using Formulas with Dates & Text 4. Linking Cells & Using Comparison Operators 5. Creating an Absolute Reference 6. Defining Named Ranges 7. Exploring the Function Library 8. Using the AutoSum Function Lesson 5: USEFUL FUNCTIONS (40 min) 1. Using the INT Function 2. Using the Rounding Function 3. Using the ABS Function 4. Using the SUBTotal Function 5. Using Logical Functions 6. Using the AND & the OR Function 7. Using LEFT, RIGHT & MID Functions 8. Using the UPPER, LOWER, PROPER & TRIM Functions 9. Using COUNT Functions 10. Using the VLOOKUP Function Lesson 6: CREATING REPORTS (33 min) 1. Creating a Subtotal Report 2. Using Conditional Formatting 3. Creating & Managing Conditions 4. Creating a Chart 5. Refining Charts 6. Using Basic Chart Types Lesson 7: SHARING & DISTRIBUTING YOUR WORK (25 min) 1. Inserting Headers & Footers 2. Adding Comments 3. Adjusting Page Layout 4. Distributing Your Worksheets 5. Protecting Your Worksheets 6. Understanding Compatibility Lesson 8: TIPS & TRICKS (53 min) 1. Using the Fill Handle 2. Filling in a Series of Numbers 3. Typing in Multiple Cells at Once 4. Leveraging a Custom List & Transposing a Range 5. Deleting & Inserting Blank Cells 6. Filling Holes in Your Data 7. Getting a List of Unique Records & Parsing Text 8. Rearranging Columns & Linking to Multiple Cells 9. Using Right Mouse Button Drag Options 10. Make Format Painter Persist & Paste Special Formats 11. Formatting Portions of Text & Multiple Sheets 12. Creating Cell Border Effects & Sorting on Color 13. Turning Formulas into Hard Data 14. Copy Formula References & Highlight Formulas 15. Creating Dynamic Charts & Combination Charts 16. Add a Secondary Axis, Average Line & Smooth Line 17. Comparing Data Dynamically with Charts 18. Final Comments & Credits

[此贴子已经被作者于2007-10-6 16:00:35编辑过]

圈圈2005 · 发表于 2007-10-6 15:56

[em06]看不懂

月黑风高 · 发表于 2007-10-7 11:11

本人标准英盲，不下了，纯支持

sunwei1987 · 发表于 2013-1-3 18:08

没什么用，看不懂，不过楼主辛苦了，能找到这么个资源

LFXD · 发表于 2014-1-9 17:49

楼主辛苦了！怪我看不懂。

眉飞色舞千千样 · 发表于 2014-3-29 20:13

确实看不懂

daxiaym · 发表于 2014-4-1 08:24

看不懂，加上翻译就好了！

		自动登录	找回密码
密码			免费注册