周末面授班新班每周日：10:00 am 白天面授班：10月2-21日：9:30 am-2:30 pm ，
实战一：In a job interview, the recruiter wants you to take an Excel test before moving to the next step. You learned some Excel from YouTube and even some training class, however, your test result is not good enough to impress the recruiter. So, he told you he would call you when a job fits you, but that call never comes. Does this sounds familiar? Definitely you don’t want this happen again! We will walk you through real Excel tests of a famous recruiter. The next time, you will be best. 案例特色：全面解码招聘者的测试试题，知道他们要考什么，怎么去准备，进而在众多的面试者中胜出，拿到自己心仪的工作。同一个测试，对有准备的人来说是机会，对没有准备的人来说，却意味着又一次白白浪费了机会，您呢？
实战二：You are a financial analyst working for a world famous consulting company. CFO wants you to create an Excel model to monitor and control monthly wireless expenses of the company’s 3,000 employees. You need to download 12 months data from ERP system, convert data, analyze data by cost centers, compare total amount, rate and usage to prior three years, capture significant variances, and present your findings. Are you ready to overcome this challenge?
实战三：You are preparing financial statements from trial balance. The existing model created by previous analysts uses direct cell links. However, since every month the G/L accounts have minor changes, you need to check each link one by one with extreme attentions. You have to work until midnight to get financial statements balanced before deadline. Your goal is to create a new model to complete the same work within 20 minutes and absolutely accurate. Furthermore, you want to create an interactive report with dropdown lists to display MTD and YTD of any month.
案例特色：以全新的思维，全新的方法来准备财务报表，告别繁琐冗长的单元格连接法，让完成这项工作成为享受而不是痛苦。你的报表永远准确，如果有人怀疑，你尽可大胆地脱口而出，”You are wrong”。另外，互动式下拉菜单的创建，可以让你在一个Excel 文件中任意展现任何一个月的当月值和年初至今值，而不用去浪费时间，为每一个月都要去创建一个Excel 文件。此案例的方法不仅仅用来准备财务报表，大量其它的商务报告都可以用这个方法。
实战四：You are required to prepare a dynamic dashboard for quarterly reporting based on two years P&L statements and budget. You need to display total, details and 13 months trend of sales, cost of sales, operating expenses and profits by selecting year, month and category from dropdown lists. You want to automate this dashboard instead of spending hours doing manually. The secret behind the scene will be decrypted in this exercise. You will become the master of dashboard.