|
本帖最后由 usalaotu 于 2017-3-6 00:22 编辑
USALaoTu.com 中国科学技术大学近代物理系,中国科学院北京高能物理所,美国能源部费米实验室,超导超级粒子对撞机实验室,美国航空,日立半导体,EDS,eBay,Netscape,AOL,Yahoo,微软硅谷专家美国老土博士开创,北美最早,最大,成功转行学生最多数据分析师技术培训网校。查看USALaoTu 网校更多免费辅导视频:http://www.usalaotu.com/forum/index.php?board=40.0
USALaoTu.com 坚定不移的坚持以找数据分析工作为中心,培养学生能做会说两个基本点。每天有课,每周两晚高薪转行求职辅导,用三十年业界第一手丰富经验,把世界各地成千求变爱家男女送进大公司。
视频剪辑:USALaoTu核心课同学第336次专业求职找工作辅导周会
https://youtu.be/e7kMoqd4-0M
-- Excel VBA 老师介绍课程大纲;
-- 两位高薪转行找到SQL Server DBA 工作同学们,学习,问题与工作经验分享
-- 今天刚刚经历现场面试MSBI工作的同学分享面试问题;
-- 明天将要有电话面试同学请老土老师给分析该工作描述,以及面试如何说;
-- 关于如何回答工资问题,你不听会后悔的详细经验。
新开online live 课程:
Microsoft SQL Server 2014 第六期 Core Package 8:00-12:00 Sun, 2/5 - 3/05, 2017
Big Data Hadoop MongoDB Tableau 第四期 18:00-20:30 Tue, Thu, 3/7 - 4/13, 2017
Python for Data Analysis 第一期 16:00-19:00 Sat, 2/4 - 4/8, 2017
Access Excel 2013 VBA 第四期 Core Package 08:00 - 12:00 Sun 03/12 to 04/09
Course Registration: http://www.usalaotu.com/student/register.php
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
• Excel: Spreadsheet Analysis & Reporting
• Vlookup ( Hookups and Match Index) Function in Excel
• Power of Access
• Open a Blank New Access Database
• 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
Week Two: Query and Report in Access ( 4 Hours)
• 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 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. |
|