（座位有限，订满为止）
你也许已经用 Excel 很长一段时间了;
你也许从图书馆借了Excel 的书 来学习;
你也许甚至接受过一些Excel培训;
你想练出一身高超的Excel武艺， 以弥补其它方面的不足；
你想在面试的Execl测试中表现出类拔萃；
你想成为一个骄傲的Excel 高手，当办公室的同事遇到Excel 困难时，总向你寻求帮助；
我们提供这个独一无二的Excel高手培训课程，就是专门帮助你实现这个目标，让你在职场胜出。
这门20 小时的超级Excel培训课程，其目的不是教你学软件而是帮助你在职场中有效地借助 Excel 快速有效解决复杂和高难的问题。
老师会指导你运用各种各样的 Excel功能及高级组合，在课堂上解决真实商务问题：
· 制作绩效报表
· 分析商务问题
· 计划商业项目
· 建立商业模型
· 预测市场需求
学完课程后，你会发现：
你可以在15 分钟内做出一个别人要用3个小时才能做出一个报表；
你可以在两小时内分析出一个别人要用一天时间才能找出问题根源；
你可以做出一个最优化的计划，而别人只能优化到 70％
你可以开发出一个复杂的Excel 决策支持工具而别人不知从何处着手；
你可以快捷有效地实施商务预测，而别人还茫然不知所措；
授课老师是在加拿大知名企业工作的资深分析员。他本人用了职业生涯头六年才达到现在的水平,但是你不需要。
你只需要用20小时掌握老师精选的最重要，最常用的Excel功能，就可以在老师的指导下，组合运用这些公式非常漂亮地解决繁琐，复杂，超难的商务问题。
如何快速成为Excel高手？
说起是否会使用Excel，估计只要用过电脑的人都说自己会用。真的是这样吗？就笔者的多年的经验，很多人所谓的“会用”，真的只是仅仅局限于“会用”而己。输入一些内容，加上一些表格格线，点一下存盘，瞧，文件做好了。
其实，Excel是一个功能非常强大的数据处理系统，决不只是一个拿来画个表格的表格绘制工具。如果真正掌握了Excel的所有功能，你会发现，很多重复的，烦闷的数据处理过程，会变得非常美妙，你只需点点或拖拖鼠标，然后靠在椅背上啜口咖啡，本来会忙得你晕天黑地的任务己让系统帮你处理好了。这时，看着仍忙得一塌湖涂的同事，你只有一个感觉：酷……
Excel是个人电脑普及以来用途最广泛的办公软件之一，也是MicrosoftWindows平台下最成功的应用软件之一。说它是普通的软件可能已经不足以形容它的威力，事实上，在很多公司，Excel已经完全成为了一种生产工具，在各个部门的核心工作中发挥着重要的作用。无论用户身处哪个行业、所在公司有没有实施信息系统，只要需要和数据打交道，Excel几乎是不二的选择。在实际应用中，它小到可以充当一般的计算器，或者记算个人收支情况，计算贷款或储蓄等等；大到可以进行专业的科学统计运算，以及通过对大量数据的计算分析，为公司政策的制定，提供有效的参考。
Excel之所以有这样的普及性，是因为它被设计成为一个数据计算与分析的平台，集成了最优秀的数据计算与分析功能，用户完全可以按照自己的思路来创建电子表格，并在Excel的帮助下出色的完成工作任务。如果能熟练使用Excel，就能做到“一招鲜，吃遍天”，无论在哪个行业哪家公司，高超的Excel水平都能在职场上助您成功。
Excel作为办公软件的重中之重，已经成为衡量一个员工办公能力的标尺，可以说只有能熟练运用Excel进行数据处理的人，才是招聘单位青睐的人才。在现实中，95%的Excel使用者只掌握了其中5%的功能。因为他们一是不知道有那95%的功能；二是知道还有别的功能，不知道怎么去用；千万不要以为知道了Excel的全部功能菜单就是精通Excel了。每项菜单命令后都隐藏着无数的玄机，必须学习组合运用这些功能才能全面发挥Excel的强大威力，才能简单高效准确完美的完成工作中的各种复杂任务。
学习任何知识都是讲究方法的，学习Excel也不例外。正确的学习方法能使人不断进步，而且是以最快的速度进步。错误的方法则会使人止步不前，甚至失去学习的兴趣。有些人猛啃Excel书，却因为不得要领陷入茫茫大海中最后半途而废。在高手的指导下，你可以用最短的时间学到最重要的技巧。因为Excel的基本功能是有限的，不需要太多的介绍。而真正的成长来源于如何把这些有限的功能不断排列组合以创新用法。很多学员在上课的过程中，在老师的讲解和帮助下，将以往痛苦枯燥的工作，变成了轻松简单的几张表格，利用Excel强大的数据处理功能，迅速得到自己想要的结果。在课程结束的时候，很多学员都体验到Excel数据处理和分析美妙感觉，常有对Excel“相见早，相识晚”的感慨。
Excel是功能强大的工具，使用Excel进行各种数据的管理与分析已经成为我们的日常工作内容之一。在以后的工作中少走弯路，事半功倍。丰富的实例和课堂练习使学员在20小时内迅速提高Excel使用水平，成为Excel高手，在人才竞争中尽显一技之长，脱颖而出。
Introduction Super Excel
Course Outline
This 20-hour hands-on Practical Business Super Excel Skills course is designed to help people to learn and use the most important and relevant advanced Excel skills and intermediate Access skills to work effectively and efficiently in a business environment.
In each of the six classes, participants will be given business tasks and projects as they would in a real business job. They will combine various advanced features and functions in Excel and Access to plan business activities and solve complex business problems.
Participants will be guided step by step, from using simple functions to complex formula and eventually build complex model hands-on.
Learning Outcomes
Upon successful completion of this course the participants will be able to use Excel and Access to:
- Plan business activities effectively and efficiently
- Increase work productivity dramatically by using appropriate keyboard shortcuts and formula combination
- Generate business performance reports in professional presentation and very efficient manner
- Conduct complex business analyses to facilitate gaining deep insight of business issues
- Conduct business forecast to facilitate business planning
- Model business mechanism to provide decision support tool for management
- Generate optimized solutions that meet the tactic objectives of business strategies
Topic Outline
|
Lecture
|
Example Functions
|
Tasks and Projects
|
|
1
|
Keyboard shortcuts, countif, sumif, concatenate, vlookup, date, text, range
|
Use intermediate functions to address basic business problems
|
|
2
|
If, hlookup, vlookup+concatenate, if(iserror(vlookup)), if, if(and/or)
|
Combine functions to address intermediate business problems
|
|
3
|
Linked formulas to build model; Formatting for presentation
|
Automate reporting
|
|
4
|
Pivot table; index; conditional formatting;Access queries
|
Handle large volume data & complex analysis
|
|
5
|
Regression analysis, seasonal profile + moving average
|
Build forecasting model
|
|
6
|
Build planning model; hyperlink, macro, button, array formula, data validation, pmt function, goal seek
|
Generate optimized solution
|
Super Excel Course Participants Feedback
This Super Excel courses is well organized, full of vivid examples and practical cases. I came to the class knowing nothing about Excel and walked away with tons of skills. The models he developed in Excel are unique, and gave me tremendous help. As a matter of fact, I now use them everyday in my job. The instructor is the earnest teacher that I’ve ever met; I really appreciated his great help to my job.
Rachel Y.
I never knew Excel is so powerful until I took this Super Excel course. I only had very basic Excel skills before and when I asked for help from my company’s programmer, they always make the things even more complicated. After twenty hours Super Excel course , I am able to design and build efficient work chart and combine different functions to do complicated calculations which saved me lots of time and headaches. For example, I need to do inventory report monthly and before it took me hours to apply exchange rate (which is not fixed) to every items and it only takes me a couple minutes now. Above all, the instructor is a very dedicated teacher. What you learn from him is not what you can get from books, the cases you practice are from real work (I don’t think you can find anywhere else) and he shows you the solution step by step until you understand it. It is absolutely fantastic!
Julie L.
Before taking this course, I thought my Excel skills were good enough. But this was not true and I still learned so much from the course. I am lucky making the decision to take it.
Compared to other Excel courses simply teaching functions, this one focuses on business analysis and solutions thereby achieving real business goals. It helps a lot on my real life working issues. I’m in Logistics field and use Excel a lot to do analysis including lead time, forecast, etc. For some projects, it takes me two days or more for a certain step, now I know how to combine the functions and finish it in only one click. And shortcut keys saved my time and relieved my busy clicking right hand.
The Excel skills I learned here dramatically improved my working efficiency and performance. Those boring and time consuming projects became enjoyable process to me. It deserves more than it costs in my case.
Furthermore, the instructor of the Super Excel course is so responsible and nice that I really appreciated his ready-to-help attitude.
Flora Z.
Many thanks for your great teaching on this course. This course brings me into the world of Excel, and enables me to apply on my daily job. In other words, it's not only the theory and formula, but also the very practical exercises and examples. Without this course, I might only know the formula from the books, but have no ideal how to implement it. Without this course, I might spend one whole day to figure out a final result, but just 10 minutes now. I will strongly recommend my friends to take this Super Excel course to enhance their ability.
J. L.
I would like to take this opportunity to thank the Super Excel course instructor and Victoria College so much for the very effective and meaningful delivery of the Super Excel course. I really found this course to be very well structured with examples relating to the real life business scenarios. It was worth the time and efforts spent towards it.
Axay S.
The Super Excel course provided us lots of real cases to utilize advanced functions. This is very helpful in my real job. Mastery of advanced Excel is the essential and most important skills in many jobs, and this course will definitely increase my competitiveness in the job market.
Ellen L.
I would recommend this Super Excel course to anyone who wants to improve efficiency at work with Excel. What we've learned from class is sufficient for most Excel user. We only need the most important 20% of the Excel knowledge, which can help us with 80% of our daily tasks. No one wants to spend tones of time self-studying the functions he/she doesn't even know when and how to apply to the daily work. Also, the real life data examples carefully prepared by the instructor allow students to practice and enhance skills taught in class.
Jean O.
With what I learned from this course, it saved me a lot of time preparing monthly analyses and reports in my work; it also benefits my personal financial and investment decision.
Jessie Z.
I needed to improve my Excel skill for my job hunting in accounting area because all the job agencies require Excel test. The Super Excel course is very practical, and the course instructor has solid business background in using Excel. It is a shortcut for me to learn advanced Excel function.
The course did help to booster my Excel skills, and also I got to know using lots of shortcut key which is really cool. I had more confident in my interview and got a job offer recently. The instructor is a very nice teacher. He is definitely the best!
Jane Y.
The Super Excel hands-on course is definitely a very good one, which I was always looking for. Throughout the course l have learned not only lots of useful tricks on how to use functional tools in Excel, but also have the opportunity to practice with the real life data. It is amazing to realize that how powerful Excel is and most people might only use just 10% of the functions that Excel provides. I gained more confidence in how to use Excel, how to use Excel to analyze data and to produce more complex reports.
Mark
As a new immigrant, I often think about how I could get a better job and get my work more appreciated by the employer. An old immigrant said you should get yourself outstanding so that your potential employer could not afford to ignore you or not hire you. This sounds encouraging, however how could I achieve this?
Now I am getting the power to be outstanding from the short course - Super Excel and Supply Chain Management at Victoria College.
Before I started this course in June, I could use Excel to do some sum up calculation. I thought I knew a lot about Excel. Actually, from my first class, I had to concentrate myself on all the skills the instructor passed on to us. I had to go home after work for a nap and then a cup of coffee before I went to class on Wednesday evening and spent a lot of time practicing during the weekend. So far, I have finished my fourth class and I have learned count if, sum if, date, vlookup, if(iserror(vlookup), concatenate, if, pivot table, Access queries and a lot of keyboard shortcuts. These skills are totally new to me. It is not refreshing my skills, but rather bringing me to a new and higher level.
I really appreciated the instructor sum up his knowledge and share it with us generously. These dollars and learning will bring me much more dollars on my pay cheque in the near future. I joked with myself after my first class: “Buddy, I will be able to make it an easy job and gain more respect from my boss with these skills”. I also thought about how I, with a business management background and worked in an office environment, could have solved some business problems and got more recognized if I had this Super Excel skill before.
I have already talked to my manager for more responsibilities with a higher position because I am confident I will be armed with more skills after I finish this course. I believe I could use the Excel skills to handle more complicated work problem and make my job safer and easier.
Kevin S.
The lessons are very practical and helpful. The skills I learned from this Super Excel course helps me to get my job done faster and make fewer mistakes. I hope I have taken this course earlier.
Jennifer
The Super Excel training helps me with my reporting project. I used some excel functions I learned from the course to automate the reporting process, it freed me up from lots of copy/paste lousy work.
Ping L.
I have to say that the instructor is the best teacher ever, he leads student with care, knowledge and experience.
Gail F.
I enjoyed every class in the Super Excel course, where the instructor shared his experiences, knowledge and skills with us. He prepared large volumes of real life Excel cases with practice and answer files. I would say this is really a high quality and professional course. It opened a window and let me know how amazing it is if one acquires the super Excel skills. It will be very helpful to advance my career.
Lanie Z.
I work in logistics field where I have to deal with large volume of data every day. It made me crazy. So I decided to find a way to help me in my work. After some research, I chose to take Super Excel course at Victoria College in May 2009, which did bring me a lot of skills and experience that I really need in my work. In this course I learned many functions and ways to combine them to calculate and analyze data more effectively and efficiently. I started to enjoy Excel after I learned functions like vlookup, hlookup, if, count, sum if, PivotTable, as well Access queries.
In my opinion, in this short course the instructor brought us lots of very practical Excel functions and skills that are most used and needed at work. I appreciate the efforts that the instructor put into this course, which boosted my Excel skills.
Y.C.M
你要如何才能做到呢？
但是你的 Excel 技能还是没有达到你自己或上司所期望的水平;
（座位有限，订满为止）
