Super Excel
（更多资料和具体参加方法）
Overview
This 15-hour hands-on practical Super Excel course is designed to help people to learn and use the most needed, important, and essential advanced Excel features/functions to work effectively and efficiently in a business environment.
In each of the five classes, participants will be given business tasks and projects as they would in a real business job, and will be guided step by step, from using simple functions to complex nested formula hands-on. They will combine various advanced features and functions to plan business activities and solve complex business problems.
Learning Outcomes
Upon successful completion of this course participants will be able to use Excel to:
1. Increase work productivity dramatically by using keyboard shortcuts and various nested formula
2. Summarize and analyze large volume of data
3. Generate business reports in very efficient manner
4. Conduct complex business analyses to facilitate business decisions
5. Conduct business forecast to facilitate business planning
6. Plan business activities effectively and efficiently
2. Summarize and analyze large volume of data
3. Generate business reports in very efficient manner
4. Conduct complex business analyses to facilitate business decisions
5. Conduct business forecast to facilitate business planning
6. Plan business activities effectively and efficiently
Topic Outline
|
Class
|
Sample Features & Functions
|
Tasks and Projects
|
|
1
|
Keyboard shortcuts, reference, vlookup
|
Master the essential and critical keyboard skills, build foundation of all formula and models, learn the first function and the other critical techniques related using function
|
|
2
|
sumif, sumifs, name, &, date, text, countif, identifying and handling duplicates, if, iferror, hlookup, if(isna(vlookup(,,,)…)), if(trim()=””,,,)
|
Combine functions (nested formula) to address intermediate business problems
|
|
3
|
if(or(and(,),and(,)),,,),if(,,if(,,,if(,,,if(,,,))));hlookup, financial functions, goal seek, text to column, left, right, mid, len, search, substitute, mid(A1,search(,substitute(,,,,len()-len(substitute())),1)+1,50), text manipulation
|
Combine functions (nested formula) to planning business activities
|
|
4
|
Pivot table, conditional formatting, horizontal sorting, hyper link, macro, buttons, index(,match(),match())
|
Analyze large volume data & automate repetitive tasks
|
|
5
|
Regression analysis via chart/ functions/ analysis toolpack, automated seasonal profile + moving average forecast, if(countif()<,a,index(range, match())), automated model,
|
Build and automate forecasting model, complex & logical nested formula
|
（更多资料和具体参加方法）
