Trending on TikTok

Buldak

Sunscreen

Sanrio

English

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

View Cart & Check Out

Nickname

Let us know how to properly address you.

Update Your Name

xxxxxxx@yamibuy.com

Account Orders Favorites

Points 0

Coupons 0

Gift Card Balance $0.00

Sign Out

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

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

Your email: {{remindEmail}}

Cancel

Jingdong book

Excel 2013表格、公式、函数与图表应用傻瓜书（附光盘）

View Cart & Check Out

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

Books Computers & Internet Office Software

Jingdong book

Excel 2013表格、公式、函数与图表应用傻瓜书（附光盘）

Name: Excel 2013表格、公式、函数与图表应用傻瓜书（附光盘）
Brand: Jingdong book
SKU: 3118048981
Price: 43.11 USD
Availability: OutOfStock

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}

Ends in

{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}

{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}

Sale ends in

Sale will starts after Sale ends in

{{ __( "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

Editer Recommend

零点起步循序渐进：真正为初学者量身定做的入门书，步步为营
系统全面超值实用：囊括初学者需要掌握的必备知识，丰富全面
全程图解快速上手：全程采用图解互动讲解的新模式，直观易学
注重方法高效学习：电脑教育专家多年的总结与心得，重在方法
版式新颖赏心悦目：采用精美双栏新版式与单色印刷，超大容量
视频光盘即学即会：提供全程教学精彩视频素材文件，超值方便
精选丰富实用案例，现场视频演示
额外免费赠送《外行学电脑傻瓜书》《Photoshop图像处理傻瓜书》视频教程
一书多用，超大容量，物超所值

Content Description

《Excel 2013表格、公式、函数与图表应用傻瓜书》以零基础讲解为宗旨，用实例引导读者学习，深入浅出地介绍了Excel 2013表格制作、公式、函数与图表应用的方法与技巧。本书知识系统全面、实例教学丰富、步骤详尽清晰、视频演示直观，使读者学起来轻松，做起来有趣，在实践操作中不断提高自身水平，完成从新手到高手的飞跃。本书共分为12章，其中包括Excel 2013轻松入门、输入与编辑Excel表格数据、工作表格式设置与美化、使用公式快速计算、使用函数高效办公、创建与编辑图表、Excel数据管理与分析、数据透视表与数据透视图、宏与VBA应用、创建链接与引用、工作表打印与输出、Excel数据安全与保护等。
本书讲解详细，注重实用，适用于各级别的Excel使用者阅读，同时也可作为大中专院校以及社会各类培训班的首选教材，对有一定经验的Excel使用者来说也有很高的参考价值。

Catalogue

01Excel 2013轻松入门
1.1 Excel 2013的工作界面
1.2 Excel 2013工作簿的基础操作
1.2.1 新建工作簿
1.2.2 保存工作簿
1.2.3 打开工作簿
1.2.4 关闭工作簿
1.2.5 隐藏工作簿
1.3 工作簿的多窗口显示
1.3.1 创建新窗口
1.3.2 切换窗口
1.3.3 全部重排
1.3.4 视图缩放
1.4 Excel 2013工作环境的设置
1.4.1 显示与隐藏网格线
1.4.2 显示与隐藏标尺
1.4.3 设置自动保存时间间隔
1.4.4 设置文档的默认保存路径
1.4.5 设置文档的默认保存类型
1.4.6 隐藏与显示功能区
1.5 共享工作簿
1.5.1 创建共享工作簿
1.5.2 修订共享工作簿
1.5.3 接受/拒绝修订工作簿
02输入与编辑Excel表格数据
2.1 Excel单元格数据编辑
2.1.1 选择单元格
2.1.2 插入单元格
2.1.3 删除单元格
2.1.4 清除单元格
2.1.5 命名单元格
2.1.6 移动单元格数据
2.1.7 复制单元格数据
2.1.8 合并多个单元格
2.1.9 取消单元格合并
2.2 手动输入数据
2.2.1 输入文本型数据
2.2.2 将数字转化为文本
2.2.3 输入日期或时间
2.2.4 输入货币型数据
2.2.5 快速填充相同数据
2.3 填充数据
2.3.1 设置记忆式输入
2.3.2 使用填充柄自动填充数据
2.3.3 使用"填充"命令填充数据
2.3.4 文本序列填充
2.3.5 自定义填充序列
2.4 编辑数据
2.4.1 修改数据
2.4.2 选择性粘贴
2.4.3 撤销和恢复数据
2.4.4 查找和替换数据
03工作表格式设置与美化
3.1 设置单元格格式
3.1.1 设置字体格式
3.1.2 设置数字格式
3.1.3 使用格式刷
3.2 设置对齐方式
3.2.1 设置水平和垂直对齐方式
3.2.2 设置旋转文本
3.3 格式化单元格
3.3.1 调整行高和列宽
3.3.2 设置单元格边框
3.3.3 设置单元格背景色和图案
3.3.4 设置工作表的背景图
3.4 文字拼音
3.4.1 添加拼音
3.4.2 显示和隐藏拼音
3.4.3 编辑拼音字段
3.4.4 设置拼音格式
3.5 套用表格样式
3.5.1 应用表样式
3.5.2 自定义表格样式
3.6 使用单元格样式
3.6.1 应用单元格样式
3.6.2 创建新样式
3.6.3 修改样式
3.6.4 删除样式
3.7 使用条件格式
3.7.1 设置三色条件格式
3.7.2 使用数据条格式
3.7.3 更改条件格式
3.7.4 删除条件格式
04 使用公式快速计算
4.1 关于公式
4.1.1 公式的结构
4.1.2 运算符
4.1.3 运算符优先级
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.4 审核公式
4.4.1 检查错误
4.4.2 追踪引用单元格
4.4.3 追踪从属单元格
4.4.4 移去箭头
4.5 单元格的引用
4.5.1 相对引用
4.5.2 绝对引用
4.5.3 混合引用
05 使用函数高效办公
5.1 函数简介
5.1.1 认识函数
5.1.2 函数分类
5.2 函数的输入和编辑
5.2.1 输入函数
5.2.2 复制函数
5.3 统计函数
5.3.1 AVERAGE 函数
5.3.2 MAX 函数
5.3.3 COUNTA函数
5.3.4 COUNT函数
5.4 文本函数
5.4.1 EXACT函数
5.4.2 LOWER 与UPPER 函数
5.4.3 CONCATENATE 函数
5.4.4 REPT 函数
5.4.5 SUBSTITUTE函数
5.5 数学与三角函数
5.5.1 ABS 函数
5.5.2 INT 函数
5.5.3 ODD 与EVEN函数
5.5.4 SUM 函数
5.5.5 DEGREES函数
5.6 逻辑函数
5.6.1 AND 函数
5.6.2 OR 函数
5.6.3 NOT 函数
5.6.4 IF 函数
5.7 财务函数
5.7.1 折旧计算函数
5.7.2 本利计算函数
5.7.3 报酬计算函数

Introduction

内容导读
本书对Excel表格数据编辑、工作表格式设置与美化、数据计算与处理、图表创建与编辑、数据管理与分析、Excel高级应用等方面进行了详细的讲解与剖析。本书的知识系
统全面、实例教学丰富、步骤详尽清晰、视频演示直观，从而使读者学起来轻松，做起来有趣，在实践操作中不断提高自身水平，完成从新手到高手的飞跃。
光盘特色
随书附赠配套情景交互式、12小时超长播放的多媒体视听教学光盘，情景教学、互动学习，既是与图书完美结合的视听课堂，又是一套具备完整教学功能的学习软件，直观、
便利、实用。
光盘中提供了全书实例涉及的所有素材文件，方便读者上机练习实践，达到即学即用、举一反三的学习效果。
同时还赠送了由中国铁道出版社出版的《外行学电脑傻瓜书》和《Photoshop图像处理傻瓜书》的多媒体光盘视频，一盘多用，超大容量，物超所值。
适用人群
本书主要面向初学者，起点低，适用面广，具体适合以下读者群体学习阅读：
1、希望尽快掌握Excel操作技能的初级者；
2、有一定基础但需要提高Excel操作技能的读者；
3、各行各业需要学习Excel的办公人员和从业人员；
4、大、中专应届毕业生和从事电脑基础操作的求职人员；
5、对电脑感兴趣的各类读者。
售后服务
如果读者在使用本书的过程中遇到什么问题或者有什么好的意见或建议，可以通过电子邮件（E-mail：jtbooks@126。com）或者QQ：843688388联系我们，我们将及时予以回
复，并尽最大努力提供学习上的指导与帮助。
希望本书能大大提高广大读者朋友的学习和工作效率，由于编者水平有限，书中可能存在不足之处，欢迎读者朋友提出宝贵意见，我们将加以改进，在此深表谢意！
编者
2014年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

Scan to Share

Add to favorites

{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}

Clip coupons

Quantity

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

Sold by JD@CHINA

Ship to

Free shipping over 69

Genuine guarantee

View details

Region

Added to Cart

Keep Shopping

More to Consider

Coupons

Clip Clipped Over

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

Free Shipping over $49

Easy Returns

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;

Return Policy

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

Sold by JD@CHINA

Fulfilled by Yami

Service Guarantee

Free Shipping over $49

Easy Returns

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

Yami-China FC

Service Guarantee

Cross-store Free Shipping over $69

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

Download the Yami App

Feedback

Back Top

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

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

Write a review

{{i}} star

{{i}} stars

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

{{ showTranslate(comment) }}Show Less

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

Show Original

Show All

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

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

{{ showTranslate(comment) }}Show Less

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

Show Original

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~

Load more reviews

Review

{{ showTranslate(commentDetails) }}Show Less

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

Show Original

Show All

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

Please write at least one word

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