|
This course is suitable for anyone who has no knowledge of Excel.
Course Outline
- Introduction What is a Spreadsheet
- Starting MS-Excel
- The Excel Screen
- Title, menu and toolbars
- Creating a new workbook
- Moving around the sheet
- Selecting/deleting and modifying cells
- Entering and editing data
- AutoFill
- Freezing a frame
- Selecting/deleting/modifying & coping rows & columns
- Using the Go To feature
- Protecting the worksheet
- Naming cells and cell ranges
- Linking
- Saving and Closing a workbook, Opening and deleting a workbook
- AutoSum, entering Formulae
- Statistical functions
- Relative and absolute addressing
- Formatting and enhancing the worksheet
- Printing a workbook print preview
- Page set-up
- Auto Format
- Sorting
- Using a chart wizard
- Creating charts
- Modifying a Chart
|
