Loading next page . . .
Blue Mountain White Mountain
Microsoft Excel Level 2
Microsoft Excel Level 2
Course Description:

During this one-day workshop, participants will learn to use various tools in order to organize worksheets, use advanced formulas and working with charts.

Course Topics:
  • Worksheet organization: range names, workbook templates, worksheet security, outlining
  • Advanced formulas: using the IF Function, linking formulas
  • Using multiple workbooks and worksheets: working with multiple workbook, setting up and using multiple worksheets, creating links with formulas, modifying and restoring links, consolidating data
  • Working with charts: creating charts, changing chart data, modifying chart elements. creating custom charts, applying formatting
  • Annotating worksheets: creating styles, working with styles, using conditional formatting, using sparklines