USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司! => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on February 24, 2017, 11:07:58 AM
-
USALaoTu 核心课 最佳入门课之一: Access and Excel 2010/13 & VBA 第四期 (Core Package class) 8:00 - 12:00 Sunday 3/12 - 4/9
Dr. Laotu will teach you Access database.
北美在职业界Excel, VBA expert will show you skills of Excel, VBA.
This class will cover Access, Excel and VBA skills. Many Large Finance Institute and Banks are heavily using these skills.
This webinar meets 5 times.
Sun, Mar 12, 2017 8:00 AM - 12:00 PM PDT
Sun, Mar 19, 2017 8:00 AM - 12:00 PM PDT
Sun, Mar 26, 2017 8:00 AM - 12:00 PM PDT
Sun, Apr 2, 2017 8:00 AM - 12:00 PM PDT
Sun, Apr 9, 2017 8:00 AM - 12:00 PM PDT
-
First two classes will teach Access 2013/2016.
Third class will teach Excel 2013.
Fourth and fifth classes will focus on excel VBA.
Here is the outline of Excel and VBA class part:
EXCEL
Chapter 1. Introduction : Excel in a Nutshell
Introducing Excel objects
Chapter 2. Excel Fromula and Formmatting: Tricks and Techniques
2.1 use Formulas
2.2 Formatting basics
2.3 Recording Marcos
2.4 Project 1
Chapter 3. Excel Visual Basic for Applications (VBA) Fundamental
3.1 Introducing VBE
3.2 Variables, Data type and Constants
3.3 Working with Sub Procedures
3.4 Createing Function procedures
3.5 VBA Programming Examples and Techniques
3.6 Project 2 : A real project.
Chapter 4. Advance VBA: UserForms, Excel Utilities, Pivot Tables, Charts and Events.
4.1 Working with UserForm (important)
4.2 Advanced UserForm Techniques
4.3 Excel Utilities
4.4 Working with Pivot Tables
4.5 Working with Charts
4.6 Understanding Excel's Events
4.7 Interacting with Other Application
4.8 Project 3
Starging with VBA to walk through the application developing process which hopefully will benefit you in the future when you decided to learn anohter programming language.
Excel is still a very useful tool for a lot of companies.
-
Excel, Access, VBA skills are used in every companies, specially in large bank and insurance companies.
This course is opening to meet students demand.
After you find a high pay job as a database analyst, you want yourself to be armed with advanced Excel, Access and VBA skills as well.
Stunning reports and visualizations with Excel, advanced VBA programming and Basic Access database are used in most of big companies, especially in large bank and insurance enterprises.
Week One : Introduction - Install Access and Import Data ( 4 Hours)
• Introduction
• Excel &Access (2013, 2016) Integration
• Open several Access Databases
• Table Datasheet View
• Different Types of Data
• Import an Excel Worksheet to Access
• Linking an Excel Worksheet to Access
• Lab1:Importing a Worksheet into a New Table
• Lab2: Interview Test-How to Design a Dynamic Financial Quarterly Result Report by Using Excel Formula
• Configure ODBC for SQL Server Database connections
• Import data from remote SQL Server database to Access tables
• Create table relations, concept of table constraints
• Access Query
• Select One Single Query From One Table
• Select Query From Multiple Tables
• Query Operation For Calculation
• Define a Query For Report
• Export a Access Report to Excel
• Creating and Modifying Grouped Reports
• Customizing Reports with Formatting
• Page Layout Techniques
• Lab1 Join Two Tables
• Lab2 Use The Find Duplicates Query Wizard
• Lab3 Find Unmatched Rows
Week Two: Access and SharePoint, Reports, Forms ( 4 Hours)
• Introduction of SharePoint
• Upload files to SharePoint Site
• Link Access tables to SharePoint List
• Export Access table date to SharePoint Lst
• Import SharePoint List to Access Table
• Move Access database tables to SharePoint Lists
• Create Access Web Applications
• Publish Access Web Application on Web
• Access Reports
• Import data from Remote SQL Server Database
• Access Forms for different businesses
• Develop a Patient Navigation Forms
Week Three: Excel in a Nutshell ( 4 Hours)
Chapter 1. Introduction : Excel in a Nutshell
Introducing Excel objects
Chapter 2. Excel Fromula and Formmatting: Tricks and Techniques
2.1 use Formulas
2.2 Formatting basics
2.3 Recording Marcos
2.4 Project 1
Week Four: Excel Visual Basic for Applications (VBA) Fundamental ( 4 Hours)
Chapter 3. Excel Visual Basic for Applications (VBA) Fundamental
3.1 Introducing VBE
3.2 Variables, Data type and Constants
3.3 Working with Sub Procedures
3.4 Createing Function procedures
3.5 VBA Programming Examples and Techniques
3.6 Project 2 : A real project.
Week Five: Advanced Excel VBA ( 4 Hours)
Chapter 4. Advance VBA: UserForms, Excel Utilities, Pivot Tables, Charts and Events.
4.1 Working with UserForm (important)
4.2 Advanced UserForm Techniques
4.3 Excel Utilities
4.4 Working with Pivot Tables
4.5 Working with Charts
4.6 Understanding Excel's Events
4.7 Interacting with Other Application
4.8 Project 3
Starging with VBA to walk through the application developing process which hopefully will benefit you in the future when you decided to learn anohter programming language.
Excel is still a very useful tool for a lot of companies.
-
Content of SharePoint is added into Access Excel VBA class:
Week Two: Access and SharePoint, Reports, Forms ( 4 Hours)
• Introduction of SharePoint
• Upload different files to SharePoint Site
• Link Access tables to SharePoint List
• Export Access table date to SharePoint Lst
• Import SharePoint List to Access Table
• Move Access database tables to SharePoint Lists
• Create Access Web Applications
• Publish Access Web Application on Web
• Access Reports
• Import data from Remote SQL Server Database
• Access Forms for different businesses
• Develop a Patient Navigation Forms