{{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行政、文秘与人力资源一招制胜

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

凭什么你可以不加班 Excel行政、文秘与人力资源一招制胜

{{__(":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行政、文秘与人力资源一招制胜》是以Excel2013为载体,以实际应用为导向,站在企业的角度为广大行政与人力资源工作者专门设计的【理论+思维+操作】的综合性书籍,适合有一定Excel操作基础的人阅读,是一本提高行业技术知识的宝典。本书分为两个部分第一部分是行政管理模块的内容,包括日常办公事务处理,行政人事管理,客户数据管理,日常费用管理,以及文件打印输出管理。本书的第二部门就是人力资源管理模块,包括人员规划与管理,人员招聘与培训,员工值班与休假,员工业绩分析,员工的薪资进行的各种计算和管理,以及最后的成本分析。
Catalogue

前言
如何获取云空间资料
\第1章日常办公事务处理
1.1开机自动提醒工作计划/2
1.2办公用品采购前的准备/5
1.3防止他人修改你的表,8
1.4共享还有这个作用/11
1.5轻而易举获取外部数据/1 5
1.6让文件管理更有序/18
\第2章行政人事管理
2.1 自动获取员工出生信息/22
2.2快速输入人事资料,27
2.3 员工合同期限提示/31
2.4员工生日按天提醒/35
2.5员工加班数据轻松统计/38
\第3章客户数据管理
3.1 增减客户记录让序号自动变/42
3.2客户信息漏填了怎么办,46
3.3客户数据增减一目了然/49
3.4 自动筛选大客户数据/53
3.5 自定义关键词排列客户数据/58
\第4章日常费用管理
4.1 按月汇总多个工作表费用/63
4.2 多张工作簿中的费用类别汇总/66
4.3根据月开支汇总季度费用/70
4.4用小图分析费用趋势/73
4.5根据费用类别自动输入费用明细/77
4.6采购记录简易预算/81
\第5章文件打印输出管理
5.1 打印前的下画线怎么设置/86
5.2强制性分页打印/89
5.3打印时多页显示标题/93
5.4在表格顶部显示公司重要信息/96
5.5特殊技能显示水印/99
5.6在打印的表格中显示带圈标记/1 03
\第6章人员规划与管理
6.1 轻松掌握公司人员结构,1 09
6.2人力资源需求预测/1 1 3
6.3人员离职率分析/1 1 7
6.4从打卡机上做考勤/1 21
6.5公司KPI绩效设定与计算/1 25
\第7章人员招聘与培训
7.1 详解招聘工作流程/1 29
7.2根据笔试成绩自动计分/133
7.3培训计划甘特图/1 36
7.4考试成绩区间分布图/140
7.5培训效果检验分析/144
\第8章员工值班与休假
8.1 员工值班最优方案/148
8.2如何判断每月休假天数/1 52
8.3 员工离职月的工作天数核算/1 55
8.4三秒计算年假天数/1 58
8.5根据性别判断退休日期/161
\第9章员工业绩分析
9.1 在图表中突显周数据/167
9.2在图表中分析多个变量/1 70
9.3员工的综合能力分析/174
9.4根据排名计算奖金/178
9.5对多个业绩表进行汇总分析/1 81
、第1 0章员工薪酬管理
10.1 薪资各项目计算/187
10.2-招解决工资条/1 91
10.3员工薪资快速查询/1 96
10.4计算各种面额钞票数/200
10.5薪资体系分析/204
Introduction

企业的正常运转离不开行政和人力资源工作的协调分配,随着现代企业的多元化发展,行政与人力资源工作所涵盖的工作范围也越来越广,其产生的直接影响也是不可估量的。因此,无论是小型的民营企业还是大型的国有企业,都会日渐重视行政和人力资源工作。它们既是其他部门的连接纽带,也是企业运营的有利保障。对于从事行政与人力资源工作的员工来说,要想在各自领域占有一席之地,就必须学会解决工作中的各种难题。本书就是专为行政和人力资源工作的职业者设计的一本专业指导性书籍,重在帮助各位职场人士轻松解决日常工作中遇到的难题。
本书分为两部分,共10章,第一部分是行政管理模块,包括第1~5章,主要介绍行政工作、客户工作、日常费用、文件管理这几个模块的内容,旨在为行政人员提供一个快速解决问题的方法和建议;第二部分是人力资源管理模块,包括第6~10章,主要介绍人力资源在人员规划、人员招聘、人员休假、员工业绩和员工薪资方面的管理工作。
由于行政与人力资源工作密切相关,因此在内容安排上也有相互渗透的部分。
◎露本书特色内容布局清晰明了:本书按用户的应用划分章节,这样方便用户在遇到实际问题时在对应的章节中查看详细内容,而且根据书中的二级标题能快速分辨出该部分所能解决的实际问题。
情景导入式案例:每一个二级标题就是一个大的案例,而案例的引入是通过人物对话产生的,很好地模拟了实际工作中的场景,使阅读变得更加轻松。
场景描述与应用分析:在每个大案例中以场景描述的方式介绍小节内容,并以具体实例为依据进行演示。每一个实例在演示前都对此进行了很透彻的分析,包括应用和操作上的分析,以免在实际操作中不知道为什么要那么做,本书重在给出思维方式和解决方案。
详细的步骤解析:由于本书以案例的形式贯穿每一个知识点,因此在引入案例后还有一个针对情景中所涉及的案例分析,书中以详细步骤解析了实例中所需解答的问题。
相关的知识延伸:在每个小节后有一个知识延伸部分,这部分内容主要是从实例中进行延伸和扩展的,既包括操作技法上的扩展,也包括应用上的延伸,具有很强的启发作用。知识延伸部分内容的重要性不亚于实例中介绍的内容。
一招制胜:上述五大特色综合起来就是本书的最大亮点——“一招制胜”,“一招”即章节后的二级标题,“制胜”即它不但解决了对应模块中的难题,运用思维拓展,还能用同样的模式解决工作中的其他问题。
本书以实际应用为导向,是站在企业的角度为广大行政与人力资源工作者专门设计的【理论+思维+操作】的综合性书籍,适合具有一定Excel操作基础的读者阅读。
由于编者水平有限,在编写本书的过程中难免有不足之处,恳请广大读者指正批评。
作者2015年6月

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