excel 基本函数_Excel用户的14种基本技能

excel 基本函数

If you use Excel at work, or list it on your résumé, what tasks should you be able to do? Are there basic skills for Excel users that office workers should be able to perform with little or no help?

如果您在工作中使用Excel或在简历中列出它，那么您应该能够执行哪些任务？ 对于Excel用户，有没有上班族应该在很少或没有帮助的情况下就能执行的基本技能？

Excel用户基本技能 (Basic Skills for Excel Users)

I'm sure your list is different, but here's mine. Would any of these make your list? There are videos for some of these skills below, and Excel courses that you can take, to improve your skills quickly.

我确定您的清单不一样，但这是我的。 这些都会成为您的清单吗？ 以下是一些其中一些技能的视频，以及您可以参加的Excel课程，以快速提高您的技能。

1. Sum or Count cells, based on one criterion or multiple criteria

   根据一个或多个条件对单元格求和或计数

2. Build a Pivot Table to summarize date

   建立数据透视表以汇总日期

3. Write a formula with absolute and relative references

   用绝对和相对引用编写公式

4. Create a drop down list of options in a cell, for easier data entry

   在单元格中创建选项的下拉列表 ，以简化数据输入

5. Sort a list of text and/or numbers without messing up the data

   在不弄乱数据的情况下对文本和/或数字列表进行排序

6. Create a worksheet formula to look up a specific value in a table

   创建工作表公式以在表中查找特定值

7. Record and modify a simple Excel macro and use it to save time

   记录并修改一个简单的Excel宏，然后使用它来节省时间

8. Design and build a simple worksheet template, such as an order form

   设计和构建简单的工作表模板，例如订单

9. Create an Excel chart from worksheet data

   根据工作表数据创建Excel图表

10. Apply conditional formatting that uses a formula as its rule

    应用以公式为规则的条件格式

11. Nest two or more functions in a formula

    在公式中嵌套两个或多个函数

12. Insert and protect worksheets (and understand the limits of Excel's worksheet protection)

    插入和保护工作表 (并了解Excel工作表保护的限制)

13. Create formulas for simple date and time arithmetic

    创建用于简单日期和时间算术的公式

14. Filter unique items from a list

    从列表中过滤唯一项

Excel用户基本技能-1 (Basic Skills for Excel Users - 1)

This video shows skill number 1 in my list - how to sum numbers based on multiple criteria. This example uses the SUMIFS function to get the total.

该视频在我的列表中显示了技能编号1-如何根据多个条件求和。 本示例使用SUMIFS函数获取总数。

演示地址

Excel用户基本技能-2 (Basic Skills for Excel Users - 2)

This video shows skill number 2 in my list - how to create a pivot table to summarize data in Excel.

该视频显示了清单2中的技能2-如何创建数据透视表以汇总 Excel中的数据 。

演示地址

Excel用户基本技能-4 (Basic Skills for Excel Users - 4)

This video shows skill number 4 in my list - how to create a drop down list in a worksheet cell, with data validation. This makes is easier for people to enter valid information in worksheets

该视频显示了清单4中的技能-如何在工作表单元格中创建下拉列表以及数据验证。 这使人们更容易在工作表中输入有效信息

演示地址

Excel用户基本技能-6 (Basic Skills for Excel Users - 6)

This video shows skill number 6 in my list - look up a specific value in a table. This example uses the VLOOKUP function to return a price for the selected product.

该视频在我的列表中显示了技能编号6-在表格中查找特定值。 本示例使用VLOOKUP函数返回所选产品的价格 。

演示地址

Excel用户基本技能-14 (Basic Skills for Excel Users - 14)

This video shows one of the basic skills for Excel users that you should have. It's skill number 14 in my list - how to filter unique items from a list.

该视频显示了您应该具备的Excel用户基本技能之一。 这是我列表中的14号技能-如何从列表中过滤唯一项。

演示地址

Excel课程 (Excel Courses)

If you want to learn quickly and efficiently, check out these Excel courses that I recommend. Led by Excel experts, this list has training for different skill levels.

如果您想快速有效地学习，请查看我推荐的这些Excel课程。 该列表由Excel专家领导，具有针对不同技能水平的培训。

Excel Skills: Mynda Treacy's Excel Skills course covers all the basics in Excel, and will get you up and running quickly.

Excel技能 ：Mynda Treacy的Excel技能课程涵盖了Excel的所有基础知识，可帮助您快速入门和运行。

Expert Excel: After you've mastered the basics in Excel, enroll in Mynda Treacy's Excel Expert course. The lessons in this course will take you from Intermediate level, to Expert skills.

专家Excel ：掌握了Excel的基础知识之后，请注册Mynda Treacy的Excel专家课程 。 本课程的课程将带您从中级到专家技能。

Pivot Tables: John Michaloudis leads the Xtreme Pivot Table Course -- with 200+ video tutorials, it covers everthing you need to know about pivot tables, and more!

数据透视表 ：John Michaloudis领导Xtreme数据透视表课程 -提供200多个视频教程，涵盖了您需要了解的有关数据透视表的所有内容，以及更多内容！

Dashboards: Learn new skills that could help you advance at work. Mynda Treacy leads a highly-rated Excel Dashboard Course, and registration opens a few times each year. Sign up to be notified, the next time the course is available.

仪表板 ：学习可以帮助您进步工作的新技能。 Mynda Treacy主持了一个高度评价的Excel Dashboard课程 ，并且每年开放几次注册。 注册以在下一次课程可用时得到通知。

Power Query: Expand your Excel skills -- learn Power Query at your own pace, in this online course from experts Ken Puls and Miguel Escobar. The course starts with the Power Query basics, and gradually builds up to advanced techniques. There are 15 modules, broken into 55 videos (over 12 hours of content). See all the course details and sign up now.

Power Query ：扩展您的Excel技能-在此在线课程中，由Ken Ken Puls和Miguel Escobar专家以您自己的步调学习Power Query。 该课程从Power Query基础开始，然后逐步发展为高级技术。 有15个模块，分为55个视频(内容超过12小时)。 查看所有课程详细信息并立即注册 。

翻译自: https://contexturesblog.com/archives/2009/07/13/14-basic-skills-for-excel-users/

excel 基本函数