Cpsc 203 introduction to computers
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

CPSC 203 Introduction to Computers PowerPoint PPT Presentation


  • 52 Views
  • Uploaded on
  • Presentation posted in: General

CPSC 203 Introduction to Computers. T59 & T64 TA: Jie (Jeff) Gao. Introduction to Excel. Excel is a spreadsheet software Excel document – Workbook Worksheets in workbook It is mainly used for calculating numbers, especially the repetition of same calculation on different numbers.

Download Presentation

CPSC 203 Introduction to Computers

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Cpsc 203 introduction to computers

CPSC 203Introduction to Computers

T59 & T64

TA: Jie (Jeff) Gao


Introduction to excel

Introduction to Excel

  • Excel is a spreadsheet software

  • Excel document – Workbook

    • Worksheets in workbook

  • It is mainly used for calculating numbers, especially the repetition of same calculation on different numbers

CPSC 203 Tutorials by Jie Gao


Excel interface

Excel – Interface

  • Menu, toolbars, scroll bars

  • Cell address bar, formula bar

  • Work space

  • Worksheet tabs and navigator

CPSC 203 Tutorials by Jie Gao


Excel basic concepts

Excel – Basic Concepts

  • Columns, rows

  • Cells

    • Cell naming

  • Data types

    • “General”

    • Number

    • Currency

    • Date/time

    • Text

CPSC 203 Tutorials by Jie Gao


Excel inputting data

Excel – Inputting Data

  • Directly input – overwrites the old content

  • Double click and input – keeps the old content

  • Input in the formula bar

  • Fill handle

    • Generate sequence

    • Copy data

    • Ctrl key to toggle

CPSC 203 Tutorials by Jie Gao


Excel cell formatting

Excel – Cell Formatting

  • Font: face, style, size, colour

  • Background

  • Border

  • Alignment

  • Indentation

  • Orientation

  • Data type related

CPSC 203 Tutorials by Jie Gao


Excel worksheets

Excel – Worksheets

  • Rename worksheets

  • Add a new worksheet

  • Delete a worksheet

  • Change worksheet orders

CPSC 203 Tutorials by Jie Gao


Excel formulas

Excel – Formulas

  • Formulas are calculation expressions

  • Starts with a “=“

  • The formula expression is shown in the formula bar but the formula result is shown in worksheet

  • Examples

CPSC 203 Tutorials by Jie Gao


Excel functions

Excel – Functions

  • Functions are predefined formulas

  • They are organized in categories

  • Use the “Paste function” button or “Insert  Function” menu

    • Choose function

    • Provide arguments

      • Input by hand

      • Pick by mouse

CPSC 203 Tutorials by Jie Gao


Excel useful functions

Excel – Useful Functions

  • Statistical

    • Min, Max, Average

  • Mathematical

    • Sum

  • Date and time

    • Now

  • More …

CPSC 203 Tutorials by Jie Gao


Assignment 1

Assignment 1

  • Due: 2:00pm Jan 27

  • 3 Parts:

    • Follow steps on EX-176 to EX-197 (NOT EX-198) to get a payment schedule

    • The payment schedule with formula expressions shown

    • A chart showing Principal Paid and Interest Paid for the last 12 months (any suitable chart type is OK)

CPSC 203 Tutorials by Jie Gao


  • Login