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函数、图表与透视表从入门到精通（修订版）（附光盘1张）

View Cart & Check Out

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

Books Computers & Internet Office Software

Jingdong book

Excel函数、图表与透视表从入门到精通（修订版）（附光盘1张）

Name: Excel函数、图表与透视表从入门到精通（修订版）（附光盘1张）
Brand: Jingdong book
SKU: 3118197591
Price: 46.56 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

全面：函数、图表与透视表的基础理论
丰富：通过300个案例展示精彩应用
实战：提供1 00个题目，提升实战技能
视频：提供教学视频，现场指导学习
售后：搭配售后服务QQ群与售后论坛
《Excel函数、图表与透视表从入门到精通（修订版）》内容包括Excel函数、图表与透视表相关的理论与实战案例。
为了让读者可以更快地掌握函数、图表与透视表的操作，《Excel函数、图表与透视表从入门到精通（修订版）》的配套光盘中除了赠送读者Excel百宝箱无限制版和大量模板外，还提供大量动画教材，涉及40多个常用函数的语法与应用思路，以及图表与透视表的案例应用。
动画位于随书光盘的“视频教材”文件夹中，双击其中的index.htm文件即可打开主页，然后单击左边的菜单按钮，在右边的主窗口中将显示相应的动画教材。

Content Description

《Excel函数、图表与透视表从入门到精通（修订版）》是《Excel函数、图表与透视表从入门到精通》的升级版，对正文内容做了部分修改，同时增加了10集动画教材，以及诸多Excel常用模板文件，并收录于光盘中。
《Excel函数、图表与透视表从入门到精通（修订版）》是针对Excel入门级用户编著的用于数据运算、整理和分析的制表秘籍，挑选了与数据分析相关的三大组件作为《Excel函数、图表与透视表从入门到精通（修订版）》重点教学内容。书中基本理论和与理论相关的案例各占50%篇幅，通过理论与实践的结合促进读者的应用能力。
《Excel函数、图表与透视表从入门到精通（修订版）》在数据处理的三大教学内容以外结合300个案例和100个课后练习强化读者对函数、图表和透视表的熟练度，在随书光盘中也同步提供所有案例原件和问题答案，帮助读者更好地学习《Excel函数、图表与透视表从入门到精通（修订版）》内容，作者也期望读者通过《Excel函数、图表与透视表从入门到精通（修订版）》可以提升在职场中的竞争力。
《Excel函数、图表与透视表从入门到精通（修订版）》提供完善的售后服务，包括售后服务论坛、售后服务QQ群，以及诸多赠品，包括40多个动画教材和Excel百宝箱的正版安装软件（价值50元，在淘宝店出售），读者可以从随书光盘中免费获得使用权。

Catalogue

第1篇入门及函数篇
第1章 Excel入门
1.1 熟悉Excel界面
1.1.1 Excel界面浏览
1.1.2 新界面的优势
1.1.3 多功能的状态栏
1.1.4 自定义用户界面
1.2 Excel功能区简介
1.2.1 功能区的功能分布
1.2.2 调用上下文选项卡
1.3 调用快捷键
1.3.1 万能的功能键（Alt）
1.3.2 调用旧版菜单键
1.3.3 自定义快捷键
1.4 设置Excel选项
1.4.1 Excel选项功能介绍
1.4.2 详解公式选项
1.5 及时调用帮助
1.5.1 调用函数帮助的4种方式
1.5.2 Excel帮助的缺点
第2章初识公式
2.1 公式的概念与结构
2.1.1 何谓公式
2.1.2 公式的结构
2.2 公式的优缺点
2.2.1 公式的应用前景
2.2.2 公式的计算速度
2.2.3 公式的3个缺点
2.2.4 用VBA扩展内部公式的功能
2.3 录入与编辑公式
2.3.1 如何录入公式
2.3.2 公式与文本的两种转换方式
2.3.3 修改公式
2.4 认识引用
2.4.1 如何引用单元格
2.4.2 跨表引用技巧
2.4.3 相对引用、绝对引用与混合引用
2.4.4 将引用转换成值
2.4.5 区分引用与文本
2.5 认识运算符与优先级
2.5.1 Excel公式所支持的运算符
2.5.2 Excel公式所支持的数学符号
2.5.3 了解运算优先级
2.6 复制公式
2.6.1 复制公式的必要性
2.6.2 复制公式的多种技巧
2.7 定位公式
2.7.1 选择所有公式
2.7.2 隐藏所有公式
2.7.3 删除所有值为错误的公式
2.8 公式的错误类型
2.8.1 公式错误的种类
2.8.2 #DIV／0！错误
2.8.3 #N／A错误
2.8.4 #NAME？错误
2.8.5 #NUM！错误
2.8.6 #VALUE！错误
2.8.7 #REF！错误
2.8.8 检查错误
2.9 公式求值
2.10 迭代计算
2.10.1 何谓迭代计算
2.10.2 迭代计算的应用：累加
2.10.3 迭代计算的应用：自动添加不更新的时间
2.10.4 迭代计算的应用：解方程
第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.3 函数的参数
3.3.1 参数的作用
3.3.2 参数的类型
3.3.3 参数嵌套
3.3.4 选择参数的技巧
3.3.5 省略参数与省略参数的值
3.4 函数的录入方式
3.4.1 使用函数库
3.4.2 使用插入函数向导
3.4.3 直接录入
3.5 函数运算中的空单元格与空文本
3.6 函数与公式的限制
3.6.1 数字计算精度
3.6.2 日期与时间计算精度
3.6.3 浮点运算偏差
3.6.4 公式长度限制
3.6.5 参数个数限制
3.6.6 参数的类型限制
3.6.7 IF函数嵌套限制
3.6.8 功能限制及例外项
第4章数学运算
4.1 求和运算
4.1.1 SUM求和
4.1.2 SUMIF条件求和
4.1.3 SUMIFS多条件求和
4.1.4 SUMPRODUCT乘积之和
4.1.5 SUMSQ求平方和
4.2 求积运算
4.2.1 PRODUCT求积
4.2.2 MMULT两数组的矩阵积
4.3 商与余数
4.3.1 QUOTIENT求商
4.3.2 MOD求余数
4.4 随机数
4.4.1 RAND随机小数
4.4.2 RANDBETWEEN随机整数
4.5 乘方与开方
4.5.1 SQRT开平方
4.5.2 POWER乘方
4.6 数据的舍入问题
4.6.1 ODD／EVEN取奇数与偶数
4.6.2 TRUNC／INT截取为指定位数小数或整数
4.6.3 CEILING向上舍入为最接近基数的倍数
4.6.4 FLOOR向下舍入为最接近基数的倍数
4.6.5 ROUND四舍五入
4.6.6 ROUNDDOWN向下舍入
4.7 分类汇总
第5章逻辑运算
5.1 真假值运算
5.1.1 TRUE／FALSE真假运算
5.1.2 AND／OR判断是否符合条件
5.1.3 NOT逻辑值求反
5.2 条件判断
5.2.1 IF条件判断
5.2.2 IFERROR防错函数
第6章文本处理
……
第2篇图表篇
第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

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 + ')'}}