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效率手册：早做完，不加班（精华版透视表篇）

View Cart & Check Out

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

Books Computers & Internet Office Software

Jingdong book

Excel效率手册：早做完，不加班（精华版透视表篇）

Name: Excel效率手册：早做完，不加班（精华版 透视表篇）
Brand: Jingdong book
SKU: 3118019121
Price: 23.98 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

《Excel效率手册早做完，不加班（精华版透视表篇）》继承了《Excel效率手册早做完，不加班》以及《Excel效率手册早做完，不加班（精华版函数篇）》的精华内容以及幽默风格，轻松为您讲解Excel表格使用中的简单快捷方法，让工作更快捷，更省时。让你早做完，不加班！

Content Description

《Excel效率手册：早做完，不加班（精华版透视表篇）》是一本有趣的Excel书籍，基于卢子的职场经历改编而成。通过讲故事的形式讲解Excel中的数据透视表，让读者在轻松、愉快的环境中学到各种技能。
《Excel效率手册：早做完，不加班（精华版透视表篇）》为读者展示了在Excel2013中运用数据透视表解决疑难问题的实战技能，包含数据透视表的基础理论及操作技能、数据透视表与SQL结合的实际应用。
《Excel效率手册：早做完，不加班（精华版透视表篇）》能有效地帮助职场新人提升职场竞争力，也能帮助财务、品质分析、人力资源管理等人员解决实际问题。

Author Description

陈锡卢，网名卢子。IT部落窝论坛Excel版主。在日企从事品质分析工作5年，精通Excel函数与公式跟数据透视表，经常在论坛、QQ交流群帮助别人解答疑惑，具有丰富的实战经验。备受好评的《Excel效率手册早做完，不加班》作者。

Comments

★作为中国会计视野论坛的管理员，我和卢子版主有很多接触。他一直为网友们解答各种Excel的问题，无论是低级的还是复杂的，都孜孜不倦地答疑解惑。同时他也是一个乐于分享的人。本书中的很多内容来自论坛数万点击量的精华帖改编而成，随着故事的讲述让大家由浅入深地学习到Excel的各种功能，非常有趣，值得一读。
——胡晓栋上海国家会计学院中国会计视野论坛管理员

★“学会计，有方法”一直以来都是会计网的建站宗旨，会计越学越活，方法越用越新。作为一名会计财务人员，熟练掌握实用的Excel技巧，将大大提升工作效率。卢子的这本书，深入浅出地讲解了Excel的各种技巧，图文并茂，如同真人现身说教，颇有特色。书中很多案例都来自卢子与同事的互动，让人边看边学，很有参与感。更难得的是，卢子非常系统地为每一章都做了小结，有方法论的、有学习感悟的，都是实战技巧。认真看、经常用，你就能够发现一个简单、有趣的Excel世界。
——李海明会计网联合创始人

★率非常高，也是Excel非常强大的一个分支，因此每个Excel用户都应很好地掌握它。本书的前一个版本《Excel效率手册早做完，不加班》已获得巨大成功。如果你已看过《Excel效率手册早做完，不加班》，再看本书时，你获取到的Excel知识会更加系统和连贯。本书依然延续了前一个版本的文风，采用“引入情景案例→提出解决方案→涉及Excel关键知识点剖析讲解→完整操作步骤→扩展知识点讲述”的方法讲解Excel中的战斗机——数据透视表。
——杨阳 IT部落窝创办者

Catalogue

01 对帐风波
1.1 告别手工账
1.2 传统思维惹的祸
1.3 小结与练习

02 Excel"替规则"
2.1 学做表
2.2 模仿数据库
2.3 规范数据源的好处
2.4 小结与练习

03 数据透视表登场
3.1 多变的要求
3.2 聊聊数据透视表
3.2.1 什么是数据透视表
3.2.2 多角度分析数据
3.3 小结与练习

04 数据透视表行业运用
4.1 初识数据透视表
4.2 品质分析
4.2.1 认识全新的Excel 2013
4.2.2 更改数据透视表布局
4.2.3 更改字段名
4.2.4 改变数字的格式
4.2.5 刷新数据透视表
4.2.6 更改值的汇总依据
4.2.7 3种常用百分比
4.3 销售分析
4.3.1 对销售额进行排名
4.3.2 筛选销售额最多的8款产品
4.3.3 LO系列产品的销售数量
4.3.4 对销售数量划分等级
4.3.5 统计每月销售情况
4.3.6 动态数据源
4.3.7 找回遗失的数据透视表和数据透视图向导
4.3.8 多重合并计算数据区域妙用
4.3.9 数据安全
4.4 经典案例分析
4.4.1 根据金额的正负，统计收支情况
4.4.2 按周统计销售数量
4.4.3 多行多列提取不重复并汇总数量
4.4.4 一个职业一个表格
4.4.5 在每个项目后面插入分页符
4.4.6 数据透视表之再透视
4.4.7 每天不重复人数
4.4.8 让筛选更加有魔法的切片器
4.4.9 一眼识别数据变化的日程表
4.5 小结与练习

05 锦上添花的SQL
5.1 从实例一步步带你走进select的世界
5.1.1 什么是SQL
5.1.2 与SQL有关的故事
5.1.3 认识SQL的储存地
5.1.4 输入第一条语句
5.1.5 执行各种筛选
5.1.6 获取不重复番号
5.1.7 认识常用的SQL函数
5.2 让数据透视表更强大
5.2.1 辅助列的取代法
5.2.2 SQL魅力的体现
5.2.3 了结当初之憾
5.2.4 SQL其实也能玩
5.3 小结与练习

06 职场价值的体现
6.1 快速准确地提供数据
6.1.1 客户7月份销售额统计
6.1.2 中秋节销量预测
6.1.3 安排生产
6.1.4 购进物料
6.1.5 资金安排
6.1.6 报告撰写
6.2 让分析更直观
6.2.1 主要销售客户
6.2.2 主要销售地区
6.2.3 主要销售产品
6.3 小结与练习
附录数据透视表Q/A汇集

Introduction

本人在2011—2013年期间总结了很多数据透视表和SQL精华帖，如“Excel 2010数据透视表完全剖析”、“从实例带你一步步走进select的世界”等，深受网友好评，很多人建议我将所有精华帖总结成书出版，方便阅读。不过我一再推脱，没想到一推就是好几年。2014年4月，我的新书《Excel效率手册早做完，不加班》出版，没想到短短几个月就重印好几次。很多粉丝纷纷要求我一定要写数据透视表精华篇，我已不能再找理由推脱了。第一本书比我想象中更受欢迎，但里面有的内容写得并不够完美。对于处女座的我而言，追求完美这一特性永不变。这也是我想尽快完成一本数据透视表书籍的原因，我想尽自己最大的努力，让所有读者都能够学好数据透视表，并提高工作效率，告别加班。
本书共分为6章，以卢子为主角，通过讲述他跟各种各样职场人员的对话与8小时外的自学，来了解Excel的战斗机——数据透视表，从而提高工作效率。对效率的追求和表述，将贯穿全书。有时卢子会直接说出来，有时则通过前后对比来展现。主要内容可分为以下三大部分。
（1）第1～3章通过写卢子帮助财务小丁的事儿，了解不规范制作表格会给后期的数据处理带来极大的麻烦，接着讲解如何制作表格才能给后期带来便利，最后简单了解数据透视表的作用。通过这些知识，来塑造一个高手的形象。
（2）第4～5章通过写卢子当初是如何学习数据透视表与SQL语句（这两章是本书的重点）来讲解常用的技能，对数据透视表的应用也会更加得心应手。
（3）第6章通过写卢子借助数据透视表给领导快速准确提供数据和给客户提供直观的图表，从而体现本身的价值。
网络上流传着这么一句话：Excel虐我千百遍，我待你如初恋，你如同我心中另一个世界，用我的真心跟你谈一场天长地久的恋爱。虽然Excel不是我的恋人，但7年来与Excel朝夕相处，不是恋人胜似恋人。
这是一场注定相恋终身的恋情。Excel给了我现在的工作，让我结识了很多人，让我感受到生活的美好和人与人之间的温情。我有一种萌动，需要将这几年我所感觉到的、获得的快乐分享给更多人。唯有如此，才能表达我心中的喜悦，才能表达我对Excel以及所有曾帮助过我的人的热爱和感激。
在这里，我最想说的是学习方法，这是感受温情和爱的学习方法。刚开始学习时，要善于向身边的同事及朋友请教问题。同时也要学会自觉学习，毕竟没有人可以帮助你一辈子。学到新知识要及时跟同事、朋友、网友分享，这样你将会获得别人的好感，以后别人有好的方法也会告诉你。拥有6个苹果，如果拿5个分给别人，将会从他人那里得到5种不同口味的水果，如果不分享你只能有一种水果。当学习到了一定程度时，要善于抓住机会在领导面前展现自己的技能，你不表现自己，学得再多又有何用？并不是每个领导都是伯乐，不善于表现自己，能力越强你会越痛苦。除了工作上，你还可以将Excel当成游戏，自从学了她以后，我就很少玩游戏，她成了我的游戏。当然也可以用在生活上，从2009年开始我就拿她来记账，有一个表格用了3年还在继续使用，用久了也是有感情的。学Excel不是以炫耀技能为目的，要以合适的方法做合适的事。无招胜有招，这才是Excel的最高境界。
最后我想直接说出我的感谢。感谢Excel，我的恋人。感谢好友无言的人对我技术上的支持，让我的Excel能够锦上添花。感谢Excel Home站长周庆麟，是他的帮助让我获得了学习Excel的快乐。感谢中国会计视野论坛、IT部落窝所有的Excel网友，是你们让我感受到分享的快乐。还要感谢您，拿起这本书的读者——是您的阅读，将我对Excel的爱传向广阔的世界。
另外，还得感谢以下参与本书编写的人员：龚思兰、孙华平、林丰钿、卞贺永、邱晓燕、邱显标、邓丹、李应钦、周佩文、鄢启明、魏才玉、许罡、柯建华、李江、王成军、张红兰、张友东、徐七阶、李春平。
编者

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

Change Your Zip Code

Location History

Excel效率手册：早做完，不加班（精华版 透视表篇）

Excel效率手册：早做完，不加班（精华版透视表篇）