Trending on TikTok

Sanrio

Sriracha

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: 3118211421
Price: 45.94 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

Content Description

《Excel 2013财务会计应用从入门到精通》共15章，在详细介绍Excel 2013各项基础功能的基础上，以具体实例着重介绍了这些功能在财务会计中的应用。书中具体包括单元格的操作，数据的编辑，财务表格的美化方法，公式在计算财务数据方面的应用，函数在处理财务数据方面的应用，数据的汇总与查询，图表的应用，使用数据透视表、数据透视图和切片器分析与处理财务数据，宏与控件的相关知识，以及财务管理的网络应用，财务表格的打印与输出，记账凭证的编制、明细账和总账的编制，资产负债表、利润表、现金流量表的编制等内容。
《Excel 2013财务会计应用从入门到精通》内容全面、讲解充分、图文并茂，并融入了作者的实际操作心得，适合Excel的初中级读者、财会从业人员，以及对Excel新版本比较感兴趣的读者，同时亦可作为大中专院校、会计电算化培训班的授课教材。

Catalogue

第1章 Excel财务会计应用基础
1.1 Excel在会计与财务管理中的应用
1.2 安装Excel 2013
1.2.1 电脑配置要求
1.2.2 安装Microsoft Office 2013
1.2.3 卸载Microsoft Office 2013
1.3 启动Excel 2013
1.4 Excel 2013工作界面
1.4.1 快速访问工具栏
1.4.2 标题栏
1.4.3 选项卡功能区
1.4.4 数据编辑栏
1.4.5 工作表编辑区
1.4.6 状态栏
1.5 工作簿、工作表和单元格的关系
1.6 工作簿的基本操作
1.6.1 新建工作簿
1.6.2 保存工作簿
1.6.3 打开工作簿
1.6.4 关闭工作簿
1.6.5 保护工作簿
1.7 工作表的基本操作
1.7.1 选择工作表
1.7.2 新建和删除工作表
1.7.3 移动与复制工作表
1.7.4 重命名工作表
1.7.5 保护工作表
1.7.6 拆分和冻结工作表
1.8 退出Excel 2013
1.9 实例——制作财务日报表

第2章单元格操作
2.1 单元格的基本操作
2.1.1 选择单元格
2.1.2 插入和删除单元格
2.1.3 合并单元格
2.1.4 保护单元格
2.2 输入和填充单元格数据
2.2.1 手动输入单元格中的数据
2.2.2 快速填充数据
2.2.3 限制输入条件
2.3 实例——制作公司日常费用表

第3章编辑财务数据
3.1 修改和清除单元格中的数据
3.1.1 在编辑栏中修改和清除数据
3.1.2 在单元格中修改和清除数据
3.2 复制和移动数据
3.2.1 复制数据
3.2.2 移动数据
3.3 查找和替换数据
3.3.1 查找数据
3.3.2 替换数据
3.4 撤销与恢复数据
3.5 实例——编辑银行账户管理记录表

第4章格式化财务表格
4.1 设置单元格内容的格式
4.1.1 设置字体格式
4.1.2 设置数字格式
4.1.3 设置单元格对齐方式
4.2 改变单元格的行高与列宽
4.2.1 手动调整
4.2.2 自定义调整
4.3 为单元格添加边框
4.4 统一账簿样式
4.4.1 使用自带的样式格式化表格
4.4.2 创建新样式
4.4.3 套用其他工作簿的样式
4.4.4 设置条件格式
4.4.5 管理条件格式规则
4.5 实例——格式化销售业绩分析表

第5章使用公式计算财务数据
5.1 认识公式
5.1.1 公式的组成
5.1.2 认识公式中的运算符
5.2 使用公式
5.2.1 创建公式
5.2.2 编辑公式
5.2.3 复制公式
5.2.4 删除公式
5.3 公式中常见的错误值
5.4 引用单元格
5.4.1 相对引用和绝对引用
5.4.2 引用同一工作簿其他工作表中的单元格
5.4.3 引用其他工作簿中的单元格
5.4.4 使用名称计算数据
5.5 实例——计算销售业绩奖金

第6章使用函数计算财务数据
6.1 认识函数
6.1.1 函数的结构
6.1.2 函数的分类
6.2 使用函数
6.2.1 插入函数
6.2.2 嵌套函数
6.3 常用函数的应用
6.3.1 SUM函数的应用
6.3.2 AVERAGE函数的应用
6.3.3 MAX 与MIN函数的应用
6.3.4 MEDIAN函数的应用
6.3.5 LARGE与SMALL函数的应用
6.3.6 用RANK函数排序数字
6.3.7 FREQUENCY函数的应用
6.3.8 IF函数的应用
6.3.9 用AND函数求交集
6.3.10 COUNT系列函数的应用
6.3.11 TODAY函数的应用
6.4 实例——核算员工工资

第7章财务管理常用函数的应用
7.1 投资预算函数的使用
7.1.1 用EFFECT计算有效年利率
7.1.2 用FV函数计算固定利率
7.1.3 用FVSCHEDULE函数计算变化利率投资未来值
7.1.4 用NOMINAL函数计算名义年利率
7.1.5 用NPER函数计算投资周期数
7.1.6 用NPV函数计算非固定投资回报
7.1.7 用PV函数计算固定投资回报
7.2 本利函数的使用
7.2.1 用IPMT函数计算偿还的利息
7.2.2 用PMT函数计算贷款每期还款额
7.2.3 用PPMT函数计算付款中的本金
7.3 折旧函数的使用
7.3.1 用AMORDEGRC函数计算每个结算期间的折旧值
7.3.2 用DB函数计算指定期间内的折旧值
7.3.3 用DDB函数加速折旧资产
7.3.4 用SLN函数计算一个期间内某项资产的直线折旧值
7.3.5 用SYD函数按年限总和折旧法计算折旧值
7.3.6 用VDB函数按余额递减法计算资产折旧值
7.4 报酬率函数的使用
7.4.1 用IRR函数计算某一连续现金流量的内含报酬率
7.4.2 用MIRR函数现金流修正内部收益率
7.5 实例——制作项目投资经营表

第8章汇总和查询财务数据
8.1 数据的排序
8.1.1 快速排序
8.1.2 自定义条件排序
8.2 数据的筛选
8.2.1 自动筛选
8.2.2 高级筛选
8.2.3 清除筛选
8.3 分类汇总
8.3.1 创建分类汇总
8.3.2 隐藏和显示分类汇总
8.3.3 清除分类汇总
8.4 使用记录单编辑财务记录
8.4.1 添加记录单工具按钮
8.4.2 使用记录单添加记录
8.4.3 使用记录单修改、删除记录
8.4.4 使用记录单筛选记录
8.5 使用数据查询向导
8.5.1 使用MS Query新建数据源
8.5.2 创建一个查询
8.6 实例——汇总固定资产记录单
8.6.1 基础设置
8.6.2 制作固定资产档案
8.6.3 编制固定资产报表
8.6.4 创建分类汇总

第9章用图表使财务数据形象化
9.1 认识图表及其组成
9.2 认识图表的类型
9.3 插入图表
9.4 编辑图表
9.4.1 设置图表的大小和布局
9.4.2 设置图表的类型
9.4.3 在图表中添加和删除数据
9.4.4 设置图表选项的格式
9.4.5 移动图表到其他工作表
9.4.6 在图表中添加注释
9.5 使用趋势线预测数据的发展趋势
9.5.1 在图表中添加趋势线
9.5.2 修改趋势线
9.5.3 删除趋势线
9.6 使用误差线分析数据的误差
9.6.1 在图表中添加误差线
9.6.2 修改误差线
9.6.3 删除误差线
9.7 实例——预测商品的销售趋势

第10章处理和分析财务数据
10.1 在财务工作表中使用透视表
10.1.1 检查源数据
10.1.2 认识数据透视表
10.1.3 创建空白数据透视表
10.1.4 生成数据透视表
10.1.5 添加筛选条件查看数据
10.1.6 修改数据透视表
10.1.7 显示、隐藏数据
10.1.8 选择、移动数据透视表
10.2 删除数据透视表
10.2.1 删除数据透视表中的字段
10.2.2 删除整个数据透视表
10.3 使用数据透视图分析数据
10.3.1 认识数据透视图
10.3.2 创建数据透视图
10.3.3 在数据透视图中筛选数据
10.4 使用切片器筛选数据
10.5 实例——分析订单统计表
10.5.1 建立数据透视表
10.5.2 更新数据
10.5.3 创建数据透视图

第11章 Excel的高级应用
11.1 控件的使用
11.2 宏的使用
11.2.1 宏的作用
11.2.2 录制宏
11.2.3 调用宏
11.2.4 宏的安全设置
11.2.5 删除宏
11.3 组件间的链接和嵌入
11.3.1 插入链接对象
11.3.2 插入嵌入对象
11.3.3 修改链接和嵌入的对象
11.4 实例——制作预期销售表

第12章财务管理网络应用
12.1 在局域网中共享财务表格
12.1.1 创建共享工作簿
12.1.2 编辑共享工作簿
12.1.3 设置共享工作簿
12.1.4 取消共享工作簿
12.1.5 保护共享工作簿
12.2 网络中超链接的运用
12.2.1 创建超链接
12.2.2 编辑超链接
12.3 使用电子邮件发送工作簿
12.4 实例——制作存货记录表

第13章财务表格的打印和输出
13.1 页面布局设置
13.1.1 设置页面打印方式
13.1.2 设置页边距
13.1.3 设置页眉和页脚
13.1.4 设置分页符
13.2 打印预览
13.2.1 设置显示边距
13.2.2 设置显示比例
13.2.3 设置打印标题
13.3 打印Excel表格
13.3.1 设置打印属性并打印
13.3.2 区域打印表格
13.3.3 快速打印
13.4 实例——设置并打印差旅费报销单

第14章制作日常财务表格
14.1 制作记账凭证
14.1.1 基础设置
14.1.2 期初余额设置
14.1.3 编制记账凭证信息
14.1.4 凭证查询
14.2 制作日记账簿
14.2.1 基础设置
14.2.2 编制银行存款日记账
14.2.3 编制现金日记账
14.3 制作明细科目汇总表

第15章制作财务报表
15.1 制作资产负债表
15.1.1 行业知识
15.1.2 设置资产负债表格式
15.1.3 输入资产负债表公式
15.2 制作利润表
15.2.1 行业知识
15.2.2 设置利润表格式
15.2.3 输入利润表公式
15.3 制作现金流量表
15.3.1 行业知识
15.3.2 设置现金流量表格式
15.3.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 + ')'}}