Excel Intermediate
THIS COURSE CAN BE RUN AS A CLOSED COURSE FOR YOUR COMPANY OR AS A 1 TO 1 COURSE FOR INDIVIDUALS. PLEASE CALL FOR INFORMATION AND DATES
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.
Sorry, there are currently no dates scheduled for this course.
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.