{{sellerTotalView > 1 ? __("sellers", {number: sellerTotalView}) : __("seller", {number: sellerTotalView}) }}, {{numTotalView > 1 ? __("items", {number: numTotalView}) : __("item", {number: numTotalView}) }}
free FREE

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

{{email ? __('Got it!') : __('Restock Alert')}}

We will notify you by email when the item back in stock.

Cancel
Yami

Jingdong book

中等职业学校教学用书(计算机技术专业):Excel 2007实用教程

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

中等职业学校教学用书(计算机技术专业):Excel 2007实用教程

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}
Ends in
{{ itemCurrency }}{{ item.valid_price }}
{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}
{{ itemDiscount }}
{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}
{{ itemCurrency }}{{ item.valid_price }}
Sale ends in
Sale will starts after Sale ends in
{{ getSeckillDesc(item.seckill_data) }}
{{ __( "Pay with Gift Card to get sale price: :itemCurrency:price", { 'itemCurrency' : itemCurrency, 'price' : (item.giftcard_price ? priceFormat(item.giftcard_price) : '0.00') } ) }} ({{ itemCurrency }}{{ priceFormat(item.giftcard_price / item.bundle_specification) }}/{{ item.unit }}) Details
Best before

Currently unavailable.

We don't know when or if this item will be back in stock.

Unavailable in your area.
Sold Out

Details

Full product details
Content Description

Excel 2007是Microsoft Office System 2007中的电子表格软件,它提供了强大的工具和功能,可以用来制作电子表格、完成各种数据运算、进行数据分析与预测、制作图表等。《Excel 2007实用教程》通过大量的实战演练,详细地介绍了Excel2007电子表格系统的基础知识、基本操作和数据管理分析技术。《Excel 2007实用教程》共分10章,主要内容包括:初识Excel 2007,Excel 2007基本操作,编辑工作表,格式化工作表,打印工作表,公式应用,函数应用,制作图表,数据处理,数据分析。
《Excel 2007实用教程》坚持以就业为导向、以能力为本位的原则,突出实用性、适用性和先进性;结构合理、论述准确、内容翔实、步骤清晰,注意知识的层次性和技能培养的渐进性;遵循难点分散的原则合理安排各章的内容,降低学生的学习难度;通过丰富的操作实例引导学习者学习,旨在培养他们的实践动手能力。每章后均配有本章小结、习题和上机实验。
《Excel 2007实用教程》可作为中等职业学校计算机及应用等专业的教材,也可作为各类办公自动化人员的参考书。
Catalogue

第1章 初识Excel 2007
1.1 认识Excel 2007用户界面
1.1.1 启动Excel 2007
1.1.2 Excel 2007用户界面介绍
1.1.3 退出Excel 2007
1.2 理解工作簿、工作表和单元格
1.2.1 工作簿
1.2.2 工作表
1.2.3 单元格
本章 小结
习题1
上机实验1

第2章 ExceI2007基本操作
2.1 创建工作簿
2.1.1 创建空白工作簿
2.1.2 基于模板创建工作簿
2.1.3 基于现有工作簿创建新工作簿
2.2 保存工作簿
2.2.1 保存新建工作簿
2.2.2 保存现有工作簿
2.2.3 设置自动保存
2.2.4 设置工作簿密码
2.3 打开和关闭工作簿
2.3.1 打开工作簿
2.3.2 在工作簿之间切换
2.3 13关闭工作簿
2.4 操作工作表
2.4.1 在工作表之间切换
2.4.2 插入工作表
2.4.3 重命名工作表
2.4.4 设置工作表标签颜色
2.4.5 选择工作表
2.4.6 移动或复制工作表
2.4.7 隐藏和显示工作表
2.4.8 删除工作表
2.4.9 保护工作表
本章 小结
习题2
上机实验2

第3章 编辑工作表
3.1 手动输入数据
3.1.1 输入文本
3.1.2 输入日期和时间
3.1.3 输入数字
3.1.4 设置数据有效性
3.2 自动填充数据
3.2.1 使用记忆式输入
3.2.2 填充相邻单元格内容
3.2.3 填充内置序列
3.2.4 填充自定义序列
3.2.5 快速输入相同数据
3.3 修改单元格数据
3.3.1 编辑单元格内容
3.3.2 查找和替换
3.3.3 撤销、恢复或重复
3.4 移动和复制数据
3.4.1 选择单元格或区域
3.4.2 使用剪贴板移动或复制单元格
3.4.3 使用鼠标移动或复制单元格
3.4.4 以插入方式移动或复制单元格
3.4.5 移动或复制单元格数据
3.4.6 复制特定单元格内容
3.5 插入行、列或单元格r
3.5.1 插入行
3.5.2 插入列
3.5.3 插入单元格
3.6 删除行、列或单元格
3.6.1 删除行
3.6.2 删除列
3.6.3 删除单元格
本章 小结
习题3
上机实验3

第4章 格式化工作表
4.1 设置单元格格式
4.1.1 设置字符格式
4.1.2 设置数字类型
4.1.3 重定位单元格数据
4.1.4 合并单元格
4.1.5 设置单元格边框
4.1.6 设置单元格底纹
4.1.7 套用表格格式
4.2 设置条件格式
4.2.1 使用色阶设置单元格格式
4.2.2 使用数据条设置单元格格式
4.2.3 使用图标集设置单元格格式
4.2.4 突出显示单元格
4.3 调整行高与列宽
4.3.1 调整行高
4.3.2 调整列宽
4.3.3 隐藏行或列¨
4.3.4 冻结行或列
4.4 使用单元格样式
4.4.1 应用单元格样式
4.4.2 新建单元格样式
4.4.3 删除单元格样式
4.5 美化工作表
4.5.1 插入图片
4.5.2 插入剪贴画
4.5.3 插入自选图形
4.5.4 插入SmanArt图形
4.5.5 插入艺术字
本章 小结
习题4
上机实验4

第5章 打印工作表
5.1 设置页面
5.1.1 设置页边距
5.1.2 设置纸张方向
5.1.3 设置纸张大小
5.1.4 设置打印区域
5.1.5 设置打印标题
5.1.6 设置页眉和页脚
5.1.7 设置分页符
5.2 设置文档主题
5.2.1 应用文档主题
5.2.2 自定义主题颜色
5.2.3 自定义主题字体
5.2.4 设置主题效果
5.2.5 保存文档主题
5.3 使用视图方式
5.3.1 普通视图
5.3.2 页面布局视图
5.3.3 分页预览视图
5.3.4 打印预览视图
5.4 打印工作表
5.4.1 打印部分内容
5.4.2 打印工作表
5.4.3 打印整个工作簿
5.4.4 打印Excel表格
本章 小结
习题5
上机实验5

第6章 公式应用
6.1 公式概述
6.1.1 公式的组成
6.1.2 常用运算符
6.1.3 运算符优先级
6.2 创建公式
6.2.1 输入公式
6.2.2 修改公式
6.2.3 移动公式
6.2.4 复制公式
6.2.5 删除公式
6.3 单元格引用
6.3.1 引用样式
6.3.2 相对引用
6.3.3 绝对引用
6.3.4.混合引用
6.3.5 三维引用
6.3.6 外部引用
6.4 使用数组公式
6.4.1 数组的概念
6.4.2 创建数组公式
6.4.3 编辑数组公式
……

第7章 函数应用
第8章 制作图表
第9章 数据处理
Introduction

Excel 2007是Microsoft Office System 2007中的电子表格软件,它提供了强大的工具和功能.可以用来制作电子表格、完成各种数据运算、进行数据分析与预测、制作图表,以及使用VBA语言编程等,在管理、统计、财经、金融等诸多领域中都得到了广泛的应用。
本书根据教育部颁布的《中等职业学校计算机及应用专业教学指导方案》的基本精神,结合现代职业教育的特点和社会用人需求,通过大量的实战演练,详细地介绍了Excel 2007电子表格系统的基础知识、基本操作和数据管理分析技术。在编写过程中,坚持以就业为导向、以能力为本位的原则,力求突出教材的实用性、适用性和先进性。
本书共分1 0童。第l章介绍Excel 2007的用户界面,并讲述工作簿、工作表和单元格的基本概念;第2章介绍Excel 2007中的基本操作,包括创建工作簿、保存工作簿、打开和关闭工作簿及操作工作表;第3章讲述工作表的编辑,包括手动输入数据、自动填充数据、修改单元格数据、移动和复制数据、插入行列或单元格及删除行列或单元格;第4章讨论如何对工作表进行格式化,包括设置单元格格式、设置条件格式、调整行高与列宽、使用单元格样式及美化工作表:第5章讲解如何对工作表进行打印,包括设置页面、设置文档主题、使用视图方式及打印工作表:第6章讨论如何利用公式对工作表数据进行计算,包括公式概述、创建公式、单元格引用、使用数组公式、处理名称及审核公式;第7章介绍如何利用函数对工作表数据进{亍计算,首先讲述函数的作用、语法和分类,然后讲解如何输入和嵌套函数,最后分门别类地讨论一些常用函数的使用方法;第8章讲述图表的制作方法,主要介绍图表的组成和类型、创建图表及设置图表格式:第9章讨论如何进行数据处理,包括导入数据、使用Excel表格、数据排序、数据筛选及分类汇总;第10章讨论如何进行数据分析,包括使用数据透视表、使用数据透视图及创建趋势线。
本书及源文件中用到的数据均为虚构,如有雷同,实属巧合。
本书由赵增敏、秦笑舒担任主编,朱粹丹、余霞担任副主编。参加本书编写、数据测试和文字录入的还有赵朱曦、郭宏等,在此一并致谢。
由于作者水平所限,书中疏漏和错误之处在所难免,恳请广大读者提出宝贵意见。
为了方便教师教学和学生学习,本书还配有源文件、教学指南、电子教案和习题答案(电子版)。请有此需要的教师或学生登录华信教育资源网免费注册后进行下载,有问题时请在网站留言板留言或与电子工业出版社联系。

Specifications

Brand Jingdong book
Brand Origin China

Disclaimer

Product packaging, specifications and price are subject to change without notice. All information about the products on our website is provided for information purposes only. Please always read labels, warnings and directions provided with the product before use.

View Full Terms of Use
Add to favorites
{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}
{{__("Buy Directly")}} {{ itemCurrency }}{{ item.directly_price }}
Quantity
{{ quantity }}
{{ instockMsg }}
{{ limitText }}
{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}
Sold by JD@CHINA
Ship to
{{ __("Ship to United States only") }}
Free shipping over 69
Genuine guarantee

Added to Cart

Keep Shopping

More to Consider

{{ item.brand_name }}

{{ item.item_name }}

{{ item.currency }}{{ item.market_price }}

{{ item.currency }}{{ item.unit_price }}

{{ item.currency }}{{ item.unit_price }}

Coupons

{{ coupon.coupon_name_new | formatCurrency }}
Clip Clipped Over
{{ getCouponDescStr(coupon) }}
{{ coupon.use_time_desc }}
Expires soon {{ formatTime(coupon.use_end_time) }}

Share this item with friends

Cancel

Yami Gift Card

Get this exclusive deal when paying with gift card

Terms and Conditions

Gift card deals are special offers for selected products;

The gift card deals will automatically be activated if a customer uses gift card balance at check out and the balance is sufficient to pay for the total price of the shopping cart products with gift card deals;

You will not be able to activate the gift card deals if you choose other payment methods besides gift card. The products will be purchased at their normal prices;

If your account balance is not enough to pay for the products with gift card deals, you can choose to reload your gift card balance by clicking on the Reload button at either shopping cart page or check out page;

Products that have gift card deals can be recognized by a special symbol showing 'GC Deal';

For any additional questions or concerns, please contact our customer service;

Yamibuy reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

Yami is committed to provide our customers with a peace of mind when purchasing from us. Most items shipped from Yamibuy.com can be returned within 30 days of receipt of shipment (For Food, Beverages, Snacks, Dry Goods, Health supplements, Fresh Grocery and Perishables Goods, within 7 days of receipt of shipment due to damages or quality issues; To ensure that every customer receives safe and high-quality products, we do not provide refunds or returns for beauty products once they have been opened or used, except in the case of quality issues; Some products may have different policies or requirements associated with them, please see below for products under special categories, or contact Yami Customer Service for further assistance).
Thank you for your understanding and support.

Learn More

Sold by Yami

Terms and Conditions of Yami E-Gift Card

If you choose “Redeem automatically” as your delivery method, your gift card balance will be reload automatically after your order has been processed successfully;

If you choose “Send to Email”as your delivery method, the card number and CVV will be sent to the email address automatically;

Any user can use the card number and CVV to redeem the gift card, please keep your gift card information safely. If you have any trouble receiving email, please contact Yami customer service;

Yami gift card can be used to purchase both Yami owned or Marketplace products;

Yami gift card will never expire;

Yami gift card balance does not have to be used up at once;

All rights reserved by Yami.

Return Policy

Gift card that has already been consumed is non-refundable.

Sold by JD@CHINA

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Sold by JD@CHINA

Service Guarantee

Yami Cross-store Free Shipping over $69
Yami 30-days Return

Yami-China FC

Yami has a consolidation warehouse in China which collects multiple sellers’ packages and combines to one order. Our Yami consolidation warehouse will directly ship the packages to your door. Cross-store free shipping over $69.

Return Policy

You may return products within 30 days upon receiving the products. Sellers take responsibilities for any wrong shipment or missing items. Packing needs to be unopened for any other than quality issues return. We promise to pack carefully, but because goods are taking long journey to destinations, simple damages to packaging may occur. Any damages not causing internal goods quality problems are not allowed to return. If you open the package and any quality problem is found, please contact customer service within three days after receipt of goods.

Shipping Information

Yami Consolidation Service Shipping Fee $9.99(Free shipping over $69)

Sellers in China will ship their orders within 1-2 business days once the order is placed. Packages are sent to our consolidation warehouse in China and combined there. Our Yami consolidation warehouse will directly ship the packages to you via UPS. The average time for UPS to ship from China to the United States is about 10 working days and it can be traced using the tracking number. Due to the pandemic, the delivery time may be delayed by about 5 days. The package needs to be signed by the guest. If the receipt is not signed, the customer shall bear the risk of loss of the package.

Sold by JD@CHINA

Service Guarantee

Free shipping over 69
Genuine guarantee

Shipping

Yami Consolidated Shipping $9.99(Free shipping over $69)


Seller will ship the orders within 1-2 business days. The logistics time limit is expected to be 7-15 working days. In case of customs clearance, the delivery time will be extended by 3-7 days. The final receipt date is subject to the information of the postal company.

Yami Points information

All items are excluding from any promotion or points events on Yamibuy.com

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Yami

Download the Yami App

Back Top

Recommended for You

About the brand

Jingdong book

为您推荐

Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折

Reviews{{'('+ commentList.posts_count + ')'}}

Have your say. Be the first to help other guests.

Write a review
{{ totalRating }} Write a review
  • {{i}} star

    {{i}} stars

    {{ parseInt(commentRatingList[i]) }}%

Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}
Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

No related comment~

Review

Yami Yami

{{ showTranslate(commentDetails) }}Show Less

{{ strLimit(commentDetails,800) }}Show more

Show Original

{{ commentDetails.content }}

Yami
Show All

{{ formatTime(commentDetails.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ commentDetails.likes_count }} {{ commentDetails.likes_count }} {{ commentDetails.reply_count }} {{commentDetails.in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Comments{{'(' + replyList.length + ')'}}

Yami Yami

{{ showTranslate(reply) }}Show Less

{{ strLimit(reply,800) }}Show more

Show Original

{{ reply.reply_content }}

{{ formatTime(reply.reply_in_dtm) }}

{{ reply.reply_likes_count }} {{ reply.reply_likes_count }} {{ reply.reply_reply_count }} {{reply.reply_in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Cancel

That’s all the comments so far!

Write a review
How would you rate this item?

Please add your comment.

  • A nice nickname will make your comments more popular!
  • The nickname in your account will be changed to the same as here.
Thanks for your review
Our community rely on great reviews like yours to find the best of Asia.

Report

If you find this content inappropriate and think it should be removed from the Yami.com site, let us know please.

Cancel

Are you sure to delete your review?

Cancel

You’ve Recently Viewed

About the brand

Jingdong book