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课程,以快速提高您的技能。
Sum or Count cells, based on one criterion or multiple criteria
根据一个或多个条件对单元格求和或计数
Build a Pivot Table to summarize date
Write a formula with absolute and relative references
用绝对和相对引用编写公式
Create a drop down list of options in a cell, for easier data entry
Sort a list of text and/or numbers without messing up the data
在不弄乱数据的情况下对文本和/或数字列表进行排序
Create a worksheet formula to look up a specific value in a table
Record and modify a simple Excel macro and use it to save time
记录并修改一个简单的Excel宏,然后使用它来节省时间
Design and build a simple worksheet template, such as an order form
设计和构建简单的工作表模板,例如订单
Create an Excel chart from worksheet data
根据工作表数据创建Excel图表
Apply conditional formatting that uses a formula as its rule
应用以公式为规则的条件格式
Nest two or more functions in a formula
在公式中嵌套两个或多个函数
Insert and protect worksheets (and understand the limits of Excel's worksheet protection)
插入和保护工作表 (并了解Excel工作表保护的限制)
Create formulas for simple date and time arithmetic
创建用于简单日期和时间算术的公式
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 基本函数