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 2010

Description

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.

Duration

1 day

Outcomes

Students will learn how to create multiple-sheet workbooks and consolidate data with links. Students will deal comprehensively with formulas and functions and create charts and sparklines.

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/or 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 function, =PMT

Module 4:  Charts and Sparklines

• Inserting a chart
• Working with contextual tabs:
• 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
• Sparklines