{{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 2013公式与函数辞典646秘技大全(646秘技大全 全新升级版 附光盘)

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

Excel 2013公式与函数辞典646秘技大全(646秘技大全 全新升级版 附光盘)

{{__(":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
Content Description

《Excel 2013公式与函数辞典646秘技大全(646秘技大全 全新升级版)》共分为12部分,按功能对353个函数进行了彻底解说,包括日期与时间函数、数学与三角函数、统计函数、数据库函数、文本函数、财务函数、逻辑函数、查找与引用函数、信息函数、工程函数和外部函数等11大类函数。但书中并不是单纯地讲解知识点,而是将函数知识与行政、工程、财务、统计等各个领域中的经典实例结合,使读者不仅能学习到函数的操作方法,而且能利用函数提高数据处理、分析和管理的能力。同时《Excel 2013公式与函数辞典646秘技大全(全新升级版)》还包含600多个函数的逆向查找技巧。

Author Description

王国胜,为专业办公专家、专业职场培训师,出版过不少办公畅销书,如《PPT实战技巧精粹辞典(2010超值全彩版)》、《Excel 2010实战技巧精粹辞典》都是全国办公图书的畅销产品;写作认真,案例深入浅出,自身有着丰富的办公实战经验。

Catalogue

SECTION 01 函数的基础知识
函数的基本事项
基础公式
认识公式
输入公式
EXAMPLE 1 输入公式
POINT 引用单元格比直接输入数据更方便
EXAMPLE 2 修改公式
POINT 使用F2键编辑公式
EXAMPLE 3 删除公式
复制公式
EXAMPLE 1 使用自动填充方式复制
POINT 自动填充时的单元格格式
EXAMPLE 2 使用复制命令复制
POINT 错误检查选项
单元格的引用
EXAMPLE 1 相对引用
EXAMPLE 2 绝对引用
EXAMPLE 3 混合引用
EXAMPLE 4 单元格名称的使用
POINT 删除名称
函数基础
认识函数
输入函数
EXAMPLE 1 利用"插入函数"对话框输入函数
POINT 使用"自动求和"按钮求和
POINT 搜索函数
EXAMPLE 2 直接输入函数
参数的修改
EXAMPLE 1 通过公式编辑栏修改
EXAMPLE 2 删除函数
函数的嵌套
EXAMPLE 1 嵌套函数
POINT 直接输入嵌套函数时,发生错误的提示
错误分析
EXAMPLE 1 检查错误选项
POINT 可以忽略的错误
EXAMPLE 2 确认循环引用
POINT 错误检查规则的修订
加载宏的使用
EXAMPLE 1 安装加载宏
POINT 没有安装加载宏,直接输入加载宏中包含的函数
POINT 分析工具库以外的加载宏函数
数组的使用
EXAMPLE 1 使用数组常量
EXAMPLE 2 使用数组公式
POINT 修改或删除数组公式
SECTION 02 日期与时间函数
函数分类
关键点

Chapter 02 使用Word制作图文混排的文档
2.1 制作工作流程图
2.1.1 用SmartArt制作流程图
2.1.2 使用形状工具制作流程图
2.2 制作旅游宣传单页
2.2.1 制作宣传页页头内容
2.2.2 编排正文内容
2.2.3 制作宣传页页尾内容
2.3 制作公司简报
2.3.1 设计简报报头版式
2.3.2 设计简报内容版式
2.3.3 设计简报报尾版式

Chapter 03 使用Word制作带表格的文档
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.3.3 根据表格内容插入图表
3.3.4 美化表格
当前日期
返回当前日期 TODAY
EXAMPLE 1 显示当前日期
组合技巧 表示时间以外的年月日(TODAY+时间函数)
返回当前日期和时间 .NOW
EXAMPLE 1 表示当前日期和时间
周数
返回序列号对应的一年中的周数 .WEEKNUM
EXAMPLE 1 计算剩余周数
POINT 注意跨年度的计算
用序列号表示日期
返回某日期对应的年份 .YEAR
EXAMPLE 1 提取年份
POINT YEAR函数只提取年份信息
组合技巧 计算每年毕业工作的人数(YEAR+COUNTIF)
返回序列号对应的日期中的月份 MONTH
EXAMPLE 1 提取月份
POINT MONTH函数只提取月份信息
返回序列号对应的月份中的天数 .DAY
EXAMPLE 1 提取"某一天"
返回序列号对应的小时数 .HOUR
EXAMPLE 1 提取小时数
返回序列号对应的分钟数 .MINUTE
EXAMPLE 1 提取分钟数
POINT MINUTE函数只提取分钟数
返回序列号对应的秒数 .SECOND
EXAMPLE 1 提取秒数
返回序列号对应的星期几 WEEKDAY
EXAMPLE 1 提取星期数
组合技巧 使用日期表示格式中星期数的名称
组合技巧 表示当前的年月日(NOW+日期函数)
期间差
计算起始日和结束日间的天数(除星期六、日和节假日) NETWORKDAYS
EXAMPLE 1 从开始日和结束日中求除去假期的工作日
按照一年360天的算法,返回两日期间相差的天数 DAYS360
EXAMPLE 1 用NASD方式求到结束日的天数
计算两个日期之间的天数 DAYS
EXAMPLE 1 计算两个日期之间的间隔
POINT 相似函数比较
从开始日到结束日间所经过天数占全年天数的比例 .YEARFRAC
EXAMPLE 1 计算所经过天数的比例
用指定的单位计算起始日和结束日之间的天数 .DATEDIF
EXAMPLE 1 用年和月求起始日和结束日之间的天数
计算时间的序列号
计算出指定月数之前或之后的日期 .EDATE
EXAMPLE 1 算出指定月数后的日期
POINT EDATE函数计算第几个月后的相同日
返回指定月最后一天的序列号 EOMONTH
EXAMPLE 1 算出指定月的月末日
POINT EOMONTH函数
返回指定工作日后的日期 WORKDAY
EXAMPLE 1 计算工作日

Chapter 05 使用Excel制作普通工作表
5.1 制作员工能力考核表
5.1.1 创建表格内容
5.1.2 设置表格内容格式
5.1.3 为表格添加边框
5.2 制作员工通讯录
5.2.1 输入通讯录内容
5.2.2 编辑通讯录表格
5.2.3 查找和替换通讯录内容
5.2.4 打印员工通讯录
5.3 制作员工档案表
5.3.1 输入并设置员工基本信息
5.3.2 设置表格样式
5.3.3 建立超链接
使用Excel函数进行数据运算

Chapter 06
6.1 制作员工培训成绩统计表
6.1.1 使用公式输入数据
6.1.2 使用基本公式进行计算
6.1.3 计算名次
6.1.4 统计员工参考人数
6.2 制作员工工资单
6.2.1 设置工资表格式
6.2.2 计算员工工资相关数据
6.2.3 制作工资查询表
6.2.4 设置工资表页面
6.2.5 制作并打印工资条
6.3 制作万年历
6.3.1 使用函数录入日期
6.3.2 美化万年历
计算时间的序列号
计算出指定月数之前或之后的日期 .EDATE
EXAMPLE 1 算出指定月数后的日期
POINT EDATE函数计算第几个月后的相同日
返回指定月最后一天的序列号 .EOMONTH
EXAMPLE 1 算出指定月的月末日
POINT EOMONTH函数
返回指定工作日后的日期 WORKDAY
EXAMPLE 1 计算工作日
特定日期的
序列号
求以年、月、日表示的日期的序列号 DATE
EXAMPLE 1 求以年、月、日表示的序列号
组合技巧 显示2个月后的日期(DATE +计算式)
POINT 在单元格中直接输入函数公式
返回某一特定时间的序列号 .TIME
EXAMPLE 1 返回某一特定时间的序列号
将日期值从字符串转换为序列号 DATEVALUE
EXAMPLE 1 将日期值从字符串转换为序列号
将表示时间的文本转换为序列号
EXAMPLE 1 将时间文本转换为序列号进行计算

SECTION 03 数学与三角函数
SECTION 04 统计函数
SECTION 05 数据库函数
SECTION 06 文本函数
SECTION 07 财务函数
SECTION 08 逻辑函数
SECTION 09 查找与引用函数
SECTION 10 信息函数
SECTION 11 工程函数
SECTION 12 外部函数

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