Introducing Excel
- Starting / exiting Excel
- The Excel Screen
- Worksheets and workbooks
- Using menus and dialogue boxes
- Zoom
- Help
Creating A Spreadsheet
- Starting a new file
- Opening and closing files
- Entering, editing and deleting data
- Saving
Selection Techniques
- Cells, rows, columns and ranges
- Select adjacent and non-adjacent
- ranges
- AutoFill
Formatting Cells
- Formatting numbers and text
- Cell borders and shading
- Autoformat
|
Moving Through A Workbook
Basic Formulae Concepts
- Simple calculations
- AutoSum
- Absolute and Relative referencing
- AutoCalculate
- AutoSum
Changing The Workbook
- Cut, copy and paste
- Drag and drop
- Column widths and row heights
- Inserting and deleting
rows/columns
Page Setup & Printing
- Headers and footers
- Page breaks
- Print preview
- Setting up the spreadsheet to print
|