Objective:
The course is designed to equip participants with basic and intermediate features of Excel 2003. Participants will sit for Microsoft Office Specialist Exam at the end of the course
Course Outline
Creating Data and Content
- Enter and edit cell content
- Locate specfic cell content
- Locate, select and insert supporting information
- Insert, position, and size graphics
Analyzing Data
- Filter lists using the AutoFilter feature
- Sort lists
- Insert and modify formulas
- Use statiscal, date and time, financial and logical functions
- Create, modify and position diagrams and chart based on worksheet data
Fomatting Data and Content
- Applly and modify cell formats
- Applly and modify cell styles
- modify row and column formats
- Format worksheets
Collaborating
- Insert, view, and edit comments
Managing Workbooks
- Create new workbooks from template
- Insert, delete and move cells
- Customizing Printout Create new workbooks from templateCreate and modify hyperlinks
- Page Settings Create new workbooks from template
- Organize worksheets
- Preview data in other view
- Customise window layout
- Steup pages for printing
- Print date
- Organize workbooks using file folders
- Save data in appropriate formats for different uses
|