|
Modules
|
Spreadsheet Principles
- What is a Spreadsheet?
- What documents would you produce using a spreadsheet?
- Why use a spreadsheet application?
- What are the names of some spreadsheet programmes?
Starting with Spreadsheets
- Starting the programme
- Understanding the Screen
- The Mouse Pointer
- Using the keyboard to move around the screen
- Entering data on a spreadsheet
- Regional Settings
- Editing data on a spreadsheet
- Entering data using the automatic fill
Working with File commands
- Saving a workbook
- Closing a workbook
- Opening an existing workbook
- Starting a new blank workbook
- Saving changes to a workbook
- Saving a workbook with a Different Name
- Saving an Excel file in a different file format
- Deleting an Excel workbook file
- Exit the spreadsheet programme
Formatting Spreadsheets
- Selecting cells for changes
- Formatting Columns
- Formatting Rows
- Aligning data
- Changing Number Formats
- Changing Fonts, Sizes, Styles and Colours
- Setting Borders
|
Producing Spreadsheets with formulas
- Entering Formulas
- Filling Formulas
- Using Functions
- Checking your work
Editing Spreadsheets
- Inserting or Deleting Rows or Columns
- Cutting and Copying
- Using the Clipboard
More features
- Check your spelling
- Auto Correct
- Finding and replacing text
- Getting Help
Printing a Spreadsheet
- Previewing the spreadsheet
- Page settings
- Margin settings
- Header and Footer settings
- Sheet settings
- Printing a worksheet
Create and edit a graph/chart.
- Why do we use charts/graphs?
- Chart Terminology
- Creating a Chart
- Setting the Chart type
- Chart Titles
- Chart Location
- Moving, Resizing and Deleting charts as Objects
- Formatting a Chart
- Printing charts
|
