1 - Basic Formulas
SUM, AVERAGE, MAX, MIN
2 - Absolute References
3 - Calculating Data with Advanced Formulas
3D FormulasRange NamesSpecial Functions VLOOKUP, IF, CONCATENATE, TODAY, PROPER, SUMIF, COUNTIF, RIGHT
4 - Presenting Data using Charts
Create, Modify and format chartsLine, Pie and Column ChartsCreate SparklinesCreate line, column and win/loss Sparklines
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 knowledge of working on Excel using formulas and charts.