初中级办公室软件Microsoft Excel Modeling 

课程设置：

本课程适合对Excel有一定初级基础的同学；

全英文教学，6hours per day/2days；

6大经典报表案例贯穿课程，倾述本人亲身经历，让你看透Excel；

独创6大情景，体会Excel在面试与职场中的巨大威力；

课程鼓励互动式教学，激发学生思考与对Excel用法的创新；

对Excel功能覆盖全面，包括高级函数，透视表，条件格式，复杂数据导入，数据整合，报表仪表盘，高级图表设计，表格排版以及少量对VBA的运用，让你大幅提高工作效率；

课程价格:   $580

Case one：Tele-communication

• Advanced Data Delimitation
• Advanced Functions VLOOKUP + OFFSET
• Advanced Text Functions LEFT + FIND + SERACH
• Intermediate Data setup for Dashboard

Case Two：Airline company

• Advanced SUMIFS, COUNTIFS, SUMPRODUCT
• Intermediate ARRAY formulas
• Advanced Sorting
• Advanced Report printing set up
• Advanced Pivot Table manipulation

Case Three：Retail

• Advanced UDF
• Immediate VBA editor navigations
• Understanding of Excel Objects
• Basic Looping
• Basic VBA Macro recordings
• Case Four：IT
• Advanced Excel Theme and Colour manipulation
• Advanced Charting manipulation
• Advanced dynamic object manipulation
• Advanced layout analytical mind
• Advanced Data validations

Case Five：Banking

• Advanced web link to RBA for interest base rate
• Advanced conditional formatting
• Advanced Protected controls
• Advanced Data validation for controls
• Immediate Goal Seek Analysis
• Print objects manipulation
• Advanced data formatting manipulation
• Advanced Excel VBA looping methods
• Advanced Short Cut Keys Usages