1 / 0

Create and Edit A Excel Document

Lab of COMP 102 Feb . 15-16, 2012. Create and Edit A Excel Document. Shenghua ZHONG Department of Computing The Hong Kong Polytechnic University zsh696@gmail.com. Outline. Definition of Excel Create Excel document Excel window and toolbar Basic operation of Excel. Outline.

makara
Download Presentation

Create and Edit A Excel Document

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. Lab of COMP 102Feb. 15-16, 2012

    Create and Edit A Excel Document

    Shenghua ZHONG Department of Computing The Hong Kong Polytechnic University zsh696@gmail.com
  2. Outline Definition of Excel Create Excel document Excel window and toolbar Basic operation of Excel
  3. Outline Definition of Excel Create Excel document Excel window and toolbar Basic operation of Excel
  4. What is Excel Definition of Excel A commercial spreadsheet application developed by Microsoft Run on Microsoft Windows and Apple’s Mac OS X Features calculation, graphing tools, pivot tables History Microsoft released the first version of Excel for the Mac in 30 September 1985 The most obvious change in Excel is a interface called Ribbon in Excel 2007 Website office.microsoft.com/en-us/excel
  5. Outline Definition of Excel Create Excel document Excel window and toolbar Basic operation of Excel
  6. Create A Excel Document How to find it Start Button-> All Programs->Microsoft Office->Microsoft Office Excel 2007 How to open it Click Microsoft Office Excel 2007 Iconof it
  7. Outline Definition of Excel Create Excel document Excel window and toolbar Basic operation of Excel
  8. The Excel Window and Toolbar
  9. Outline Definition of Excel Create Excel document Excel window and toolbar Basic operation of Excel
  10. How to Select Cell Single cell--- click one cell Continuous many cell--- click first cell and shift + click the ending cell Discontinuous many cell---ctrl + click single cell Whole cells in row or column cell--- click beginning cell of row or column All cells---ctrl + a, click the intersect of initial rows and columns Clear selected cells--- Click any empty location in sheet
  11. = (B4 + 25) / SUM（D5:F5） Domain address function operator Domain address Arithmetic operator function constant Basic Function of Excel Operand Cell, Number, Function, domain, … Operator Arithmetic operator: +, -, *, /, %, ^, ( ),… Logical operator: &,OR,… Relation operator: =, >, >=, <=, <, <>,…
  12. Utilize Statics Function
  13. Choose More Other Functions
  14. Sort in Excel Easy sort Custom sort by different levels
  15. Filter Data From Excel
  16. Filter Data by Numbers Filters
  17. Insert Chart based on Data
More Related