|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-vba-how-to-write-like-a-professional/
课程评论：没有评论
课程名称：Excel VBA：如何像专业人士一样编写宏 概述： 这个课程于2018年9月添加了新内容，教您如何使用Excel VBA复制和过滤数据，包括13个练习和完整的解决方案，帮助您实践和巩固所学知识。2018年4月，又新增了一个模块，讲述如何从头到尾构建一个完整的Excel VBA应用程序，其中介绍了一些在其他Excel VBA课程中没有教授的独特技术。这一部分包含经过验证的原则和鲜为人知的技巧，帮助您在比平常快很多的时间内构建应用程序。此外，您将学习一些技巧和窍门，可以减少错误，使代码更有组织，也使应用程序更容易维护和更新。本课程是唯一一个展示专业开发者从零开始创建VBA应用程序的体验课程。 在2018年1月，课程新增了关于在Excel VBA中使用数组的6个新讲座。您将了解到，顶级Excel VBA程序员并不比您更聪明或更有天赋，而是使用了一系列经过验证的编程原则和鲜为人知的技巧。本课程由保罗·凯利教授，他在20多年的专业软件开发中积累了许多必备的秘密，包括轻松打开任何工作簿的代码、提高生产力的循环使用、如何创建现实世界的VBA项目、解决错误的翻译表、使用适当的工作表方法、轻松测试宏输出、快速创建稳固的Excel宏、内置的VBA工具帮助您查找bug、简单格式化单元格的技巧，以及应该避免使用的“邪恶”工作簿类型等。此外，如果您对课程不满意，可以在30天内无条件申请全额退款。 此课程非常适合希望提升Excel VBA技能的学习者，从基础到高级课程内容应有尽有，让您轻松掌握VBA编程。
September 2018 Added New Content!How to Copy and Filter Data using Excel VBAThis new section comes with 13 Exercises plus full solutions to help you practice and reinforce what you have learned.---------------------------------------------------------April 2018 Added New Content!Learn how to build an entire Excel VBA application from start to finish. In this brand new section you will see techniques not taught in any other Excel VBA course. This new section(number 15) contains proven principles and little-known techniques that will help you build an application in a fraction of the time it would normally take you. You will also learn tips and tricks that will reduce your errors, make your code more organised, and make your applications easier to maintain and update.This is the only Excel VBA course that shows you first hand, a professional developer creating a VBA application from scratch. ---------------------------------------------------------January 2018 Added New Content! Using Arrays in Excel VBA: 6 brand new lectures.FINALLY! A Way To Write Excel VBA Like a ProfessionalIf you think the top Excel VBA programmers are smarter or more gifted than you, then you're mistaken. Truth is, they use dozens of proven programming principles..little-known techniques that are completely unknown to most VBA users. What are these principles? How can you learn them? And how can you use them to create your own Macros? In this course, Paul Kelly teaches you dozens of must-have secrets that he learned during his 20+ years as a professional software developer, including *How To Easily Open Any Workbook - I provide the code, You can use it everywhere!* Why using Loops can increase your productivity exponentially - Start using them immediately* How To Create a Real-World VBA Project - A step-by-step guide through a Fruit Sales example project* The Error Translator Table - An easy way to resolve errors that should have been written years ago* Which worksheet method to use - Your code will still work even if the user changes the sheet name!* How to easily test the output of your macros - It's childs play to write values to this Window* How To Quickly Create Solid Excel Macros - Tons of examples you can "steal" for yourself.* The In Built VBA Tools That Help You Easily Find Bugs - If you think you would make a good detective then you may really enjoy this* How to Easily Format any Cell - Changing a cells font, color, format is so simple you could do it now.* These "Evil" Workbook types should never be used - Do You Use them?* And Much More. Remember if you are not happy with the course for any reason you can get a FULL REFUND within 30 days - no questions asked!!!
