Excel® I Introduction to Workbooks, Charting, Data Management

Excel icon

Overview

Microsoft 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 Tuesdays:  January 27 – February 4th 2015 at 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 Management

 

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s