1 / 36

Mastering Microsoft Excel 2007 Functions and Features

Learn about spreadsheet definitions, organizing information, and Excel 2007 features to process and analyze data efficiently. Discover cell addressing, formulas, and types of data formats.

wade-carson
Download Presentation

Mastering Microsoft Excel 2007 Functions and Features

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. Lesson 4MICROSOFT EXCEL PART 1by Nguyễn Thanh TùngEmail: tungnt@isvnu.vnWeb: http://khoaquocte.vn/Article/Index/405

  2. SUMMARY • Document editing software • Microsoft Word 2007 • Features of Microsoft Word 2007

  3. TODAY'S LESSON CONTENT • Spreadsheet definition • How to process information as table form • Concepts in spreadsheet • List of spreadsheet software • Row, Column, Cell • Constants and expressions • Microsoft Excel 2007 • Organizing information in Excel • Address of a cell in Excel • how to reference to a cell • Lists the data types

  4. ORGANIZING INFORMATION • Student Information: Name • Student Mark: Thể dục, Hát • Method 1: • Name: Tom, Thể dục: 10, Hát: 8 • Name: Jerry, Thể dục: 8, Hát: 10 • Cách 2:

  5. STORAGE AND PROCESS INFORMATION AS TABLE • Advantages • No duplicate • Easy to follow • Easy to perform calculation

  6. SPREADSHEET APPLICATIONS • Spreadsheets are widely applied: • The office work, administration • The accounting jobs • Management jobs • Job analysis and design

  7. POPULAR SPREADSHEET • Microsoft Excel • Apple iWorks – Apple Numbers • Open Office – Calc : free • Google docs : online software • …

  8. COMMON CONCEPT IN SPREADSHEET • A spreadsheet is a collection of cells, the cells are created by rows and columns • Data contained in cells • Cell Content: • Constant: style number, style, date format, ... • Result expression: coresponding to this cell: cell 1 + cell 2, …

  9. MICROSOFT EXCEL 2007 • Excel Versions: 95, 97, 2000, 2002/XP, 2003,2007, 2010 • New user interface, very friendly • Quick Access Toolbar, Ribbon (Toolbars) • Very small file

  10. Start Excel

  11. Start Excel

  12. Ribbon (Control Power point)

  13. Top layer tabs • Home • Insert • Page Layout • Formulas • Data • Reviews • View

  14. Home • Copy, paste • Font format • Paragraph format • Number • Style • Editing

  15. Insert • Pages Format • Insert Tables • Illustrations (Graphic objects) • Charts • Links to Webpage and Internet • Headers and Footer • Graphic Text • Symbol

  16. Page layout • Create themes • Paper setup • Sheet Options • Format and arrange object

  17. Formulas • Functions in library • Defined functions

  18. Data • Get external data • Manage Connections • Sort & Filter • Data Tools

  19. Review • Check document (spelling) • Comment • Security

  20. View • Workbook View • Show/Hide option • Zoom out/in

  21. ORGANIZATION OF INFORMATION IN EXCEL • Information stored in Excel into three levels: • WorkbookAn excel file. A workbook may contain multiple worksheets. • Worksheet: is a table of cells, formed by the rows and columns • Cell: As a small information units stored in excel. A cell can contain numbers or letters • In Excel 2007, a worksheet contains columns and 1,048,576 lines are 16.384, 65.536 and 256 columns instead of the older versions. • Example: Payroll • Worksheet: January, …, December • Cell: Name, Salary, …

  22. CELL ADDRESS AND CELL REFERENCE • Cells in an Excel worksheet is defined based on the column and row address • Column in excel is numbered by A, B, … • Row in excel is numbered by 0, 1, … • Example: A13 is the address of the cell created by the column A and line 13 • Address box: <column address> <row address> • Relative address: <name column> / <name row> • Absolute address: $ <name column> / $ <name row> • For example, A13, $ A $ 13, A $ 13, $ A13

  23. Relative and Absolute Reference • In Excel, if a formula is relative references, when copy that formula to other cells, Excel will automatically change the cell reference corresponding to the row or column. • For example: C1 = A1 + B1. When you copy cell C1 to cell C2, Excel will automatically convert C2 = A2 + B2 • Depend on case that the user will decide to use the relative reference or an absolute Press F4 to automatically switch between different types of address

  24. Relative and absolute reference

  25. MIỀN CÁC Ô (RANGE) • Is set in a rectangular box is limited by 2 cell references or set of domainDefinition: • <Cell 1>: <Cell 2> • <Range 1>; <Range 2> • Examples: • C2: D8 • B2..B8; E2..E8 • Range may be named • B2..B8= range 1; • E2..E8 =range 2;

  26. TYPES OF NUMBERS FORMAT IN EXCEL • General: the general format, no specific requirements • Number: Example: 1234.10 • Currency: Example: $ 100 • Date: Example: 3/14/2010 • Time: Example: 13:30

  27. TYPES OF NUMBERS FORMAT IN EXCEL • Percentage: Example: 80% • Fraction: Example: 1/2 • Scientific: Example: 5.00E-01 • Text: Example: abc • Special: special code for countries • Custom: defined by users

  28. DEMO • The interface elements on Excel • Create / Open Workbook • Add / delete / rename worksheet • Edit box • The simple formula (unused function) • Format cells

  29. Demo1 (Ex 16-Ex 58 Text book)

  30. Skills in Demo 1 • Use Auto sum and Fill handle to copy cells • Format title and Total cells • Make charts

  31. Demo2 (Ex 83-Ex 132 Text book)

  32. Skills from Demo2 • Insert formulas • Insert function (Auto sum, average, max, min) • Formatting and conditional formatting • Printing • Display formula (Ctrl key +"`" key) • Import external data from Web source

  33. Demo3 (Ex 163-Ex 227 Textbook)

  34. Skills from Demo 3 • Dates and Time (Now) • Rotating texts • What if Analysis • Pie Charts • Split Windows into Panes • Goal Seek

  35. Print Documents

  36. Find and Replace

More Related