This is a middle level or Intermediate course for people who have done a beginners course but need more skills to analyse and present data.
Version 2003
Duration
1 day
Outcomes
Students will learn how to create multiple-sheet workbooks quickly and efficiently and consolidate data. Students will deal comprehensively with formulas and functions and create charts (graphs).
Unit Standards
Saqa US ID: 116940: Use a graphical user interface (GUI)-based spreadsheet application to solve a given problem
Saqa US ID: 116943: Using a graphical user interface (GUI)-based spreadsheet application, enhance the functionality and apply graph /charts to a spreadsheet
Prerequisites
The student must have attended a beginner's course in Excel and worked with Microsoft Excel on a daily basis.
Course content
Module 1: Creating Multiple-Worksheet Workbooks
- Using Multiple Sheets:
- Inserting a New Sheet
- Renaming a Sheet
- Deleting a Sheet
- Grouping Sheets
- Moving, Copying & Pasting Data
- Summing through the sheets
Module 2: Protection
- Protecting Workbooks and Worksheets
- Hiding Columns & Rows
- Password Protection for files
- Conditional formatting
- Cell Comments
Module 3: Functions & Formulas
- Absolute, relative and mixed references in formulas
- Link Formulas
- Using the Function Wizard
- Logical function, =IF
- Date functions, =Now, =Today, =Weekday
- Financial function, =PMT
Module 4: Charting
- Using the Chart Wizard
- Selecting a ChartType
- Choosing Chart Options
- Editing a Chart
- Adding a Data Series
- Deleting a Series from a Range
- Changing Chart Type
- Changing the Chart Format
- Adding Text, drawing objects
- Printing Charts
