Excel Intermediate
This course is to continue introducing the user to the fundamental principles, following the one day course entitled Excel 2007 Foundation. Can be followed by Excel 2007 Advanced.
Click on a location to see available dates, read more details and to register your interest:
Course outline
Multiple Workbooks
Link workbooks; Use multiple workbooks; Side by Side comparison.
Use References
Absolute, relative and mixed.
Ranges
Create and name ranges; Clear and format ranges; Copy and move ranges.
Functions
Use worksheet functions; Function argument ToolTips; Search for a function; Watch window.
Charts
Create, format, and modify charts; Preview and print charts.
Formatting Worksheets
Apply formats (accounting, fraction, and scientific); Create custom formats; Use styles and AutoFormats.
Workgroup Functions
Use comments.