{{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 2007财务管理入门与提高

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

Excel 2007财务管理入门与提高

{{__(":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
Editer Recommend

《Excel 2007财务管理入门与提高》结合Excel命令讲解具有代表性的财务管理实例,帮你解决日常工作中的各种难题。采用手把手教学方式,可操作性强,只要按步骤操作即可享受成功喜悦。从“入门”到“提高”,帮助新手快速入门,帮助老手成功进阶。
Content Description

《Excel 2007财务管理入门与提高》将为你提供一个使用Excel2007进行财务管理的机会,让你轻松地从入门到提高。Excel功能强大,它不仅能呈现整齐、美观的电子表格,还能对表格中的数据进行各种复杂的计算处理,为用户处理数据、统计分析等活动提供依据,同时,Excel还可以将表格中的数据通过图表的形式表现出来,以便更好地分析和管理数据。它能快速制作出日常财务表格、会计凭证、会计报表、财务趋势和预测、固定资产管理和财务预算等方面的表格。
《Excel2007财务管理入门与提高》共12章,第1~5章介绍了Excel2007基础知识、基本操作,第6章介绍了制作日常财务表格,第7章介绍了制作会计凭证,第8章介绍了制作会计报表,第9章介绍了进行成本和费用分析,第10章介绍了财务预测和趋势分析,第11章介绍了固定资产管理,第12章介绍了财务预算。
《Excel2007财务管理入门与提高》采用由浅入深、循序渐进的手把手教学方式,结合实例讲解,操作步骤完整清晰,注重实用性和可操作性,读者只要跟从操作,就能熟练运用Excel2007软件进行财务管理工作。
Catalogue

第1章 Excel基础知识
1.1 Excel在财务管理中的应用
1.2 Excel2007的启动和退出
1.2.1 Excel2007的启动
1.2.2 Excel2007的退出
1.3 Excel2007的操作界面
1.3.1 0ffice按钮
1.3.2 快速访问工具栏
1.3.3 标题栏
1.3.4 工具选项卡
1.3.5 名称框和编辑栏
1.3.6 工作表区
1.3.7 状态栏
1.4 Excel2007的视图方式
1.4.1 普通视图
1.4.2 页面布局视图
1.4.3 分页预览视图
1.4.4 全屏显示视图
1.4.5 拆分视图
1.5 小结
1.6 练习
第2章 Excel基本操作
2.1 工作簿、工作表和单元格的关系
2.1.1 工作簿、工作表和单元格简介
2.1.2 工作簿、工作表和单元格的关系
2.2 工作簿的基本操作
2.2.1 新建Excel工作簿
2.2.2 保存Excel工作簿
2.2.3 打开和关闭共作簿
2.2.4 保护工作簿
2.3 共作表的操作
2.3.1 选择工作表
2.3.2 重命名工作表
2.3.3 插入和删除工作表
2.3.4 移动和复制工作表
2.3.5 隐藏或显示工作表
2.4 单元格的基本操作
2.4.1 选择单元格
2.4.2 插入和删除单元格
2.4.3 合并单元格
2.5 小结
2.6 练习
第3章 制作与美化表格
3.1 输入数据
3.1.1 输入文本数据
3.1.2 输入数字数据
3.1.3 快速填充数据
3.2 修改数据
3.2.1 修改单元格中的全部数据
3.2.2 修改单元格中部分数据
3.2.3 删除数据
3.3 复制和移动数据
3.3.1 复制数据
3.3.2 移动数据
3.4 设置单元格格式
3.4.1 设置数据类型
3.4.2 设置对齐方式
3.4.3 设置字体格式
3.4.4 设置边框和底纹
3.4.5 编辑行高和列宽
3.5 使用样式
3.5.1 设置条件格式
3.5.2 套用表格格式
3.5.3 套用单元格样式
3.5.4 删除应用格式
3.6 小结
3.7 练习
第4章 使用公式和函数
4.1 使用公式
4.1.1 输入公式
4.1.2 使用填充法快速复制公式
4.1.3 修改公式
4.1.4 引用单元格
4.1.5 删除公式
4.2 使用函数
4.2.1 插入函数
4.2.2 嵌套函数
4.2.3 常用财务函数的运用
4.3 小结
4.4 练习
第5章 分析、管理并打印数据
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 编辑图表
5.6 打印工作表
5.6.1 页面没置
5.6.2 打印工作表
5.7 小结
5.8 练习
第6章 制作日常财务表格
6.1 制作差旅费报销单
6.2 制作盘存调整表
6.3 制作员工工资表
6.4 小结
6.5 练习
第7章 制作会计凭证和账簿
7.1 创建会计科目表
7.2 制作记账凭证
7.3 制作打印格式的记账凭证
7.4 制作现金日记账表
7.5 制作科目汇总表
7.6 制作总分类账表
7.7 小结
7.8 练习
第8章 制作会计报表
8.1 制作资产负债表
8.2 制作损益表
8.3 制作现金流量表
8.4 利润分配表
8.5 小结
8.6 练习
第9章 成本费用分析
9.1 制作材料成本对比表
9.2 产品销售分析表
9.3 销售费用分析表
9.4 小结
9.5 练习
第10章 财务预测和趋势分析
10.1 主营业务收入预测
10.2 销售额预测
10.3 成本预测
10.4 财务状况趋势分析表
10.5 财务状况综合分析表
10.6 小结
10.7 练习
第11章 固定资产管理
11.1 固定资产折旧计算
11.2 固定资产结构分析
11.3 固定资产增减变动分析
11.4 小结
11.5 练习
第12章 财务预算及分析
12.1 销售预算及分析
12.2 生产产量预算及分析
12.3 直接材料预算分析
12.4 现金预算
12.5 小结
12.6 练习
附录1 Excel2007快捷键
附录2 常用函数一览表
附录3 财务函数一览表
附录4 售后服务
Introduction

如何轻松设计各种财务报表?如何利用Excel对杂乱无章的财务数据进行有效分析?财务工作中的你是否还为制作各种分析报表而烦恼?别人几分钟就完成的报表,你却需要半天甚至一天的时间?本书将为你提供一个使用Excel2007进行财务管理的机会,让你轻松地从入门到提高。
Excel功能强大,它不仅能呈现整齐、美观的电子表格,还能对表格中的数据进行各种复杂的计算处理,为用户处理数据、统计分析等活动提供依据,同时,Excel还可以将表格中的数据通过图表的形式表现出来,以便更好地分析和管理数据。它能快速制作出日常财务表格、会计凭证、会计报表、财务趋势和预测、固定资产管理和财务预算等方面的表格。
本书共12章,第1~5章介绍了Excel2007基础知识、基本操作,第6章介绍了制作日常财务表格,第7章介绍了制作会计凭证,第8章介绍了制作会计报表,第9章介绍了进行成本和费用分析,第10章介绍了财务预测和趋势分析,第11章介绍了固定资产管理,第12章介绍了财务预算。
本书采用由浅入深、循序渐进的手把手教学方式,结合实例讲解,操作步骤完整清晰,注重实用性和可操作性,读者只要跟从操作,就能熟练运用Excel2007软件进行财务管理工作。
不管你是从事财务工作却不了解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
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