1 - Performing Calculations
FormulasFunctions: SUM, AVERAGE, MAX, & MINAbsolute Reference
2 - Working with Functions
Named RangesLogical Functions: IF, SUMIF, $ COUNTIF
3 - Using Lookup Functions
Lookup Functions: MATCH, INDEX, & VLOOKUPHLOOKUP
4 - Visualizing Data with Charts
Creating ChartsModifying Charts
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is intended for individuals who want to gain basic knowledge of working on Excel.