【Lynda】Excel 2007: Introduction to Formulas and Functions【CHN】中英文字幕[SRT]

作者: acely. 分类: Lynda中文字幕, ◇ 商业办公

==========教程信息=====================================================
教程名称:Excel 2007: Introduction to Formulas and Functions
作者:Curt Frye
主题:Business, Spreadsheets
使用软件:Excel 2007
难度等级:中级
时长: 2h 26m
发布日期: Nov 11, 2009

┏ACELY STUDIO,2012
┃更多资源请访问
┃◆唯一发布站:ACELY.CN
┗◆我的博客:http://blog.sina.com.cn/u/1991840741

==========教程目录文件列表=============================================
Excel 2007- Introduction to Formulas and Functions[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Introducing Excel 2007 Functions and Formulas
│ └─◇ 0101 Familiarizing yourself with functions and formulas.srt
│ └─◇ 0102 Creating a formula.srt
│ └─◇ 0103 Introducing arithmetic operators.srt
│ └─◇ 0104 Using cell references in formulas.srt
│ └─◇ 0105 Copying and pasting formulas and values.srt
│ └─◇ 0106 Editing a formula.srt
│ └─◇ 0107 Getting help using Excel functions.srt
├─◆2. Creating Basic Summary Formulas
│ └─◇ 0201 Creating a SUM or AVERAGE formula.srt
│ └─◇ 0202 Creating an AutoSum formula.srt
│ └─◇ 0203 Creating MIN, MAX, MEDIAN, and MODE formulas.srt
│ └─◇ 0204 Creating formulas to count cells.srt
│ └─◇ 0205 Creating formulas to summarize cells conditionally.srt
│ └─◇ 0206 Summarizing data on the Status bar.srt
│ └─◇ 0207 Rounding cell values up and down.srt
├─◆3. Sorting and Filtering PivotTable Data
│ └─◇ 0301 Summarizing data using named ranges.srt
│ └─◇ 0302 Creating a dynamic named range.srt
│ └─◇ 0303 Editing and deleting named ranges.srt
│ └─◇ 0304 Summarizing list data by creating subtotals.srt
│ └─◇ 0305 Grouping and outlining list data.srt
│ └─◇ 0306 Summarizing data using an Excel table.srt
│ └─◇ 0307 Referring to Excel table cells in formulas.srt
│ └─◇ 0308 Finding data using VLOOKUP and HLOOKUP formulas.srt
├─◆4. Preparing Data for Analysis in Excel
│ └─◇ 0401 Importing data into Excel.srt
│ └─◇ 0402 Connecting to an external data source.srt
│ └─◇ 0403 Cleaning up data imported into Excel.srt
│ └─◇ 0404 Creating data validation rules.srt
│ └─◇ 0405 Using lists to limit values entered into a cell.srt
├─◆5. Auditing Worksheet Formulas
│ └─◇ 0501 Managing Excel formula error indicators.srt
│ └─◇ 0502 Identifying and tracing errors.srt
│ └─◇ 0503 Tracing formula precedents and dependents.srt
│ └─◇ 0504 Evaluating Excel formulas step by step.srt
│ └─◇ 0505 Watching cell values.srt
├─◆6. Performing What-If Analysis
│ └─◇ 0601 Creating scenarios and applying them to an Excel worksheet.srt
│ └─◇ 0602 Editing, deleting, and summarizing scenarios.srt
│ └─◇ 0603 Creating a single-input data table.srt
│ └─◇ 0604 Creating a double-input data table.srt
│ └─◇ 0605 Finding target values using Goal Seek.srt
├─◆Conclusion
│ └─◇ Goodbye.srt

【本字幕由ACELY.CN独家制作发布】


┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译,对翻译结果中不当内容不承担任何责任!
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载!


>>>>>>>【点我下载】<<<<<<<

标签:, ,

您的留言是我最大的支持!

你必须登录才能发表评论!

※ 本站内容未经允许一律严禁转载!Lynda教程及字幕交流群:214645753
※ 本站文件统一解压密码:acely.cn 或 www.cgsub.com