Excel高效办公应用与技巧大全（视频教程+彩色印刷）excel教程办公软件wps谁说菜鸟不会数据分析函数与公式excel应用大全office
在工作中，是否经常面对如下问题：
• 工作任务堆积如山，别人使用Excel 工作很高效、很专业，我怎么不行？
• 使用Excel 处理数据时，总是遇到这样那样的问题，百度搜索多遍，依然找不到需要的答案，怎么办？
• 想成为Excel 办公高手，要把数据处理与分析工作及时、高效地做好，却不懂一些Excel办公技巧，怎么办？
• 工作方法有讲究，提高效率有捷径。通过对本书的学习，了解一些Excel 办公技巧，可以让你在工作中节省很多时间，解除你工作中的烦恼，让你少走许多弯路！
花一本书的钱，买到的不仅仅是一本书，而是一套超值的综合学习套餐，内容包括：图书 同步学习素材 同步视频教程 办公模板 《电脑入门***技能手册》 Office 快速入门视频教程 《Office 办公应用快捷键速查表》。多维度学习套餐，真正超值实用！
1 同步视频教程。配有与书同步的高质量、超清晰的多媒体视频教程，时长达12 小时，扫描书中二维码，即可使用手机同步学习。
2 同步学习素材。提供了书中所有案例的素材文件，方便读者跟着书中讲解同步练习操作。
3 赠送：1000 个Office 商务办公模板文件，包括Word 模板、Excel 模板、PPT 模板文件，拿来即用，不用再去花时间与精力搜集整理。
4 赠送：《电脑入门***技能手册》，即使不懂计算机，也可以通过本手册的学习，掌握计算机入门技能，更好地学习Office 办公应用技能。
5 赠送：3 小时的Office 快速入门视频教程，即使一点基础都没有，也不用担心学不会，学完此视频就能快速入门。
6 赠送：《Office 办公应用快捷键速查表》，快速提高办公效率。
Excel 是微软公司开发的Office 办公软件中的电子表格软件，它具有强大的数据统计与分析功能，被广泛地应用于日常工作中，尤其对市场销售、财务会计、人力资源、行政文秘等相关岗位来说，更是必不可少的得力助手。本书系统、全面地讲解了Excel 在日常办公中的应用技巧。在内容安排上，本书*的特点就是在指导读者做到“会用”的基础上，重在传教如何“用好”Excel 来进行高效办公。
《Excel 高效办公应用与技巧大全》共分为17 章，内容包括Excel 的基本操作与设置技巧，工作簿与工作表的管理技巧，表格数据的录入与编辑技巧，工作表的格式设置技巧，公式的应用技巧，函数（常用函数、财务函数、数学函数、日期与时间函数、文本函数、逻辑函数、统计函数、查找函数等）的应用技巧，数据和排序与筛选应用技巧，数据分析、预测与汇总技巧，使用图表分析数据的技巧，数据透视表与数据透视图的应用技巧，宏与VBA 的使用技巧，以及Excel 页面设置与打印技巧。
本书内容系统全面，案例丰富，可操作性强。全书结合微软Excel 常用版本（如Excel 2007、2010、2013、2016），以技巧罗列的形式进行编写，非常适合读者阅读与查询使用，是不可多得的职场办公***案头工具书。
本书非常适合读者自学使用，尤其适合对Excel 软件使用技巧缺少经验的读者学习使用，也可以作为大、中专职业院校计算机相关专业的教学参考用书。
IT 新时代教育由一线办公专家和多位 MVP（微软全球有价值专家）教师合作组成，他们具有丰富的Office 软件应用技巧和办公实战经验，对于他们的辛苦付出在此表示衷心的感谢！
Excel 的基础操作技巧
1.1优化 Excel 的工作环境
001 在快速访问工具栏中添加常用工具按钮
002 将常用命令按钮添加到快速访问工具栏
003 在工具栏添加新的选项卡
004 快速显示或隐藏功能区
005 将功能区同步到其他计算机
006 更改Enter 键的功能
007 设置Excel 近使用的文档个数
008 更改工作簿的默认保存路径
009 更改新建工作簿的默认字体与字号
010 更改Excel 的默认工作表数量
011 将常用工作簿固定在近使用列表中
在工作中，是否经常面对如下问题：
工作任务堆积如山，别人使用Excel 工作很高效、很专业，我怎么不行？
使用Excel 处理数据时，总是遇到这样那样的问题，百度搜索多遍，依然找不到需要的答案，怎么办？
想成为Excel 办公高手，要把数据处理与分析工作及时、高效地做好，却不懂一些Excel办公技巧，怎么办？
工作方法有讲究，提高效率有捷径。通过对本书的学习，了解一些Excel 办公技巧，可以让你在工作中节省很多时间，解除你工作中的烦恼，让你少走许多弯路！
本书内容
Shipping Overview:
• Shipping: Standard Domestic Shipping within the United States charges USD 4.99. Standard International Shipping from United Kingdom, Germany and Japan to the United States charges 14.99.
• Order Processing: Please allow 1-2 business days for order processing and preparation before shipment.
• Domestic Shipping: Orders within the U.S. are shipped via USPS or FedEx, depending on the origin of the product. The average transit time is 3-7 business days.
• International Shipping: Currently, we only ship within the USA.
• Tracking Information: Every order is trackable. You will receive a tracking number once your order has been shipped. Products may be shipped from various global fulfillment centers.
Shipping Delays:
Please note that shipping times may vary due to factors beyond our control, such as weather conditions, natural disasters, or peak holiday periods. While we strive to ensure timely delivery, the exact arrival time cannot be guaranteed and is managed by the shipping carrier.
Shipping Options:
-
Standard Delivery: Most orders are shipped within 3-7 business days. Larger items may utilize LTL shipping for safe handling.
-
Handling Time: We handle shipments on business days (Monday - Friday), with a preparation time of 1-2 days.
-
Additional Charges: Some items require additional shipping charges due to their size, weight, or special handling. These charges are specified on the product pages and are not eligible for shipping discounts.
-
Exclusions: Gift cards, packaging, taxes, and prior purchases do not count toward the minimum purchase requirement for free shipping. This offer is valid only for shipments to U.S. addresses, including Puerto Rico.
Delivery Details:
-
Estimates: Standard shipping within the US typically takes 3-7 business days. These are estimates and not guarantees.
-
Shipping Restrictions: We ship to all 50 states, Washington, DC, U.S. territories, and APO/FPO/DPO addresses. Shipping options vary based on the delivery address.
-
Remote Areas: Shipments to remote areas may incur additional charges or require pickup from a nearby shipping partner’s location.
Shipping Confirmation:
You will receive a shipping confirmation email with a tracking number as soon as your order is dispatched. If you do not receive this email immediately, please be assured that your items will arrive within the estimated delivery window provided at checkout.
Order Modifications:
If you need to cancel or modify your order, please contact our customer support immediately.
Issues with Delivery:
If your order shows as delivered but you have not received it, please contact the shipping carrier directly to resolve the issue. For persistent problems, contact our customer service at cs@everymarket.com.
Customer Support:
Our team is available 24/7 to assist you with any questions or concerns regarding your order. We are committed to ensuring a smooth shopping experience.
Return & Refund Policy Overview
Please review our return and refund policies below to ensure a smooth transaction process.
Return Policy
-
Duration: You have 30 days from receiving your item to initiate a return.
-
Condition: Items must be unworn, unwashed, with original tags and packaging intact.
-
Shipping Costs: Customers are responsible for return shipping costs.
-
Packaging: Ensure returned items are well-packaged to avoid damage during transit.
-
Tracking: Use a trackable and insured shipping method as we are not liable for items lost or damaged on return.
-
Initiating a Return: Contact us at cs@everymarket.com to start your return. We will provide a return shipping label and instructions upon approval. Returns without prior approval will not be accepted.
How to Return
-
Method: Returns must be sent back by mail to the address provided in the return instructions.
Return Label
-
Defective Products: Return labels are provided for defective items.
-
Non-Defective Returns: Customers are responsible for obtaining their return shipping label.
Product Conditions for Return
-
Eligible Products: Returns are only accepted for items in new condition.
Nonreturnable Items
Certain items are not eligible for return:
-
Electronic devices after 30 days (e.g., computers, laptops, Kindles)
-
Gift cards, prepaid game cards
-
Perishable goods, live insects, some jewelry, some health and personal care items
-
Customized or personalized products
-
Items with special shipping restrictions
Refund Policy
-
Window: Eligible products may be returned within 30 days of delivery for a refund.
-
Refund Method: Refunds are processed to the original payment method or as store credit for items purchased with gift cards.
-
Processing Time: Refunds are processed within 3-5 business days after we receive the return; please allow additional time for shipping and bank processing.
Claims
Inspect your order upon arrival and report any defects, damages, or incorrect items immediately to allow us to address the issue. For claims, contact our support team with details of the issue.
Exchange Policy
For the quickest service, return your original item and place a new order for the desired product once your return is accepted.
Return Address
EveryMarket Customer Service 2101 E Terra Ln, O'Fallon, MO 63366
Customer Support
Available 24/7 for any questions or assistance needed:
-
Phone: +1 636-312-5925
-
Email: cs@everymarket.com
在工作中，是否经常面对如下问题：
• 工作任务堆积如山，别人使用Excel 工作很高效、很专业，我怎么不行？
• 使用Excel 处理数据时，总是遇到这样那样的问题，百度搜索多遍，依然找不到需要的答案，怎么办？
• 想成为Excel 办公高手，要把数据处理与分析工作及时、高效地做好，却不懂一些Excel办公技巧，怎么办？
• 工作方法有讲究，提高效率有捷径。通过对本书的学习，了解一些Excel 办公技巧，可以让你在工作中节省很多时间，解除你工作中的烦恼，让你少走许多弯路！
花一本书的钱，买到的不仅仅是一本书，而是一套超值的综合学习套餐，内容包括：图书 同步学习素材 同步视频教程 办公模板 《电脑入门***技能手册》 Office 快速入门视频教程 《Office 办公应用快捷键速查表》。多维度学习套餐，真正超值实用！
1 同步视频教程。配有与书同步的高质量、超清晰的多媒体视频教程，时长达12 小时，扫描书中二维码，即可使用手机同步学习。
2 同步学习素材。提供了书中所有案例的素材文件，方便读者跟着书中讲解同步练习操作。
3 赠送：1000 个Office 商务办公模板文件，包括Word 模板、Excel 模板、PPT 模板文件，拿来即用，不用再去花时间与精力搜集整理。
4 赠送：《电脑入门***技能手册》，即使不懂计算机，也可以通过本手册的学习，掌握计算机入门技能，更好地学习Office 办公应用技能。
5 赠送：3 小时的Office 快速入门视频教程，即使一点基础都没有，也不用担心学不会，学完此视频就能快速入门。
6 赠送：《Office 办公应用快捷键速查表》，快速提高办公效率。
Excel 是微软公司开发的Office 办公软件中的电子表格软件，它具有强大的数据统计与分析功能，被广泛地应用于日常工作中，尤其对市场销售、财务会计、人力资源、行政文秘等相关岗位来说，更是必不可少的得力助手。本书系统、全面地讲解了Excel 在日常办公中的应用技巧。在内容安排上，本书*的特点就是在指导读者做到“会用”的基础上，重在传教如何“用好”Excel 来进行高效办公。
《Excel 高效办公应用与技巧大全》共分为17 章，内容包括Excel 的基本操作与设置技巧，工作簿与工作表的管理技巧，表格数据的录入与编辑技巧，工作表的格式设置技巧，公式的应用技巧，函数（常用函数、财务函数、数学函数、日期与时间函数、文本函数、逻辑函数、统计函数、查找函数等）的应用技巧，数据和排序与筛选应用技巧，数据分析、预测与汇总技巧，使用图表分析数据的技巧，数据透视表与数据透视图的应用技巧，宏与VBA 的使用技巧，以及Excel 页面设置与打印技巧。
本书内容系统全面，案例丰富，可操作性强。全书结合微软Excel 常用版本（如Excel 2007、2010、2013、2016），以技巧罗列的形式进行编写，非常适合读者阅读与查询使用，是不可多得的职场办公***案头工具书。
本书非常适合读者自学使用，尤其适合对Excel 软件使用技巧缺少经验的读者学习使用，也可以作为大、中专职业院校计算机相关专业的教学参考用书。
IT 新时代教育由一线办公专家和多位 MVP（微软全球有价值专家）教师合作组成，他们具有丰富的Office 软件应用技巧和办公实战经验，对于他们的辛苦付出在此表示衷心的感谢！
Excel 的基础操作技巧
1.1优化 Excel 的工作环境
001 在快速访问工具栏中添加常用工具按钮
002 将常用命令按钮添加到快速访问工具栏
003 在工具栏添加新的选项卡
004 快速显示或隐藏功能区
005 将功能区同步到其他计算机
006 更改Enter 键的功能
007 设置Excel 近使用的文档个数
008 更改工作簿的默认保存路径
009 更改新建工作簿的默认字体与字号
010 更改Excel 的默认工作表数量
011 将常用工作簿固定在近使用列表中
在工作中，是否经常面对如下问题：
工作任务堆积如山，别人使用Excel 工作很高效、很专业，我怎么不行？
使用Excel 处理数据时，总是遇到这样那样的问题，百度搜索多遍，依然找不到需要的答案，怎么办？
想成为Excel 办公高手，要把数据处理与分析工作及时、高效地做好，却不懂一些Excel办公技巧，怎么办？
工作方法有讲究，提高效率有捷径。通过对本书的学习，了解一些Excel 办公技巧，可以让你在工作中节省很多时间，解除你工作中的烦恼，让你少走许多弯路！
本书内容
Shipping Overview:
• Shipping: Standard Domestic Shipping within the United States charges USD 4.99. Standard International Shipping from United Kingdom, Germany and Japan to the United States charges 14.99.
• Order Processing: Please allow 1-2 business days for order processing and preparation before shipment.
• Domestic Shipping: Orders within the U.S. are shipped via USPS or FedEx, depending on the origin of the product. The average transit time is 3-7 business days.
• International Shipping: Currently, we only ship within the USA.
• Tracking Information: Every order is trackable. You will receive a tracking number once your order has been shipped. Products may be shipped from various global fulfillment centers.
Shipping Delays:
Please note that shipping times may vary due to factors beyond our control, such as weather conditions, natural disasters, or peak holiday periods. While we strive to ensure timely delivery, the exact arrival time cannot be guaranteed and is managed by the shipping carrier.
Shipping Options:
-
Standard Delivery: Most orders are shipped within 3-7 business days. Larger items may utilize LTL shipping for safe handling.
-
Handling Time: We handle shipments on business days (Monday - Friday), with a preparation time of 1-2 days.
-
Additional Charges: Some items require additional shipping charges due to their size, weight, or special handling. These charges are specified on the product pages and are not eligible for shipping discounts.
-
Exclusions: Gift cards, packaging, taxes, and prior purchases do not count toward the minimum purchase requirement for free shipping. This offer is valid only for shipments to U.S. addresses, including Puerto Rico.
Delivery Details:
-
Estimates: Standard shipping within the US typically takes 3-7 business days. These are estimates and not guarantees.
-
Shipping Restrictions: We ship to all 50 states, Washington, DC, U.S. territories, and APO/FPO/DPO addresses. Shipping options vary based on the delivery address.
-
Remote Areas: Shipments to remote areas may incur additional charges or require pickup from a nearby shipping partner’s location.
Shipping Confirmation:
You will receive a shipping confirmation email with a tracking number as soon as your order is dispatched. If you do not receive this email immediately, please be assured that your items will arrive within the estimated delivery window provided at checkout.
Order Modifications:
If you need to cancel or modify your order, please contact our customer support immediately.
Issues with Delivery:
If your order shows as delivered but you have not received it, please contact the shipping carrier directly to resolve the issue. For persistent problems, contact our customer service at cs@everymarket.com.
Customer Support:
Our team is available 24/7 to assist you with any questions or concerns regarding your order. We are committed to ensuring a smooth shopping experience.
Return & Refund Policy Overview
Please review our return and refund policies below to ensure a smooth transaction process.
Return Policy
-
Duration: You have 30 days from receiving your item to initiate a return.
-
Condition: Items must be unworn, unwashed, with original tags and packaging intact.
-
Shipping Costs: Customers are responsible for return shipping costs.
-
Packaging: Ensure returned items are well-packaged to avoid damage during transit.
-
Tracking: Use a trackable and insured shipping method as we are not liable for items lost or damaged on return.
-
Initiating a Return: Contact us at cs@everymarket.com to start your return. We will provide a return shipping label and instructions upon approval. Returns without prior approval will not be accepted.
How to Return
-
Method: Returns must be sent back by mail to the address provided in the return instructions.
Return Label
-
Defective Products: Return labels are provided for defective items.
-
Non-Defective Returns: Customers are responsible for obtaining their return shipping label.
Product Conditions for Return
-
Eligible Products: Returns are only accepted for items in new condition.
Nonreturnable Items
Certain items are not eligible for return:
-
Electronic devices after 30 days (e.g., computers, laptops, Kindles)
-
Gift cards, prepaid game cards
-
Perishable goods, live insects, some jewelry, some health and personal care items
-
Customized or personalized products
-
Items with special shipping restrictions
Refund Policy
-
Window: Eligible products may be returned within 30 days of delivery for a refund.
-
Refund Method: Refunds are processed to the original payment method or as store credit for items purchased with gift cards.
-
Processing Time: Refunds are processed within 3-5 business days after we receive the return; please allow additional time for shipping and bank processing.
Claims
Inspect your order upon arrival and report any defects, damages, or incorrect items immediately to allow us to address the issue. For claims, contact our support team with details of the issue.
Exchange Policy
For the quickest service, return your original item and place a new order for the desired product once your return is accepted.
Return Address
EveryMarket Customer Service 2101 E Terra Ln, O'Fallon, MO 63366
Customer Support
Available 24/7 for any questions or assistance needed:
-
Phone: +1 636-312-5925
-
Email: cs@everymarket.com
Oops!
Sorry, it looks like some products are not available in selected quantity.