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图表·公式·函数·数据分析从新手到高手（超值全彩版附光盘）

View Cart & Check Out

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

Books Computers & Internet Office Software

Jingdong book

Excel图表·公式·函数·数据分析从新手到高手（超值全彩版附光盘）

Name: Excel图表·公式·函数·数据分析从新手到高手（超值全彩版 附光盘）
Brand: Jingdong book
SKU: 3118156721
Price: 43.28 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图表、公式、函数、数据分析从新手到高手》就是让你不加班，轻轻松松高效完成各项办公事务！

通过对日常办公案例的详细讲解，配合完整的视频教学，让你从中掌握Excel 公式、函数、图表、数据分析4大功能包含的丰富实用知识点和应用技能。学习本书后，让你从一个办公操作的新手，华丽变身为大家羡慕的办公高手，走向高薪之路，与“加班”say goodbye！
《Excel图表·公式·函数·数据分析从新手到高手（超值全彩版）》适用于被处理办公文件搞得头昏眼花的HR苦佬；经常熬夜加班、被领导批评的行政人员；工资顽固性低下的销售、财务等商务办公仔。

《Excel 图表.公式.函数.数据分析从新手到高手（畅销升级版附光盘）》

更多精彩，点击进入品牌店查阅>>

Content Description

第01-04章：主要介绍了Excel的工作界面、数据的输入与编辑、数据有效性的设置、工作簿/表的操作、行/列的插入与删除、行高与列宽的调整、单元格的选择、插入、删除、合并，以及单元格的格式化操作等知识。
第05-06章：主要介绍了公式的输入与编辑、函数的应用基础，举例介绍了常见运算函数、财务函数、日期与时间函数、逻辑函数、信息函数的使用，以及函数的嵌套使用。
第07-08章：主要介绍了数据的基本排序、特殊排序、随机排序的操作方法，数据的自动筛选、自定义筛选和高级筛选的操作方法，数据的分类汇总与合并计算的操作方法，以及数据透视表/图的创建、删除、设置等操作方法。
第09-11章：主要介绍了剪贴画与图片的应用、SmartArt图形的应用、艺术字的应用、文本框的应用、图表的创建、编辑与美化以及工作表的打印等。
第12-14章：主要介绍了Excel在行政文秘办公、人力资源管理以及市场营销中的应用。

Catalogue

Chapter 01 Excel2010快速入门
1.1 Excel 2010概述
1.1.1 Excel 的应用领域
1.1.2 Excel 2010的新特性
1.1.3 Excel 2010的启动与退出
1.2 认识Excel 2010的操作界面
1.2.1 标题栏
1.2.2 功能区
1.2.3 编辑栏
1.2.4 工作表区
1.2.5 状态栏
1.2.6 自定义Excel工作界面
1.3 Excel的三大元素
1.3.1工作薄
1.3.2工作表
1.3.3单元格
1.4 Excel的视图应用
1.4.1 普通视图
1.4.2 页面布局视图
1.4.3 分页预览视图
1.4.4 全屏显示视图
1.5 认识“Excel选项”对话框
1.6 综合实例：使用“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.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.5.1 查找数据
2.5.2 替换数据
2.6 文本批注
2.6.1 插入批注
2.6.2 编辑批注
2.7 保存工作簿
2.7.1 保存新建工作簿
2.7.2 另存为工作簿
2.7.3 保存当前工作窗口布局
2.7.4 设置自动保存
综合实例：创建员工信息表内容
Chapter 03 工作表编辑与格式化
3.1 单元格的基本操作
3.1.1 插入行与列
3.1.2 更改行高与列宽
3.1.3 删除多余的行和列
3.1.4 合并与拆分单元格
3.1.5 隐藏行与列
3.1.6 单元格的隐藏和锁定
3.2 设置单元格格式
3.2.1 设置数据类型
3.2.2 设置对齐方式
3.2.3 设置字体字号
3.2.4 设置自动换行
3.2.5 为单元格添加背景色
3.2.6 使用格式刷复制单元格格式
3.3 使用单元格样式
3.3.1 快速设置单元格样式
3.3.2 修改单元格样式
3.3.3 自定义单元格样式
3.3.4 合并样式
3.4 套用表格格式
3.4.1 套用格式
3.4.3 自定义样式
3.4.3 撤销套用的样式
综合案例：设置员工信息表格式
Chapter 04 工作表与工作簿的管理
4.1 工作表的基本操作
4.1.1 新建工作表
4.1.2 选择工作表
4.1.3 重命名工作表
4.1.4 删除工作表
4.1.5 移动与复制工作表
4.1.6 隐藏与显示工作表
4.1.7 更改工作表标签颜色
4.1.8 工作表背景的添加与设置
4.2 管理工作簿
4.2.1 打开工作薄
4.2.2 关闭工作簿
4.2.3 保护工作簿
4.2.4 拆分工作簿窗口
4.2.5 冻结窗格
4.2.6 切换工作簿窗口
4.2.7 重排工作簿窗口
4.2.8 新建工作簿窗口
4.2.9 并排查看
4.2.8 隐藏工作簿窗口
4.2.10 共享工作簿
综合案例：编辑员工入职安排表
Chapter 05 体验公式的应用
5.1 认识公式
5.1.1 理解运算符
5.1.2 公式运算的次序
5.1.3 公式的结构
5.1.4 公式的输入
5.1.5 编辑复制公式
5.2 引用样式
5.2.1 相对引用
5.2.2 绝对引用
5.2.3 混合引用
5.3 引用其他工作表数据
5.3.1 引用同一工作簿中工作表的数据
5.3.2 引用不同工作簿中工作表的数据
5.4 数组公式及其应用
5.4.1 创建数组公式
5.4.2 使用数组公式的规则
5.5 公式中常见的错误值
5.5.1 #DIV/0!错误值
5.5.2 #N/A错误值
5.5.3 #NAME?错误值
5.5.4 #REF!错误值
5.5.5 #VALUE!错误值
5.6 公式审核
5.6.1 显示公式
5.6.2 检查错误公式
5.6.3 追踪引用和从属单元格
综合案例：制作员工培训成绩统计表
Chapter 06 使用函数计算数据
6.1 函数基础入门
6.1.1 什么是函数
6.1.2 函数的类型
6.2 常用函数的使用
6.2.1 SUM函数
6.2.2 AVERAGE函数
6.2.3 MAX/MIN函数
6.2.4 RAND函数
6.2.5 IF函数
6.3 财务函数的使用
6.3.1 PMT函数
6.3.2 PV函数
6.3.3 FV函数
6.3.4 DB函数
6.3.5 SLN函数
6.4 日期与时间函数的使用
6.4.1 YEAR函数
6.4.2 MONTH函数
6.4.3 DAY函数
6.4.4 NOW函数
6.5 逻辑函数的使用
6.5.1 AND函数
6.5.2 OR函数
6.5.2 NOT函数
6.6 信息函数的使用
6.6.1 CELL函数
6.6.2 TYPE函数
6.7 输入与修改函数
6.7.1 输入函数
6.7.2 修改函数
6.7.3 函数的嵌套使用
综合案例：制作学生成绩统计表
Chapter 07 数据管理与分析
Chapter 08 数据的动态统计分析
Chapter 09 工作表的美化
Chapter 10 图表的应用
Chapter 11 页面设置与打印
Chapter 12 Excel在行政文秘办公中的应用
Chapter 13 Excel在人力资源管理中的应用
Chapter 14 Excel在市场营销中的应用
附录
附录A：Excel常用函数查询
附录B：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

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图表·公式·函数·数据分析从新手到高手（超值全彩版 附光盘）

《Excel 图表.公式.函数.数据分析从新手到高手（畅销升级版 附光盘）》

Excel图表·公式·函数·数据分析从新手到高手（超值全彩版附光盘）

《Excel 图表.公式.函数.数据分析从新手到高手（畅销升级版附光盘）》