Course Code:
excbspkinstpro
Duration:
7 hours
Course Outline:
Excel Advanced: Formulas and Functions (English program):
Popular functions (IF, SUMIF, COUNTIF, VLOOKUP)
Streamlining workflow processes
Collaborating within Excel
Structured references
Importing and exporting data
Data analysis
Linking to other worksheets
Combining and nesting functions in Excel
or/and
Excel Expert: External Data and Macros (English program):
Reviewing worksheets
The Go To dialog box
What-If analysis
Importing and exporting data
Tables and relationships
Introduction to macros
Introduction to forms