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 2007 

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 work 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: Protecting and managing data

• Protecting Workbooks and Worksheets
• Hiding Columns & Rows
• Password Protection for files
• Conditional formatting
• Cell Comments
• Paste Special

Module 3: Functions & Formulas

• Absolute, relative and mixed references in formulas
• Link Formulas
• Edit Links
• Getting help with functions
• Logical function, =IF
• Date functions, =Now, =Today, =Weekday
• Financial functions, =PMT

Module 4: Charting

• Inserting a chart
• Working with Contextual tabs:
• Design
• Layout
• 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
• Share Excel Charts