VBA 实战集训营
【四大Real Project】 【VBA面试专题培训，涵盖金融，IT和咨询行业】 【手把手教你如何把VBA放到简历上】 VBA Project实战集训营，投行+咨询精英导师，VBA培训专家，带你迅速掌握VBA！
课程介绍
课程大纲
第一部分：VBA Editing Environment
- VBE Immediate Window
- A simple VBA Program
- Run VBA Code
- Test VBA Code
第二部分： VBA and Excel
- VBA and Excel Cells
- VBA and Excel Worksheets
- VBA and Excel Workbooks
- Excel Macro Recorder
第三部分：VBA as a Programming Language
- Customized BSM model
- Market Risk Analytics
- Credit Risk Analytics
- Portfolio Risk Simulations
- Monte Carlo Simulation
- UserForm application
- Reporting Analytics
- Investment Analytics
Excel 特训营
带你迅速掌握Excel核心功能和工作中的常见应用，三大实战Project，涵盖面试问题中的Excel test常见问题。
课程介绍
课程大纲
第一部分：Excel的基础知识
- Intro to Excel Environment
- Basic Excel Operations
- Print Excel Worksheets
- Basic Conditional Formatting
- Basic Formattings
- Quick Entries
第二部分：数据的排序和筛选
- Sort and Filter
- Text to Column
- Array Formulas
- Date Formulas
- IF Formula
- Index and Match
第三部分：Excel必须掌握的运算函数
- Logical Formulas
- SUM，AVG，COUNT，COUNTA
- SUMIF(S), AVERAGEIF(S), COUNTIF(S)
- Text Formulas
第四部分：高级查找和数据透视表
- Vlookup and Hlookup
- Basic PivotTable
- Basic Plots
SQL 特训营
10小时，让你迅速掌握SQL和实战Project应用, 并涵盖SQL在IT，银行和通讯公司的常见面试问题。
课程介绍
课程大纲
SQL Level 1
- Intro to the SQL class
- Workbench Setup
- Basic Select
- Import/Export database, tables and understand the meta data
SQL Level 2
- Appreciation
- DISTINCT, COUNT, CASE WHEN, and IF THEN Statement
- ORDER BY, GROUP BY and HAVING Statement
- NULL Handling in SQL
SQL Level 3
- Left Join
- Inner Outer
- Ultimate Example
- Union
- Left Join Examples
Tableau 特训营
10小时，让你迅速掌握SQL和实战Project应用, 并涵盖SQL在IT，银行和通讯公司的常见面试问题。
课程介绍
课程大纲
Module 1 Introduction to Tableau
- What is Tableau
- Tableau products
- Connecting to a data source
- Tableau worksheet and workbook
- Dimensions and Measures
- Understanding Data
Module 2 Charts and Graphs
- Sorting and filtering
- Choosing the right chart
- Understanding chart elements
- Creating basic charts
- Analyzing data using statistical tool
Module 3 Custom Visuals
- Formatting charts
- Formatting Tableau visualizations
- Groups and sets
- Custom calculations and fields
- Pivot crosstabs
Module 4 Dashboards
- Mapping geographic data
- Creating dashboards
- Highlighting and actions
- Managing story point navigation
- Exporting data to csv file
- Publishing Tableau workbook online
- Connecting to JSON and spatial data file
