278206 application of software package in office
This presentation is the property of its rightful owner.
Sponsored Links
1 / 48

278206 Application of Software Package in Office PowerPoint PPT Presentation


  • 47 Views
  • Uploaded on
  • Presentation posted in: General

278206 Application of Software Package in Office. การใช้งานโปรแกรมตารางคำนวณ (3) (Spread Sheet). อ.ธารารัตน์ พวงสุวรรณ [email protected] [email protected]อก. การนำเข้าข้อมูลจากภายนอก. Excel มีความสามารถในการจัดการกับฐานข้อมูล ทำให้สะดวกในการจัดเก็บ ค้นหา แก้ไข/ลบข้อมูล

Download Presentation

278206 Application of Software Package in Office

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


278206Application of Software Package in Office

(3)

(Spread Sheet)

.

[email protected]



  • Excel /

  • Excel Excel


Excel

  • Microsoft Excel (*.xlsx)

  • Text files (*.txt)

  • Microsoft Access (*.mdb)


  • Data


4. Click Open


5. - 1 3 Next

5.1 (Original data type) 2

  • Delimited ()

  • Fixed width ()

    5.2 (Start import at row) 1

    5.3 (File origin) 874 : Thai (Windows)



6. - 2 3 Excel


  • - 3 3 Column General, Text, Date, Column

    Do not import column (skip) Excel General


8. Import Data

(Existing worksheet) (New

worksheet)


Data Validation


  • Excel Data Validation




  • Allow:

    • Any Value ()

    • Whole number ()

    • Decimal ()

    • List ()

    • Date ()

    • Time ()

    • Text length ()

    • Custom ()


  • Data:

    o Between ()

    o Not between ()

    o Equal to ()

    o Not equal to ()

    o Greater than ()

    o Less than ()

    o Greater than or equal to ()

    o Less than or equal to ()


  • Data:

    o Between ()

    o Not between ()

    o Equal to ()

    o Not equal to ()

    o Greater than ()

    o Less than ()

    o Greater than or equal to ()

    o Less than or equal to ()


  • Data ()

  • Whole number ()

  • between

  • (Minimum)

  • (Maximum)





Data Validation


  • Data > Validation ( > )

  • Settings () Clear All ()


Pivot Table


Pivot Table

  • Pivot Table

    (Data Base)

  • Worksheet Excel (External Data File)

  • Pivot Table Excel 97

  • Pivot Table Report Generator

  • Excel


Pivot Table

  • 3


Pivot Table


Pivot Table

  • Sheet1

  • Pivot Table

    Cursor Pivot Table


Pivot Table


Pivot Table

3. Insert Tables Pivot Table Excel

Pivot Table Table / Range


Pivot Table

4. Pivot Table Worksheet Worksheet


Pivot Table

5. Pivot Table

  • Pivot Table

    Field List Pivot

    Table

  • Pivot Table Field List

    Pivot Table Field List

    Pivot Table


Pivot Table


Pivot Table

Report Filter

Column Label Column

Row Label Row

Value


Pivot Table

** Pivot Table

1


(Format) Pivot Table


(Format) Pivot Table


Pivot Table


(Grouping) Pivot Table


(Grouping) Pivot Table

Pivot Table


(Grouping) Pivot Table


(Grouping) Pivot Table


(Grouping) Pivot Table


(Grouping) Pivot Table

Pivot Table


(Grouping) Pivot Table


(Grouping) Pivot Table


Pivot Table


  • Login