|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-access-from-a-to-z-for-work/
课程评论：没有评论
Coursera 课程《Excel & Access：从 A 到 Z 入门工作》课程总结 本课程分为两大部分，全面涵盖了Microsoft Excel和Microsoft Access的使用技巧，旨在帮助学员从初学者进阶到能够熟练处理工作中的数据管理任务。 **第一部分：Microsoft Excel (章节 1-15)** 本部分内容由浅入深，覆盖Excel的方方面面。学员将学习： * **基础操作**：创建和编辑表格、保存文件等。 * **核心函数**：掌握SUM、AVERAGE、COUNT、IF、SUMIF、SUMIFS等常用函数，以及OFFSET、VLOOKUP、HLOOKUP、INDEX & MATCH、DGET等高级函数。 * **数据处理与分析**：学习筛选、排序、条件格式化、数据验证，并能创建各种数据场景。 * **统计功能**：应用ANOVA、回归分析等统计测试。 * **可视化与报告**：制作各类图表，并创建数据仪表盘（Dashboard）。 * **安全与打印**：保护工作表和工作簿，以及进行打印设置。 * **自动化与高级应用**： * 使用宏（Macros）和VBA（Visual Basic for Applications）实现网页抓取、破解Excel密码、自动化重复性任务等。 * 创建用户窗体（UserForm）。 讲师将结合其10年的工作经验，重点讲解常见的Excel使用误区及解决方法。 **第二部分：Microsoft Access (章节 16-20)** 本部分专注于Access在数据库管理方面的应用，重点在于查询（Query）。学员将学习： * **数据库基础**：创建和编辑表，设置字段属性和约束。 * **数据导入与导出**：从不同程序导入数据至Access，并将Access数据导出。 * **数据筛选与排序**：在Access中实现数据的筛选和排序。 * **高级查询**： * 掌握默认查询。 * 学习不同类型的查询，如选择查询（Select）、制表查询（Make Table）、追加查询（Append）、更新查询（Update）、交叉表查询（CrossTab）和删除查询（Delete），以根据需求提取和manipulate数据。 * **界面设计**：创建窗体（Form）和报表（Report）。 * **脚本应用**：在模块（Module）中使用脚本来管理数据。 讲师同样会分享处理Access常见问题的经验。 **课程目标与适用人群** 本课程面向所有希望学习Excel和Access的初学者，以及希望巩固和深化现有基础知识，了解实际工作场景中应用差异的学习者。完成课程后，学员将具备从基础到高级的数据管理能力，能够有效地利用Excel和Access工具完成工作任务。 讲师将全程提供支持，解答学员在学习过程中遇到的任何疑问。
The course contain 2 parts:Chapters 1-15: Microsoft Excel Chapters 16-20: Microsoft AccessIn the first part, about Excel, I will teach you all about Excel, from the simplest things, like how to create a table and how to save the file, to more difficult things, which will help you automate your work to accomplish tasks in a much easier way. I will use my 10 years of experience in this field of work, to teach you the most common mistakes that can be encountered when using Excel, and how to solve those problems. At the end of this part you will know to:1. Differentiate between Excel files2. Create a table and edit it3. Use base functions like Sum, Average, Count, IF, SumIF, SumIFS and much more, but also more difficult functions like Offset, Vlookup, Hlookup, Index & Match, DGet4. Use the filter and sort data5. Use Conditional Formatting6. Use Data Validation and create different scenarios for the data7. Use the statistical part of Excel, to apply ANOVA, Regression and other statistical tests8. Create all the charts and to make a Dashboard9. Protect the sheet and Workbook10. Print11. Use Macros and VBA: web scrapping, break the password of the Excel, automate repetitive tasks and more12. Create UserFormIn the second part, about Access, I will cover all the Query and you will learn how to manage large database with millions of records, and how to obtain data according to requirements. This time too, you will see the common mistakes that can appear and how to solve them.At the end of this part you will know:1. How to create a table and edit the fields2. How to apply restrictions for certain fields, according to preferences3. How to import data from different programs in Access and Export data4. How to filter data and sort them5. How to use default Query and extracting data according to preferences, using Queries: Select, Make Table, Append, Update, CrossTab, Delete6. How to create a Form and a Report7. How to use scripts in module to manage data after the preferencesThis course will take you from beginner level and will offer you solid knowledge about Excel and Access, which will help you achieve all the goals of managing databases. So this course it's for beginners who want to learn the two programs, but also for those who know the basics of the two programs, but want to improve their knowledge about them and to see different cases that can be encountered in a workplace.I will be here to help you, if you have any questions or any other ambiguity about anything. Good Luck!Credits: upklyak, pikisuperstar, slidesgo, Photoroyalty, pikisuperstar (Freepik)Music: bensound
