|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2016-mac-4-vba-macros-for-excel-an-intro/
课程评论：没有评论
课程名称：Mac版微软Excel 4：Excel的VBA宏入门 概述：欢迎参加Mac版Excel VBA入门课程。本课程深入讲解了Visual Basic，可以帮助您自动化Microsoft Excel及其他Office产品。尽管大多数人只了解Excel的基本功能，例如数据透视表和VLOOKUP公式，但实际上Excel是一个非常强大的工具，能够实现更多的自动化操作。您可以添加按钮和表单，增加互动功能，而许多人对此一无所知。 本课程旨在帮助您掌握Excel的自动化技巧，即便您是初学者，也可以在没有任何VBA或编程语言基础的情况下参与学习。课程会采用循序渐进的方式，每个视频专注于一个新的主题，或通过编码练习巩固您已有的知识。完成此课程后，您将能够独立开发自己的宏来解决特定问题，并且可以将新学的知识应用于Word和PowerPoint中。 课程适合有基础Excel知识（如能够使用基本公式和改变单元格颜色）的学员，但不设对VBA或编程语言的先决条件要求。无论您是初学者还是已经有一定基础，此课程都有助于您进一步提升Excel技能，成为提高工作效率的“巫师”。
Review of the Windows version:"This is a very good starting point in VBA. But doing this course one realize how extensive and huge VBA is. As always the teacher is great and one feels his in depth knowledge" - Daniel SandbergWelcome to Excel VBA - An Introduction for the Mac. This course delves into the Visual Basic which allows you to automate Microsoft Excel (and other MS Office products).Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.Microsoft Excel is an extremely powerful tool - and yet most people only scratch the surface of what it can do. In addition to PivotTables, VLookup formulas and the like, you can also automate it. You can add buttons and forms to add interactive features - yet most people don't even know it's there. Maybe you have someone in your organization who is an absolute wizard, getting the computer to do things and walking away while it does it. Do you want to be able to do that? Welcome to wizard school - or in other words, Visual Basic for Applications (VBA).In this course, I'll assume that you have some fair knowledge of Excel - able to do basic formulas and colour cells and the like - but you don't need any prior knowledge of VBA or any programming language for that matter. Of course, the more you already have, the better. I'll take things nice and slowly. Each video will center around one new aspect, or we'll consolidate what you already know with coding exercises. Once you have finished the course, then you will be well on your way to developing your own macros to solve your own problems. And you'll be able to take your new-found knowledge for use in Word and PowerPoint as well
