维多利亚梦想:我们提供的不仅仅是培训,而是培养能够找到工作,胜任工作,更重要的是热爱工作的人!
维多利亚精神:Never Give upYou can do it

 


Excel看似容易并不简单,怎样才能成为高手? Excel是一个常常被我们华人忽略的一个常用电脑技能,但是对那些从小就学Excel西人来讲很多10分钟就搞定的Assignment我们都要痛苦的花上3个小时才能做完,但通常你的Excel水平就能代表你在北美的工作经验。所以很多华人往往就是因为Excel不熟练而不能通过三个月的Probation而失去一个来之不易的Offer;或者就是因为Excel使用的不熟,您无法顺利通过Excel技能的考试。所以无论任何背景的人,就算你也许已经用 Excel 很长一段时间了,但是你的 Excel 技能还是没有达到你自己或上司所期望的水平?你想练出一身高超的Excel武艺,以弥补其它方面的不足;你想在面试的Execl测试中表现出类拔萃;你想成为一个骄傲的Excel 高手,当办公室的同事遇到Excel 困难时,总向你寻求帮助?

 

    千万不要忽略了华人在北美职场打拼必会的办公技能-Excel

 

本周六Adv. Excel讲座将详细解读Excel”“”“”“

 
313日(周六)4:00pm  讲座:如何提高Excel使用技巧,让您职场无忧
 

主讲人:Steve Huang 专业物流师(P. Log.)Adv. Excel高手。Steve在工作中,练就了娴熟精湛的Excel技巧。高超的Excel技巧也帮助他在工作当中如鱼得水,大获老板和同事们的赏识。Steve毕业于瑞典Chalmers University of Technology,并获得运输管理硕士学位,在Seneca College获得全球物流供应链管理证书。Steve积极参与Seneca College全球物流供应链管理顾问委员会及Peel工业教育筹划委员会的工作。曾在加拿大Wal-Mart担任distribution analyst一职长达三年,并曾在LCBO担任长达三年的senior supply chain analyst。拥有美国零售工业管理协会颁发的RSCC证书(Retail Supply Chain Certification),他是Supply Chain Logistics Association CanadaCanadian Professional Logistics InstituteCouncil of Supply Chain Management Professionals (US)三大专业协会的成员。


Adv. Excel 经验班
公开课: 313日(周六)4:00pm                
第一次课: 317(周三) 7pm,以后固定每周三7pm - 10:20pm

 

这门20 小时的超级Excel培训课程,其目的不是教你学软件而是帮助你在职场中有效地借助 Excel 快速有效解决复杂和高难的问题。因为Excel的基本功能是有限的,不需要太多的介绍。而真正的成长来源于如何把这些有限的功能不断排列组合以创新用法。学员在20小时内的上课过程中,丰富的实例和课堂练习使学员在迅速提高Excel使用水平,在老师的讲解和帮助下,将以往痛苦枯燥的工作,变成了轻松简单的几张表格,利用Excel强大的数据处理功能,迅速得到自己想要的结果。在课程结束的时候,很多学员都体验到Excel数据处理和分析美妙感觉,常有对Excel“相见早,相识晚的感慨。

 

【课程目标】
你可以在15 分钟内做出一个别人要用3个小时才能做出一个报表;
你可以在两小时内分析出一个别人要用一天时间才能找出问题根源;
你可以做出一个最优化的计划,而别人只能优化到 70
你可以开发出一个复杂的Excel 决策支持工具而别人不知从何处着手;
你可以快捷有效地实施商务预测,而别人还茫然不知所措;
授课老师是在加拿大知名企业工作的资深分析员。六年职业生涯Excel运用精华总结。
你只需要用20小时掌握老师精选的最重要,最常用的Excel功能,就可以在老师的指导下,组合运用这些公式非常漂亮地解决繁琐,复杂,超难的商务问题。

 

【上期学员谈Adv. Excel上课感受】
 
说起来最早接触Excel是在十多年前,那时候在国内的一家设计院工作,虽然工作中主要是用画图软件,但也时常被所里的总工们或是老同志抓差做一些文档工作,要用到Word和Excel。这两个软件我都是自学的,自己慢慢摸索,觉得自己用的也算是得心应手。那时对Excel的认识就是觉得它是用来作表格的,用Word难画的表格就用它来做。虽然也知道它可以做一些运算,但是从来没用到过。现在学了这个SuperExcel课程后,才知道原来Excel有如此强大的功能,绝不是仅仅做个表格而已,想想当时自己只是接触到了一些皮毛,甚至连皮毛都谈不上。在这个课上,老师用他多年工作中积累的经验,总结了一些Excel常用的并且实用的功能教给我们。对这个课程,我觉得有几个值得一提的地方。 首先,是学员每人有一台电脑,可以在老师讲解后,自己做练习,自己做过的东西,就会印象比较深刻些,不懂得地方,老师也可以做到手把手的教你。其次,老师并不是只是简单的教会你用某个功能,那样的话,自己找本书看就可以了。他是通过工作中的实际需求,教你如何运用这些功能作一些数据的处理和分析、市场预测、优化计划和解决其它一些商业问题,所以我觉得这个课程的针对性和实用性很强。还有就是从整个课程的安排上,看得出黄老师是很花心血的,站在学员的角度为我们考虑。举例来说,我们每节课都会有两份表格,一份是用来做练习的PracticeFile,还有一份是AnswerFile。当我回家后做练习,这个AnswerFile非常有用,有时候我们忘了怎么用公式时,点点AnswerFile的formula就会看到答案,可以帮助我们更好的做练习。 还有一个很值得一提的地方就是,如果你一个学期下来,还有不明白的地方,可以重复再学,我就是再听第二次的时候,感觉比第一次更容易理解了,做起来也更顺手了。总之,通过学这个课,我对Excel有了全新的认识,在应用上也有了很大的提高。谢谢黄老师和维多利亚学院提供了这样精彩的课程给我们。(Jing J.)
 
我在2009年5月至6月参加了黄老师的供应链管理暨SuperExcel课程,由于我以前有过一些物流方面的工作和学习经验,因此当我上完这一整套课程后最大的体会就是我能认识到黄老师所教授的,正是他在过去多年中不断积累的工作知识经验和具体操作技能的精华。先从供应链管理方面来说,黄老师的课程包含了几大重要的模块,包括物流,采购,库存管理,配送,预测等,在20个小时中你可以学到上千页的教材中的核心部分。再从Excel方面来说,我本人此前掌握的Excel功能最“复杂”的可能就是加减乘除求和了,因此在曾经参加的面试中在被问到Excel时根本无法有所表现,而Excel在供应链领域的几乎所有工作中都是至关重要的技能。我的一个朋友现在已经是一家大企业的物流经理,他告诉我前几年在还没有加拿大工作经验的时候之所以能够进入这家大企业完全是因为他的Excel应用技能比较好。而通过与这位朋友的交流,我发现只要掌握了黄老师所教授的Excel技能中的一半,就已经可以达到我的这位朋友的水平。 (Roger T)
 

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 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.

 

I needed to improve my Excel skill for my job hunting in accounting area because all of the job agency 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 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 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.)


【维多利亚相关课程介绍】
 

ACCESS & VBA 
公开课:  313日(周六)4pm
第一次课:317(周三)7pm,以后固定在每周三7pm-10pm
 
Access
不仅是一个数据库,而且还具有强大的数据管理功能,它可以方便地利用各种数据源,生成窗体、查询、报表和应用程序等。它也可与Internet融合,在数据库中可以直接链接到指定的Web页面或网络文件,或把Web页面上的表格导入到数据库。Access 增加了数据库访问的安全机制,可对表一级设置访问许可权。Access 还可以方便地与Office其它软件融合,如与Word混合使用,打印通用信函或信封等。
 
Access
虽然强大,但仍会有些功能是它没有提供的,为此Access为我们预备了VBA。配合VBA的使用,我们可以实现任何指定功能,提高工作自动化,增加工作效率。所以,VBA已成为Access工作人员必需掌握的有力工具。VBAVisual Basic for Applications)是新一代标准宏语言,是基于Visual Basic for Windows 发展而来的。它与传统的宏语言不同,传统的宏语言不具有高级语言的特征,没有面向对象的程序设计概念和方法。而VBA 提供了面向对象的程序设计方法,提供了相当完整的程序设计语言。

 

VBA 简单易懂,是最易学习和掌握的电脑语言之一,是学习程序设计最好的入门语言。
 
“Access&VBA
实践班全新设计,教授Access & VBA开发和使用环境的全面技术,更着重于Example 的演示和说明,使学员了解如何用 AccessVBA 去处理不同类型的 Data Input and Output,无论就业或提升都是帮助巨大!此课虽没有大做宣传,却美名远远扬,课程口碑极好,就业形势和效果不同凡响。
 
【授课老师】Lisa Li数学硕士,北美计算机文凭。从事计算机编程和数据分析工作近10年,历任researcherdata analystmarketing analystbusiness analyst等职。自20069月,于George Brown College任教,教授数学和计算机课程。维多利亚“Access&VBA 实践班课程的授课老师,合理的知识安排,大量的实例,和生动有趣的练习,帮助您在短时间内掌握基本统计学知识,使您的SAS学习和工作更加得心应手。

 

【特别推荐报税讲座】
 

2010年报税季节最后机会,安省税务厅查税官员为新老移民免费推出
实用报税讲座”  帮您掌握各项个人抵税,报税新政策,让您更加省税!

 
本年度最后一次报税专场,机不可失
 

313(周六)2:30pm  报税讲座:如何合理合法的省税和避税

 

【主讲人】Chris Li
-- CGA- 加拿大特许会计师; CPA-  美国注册会计师。
-- Chris
在安省财政厅税务局从事税务/审计工作超过8年,曾任多个专业税务部门审计员,并曾在全球四大会计师事务所(BIG 4) Ernst & Yong 从事上市公司审计工作。
-- Chris
拥有丰富的加拿大工作经验,非常熟悉加拿大税法/会计制度,对于安省政府用人原则有精确了解,对于如何寻找、申请并且成功获得政府工作深有体会!
--
同时,Chris也在帮助我校学员就业方面做了很多努力,特别是200612月份,他曾将政府紧急招聘会计职位的信息发给我们,并推荐了2位学员进入政府税务部门。


实用报税班 最后一期特价机会仅$280
第一次课时间:316(周二)7pm,以后固定在每周二,五  7pm-10pm

 
课程共20小时(17小时授课和3小时实例练习),会详细剖析T1 Return 上各种常见的报税项目,还会深入分析一些最常见而又最重要的项目,例如:自雇人士,无限公司,租务收入,股票及投资收入和资本资值等,以上这些项目是最为复杂,但又是最能利用国家的税务政策去处理合理的税务策略。同时应用联邦税表T1 General及税务软件Qunick Tax来授课,这样既能帮助学员容易理解及接受繁复的税务名词,及报税程序,又能提供一个良好平台给学员能立即适应现实及市场的税务工作。

 
热烈庆祝维多利亚密市开张
 

众盼已久的维多利亚密市分校即将在四月中旬在黄金广场开张,具体地址:1140 Burnhamthorpe Rd West  Unit 129  L5C 4E6..密市分校将推出大量在主校深受欢迎的系列课程。密市分校将秉承主校办校的宗旨,实实在在为华人就业提升贡献力量。

 
欢迎大家致电维多利亚,告之我们希望在密市分校学到的课程,密市分校咨询电话:416-894-3163416-665-1888
 

 
 
 

 

本页最后更新: | --