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: 3118218111
Price: 42.09 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 Home网站的行业专家为人力资源与行政从业人员量身订做，

“职业工作方法+Excel办公应用”相结合，

帮助读者迅速掌握所在职业的Excel高效办公方法。

Content Description

《Excel 2013高效办公会计实务》以Excel在会计工作中的具体应用为主线，按照财务会计工作人员的日常工作特点谋篇布局，通过介绍典型应用案例，在讲解具体工作方法的同时，介绍相关的Excel 2013常用功能。

《Excel 2013高效办公会计实务》分为9章，分别介绍了Excel 2013基本操作，凭证、凭证汇总及总账，材料收、发、余的核算，工资的核算，固定资产的核算，成本费用表，其他常用表，资产负债表、损益表、现金流量表和加工单等内容。

《Excel 2013高效办公会计实务》案例实用，步骤清晰。本书面向会计人员，特别是职场新人和急需加强自身职业技能的进阶者，同时也适合希望提高现有实际操作能力的职场人士和大中专院校的学生阅读。

Catalogue

第1章基本操作1
1．1 利润表2
1．1．1 新建工作簿并录入数据2
1．1．2 设置表格格式8
1．1．3 打印设置15
1．2 应付款表16
1．2．1 录入数据17
1．2．2 编制公式18
1．2．3 绘制簇状柱形图22
1．3 到期示意表28
1．3．1 绘制到期示意表29
1．3．2 SUMIF函数的高级应用38
1．3．3 条件格式40
1．3．4 制作图片42
1．4 货品销售台账46
1．4．1 绘制商品流水账47
1．4．2 绘制月末统计表48

第2章凭证、凭证汇总及总账54
2．1 凭证汇总表55
2．1．1 绘制科目代码表56
2．1．2 绘制凭证明细表64
2．1．3 绘制凭证汇总表75
2．1．4 绘制总账表81
2．2 经费收支账表85
2．2．1 绘制经费收支账表86
2．2．2 批注88
2．2．3 绘制汇总表90

第3章材料收、发、余的核算92
3．1 进销存计算表93
3．1．1 绘制基础资料代码表94
3．1．2 绘制入库表97
3．1．3 绘制出库表101
3．1．4 绘制材料总账表103
3．1．5 绘制成本表105
3．2 成本变化图107
3．2．1 绘制成本变化107
3．2．2 绘制折线图108
3．2．3 VLOOKUP函数错误值问题111

第4章工资的核算114
4．1 工资表115
4．1．1 税率表117
4．1．2 员工基础资料表117
4．1．3 考勤统计表121
4．1．4 工资明细表124
4．1．5 零钱统计表134
4．1．6 银行发放表141
4．1．7 工资条144
4．1．8 工资凭证表153
4．2 员工信息统计表156
4．3 核对银行卡号160

第5章固定资产的核算168
5．1 分类折旧表169
5．1．1 绘制分类折旧表170
5．1．2 绘制固定资产台账表172
5．1．3 绘制月折旧表179
5．2 医院销售统计表182
5．2．1 编制日流水183
5．2．2 编制日汇总184
5．2．3 编制月汇总185
5．2．4 编制其他口径汇总186
5．3 拆分数据189
5．3．1 使用函数拆分账户名称和金额190
5．3．2 将单列文本拆分为多列193
5．3．3 从单元格中截取特定的字符串197
5．3．4 从财务软件中导出科目明细200
5．4 统计数据202
5．4．1 多条件求和203
5．4．2 统计数据204
5．4．3 一次性为小计行添加求和公式205

第6章成本费用表206
6．1 成本对比表207
6．1．1 创建材料成本对比表208
6．1．2 创建本期成本构成分析表212
6．1．3 绘制饼图214
6．2 收费统计表216
6．2．1 创建收费记录表217
6．2．2 创建收费统计表218
6．2．3 创建数据透视表型费用统计表222
6．3 数据透视表226
6．4 数组公式230

第7章其他常用表234
7．1 应收款账龄分析235
7．1．1 创建应收款账龄分析表236
7．1．2 增加时间划分档次238
7．1．3 插入簇状条形图240
7．1．4 绘制明细账表244
7．2 盘库打印条246
7．2．1 录入基础数据247
7．2．2 创建盘库打印条表248
7．2．3 设置打印页面区域252
7．3 支票套打254
7．3．1 基础信息资料表255
7．3．2 模仿背景式套打257
7．3．3 图片式支票套打261
7．4 费用对比图265
7．4．1 绘制费用对比图266
7．4．2 向图表中添加数据系列271
7．5 定位查找表272
7．6 内插值应用表276
7．7 高级筛选280
7．7．1 不包含单元格引用的高级筛选282
7．7．2 包含单元格引用的高级筛选287
7．7．3 将筛选结果输出到其他工作表中291
7．7．4 筛选不重复的记录293
7．8 数据排名和排序294
7．8．1 排名296
7．8．2 分段排名297
7．8．3 排序299
7．9 其他基础操作301
7．9．1 查找替换功能301
7．9．2 清除值为“0”的单元格303
7．9．3 在特定单元格中输入数值305
7．9．4 使用排序功能删除不需要的记录306

第8章三大财务报表310
8．1 资产负债表311
8．1．1 创建凭证汇总表312
8．1．2 创建总账表313
8．1．3 创建资产负债表315
8．1．4 设置万元显示格式321
8．2 损益表323
8．2．1 损益表323
8．2．2 VBA实现本期累计数自动过渡到下期期初326
8．3 现金流量表330
8．3．1 创建资产负债表331
8．3．2 创建利润及利润分配表334
8．3．3 创建其他数据录入表336
8．3．4 创建现金流量表338

第9章加工单351
9．1 加工单352
9．1．1 创建单位基础信息和资料库353
9．1．2 创建正表355
9．2 工程预算公式转换成公式结果365
9．3 工作日志367

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 2013高效办公 会计实务

Excel 2013高效办公会计实务