1 / 11

CPSC 203 Introduction to Computers

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.

tessa
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. CPSC 203Introduction to Computers T59 & T64 TA: Jie (Jeff) Gao

  2. 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

  3. Excel – Interface • Menu, toolbars, scroll bars • Cell address bar, formula bar • Work space • Worksheet tabs and navigator CPSC 203 Tutorials by Jie Gao

  4. Excel – Basic Concepts • Columns, rows • Cells • Cell naming • Data types • “General” • Number • Currency • Date/time • Text CPSC 203 Tutorials by Jie Gao

  5. 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

  6. Excel – Cell Formatting • Font: face, style, size, colour • Background • Border • Alignment • Indentation • Orientation • Data type related CPSC 203 Tutorials by Jie Gao

  7. Excel – Worksheets • Rename worksheets • Add a new worksheet • Delete a worksheet • Change worksheet orders CPSC 203 Tutorials by Jie Gao

  8. 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

  9. 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

  10. Excel – Useful Functions • Statistical • Min, Max, Average • Mathematical • Sum • Date and time • Now • More … CPSC 203 Tutorials by Jie Gao

  11. 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

More Related