Excel® I Introduction to Workbooks, Charting, Data Management

Excel icon

Overview

Excel is the spreadsheet component of Microsoft Office and it is an extremely versatile tool for manipulating numeric data, creating charts and sorting and filtering text data.

Coming May 20-May 27 2 sessions Tuesdays 9:00am-4:00pm UBC Robson Square

Course Description

With Excel you can:

  • Work with your numeric data
  • Display it as charts
  • Manipulate non-numeric data as tables like you can in many database products

In this hands-on introductory workshop you will examine spreadsheet principles, entering data, creating formulas, designing worksheets, charting, data management and printing. Several applications for Excel are explored using examples and case studies.
Duration: 12 hours

Register for this course: Excel® I Introduction to Workbooks, Charting, Data Managemen

 

Theoretical Objectives

  • History and applications for worksheets
  • Creating formulas
  • Formatting to add meaning
  • Functions (structure and use)
  • Charts for communication
  • Database terminology & applications

Practical Objectives

  • Worksheets for manipulating numeric data
  • Formatting
  • Creating and modifying Charts
  • Creating and modifying Data tables (edit, sort and filter)
  • Budget Models
  • Decision Support Tool

 
Lab Equipment and Devices

The sessions are conducted in a computer lab and you will have a lab computer for you to use.

You are welcome to bring your own computer to the lab sessions if you prefer to use that. Wireless access is available in the lab.

At times you will be doing a fair bit of typing and you will want to have a large enough screen and separate physical keyboard so that you can view content and type at the same time.

Lab exercises are based on using the lab computers.
If it appears that you are having challenges with your own device, we will ask you to use the lab computer.

Instructional Methods

  • Hands-on labs
  • Discussion
  • Online collaboration
  • Lecture

Course Materials

  • Web site
  • Course notes
  • Printed copies of on-screen lecture notes available on request during lectures

No Recording or Pictures in the Lab

Please note: Taking pictures or video during the course sessions is not permitted. All the course materials and lecture notes are available in physical form and on the web.