- By
**neena** - Follow User

- 88 Views
- Uploaded on

Download Presentation
## PowerPoint Slideshow about ' CPSC 203 Introduction to Computers' - neena

**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

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

- Menu, toolbars, scroll bars
- Cell address bar, formula bar
- Work space
- Worksheet tabs and navigator

CPSC 203 Tutorials by Jie Gao

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

- 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

- Font: face, style, size, colour
- Background
- Border
- Alignment
- Indentation
- Orientation
- Data type related

CPSC 203 Tutorials by Jie Gao

Excel – Worksheets

- Rename worksheets
- Add a new worksheet
- Delete a worksheet
- Change worksheet orders

CPSC 203 Tutorials by Jie Gao

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

- 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

- Statistical
- Min, Max, Average
- Mathematical
- Sum
- Date and time
- Now
- More …

CPSC 203 Tutorials by Jie Gao

Assignment 1

- Due: Jan 28, Friday 4:00pm
- 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

Download Presentation

Connecting to Server..