{{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 2010从入门到精通

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

新编Excel 2010从入门到精通

{{__(":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 2010从入门到精通》以零基础讲解为宗旨,用实例引导读者学习,深入浅出地介绍了Excel 2010的相关知识和应用方法。
《新编Excel 2010从入门到精通》分为7篇,共26章。第1篇【基础知识篇】主要介绍了Excel 2010的基础知识,工作簿、工作表和单元格的基本操作,查看与打印工作表的基本方法,以及如何输入和编辑数据等;第2篇【美化装饰篇】主要介绍了工作表的格式化,以及图表和对象的应用等;第3篇【公式和函数篇】主要介绍了Excel 2010的公式应用基础、函数、数组公式以及公式审核等;第4篇【数据分析篇】主要介绍了数据的分析方法,包括数据的排序和筛选、条件格式、数据有效性验证、分类汇总和合并运算、数据透视表和数据透视图等;第5篇【宏与VBA篇】主要介绍了宏与VBA的基础知识及VBA的应用等;第6篇【实战篇】主要介绍了Excel在财务管理、人力资源管理、行政管理及市场营销中的应用等;第7篇【高手秘技篇】总结了Excel高手常用的高效操作技巧,供读者巩固提高。
在《新编Excel 2010从入门到精通》附赠的DVD多媒体教学光盘中,包含了16小时与图书内容同步的教学录像,以及所有案例的配套素材和结果文件。此外,还赠送了大量相关内容的教学录像和电子书,便于读者扩展学习。
《新编Excel 2010从入门到精通》不仅适合Excel 2010的初、中级用户学习使用,也可以作为各类院校相关专业学生和电脑培训班学员的教材或辅导用书。

Author Description

龙马高新教育,专业的计算机研究、教育机构,拥有近20年的图书出版经历,与39所高校、8个行业协会、5家知名网站保持合作关系,屡获全国优秀畅销书大奖,其推出的“从入门到精通”、“完全自学手册”、 “编程宝典”、“完全自学手册”、“精通100%”、“非常网络6+1”等均成为业界知名图书品牌,受到百万读者的认可和推荐。

Catalogue

第1篇基础知识篇
第1章Excel 2010入门 2
1.1认识Excel 3
1.2Excel 2010的新特性 3
1.2.1从Excel 2003向Excel 2010过渡 3
1.2.2从Excel 2007向Excel 2010过渡 4
1.3Excel 2010的安装与卸载 4
1.3.1电脑配置要求 4
1.3.2安装Excel 2010 5
1.3.3卸载Excel 2010 5
1.4Excel 2010的启动与退出 7
1.4.1使用Windows【开始】菜单 7
1.4.2创建桌面快捷方式 7
1.4.3在任务栏中启动 8
1.4.4退出Excel 8
1.5Excel 2010的操作界面 8
1.6自定义操作界面 10
1.6.1自定义快速访问工具栏 10
1.6.2最小化功能区 11
1.6.3自定义功能区 11
1.6.4自定义状态栏 12
1.7综合实战—使用帮助系统 13
修复损坏的Excel 2010工作簿 14
将自定义的操作界面快速转移到其他计算机中 14
第2章工作簿和工作表 15
2.1认识工作簿和工作表 16
2.2新建工作簿 16
2.2.1创建空白工作簿 16
2.2.2基于现有工作簿创建工作簿 17
2.2.3使用模板创建工作簿 18
2.2.4设置工作簿的信息 18
2.3保存工作簿 19
2.3.1保存新建工作簿 19
2.3.2另存工作簿 20
2.3.3另存为其他兼容格式 20
2.4工作簿的基本操作 21
2.4.1打开工作簿 21
2.4.2关闭工作簿 22
2.4.3工作簿的复制和移动 22
2.5工作表的基本操作 23
2.5.1新建工作表 23
2.5.2插入工作表 24
2.5.3删除工作表 25
2.5.4选择单个或多个工作表 25
2.5.5重命名工作表 26
2.5.6移动或复制工作表 27
2.5.7显示和隐藏工作表 28
2.5.8设置工作表标签颜色 29
2.5.9保护工作表 30
2.6综合实战—创建销售报表 30
删除最近使用过的工作簿记录 32
当工作表很多时如何快速切换 32
第3章单元格、行与列的操作 33
3.1单元格的基本操作 34
3.1.1选择单元格 34
3.1.2插入与删除单元格 35
3.1.3合并与拆分单元格 36
3.1.4清除单元格 37
3.2行和列的基本操作 37
3.2.1选择行与列 37
3.2.2插入行与列 38
3.2.3删除行与列 38
3.2.4移动或复制行与列 39
3.2.5隐藏行与列 40
3.2.6显示隐藏的行与列 41
3.3设置行高与列宽 41
3.3.1 手动调整行高与列宽 41
3.3.2 自动调整行高与列宽 42
3.3.3 将行高与列宽设置为固定数值 43
3.4复制和移动单元格区域 43
3.4.1 利用鼠标复制与移动单元格区域 43
3.4.2 利用剪贴板复制与移动单元格区域 44
3.4.3用插入方式复制单元格区域 44
3.5综合实战—修改员工信息表 45
在Excel中快速移动行或列 46
使用复制格式法调整行高或列宽 46
第4章查看与打印工作表 47
4.1视图查看方式 48
4.1.1普通查看 48
4.1.2页面布局 48
4.1.3分页预览 49
4.2设置工作表的显示比例 49
4.3窗口的基本操作 50
4.3.1切换窗口 50
4.3.2新建和重排窗口 50
4.3.3冻结窗口 51
4.3.4拆分窗口 52
4.3.5隐藏窗口 53
4.4添加打印机 53
4.4.1添加本地打印机 53
4.4.2添加网络打印机 54
4.5设置打印页面 56
4.5.1页面设置 56
4.5.2设置页边距 57
4.5.3设置页眉和页脚 57
4.5.4设置打印区域 59
4.6打印工作表 60
4.6.1打印预览 60
4.6.2打印当前工作表 61
4.6.3仅打印指定区域 61
4.7 综合实战1—在同一页上打印不连续的区域 62
4.8综合实战2—打印2014年公司销售报表 63
打印网格线 64
打印行号、列标 64
第5章输入和编辑数据 65
5.1 输入数据 66
5.1.1输入文本 66
5.1.2输入数值 66
5.1.3输入日期和时间 67
5.1.4快速输入身份证号码 68
5.1.5输入特殊符号 69
5.1.6导入外部数据 69
5.1.7输入以“0”开头的数字 70
5.1.8输入带有货币符号的金额 70
5.2 认识单元格的数据类型 71
5.2.1常规格式 71
5.2.2数值格式 71
5.2.3货币格式 72
5.2.4会计专用格式 72
5.2.5日期和时间格式 73
5.2.6百分比格式 74
5.2.7分数格式 75
5.2.8文本格式 75
5.2.9特殊格式 76
5.2.10自定义格式 76
5.3 快速填充 77
5.3.1填充相同的数据 77
5.3.2填充有序的数据 77
5.3.3多个单元格的数据填充 77
5.3.4自定义序列填充 78
5.3.5同时填充多个工作表 79
5.4 编辑数据 79
5.4.1修改数据 79
5.4.2移动/复制单元格数据 80
5.4.3粘贴单元格数据 81
5.4.4查找与替换数据 81
5.4.5撤销与恢复数据 82
5.4.6清除数据 83
10.5综合实战—制作家庭账本 83
快速输入等差序列 84
快捷键在数据填充中的应用 84
第2篇美化装饰篇
第6章工作表的格式化 86
6.1设置单元格对齐方式 87
6.1.1对齐方式 87
6.1.2自动换行 88
6.1.3设置文本方向 88
6.2设置字体 89
6.2.1设置字体和字号 89
6.2.2设置字体颜色 91
6.3设置背景颜色和图案 91
6.3.1设置单元格的背景颜色 91
6.3.2设置工作表的背景图案 93
6.4使用艺术字 93
6.4.1添加艺术字 93
6.4.2设置艺术字格式 94
6.5设置边框 95
6.5.1使用功能区设置边框 95
6.5.2使用对话框设置边框 96
6.5.3设置边框线型 96
6.5.4删除边框 97
6.6快速设置表格样式 97
6.6.1套用浅色样式美化表格 97
6.6.2套用中等深浅样式美化表格 98
6.6.3套用深色样式美化表格 99
6.7套用单元格样式 99
6.7.1套用单元格文本样式 99
6.7.2套用单元格背景样式 100
6.7.3套用单元格标题样式 100
6.7.4套用单元格数字样式 101
6.8使用主题 101
6.8.1选择工作表主题 101
6.8.2新建主题颜色 102
6.8.3新建主题字体 102
6.8.4自定义主题效果 103
6.9综合实战—美化员工工资表 103
安装更多字体 104
快速应用单元格数字格式 104
第7章图表的应用 105
7.1图表的特点及使用分析 106
7.2图表的构成元素 108
7.3创建图表的方法 109
7.3.1使用快捷键创建图表 110
7.3.2使用功能区创建图表 110
7.3.3使用图表向导创建图表 110
7.4创建图表 111
7.4.1柱形图—强调特定时间段内的差异变化 111
7.4.2折线图—描绘连续的数据 111
7.4.3饼图—善于表现数据构成 112
7.4.4条形图—强调各个数据项之间的差别情况 113
7.4.5面积图—说明部分和整体的关系 113
7.4.6散点图—显示两个变量之间的关系 114
7.4.7股价图—描绘股票价格的走势 114
7.4.8曲面图—在曲面上显示两个或更多个数据系列 115
7.4.9圆环图—显示部分与整体的关系 115
7.4.10气泡图—显示三个变量之间的关系 116
7.4.11雷达图—用于多指标体系的比较分析 116
7.5编辑图表 117
7.5.1在图表中插入对象 117
7.5.2更改图表的类型 118
7.5.3在图表中添加数据 118
7.5.4调整图表的大小 119
7.5.5移动和复制图表 120
7.5.6设置和隐藏网格线 120
7.5.7显示与隐藏图表 121
7.6美化图表 122
7.6.1使用图表样式 122
7.6.2设置图表布局 122
7.6.3设置艺术字样式 123
7.6.4设置填充效果 123
7.6.5设置边框效果 124
7.7迷你图的基本操作 124
7.7.1创建迷你图 125
7.7.2编辑迷你图 125
7.7.3

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