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