ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 效率神器,一键搞定繁琐工作
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
让更多数据处理,一键完成 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
查看: 12938|回复: 6

《Total Training Microsoft Excel 2007 基础教程》(ISO)

[复制链接]

TA的精华主题

TA的得分主题

发表于 2007-10-6 15:50 | 显示全部楼层 |阅读模式
<p><strong>中文名称</strong>:Total Training Microsoft Excel 2007 基础教程<br/><b>英文名称</b>:Total Training for Microsoft Excel 2007: Essentials<br/><b>资源类型</b>:ISO<br/><b>地区</b>:美国<br/><b>语言</b>:英语<br/><b>简介</b>:</p><p><img alt="" src="http://img.verycd.com/posts/0710/post-508986-1191544044.gif" border="0"/>&nbsp;</p><strong><font color="#ff0000"><div class="msgheader">QUOTE:</div><div class="msgborder"><p><strong><font color="#ff0000">EMULE 资源下载连接:(请先确认安装eMule软件和ffdshow,及klcodec等视频解码)</font></strong></p><div class="HtmlCode"><p>Total Training Microsoft Office Excel 2007 Essentials.iso (725.16 MB)</p></div><p>`</p></div><p>Category: Communication &amp; Office Tools <br/>Presenter: Michael Alexander<br/>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. <br/>Platform: Windows <br/>Format: DVD-ROM &amp; Online <br/>Level: Beginner to Intermediate <br/>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! <br/><br/><br/>Running Time: 5 Hrs, 1 DVD<br/>Project Files: Included<br/><br/>Highlights<br/><br/>Explore the new user interface in Office Excel 2007 to find powerful tools when you need them. <br/>Learn how to import, organize, and explore massive data sets in spreadsheets. <br/>Discover how to quickly format cells and tables the way you want. <br/>Improve spreadsheet analysis and communicate your findings in professional-looking charts. <br/>See how to adjust page margins, and add or edit headers and footers, so your spreadsheet prints exactly as you'd like. <br/><br/><br/><b>Presenter: Michael Alexander</b><br/><br/>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.<br/><br/><br/><b>具体课程表:</b></p></font></strong>Category: Communication &amp; Office Tools <br/>Presenter: Michael Alexander<br/>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. <br/>Platform: Windows <br/>Format: DVD-ROM &amp; Online <br/>Level: Beginner to Intermediate <br/>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! <br/><br/><br/>Running Time: 5 Hrs, 1 DVD<br/>Project Files: Included<br/><br/>Highlights<br/><br/>Explore the new user interface in Office Excel 2007 to find powerful tools when you need them. <br/>Learn how to import, organize, and explore massive data sets in spreadsheets. <br/>Discover how to quickly format cells and tables the way you want. <br/>Improve spreadsheet analysis and communicate your findings in professional-looking charts. <br/>See how to adjust page margins, and add or edit headers and footers, so your spreadsheet prints exactly as you'd like. <br/><br/><br/><b>Presenter: Michael Alexander</b><br/><br/>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.<br/><br/><br/><b>具体课程表:</b><p><br/>Lesson 1: WORKING WITH THE USER INTERFACE (25 min)<br/>1. Introducing the Ribbon User Interface<br/>2. Introducing Workbooks &amp; Worksheets<br/>3. Introducing the Formula Bar<br/>4. Saving with Different File Extensions<br/>5. Customizing the User Interface<br/><br/>Lesson 2: ENTERING &amp; MANAGING DATA (47 min)<br/>1. Getting Data into Excel<br/>2. Importing Text Files<br/>3. Using the Freeze Panes Functionality<br/>4. Using the Zoom Functionality<br/>5. Using Hot Keys<br/>6. Managing Rows &amp; Columns<br/>7. Finding Data<br/>8. Matching Case &amp; Entire Cell Contents<br/>9. Replacing Data<br/>10. Finding &amp; Replacing Empty Values<br/>11. Sorting Data<br/>12. Sorting Multiple Columns<br/>13. Filtering Data<br/><br/>Lesson 3: USING FORMATTING TECHNIQUES (23 min)<br/>1. Formatting Numbers &amp; Dates<br/>2. Formatting Cells<br/>3. Setting the Font Type, Color &amp; Size<br/>4. Using Borders &amp; Cell Styles<br/>5. Adding Shapes &amp; Pictures<br/>6. Creating WordArt<br/><br/>Lesson 4: Formula Basics (34 min)<br/>1. Constants, Formulas &amp; Cell References<br/>2. Understanding the Order of Operations<br/>3. Using Formulas with Dates &amp; Text<br/>4. Linking Cells &amp; Using Comparison Operators<br/>5. Creating an Absolute Reference<br/>6. Defining Named Ranges<br/>7. Exploring the Function Library<br/>8. Using the AutoSum Function<br/><br/>Lesson 5: USEFUL FUNCTIONS (40 min)<br/>1. Using the INT Function<br/>2. Using the Rounding Function<br/>3. Using the ABS Function<br/>4. Using the SUBTotal Function<br/>5. Using Logical Functions<br/>6. Using the AND &amp; the OR Function<br/>7. Using LEFT, RIGHT &amp; MID Functions<br/>8. Using the UPPER, LOWER, PROPER &amp; TRIM Functions<br/>9. Using COUNT Functions<br/>10. Using the VLOOKUP Function<br/><br/>Lesson 6: CREATING REPORTS (33 min)<br/>1. Creating a Subtotal Report<br/>2. Using Conditional Formatting<br/>3. Creating &amp; Managing Conditions<br/>4. Creating a Chart<br/>5. Refining Charts<br/>6. Using Basic Chart Types<br/><br/>Lesson 7: SHARING &amp; DISTRIBUTING YOUR WORK (25 min)<br/>1. Inserting Headers &amp; Footers<br/>2. Adding Comments<br/>3. Adjusting Page Layout<br/>4. Distributing Your Worksheets<br/>5. Protecting Your Worksheets<br/>6. Understanding Compatibility<br/><br/>Lesson 8: TIPS &amp; TRICKS (53 min)<br/>1. Using the Fill Handle<br/>2. Filling in a Series of Numbers<br/>3. Typing in Multiple Cells at Once<br/>4. Leveraging a Custom List &amp; Transposing a Range<br/>5. Deleting &amp; Inserting Blank Cells<br/>6. Filling Holes in Your Data<br/>7. Getting a List of Unique Records &amp; Parsing Text<br/>8. Rearranging Columns &amp; Linking to Multiple Cells<br/>9. Using Right Mouse Button Drag Options<br/>10. Make Format Painter Persist &amp; Paste Special Formats<br/>11. Formatting Portions of Text &amp; Multiple Sheets<br/>12. Creating Cell Border Effects &amp; Sorting on Color<br/>13. Turning Formulas into Hard Data<br/>14. Copy Formula References &amp; Highlight Formulas<br/>15. Creating Dynamic Charts &amp; Combination Charts<br/>16. Add a Secondary Axis, Average Line &amp; Smooth Line<br/>17. Comparing Data Dynamically with Charts<br/>18. Final Comments &amp; Credits<br/><br/></p>
[此贴子已经被作者于2007-10-6 16:00:35编辑过]

TA的精华主题

TA的得分主题

发表于 2007-10-6 15:56 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
[em06]看不懂

TA的精华主题

TA的得分主题

发表于 2007-10-7 11:11 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2013-1-3 18:08 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
没什么用,看不懂,不过楼主辛苦了,能找到这么个资源

TA的精华主题

TA的得分主题

发表于 2014-1-9 17:49 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2014-3-29 20:13 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2014-4-1 08:24 | 显示全部楼层
看不懂,加上翻译就好了!
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

关闭

最新热点上一条 /1 下一条

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-11-3 01:28 , Processed in 1.059526 second(s), 21 queries , Gzip On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表