The student will learn to create, edit, format and print a spreadsheets.
Version 2007
Duration
1 day
Unit Standards
Saqa US ID: 116937: Use a Graphical User Interface (GUI)-Based Spreadsheet Application to create and edit spreadsheets
Prerequisites
The student must have attended an introductory Windows course
Course content
Module 1: Excel Essentials
- The Excel screen
- Customising the Quick Access Bar
- Understanding the Ribbon, contextual tabs and dialog box launchers
- The Office Button
- Help in Excel 2007
- Workbooks and WorkSheets
- Selecting Ranges
- Moving and Scrolling through the Workbook
Module 2: Creating a Spreadsheet
- Types of Data
- Data Entry
- Using AutoFill
- Editing Data
- File Management including file compatibility
- Formulas
- Absolute and Relative addressing
Module 3: Editing a Spreadsheet
- Changing column/row widths
- Alignment
- Centring headings over a group of cells
- Inserting and deleting rows / columns
- Inserting worksheets
- Moving and Copying
- Checking spelling
Module 4: Formatting a Spreadsheet
- Changing number formats
- Borders and Fill (shading)
- Cell styles
- Changing character fonts, sizes and colours
- Freezing panes
- The Zoom slider
- Copying a format to other cells
Module 5: Printing a Spreadsheet
- Using Page Layout View to create Headers and Footers
- Print Preview
- Using the Page Layout tab
- Manual Page Breaks
- Changing Orientation and Scaling
- Selecting a print area
- Print repeating titles on different pages
