MS Excel - Introduction

Description:

This course is NO LONGER AVAILABLE to our campus community. Please use lynda.usask.ca

This course introduces basic spreadsheet terminology and functions within the application framework of Microsoft Excel.  You will be able to identify Excel components, download and work with templates, navigate and save worksheets. You will learn the basics of enterting and editing text, values and formulas, how to move and copy data and formulas, work with absolute and relative referencing, and work with ranges, rows and columns. You will learn simple functions and proper spreadsheet formatting. You will create and modify charts, work with graphics, and prepare worksheets for printing.  

The course is taught using MS Excel for Windows although those working in a Mac environment can also benefit from the instruction though some keystrokes and procedures will be different.

Resources

Objectives:

Prerequisites: Before enrolling in this course, participants should possess a basic understanding of mouse operation, file and folder creation, saving and locating files, and browsing the internet. This course may be taught on laptops in a small group setting.

In this course, participants will:

  • explore the Excel Environment
  • navigate a worksheet
  • use a template
  • enter and edit text and values
  • create basic formulas, enter and edit formulas
  • add and edit comments
  • save and update workbooks
  • modify workbook. move and copy worksheets
  • insert and delete ranges, rows and columms
  • select, copy and paste spreadsheet data
  • format the display of data: cells, rows, columns
  • explore absolute and relative referencing
  • use common functions - build a simple budget sheet
  • create a basic chart
  • format a chart
  • work with pictures and graphics
  • prepare, preview and print workbook contents

 

Prerequisites:

  • Basic computer skills

Other Recommendations:

There are no additional recommendations with this course

Duration:

6 hour Course

Registration Fees:

U of S Students: $200.00
U of S Faculty: $200.00
U of S Staff: $200.00

Required Software:

There is no required software for this course.

Resources:

There are no additional resources for this course.

NOTE: Classes may have limited registration. If an offering is designated as 'Full', please email Training Services in order that we may accommodate your training needs. Due to last minute withdrawls, this class is subject to cancellation on short notice. A customized training solution may be offered in its place.

Registration Information
You must be logged in to see registration information.