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: 3118215971
Price: 33.51 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%职场案例引导学习，精选27个最实用的办公案例，让您在完成各个案例的同时，掌握Excel相关知识和工作方法。本书既适合系统学习，也适合现学书中相同或相似的案例，现用到实际工作中图文对应讲解一步一图，在讲解具体操作时，图片上清晰地标注出了要进行操作的位置与操作内容，助您顺利学会相关操作、
多媒体视频教程+超强附赠，27个重点大案例和61个实用技巧的视频教学录像，播放时间达320分钟，让您像看电视一样轻松直观地学习。附赠视频：47集Windows 7实用视频，帮您一扫Windows 7的系统困扰，附赠模板：3465个Office模板，满足您职场中的大部分应用需求技术交流群，第一时间解决您的问题，一路为您保驾护航。

Content Description

《职场无忧：Excel 2010表格制作与数据处理完全应用手册》内容系统、全面，充分考虑即将走入职场的毕业生，和广大职场人士的实际情况，打破了传统的按部就班讲解知识点的模式，以“实际应用”为出发点，结合大量源于实际工作的精彩案例，全面地讲解了Excel表格制作与数据处理在日常办公中的相关技能与操巧。本书力求使您在快速学会软件技能操作的同时，又能掌握Excel表格制作与数据处理的思路与经验。
《职场无忧：Excel 2010表格制作与数据处理完全应用手册》共10章，结合日常办公中的相关典型案例，详细地介绍了Excel表格制作与数据处理的相关技能知识。内容包括：录入与编辑数据，设置与美化表格，为表格添加对象，公式的应用，使用函数计算数据，排序、筛选和分类汇总，图表的应用，数据透视表/图的应用，导入与分析处理数据，宏与VBA的应用。
为方便学习，随书配1DVD多媒体教学光盘，包含：书中所有案例的全程视频讲解（共83集，近320分钟）；所有案例的原始文件和结果文件；附赠资源——Windows 7实用视频、3465个Office实用模板等内容。
本书既适合初学Excel的读者学习使用；也适合作为有一定基础，但缺乏实战操作经验与应用技巧的读者学习用书；同时也可以作为电脑培训班、职业院校相关专业的教材用书或参考书。

Author Description

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

Catalogue

Chapter01 录入与编辑数据
1.1 制作员工档案表
1.1.1 创建档案表
1.1.2 输入档案表内容
1.1.3 快速输入数据
1.1.4 校对与审阅档案表
1.1.5 管理员工档案表
1.1.6 管理工作簿
1.2 制作差旅报销单
1.2.1 输入与编辑文本格式
1.2.2 设置单元格格式
1.2.3 设置边框和底纹
1.3 制作员工每月动态管理表
1.3.1 输入与编辑文本
1.3.2 设置单元格格式
1.3.3 工作表的操作
1.4 技高一筹--实用操作技巧
1.4.1 如何快速插入工作表
1.4.2 如何新建模板文件
1.4.3 单元格的定位方法
1.4.4 如何查找和替换工作表中内容
1.4.5 如何输入竖排文本
1.4.6 如何对工作簿进行加密
1.4.7 以只读的方式打开工作簿
1.4.8 让低版本Excel能打开Excel 2010格式的表格
Chapter02 设置与美化表格
2.1 制作加班记录表
2.1.1 设置加班记录表的单元格格式
2.1.2 优化加班记录表
2.2 制作盘点表
2.2.1 输入盘点表
2.2.2 标记盘点表
2.3 美化工资表
2.3.1 为工资表添加条件格式
2.3.2 设置工资表格式
2.4 技高一筹--实用操作技巧
2.4.1 新建规则
2.4.2 清除已有的规则
2.4.3 编辑规则
2.4.4 新建表样式
2.4.5 新建单元格样式
2.4.6 合并样式
Chapter03 为表格添加对象
3.1 制作个人简历
3.1.1 为个人简历添加剪贴画与图片
3.1.2 编辑图片对象
3.2 制作产品推广单
3.2.1 使用艺术字制作标题
3.2.2 使用形状制作产品生产流程表
3.2.3 使用文本框输入产品推广说明
3.2.4 制作产品销售渠道图示
3.3 技高一筹--实用操作技巧
3.3.1 删除图片背景
3.3.2 旋转图片.
3.3.3 制作发光图片
3.3.4 编辑形状顶点
3.3.5 使用屏幕截取网页中图片
3.3.6 使用屏幕剪辑窗口图片
Chapter04 公式的应用
4.1 制作绩效表
4.1.1 使用公式
4.1.2 公式中单元格地址的引用
4.1.3 使用名称
4.1.4 公式审核
4.2 制作销量统计表
4.2.1 数组公式的应用
4.2.2 合并计算
4.2.3 处理公式中的问题
4.3 技高一筹--实用操作技巧
4.3.1 从一维数组中提取子数组
4.3.2 从二维数组中提取子数组
4.3.3 对数据区域满足条件的值进行统计
4.3.4 为指定范围内的数值分类
4.3.5 利用数组公式排序
Chapter05 使用函数计算数据
5.1 制作年度报表
5.1.1 输入函数的方法
5.1.2 常用函数的使用
5.2 制作记账凭证表
5.2.1 填制原始凭证
5.2.2 设置日期和现金支票格式
5.2.3 使用函数填写支票金额
5.2.4 填制记账凭证
5.2.5 制作现金和银行存款日记账表
5.3 制作固定资产管理表
5.3.1 盘点固定资产
5.3.2 固定资产的折旧处理
5.4 制作进销存管理表
5.4.1 采购管理
5.4.2 销售管理
5.4.3 库存管理
5.5 技高一筹--实用操作技巧
5.5.1 使用COUNTIF函数根据条件进行计数
5.5.2 使用PV函数计算投资的现值
5.5.3 使用NPV函数计算投资的净现值
5.5.4 使用RATE函数计算年金的各期利率
5.5.5 用PMT函数计算贷款偿还额
Chapter06 排序、筛选和分类汇总
6.1 分析库存明细表
6.1.1 数据排序与筛选
6.1.2 数据的分类汇总
6.1.3 设置库存表页面
6.2 分析汽车销售报表
6.2.1 排序与筛选的高级应用
6.2.2 组与分类汇总的高级应用
6.3 技高一筹--实用操作技巧
6.3.1 按单元格颜色进行排序
6.3.2 将多次操作后的记录单顺序还原到初始顺序
6.3.3 解决序号不参与排序的方法
6.3.4 筛选出表格中的非重复值
6.3.5 取消对组的设置
6.3.6 将数据区域转换为列表
6.3.7 调整列表区域大小
6.3.8 将列表转换为正常区域
Chapter07 图表的应用
7.1 制作销售预测分析图表
7.1.1 创建销售预测图表
7.1.2 编辑销售预测图表
7.2 制作饼图分析销售数据
7.2.1 创建饼图图表
7.2.2 编辑饼图图表
7.3 使用折线图分析房价趋势
7.3.1 创建折线图
7.3.2 编辑与美化折线图
7.4 创建股票迷你图
7.4.1 创建迷你图
7.4.2 编辑与美化迷你图
7.5 技高一筹--实用操作技巧
7.5.1 让饼图中接近于0%的数据标签消失
7.5.2 如何以主或次坐标轴显示折线图
7.5.3 创建金字塔式的条形图
7.5.4 选择区域对图表进行缩放
7.5.5 删除图表中的数据系列
7.5.6 设置图表绘图区的透明效果
7.5.7 为图表添加趋势线
7.5.8 为图表添加误差线
Chapter08数据透视表/图的应用
8.1 分析考勤记录表
8.1.1 创建考勤记录透视表
8.1.2 编辑考勤记录透视表
8.1.3 使用切片器分析数据
8.2 分析家电销售表
8.2.1 创建数据透视图
8.2.2 设置数据透视图
8.3 技高一筹--实用操作技巧
8.3.1 对数据透视表推迟布局更新操作
8.3.2 解决打开数据透视表却找不到设置区域的问题
8.3.3 如何重命名字段标题
8.3.4 在数据透视表中对编号进行排序
8.3.5 将数据透视表转换为普通表格
Chapter09 导入、分析与处理数据
9.1 制作现金流量表
9.1.1 导入现金流量表的数据
9.1.2 分析现金流量表
9.1.3 使用图表查看数据
9.2 制作楼盘销售统计表
9.2.1 制作楼盘销售统计表
9.2.2 使用规划求解计算
9.3 分析房贷表
9.3.1 使用模拟运算
9.3.2 保护房贷表
9.4 技高一筹--实用操作技巧
9.4.1 将Access数据导入Excel工作表
9.4.2 将公司网站数据导入工作表
9.4.3 导入来自文本中的数据
9.4.4 在Excel中插入演示文稿
9.4.5 在Excel中编辑演示文稿
Chapter10 宏与VBA的应用
10.1 制作工资管理系统
10.1.1 创建员工工资表
10.1.2 制作工资表简易查询系统
10.1.3 使用列表对员工工资表进行分析
10.1.4 制作与打印工资条
10.2 制作财务登录系统
10.2.1 宏的应用
10.2.2 建立用户登录界面
10.3 技高一筹--实用操作技巧
10.3.1 使用VLOOKUP函数制作工资条
10.3.2 添加"开发工具"选项卡
10.3.3 如何设置允许案例中的程序
10.3.4 显示隐藏的工作表
10.3.5 保护编写的程序代码

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