The student will learn to create, edit, format and print a spreadsheet.
Version 2010
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 2010 screen
- Customising the Quick Access Bar
- Understanding the Ribbon, contextual tabs and dialog box launchers
- The File menu and backstage office
- Help in Excel 2010
- 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
- Move, Copy and Paste options
- Checking spelling
Module 4: Formatting a Spreadsheet
- Changing number formats
- Borders and Fill (shading)
- Cell styles and themes
- 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 headings on different pages
