Super Excel Course Outline

Overview

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:

1. Plan business activities effectively and efficiently

2. Increase work productivity dramatically by using appropriate keyboard shortcuts and formula combination

3. Generate business performance reports in professional presentation and very efficient manner

4. Conduct complex business analyses to facilitate gaining deep insight of business issues

5. Conduct business forecast to facilitate business planning

6. Model business mechanism to provide decision support tool for management

7. Generate optimized solutions that meet the tactic objectives of business strategies

Topic Outline

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

                                                                                                                                                                
                                                                                                                                                                  (Let someone contact you)