|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-macros-magician-excel-and-vba/
课程评论：没有评论
Coursera 课程《Excel Macros VBA + Power Query (2合1课程)》是一门面向所有Excel用户，无论是否有编程背景的自动化和数据处理课程。 **核心内容：** * **VBA宏的入门与精通：** * 从录制宏开始，逐步学习编辑、理解和调试VBA代码。 * 通过实践，掌握从零开始编写VBA应用程序的能力。 * 涵盖各种实用技巧，如用户窗体 (Userforms)、循环处理多个文件、使用数组加速操作、文件和文件夹脚本、创建摘要报告、格式化报告、嵌入图片、批量调整图表大小、用VBA创建图表、嵌入文件图片、错误处理与调试、高级筛选、使用形状、理解表格和列表对象、创建交互式销售仪表板等。 * 特别强调了宏录制的绝对模式与相对模式的区别，并教授如何构建用户窗体和循环处理多个文件。 * 深入教授数据透视表自动化、访问列表对象（Tables），以及如何使用命名范围和VBA创建动画图表。 * 课程包含50多个已完成的文件、视频和示例，配有可下载的练习文件。 * **Power Query的精通：** * 学习Power Query这一强大的数据准备工具，无需编程即可实现复杂的数据处理。 **课程亮点：** * **零基础友好：** 循序渐进，详细讲解，特别适合没有编程经验的学习者。 * **实践导向：** 提供大量的实际案例和可下载文件，帮助学习者即学即用。 * **自动化能力：** 教授如何自动化日常工作，提高效率。 * **全面性：** 涵盖VBA的基础到高级概念，并引入Power Query，满足多种数据处理需求。 * **持续更新：** 课程会不断更新内容。 **适合人群：** 学生、会计、数据分析师、职场人士以及所有对Excel和自动化感兴趣的用户。 **学员评价：** 学员们普遍反映课程内容丰富实用，能够帮助他们从VBA基础走向精通，并有效解决日常工作中的自动化问题，强烈推荐给宏学习者。
Fear not if you don't know how to record a Macro and use it. In this course, I will show you how to record macros, edit them , understand the code, debug them and start writing your own applications. VBA for Excel is still King in terms of Automation. There is so much magic that you can achieve by learning how to code. All you need is the will power to learn and practise.Start from the Basics of recording and understanding macros. Learn to write VBA code from scratch. You don't need to be a Programmer.Once you're done with VBA, learn Power Query.....the best tool to Master without learning how to code"It is in detail ie., step by step for the non coding background learners"Rajesh L N - India"I needed a course that takes me from basic vba to intermediate vba and so far with the course content i see myself headed towards becoming an expert vba which is awesome"Emmanuel - Uganda"Excellent course contents and thanks for uploading this savior course. It really helped and perfectly fits for the day to day work automations. I highly recommend this course for macros learners...!!"Rizwan Safdar - Switzerland"Practical examples and well explained formulas. Excellent course explained with formulas and debugging. Can't wait to learn the Excel animation and move to Power BI. Would recommend the course to Excel enthusiasts to explore."Shagufta M - Pakistan"It's a very nice course, I recommend to everyone who wants to learn VBA. Instructor has got excellent knowledge about the teachings."Sarfraz - IndiaVariety of codes for different situations, written right before your eyes. Debug, compile and recover from mistakes.Over 50 completed files, videos and examples.UserformsAnimation in Charts using Named ranges and VBALooping over multiple filesUsing the speed of ArraysScripting with Files and FoldersCreating Summary ReportsFormatting your reportsEmbedding images onto sheetsResizing multiple charts in a gridCreating Charts in VBAEmbedding Pictures from a FolderError handling and debuggingUsing Advanced FilterUsing Shapes in VBAUnderstanding Tables and List ObjectsInteractive Sales DashboardRecord macros in Absolute and Relative mode, understand the differences. Start building Userforms, create loops to loop over multiple files.Understand Pivot table automation and to access Tables as List Objects. Create multiple charts and resize them in a customized grid.Create animation using Advanced techniques with Named ranges and VBA to animate Excel charts.This course covers all the basics as well as advanced concepts of VBA for beginners.Each project contains exercise files that you can download and use.This course will help students, accountants, data analysts, working professionals, any Excel enthusiast.Course will be updated with new videos...
