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 2010会计与财务管理完全应用手册（附光盘）

View Cart & Check Out

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

Books Computers & Internet Office Software

Jingdong book

职场无忧：Excel 2010会计与财务管理完全应用手册（附光盘）

Name: 职场无忧：Excel 2010会计与财务管理完全应用手册（附光盘）
Brand: Jingdong book
SKU: 3118215981
Price: 44.63 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 2010会计与财务管理完全应用手册》内容全面实用选择最实用、最常用的知识，力求您“学的知识都用得上”，通过“做案例”深度挖掘Excel会计与财务管理的技能，学习效率事半功倍100%职场案例引导学习，精选40个最实用的办公案例，让您在完成各个案例的同时，掌握Excel会计与财务管理的相关知识和工作方法。本书既适合系统学习，也适合现学书中相同或相似的案例，现用到实际工作中图文对应讲解一步一图，在讲解具体操作时，图片上清晰地标注出了要进行操作的位置与操作内容，助您顺利学会相关操作。
多媒体视频教程+超强附赠，40个重点大案例和28个实用技巧的视频教学录像，播放时间达220分钟，让您像看电视一样轻松直观地学习。附赠视频：25集Windows 7实用视频，帮您一扫Windows 7的系统困扰；附赠模板：1300个财务相关Office模板，满足您职场中的大部分应用需求；技术交流群，第一时间解决您的问题，一路为您保驾护航。

Content Description

《职场无忧：Excel 2010会计与财务管理完全应用手册》一书内容系统、全面，充分考虑即将走入职场，和广大职场人士的实际情况，打破了传统的按部就班讲解知识点的模式，以“实际应用”为出发点，结合大量源于实际工作的精彩案例，全面地讲解了Excel在会计与财务管理工作中的相关应用技能与操作技巧。力求使您在快速学会软件技能操作的同时，又能掌握Excel会计与财务管理的思路与经验。
《职场无忧：Excel 2010会计与财务管理完全应用手册》共11章，结合会计与财务管理的相关典型案例，详细地介绍了Excel在会计与财务管理工作中的相关应用与操作技能。内容包括：制作常见的财务表单、创建Excel记账表单、制单、登账、期末对账与结账、制作进销存管理表单、往来账款分析、制作工资管理系统、固定资产管理、编制财务报表、财务指标分析。
为方便学习，随书配1CD多媒体教学光盘，包含：书中所有案例的全程视频讲解（共100集，近500分钟）；所有案例的原始文件和结果文件；附赠Windows 7实用视频、1300个财务相关实用模板等内容。
本书既适合初学Excel会计与财务管理的读者学习使用，也适合有一定基础，但缺乏实战操作经验与应用技巧的读者学习用书。同时也可以作为电脑培训班、职业院校相关专业的教材用书或参考书。

Author Description

前沿文化，资深畅销书团队，全网最擅长编写办公图书的团队，其办公类著作常居排行榜之首。

Catalogue

Chapter 01 制作常见的财务表单
1.1 制作差旅费报销单
1.1.1 创建差旅费报销单
1.1.2 美化差旅费报销单
1.1.3 打印差旅费报销单
1.2 制作内部借款单
1.2.1 创建内部借款单
1.2.2 填写内部借款单
1.2.3 内部借款业务的账务处理
1.3 制作费用报销单
1.3.1 费用报销的一般流程
1.3.2 费用报销单的相关注意事项
1.4 报销单据粘贴单
1.4.1 填写报销单据粘贴单注意事项
1.4.2 单据粘贴中的常见错误
1.5 技高一筹--实用操作技巧
1.5.1 如何处理Excel中"一分钱"差异
1.5.2 如何在单元格中输入人民币符号"￥"
1.5.3 Excel中小写金额转换为汉字大写的公式
Chapter 02 创建Excel记账表单
2.1 制作会计科目表
2.1.1 准则和制度之争
2.1.2 创建会计科目表
2.2 制作记账凭证录入表
2.2.1 初始化信息
2.2.2 定义名称
2.2.3 设置下拉菜单
2.2.4 引用会计科目
2.2.5 设置单元格格式
2.2.6 录入凭证信息
2.3 创建日记账表单
2.3.1 生成现金日记账
2.3.2 生成银行存款日记账
2.4 技高一筹--实用操作技巧
2.4.1 如何使用通配符筛选会计科目
2.4.2 如何使用"自动更正"功能快速输入文本
2.4.3 如何使用连字符&合并会计科目
Chapter 03 制单
3.1 填制原始凭证
3.1.1 常见的原始凭证
3.1.2 原始凭证的填制和审核
3.1.3 支票的填制方法
3.2 填制记账凭证
3.2.1 记账凭证的种类
3.2.2 记账凭证的填制要求
3.2.3 填写记账凭证
3.2.4 记账凭证中常见的错误及更正
3.3 技高一筹--实用操作技巧
3.3.1 如何使金额中的小数点右对齐
3.3.2 如何在Excel中输入分数
Chapter 04 登账
4.1 账簿的设置与管理
4.1.1 会计账簿的分类
4.1.2 建账
4.2 登记账簿
4.2.1 账簿的登记要求
4.2.2 账簿登记案例
4.3 创建明细账
4.3.1 设置下拉列表
4.3.2 引用会计科目
4.3.3 设置单元格格式
4.3.4 录入数据
4.4 创建总账
4.4.1 制作科目汇总表
4.4.2 录入总账数据
4.4.3 编制试算平衡表
4.5 技高一筹--实用操作技巧
4.5.1 如何将Excel中的零值设置为－
4.5.2 如何查询会计账表中的明细数据
Chapter 05 期末对账与结账
5.1 对账
5.1.1 账证核对
5.1.2 账账核对
5.1.3 账实核对
5.2 账簿错误及更正
5.2.1 划线更正法
5.2.2 红字更正法
5.2.3 补充登记法
5.3 结账
5.3.1 月结
5.3.2 季结
5.3.3 年结
5.4 保护会计数据
5.4.1 保护工作簿
5.4.2 保护工作表
5.5 技高一筹--实用操作技巧
5.5.1 如何输入对账符号"√"
5.5.2 如何用"超链接"快速跳转到其他账表
Chapter 06 制作进销存管理表单
6.1 采购管理
6.1.1 制作请购单
6.1.2 制作采购明细表
6.1.3 采购业务的账务处理
6.2 销售管理
6.2.1 制作销售明细表
6.2.2 销售收入汇总分析
6.2.3 销售业务的账务处理
6.3 存货管理
6.3.1 相关函数
6.3.2 制作存货明细表
6.3.3 存货业务的账务处理
6.4 进销存业务分析
6.4.1 制作进销存分析表
6.4.2 设置存货紧缺预警
6.5 技高一筹--实用操作技巧
6.5.1 如何筛选特定客户的销售记录
6.5.2 如何筛选销售记录中的10个最大值
6.5.3 采购业务中运费如何进行会计核算
Chapter 07 往来账款分析
7.1 应收账款管理
7.1.1 逾期应收账款分析
7.1.2 应收账款账龄分析
7.1.3 应收账款业务的账务处理
7.2 应付账款管理
7.2.1 制作应付账款到期提示表
7.2.2 应付账款付款方案
7.2.3 应付账款业务的账务处理
7.3 技高一筹--实用操作技巧
7.3.1 如何使用记录单添加应付账款记录
7.3.2 如何创建应收账款账龄分析图
Chapter 08 制作工资管理系统
8.1 制作工资管理表单
8.1.1 制作基本工资表
8.1.2 制作奖金表
8.1.3 制作补贴表
8.1.4 制作社保缴纳一览表
8.2 月末员工工资统计
8.2.1 制作员工工资统计表
8.2.2 查询员工工资数据
8.2.3 制作工资条
8.2.4 打印工资条
8.3 制作工资系统登录窗口
8.3.1 保存为启用宏的工作簿
8.3.2 设置个人信息选项
8.3.3 添加"开发工具"选项卡
8.3.4 设置宏的安全性
8.3.5 设置用户登录窗口
8.4 工资业务的账务处理
8.4.1 应付职工薪酬
8.4.2 计提和发放工资
8.5 技高一筹--实用操作技巧
8.5.1 如何使用辅助列制作工资条？
8.5.2 如何使用mymsgbox代码显示提示信息
Chapter 09 固定资产管理
9.1 固定资产的日常管理
9.1.1 编制固定资产卡片
9.1.2 固定资产的增加和减少
9.2 固定资产的查询
9.2.1 按照固定资产"名称"查询
9.2.2 按照"部门名称"查询
9.3 固定资产的折旧处理
9.3.1 使用直线法计提折旧
9.3.2 使用双倍余额递减法计提折旧
9.3.3 使用年数总和法计提折旧
9.4 折旧费用的分析
9.4.1 创建折旧费用数据透视表
9.4.2 创建折旧费用分析图
9.5 固定资产业务的账务处理
9.5.1 固定资产的成本计量
9.5.2 计提固定资产折旧
9.5.3 固定资产的盘盈和盘亏
9.5.4 固定资产清理
9.6 技高一筹--实用操作技巧
9.6.1 如何查看Excel中相距较远的两列数据
9.6.2 如何在绝对与相对单元格引用之间切换
9.6.3 如何通过一次按键创建一个Excel图表
9.6.4 如何在工作表之间移动图表
Chapter 10 编制财务报表
10.1 编制资产负债表
10.1.1 资产负债表项目简介
10.1.2 编制资产负债表
10.2 编制利润表
10.2.1 利润表项目简介
10.2.2 编制利润表
10.3 编制现金流量表
10.3.1 现金流量表项目简介
10.3.2 编制现金流量表
10.4 技高一筹--实用操作技巧
10.4.1 如何共享财务报表
10.4.2 如何隐藏和显示工作
Chapter 11 财务指标分析
11.1 偿债能力分析
11.1.1 短期偿债能力指标
11.1.2 长期偿债能力指标
11.2 营运能力分析
11.2.1 流动资产周转情况分析
11.2.2 固定资产周转情况分析
11.2.3 总资产周转情况分析
11.3 获利能力分析
11.3.1 营业利润率
11.3.2 成本费用利润率
11.3.3 总资产报酬率
11.3.4 净资产收益率
11.4 发展能力分析
11.4.1 营业收入增长率
11.4.2 资本保值增值率
11.4.3 总资产增长率
11.4.4 营业利润增长率
11.5 综合指标分析
11.5.1 综合指标分析的含义及特点
11.5.2 制作杜邦分析图表
11.6 技高一筹--实用操作技巧
11.6.1 如何对比分析不同年度的权益净利率
11.6.2 如何分解权益净利率

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