Super Excel Class Schedule: on Every Wed. 7:00pm-10:00pm
Please come to try the class one time for free!!!
Please call 416-665-1888 or email at davidli@viccollege.com for further inquiry and reservation.
Practical Business Super ExcelSkills
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 3-hour session class, 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
- 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
|
Functions
|
Tasks and Projects
|
Level of Complexity
|
|
1
|
Math, lookup, text, information, logical functions; Reference; Keyboard shortcuts
|
Use intermediate functions to address basic business problems
|
Component of a machine
|
|
2
|
Math, lookup, text, information, logical functions; Reference; Keyboard shortcuts
|
Use intermediate functions to address basic business problems
|
Component of a machine
|
|
3
|
Formula of combined functions; Formatting for presentation
|
Combine functions to address intermediate business problems
|
Sub-assembly of a machine
|
|
4
|
Pivot table; Charts;
Access queries
|
Handle large volume data & complex analysis; Present results
|
Sub-assembly of a machine
|
|
5
|
Advanced lookup and math formula
|
Automate reporting
|
Standard machine
|
|
6
|
Statistical functions;
Array formula
|
Build forecasting model
|
Standard machine
|
|
7
|
Formula track & trace; Formula error solving
|
Generate optimized solution
|
Specialized machine
|