v

您的位置:VeryCD教育计算机


《Total Training Microsoft Excel 2007 基础教程》(Total Training for Microsoft Excel 2007: Essentials)[ISO]

  • 状态: 精华资源
  • 摘要:
    对白语言英语
  • 时间: 2007/10/04 21:33:13 发布 | 2007/10/06 15:34:33 更新
  • 分类: 教育  计算机 

tomclarence

精华资源: 48

全部资源: 51

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名Total Training Microsoft Excel 2007 基础教程
英文名Total Training for Microsoft Excel 2007: Essentials
资源格式光盘镜像
地区美国
对白语言英语
简介

IPB Image

Title: Microsoft Excel 2007 Essentials

Total Training 发布了全部的Office 2007的教程,这次发布Excel的基础教程,以后会渐渐补充完整...
安装klcodec即可播放,记得选择ffdshow.
我安装时,默认是翻转的图像.所以在任务栏的ffdshow图标点右键,选择Flip,翻转图像,就可以了.
具体设置,如图.


IPB Image

教程正常播放时,如图.

IPB Image

OK, NOW, ENJOY IT...



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


杀毒情况:
安全检测软件软件:NOD32 2.7
版本号:Virus and Spyware Definition Version 1.20.2826.4
Firewall Policy Version 1.2.23.91
常驻:
no2.eserver.emule.org.cn
no1.eserver.emule.org.cn

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有57网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。