1 / 11

Introduction to Excel: Mastering Spreadsheet Basics and Functions

Dive into the foundational aspects of Microsoft Excel with this comprehensive guide. Learn about workbooks, worksheets, and the Excel interface including menus, toolbars, and the formula bar. Understand key concepts such as cells, data types, and cell formatting. Discover methods for data input, the functionality of formulas and functions, and the importance of using statistical and mathematical operations. This resource is designed for beginners to develop essential skills in utilizing Excel for effective data management and calculations.

neena
Télécharger la présentation

Introduction to Excel: Mastering Spreadsheet Basics and Functions

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 T43, T46 & T68 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: 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

More Related