|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-3-in-1-excel-vba-sql-master-course/
课程评论：没有评论
《Excel、VBA 与 SQL 合集大师课程》旨在帮助您成为Microsoft Excel领域的专家。本课程由经验丰富的软件开发者Mark讲授，他曾在IBM、摩根士丹利和西门子等公司工作，深知企业所需技能。 课程内容涵盖三大核心部分，总计超过40小时的视频讲座，并新增了Google Sheets部分： 1. **Excel精通：** 从零基础开始，逐步深入到Excel的专家级应用。您将熟练掌握函数、公式、图表、数据透视表、条件格式等各项功能，并完成一个实际项目。 2. **VBA自动化：** 学习Excel的编程语言Visual Basic for Applications (VBA)，实现任务自动化。内容包括子程序、变量、数据类型、宏的录制与增强、调试与错误处理、事件、类和面向对象编程等。 3. **SQL数据库操作：** 学习SQL编程语言，并在Excel中执行SQL语句。您将掌握数据库设置、数据类型、基本操作、VBA与SQL的集成、数据查询、表操作、连接查询 (joins)、SQL函数及安全性等。 4. **Google Sheets入门：** 针对初学者，从基础知识开始讲解Google Sheets的各项功能。 本课程提供30天不满意退款保证，助您无忧学习，成为数据处理和自动化领域的全能人才。
Hello!Thank you for visiting our course page.Do you want to become the go-to person at your company for Microsoft Excel problems? Do you want to nail your next job interview? Or just want a new skill? If yes, then this course is for you.Watch the FREE video lectures to see how the course is structured and delivered!Join the course risk-free thanks to the 30-day no questions asked money-back guarantee! If you decide it's not for you, just ask for a refund.I'm Mark and I will be your instructor. I have worked at companies like IBM, Morgan Stanley, and Siemens, so believe me, I know what skills these companies need! I'm a self-taught software developer, who will teach you how to use Excel like a pro, but we will not stop there! I'll also teach you how to write clean and professional VBA code to automate Excel tasks! And on top of that, you'll also learn the SQL programming language, so by the end of the course, you'll know how to work with an actual database!This course is made up of 3 different courses, and packed with over 40 hours of video lectures.*** UPDATE! Google Sheets course is being added to this course! ***1. EXCELThe first part is dealing with Excel itself. It takes you from the VERY BASICS to EXPERT level. If you already have some Excel knowledge, you can skip the introductory parts!By the end of this part you will use Excel confidently, and be able to handle advanced tasks. You will learn the ins and outs of functions, formulas, charts, pivot tables, conditional formatting and a lot more.At the end of this part we will have a live project also.2. VBAThe VBA sections of this course will enhance your Microsoft Excel knowledge even further and will introduce you to programming. VBA stands for Visual Basic for Applications. Excel VBA is Microsoft's programming language for Excel. It is used to automate tasks and perform several other functions beyond creating and organizing spreadsheets.In the VBA sections of this course you will learn for exampleSubroutines, variables, data typesCore VBA programming conceptsVBA functions and more challenging conceptsMacros, recordings and enhancing themDebugging and error handlingEssential VBA operationsEventsManaging your VBA codeClasses and Object-based programming3. SQLIn this part of the course you will learn how to work with a database and execute SQL statements within Excel.In the SQL part of the course you will:learn SQL and how to set up your databaselearn about data typeslearn basic operationslearn how to set up VBA for SQLlearn how to query datalearn about basic statementslearn how to work with a tablelearn about joinslearn about SQL functions and securitySo what are you waiting for? Enroll now and become an EXCEL expert!4. Google SheetsThe Google Sheets sections start from the very beginning, assuming that the learner is an absolute beginner. If you have some knowledge of Google Sheets, you can skip the introductory parts.
