|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/everyday-excel-part-1
课程评论：没有评论
课程名称：日常Excel基础，第一部分 课程概述：“日常Excel基础，第一部分”旨在帮助学习者从零基础开始学习Excel。无论是Excel的新手还是高级用户，都能在本课程中获得新技能和工具。本课程是三部分系列和专业化课程的第一部分，涵盖了从基础到高级的Excel技术和工具。在这一部分中，您将学习：1）如何有效导航Excel环境；2）编辑和格式化Excel工作表；3）实施基础到高级的Excel函数（包括财务、逻辑和文本函数）；4）管理数据集（筛选、删除重复项、整合数据、排序和数据验证）；5）通过散点图、柱形图和饼图有效可视化数据。 即使您对Excel完全陌生也没有关系！该课程旨在让学习过程有趣，富有启发性，适合广大受众。无需编程或高等数学技能，课程分为5周（模块）。每个模块需通过掌握测验和完成问题解决作业。 课程内容大纲： 1. **导航Excel**：学习基本工作表导航，打开和保存Excel文件，了解工作表和工作簿的区别，掌握快捷键和编辑格式技能等。 2. **表达式输入和常用Excel函数**：学习Excel语法，运算顺序，输入数学公式和基本内置函数（如求和、计数、平均等）。 3. **更多Excel函数**：深入学习逻辑函数（如IF、AND、OR）和金融函数，以及如何使用数组公式和创建自定义函数。 4. **数据管理**：掌握如何应用筛选，创建Excel表格，验证数据，去重和整合数据，以及使用查找函数（如VLOOKUP）。 5. **绘图、导入数据及转换文件类型**：学习数据可视化原则，使用不同图表（散点图、柱形图和饼图），以及如何共享和打印工作表。 完成每一个模块后，您需要通过测验和完成在电脑中进行的作业。当成功完成所有要求后，您将获得课程证书。祝您好运，学习愉快！
Name:Navigating Excel
Description:In Week 1, you will learn basic worksheet navigation, how to open and save Excel files, and all about worksheets and workbooks. You will learn the difference between cells, columns, and rows in Excel, as well as cell references. You will learn how to move around the worksheet effectively using shortcut key combinations, and you will learn how to edit the worksheet. You will also learn how to format cells, conditionally format cells, and how to change between number, text, date, currency, and other cell formatting options. There will be particular emphasis on relative vs. absolute cell addressing modes and you will learn how to name cells and cell ranges. You will be introduced to basic macro recording using VBA and you will learn how to set personal preferences in Excel. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. The Week 2 material will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!
Name:Expression Entry and Common Excel Functions
Description:In Week 2 you will learn about how to properly write Excel syntax. You will learn the order of operations, how to input mathematical formulas into Excel, and how to troubleshoot when things don't go as expected. You will be introduced to just a few of the thousands of built in functions in Excel. The functions that you will learn about in this module relate to summing, counting, averaging, how to round numbers and calculate remainders, random number generation, and combinations and permutations. Week 2 concludes with a quiz and an on-computer, in-application assignment. Upon successful completion of these items, the Week 3 material will be unlocked. Good luck and have fun!
Name:More Excel functions
Description:In Week 3, you will learn more advanced functions in Excel. These include logical functions (IF, AND, OR) and advanced logical functions (SUMIF, COUNTIF, AVERAGEIF). You will learn how to effectively use Auto Fill and Fill Series but then I explain how to use text functions, which overcome some of the limitations of the Auto Fill feature. You will be introduced to Excel's financial functions (many more financial functions will be covered in Part 2 of the course), and you will learn how to use array formulas in Excel. Finally, I show how you can create your own user-defined function in VBA. Week 3 concludes with a quiz and on-computer, in-application assignment. When completed successfully, the Week 4 material will be released. Good luck!
Name:Managing Data
Description:Week 4 really gets at the heart of why Excel is so great for managing data. You will learn how to apply a filter, how to create an Excel Table, and how to validate data (for example, by only allowing items in a drop-down list). You will learn how to sort data, how to clean up data prior to using, how to remove duplicates in your data, and how to consolidate data from multiple sources. Finally you will learn how to use one-way lookup functions in Excel (VLOOKUP and the INDEX/MATCH combination). Quiz 4 and the on-computer, in-application Assignment 4 will test your understanding of the material in Week 4. Once you've completed these assessments, the Week 5 material will be unlocked. Good luck and have fun!
Name: Plotting, Importing Data, and Converting to Other File Types
Description:Week 5 is all about data visualization. You will learn the differences between and how to use scatter plots, column charts, and pie charts. You will be introduced to Pivot Tables, Slicers, and Sparklines, which all represent different and exciting ways to visualize your data. I will show you how to share data (embed vs. linking) with Word and PowerPoint as well as how to print your worksheets and how to convert them to .pdf documents. Like the other modules, Week 5 concludes with a quiz and an on-computer, in-application assignment. When you've completed those assessments, you will earn the Course Certificate! Good luck!
"Everyday Excel, Part 1" is aimed at learners who are seeking to learn Excel from the ground up. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools. This course is the first part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 1), you will: 1) learn how to effectively navigate around the Excel environment; 2) edit and format Excel worksheets; 3) implement basic to advanced Excel functions (including financial, logical, and text functions); 4) learn how to manage data sets (filter, remove duplicates, consolidate data, sort data, and validate data); and 5) learn how to effectively visualize data through scatterplots, column charts, and pie charts. New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. No prior knowledge in programming nor advanced math skills are necessary. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.
