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


  • 45 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


278206 application of software package in office

278206Application of Software Package in Office

(3)

(Spread Sheet)

.

[email protected]


278206 application of software package in office


278206 application of software package in office

  • Excel /

  • Excel Excel


Excel

Excel

  • Microsoft Excel (*.xlsx)

  • Text files (*.txt)

  • Microsoft Access (*.mdb)


278206 application of software package in office

  • Data


278206 application of software package in office

4. Click Open


278206 application of software package in office

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)


278206 application of software package in office


278206 application of software package in office

6. - 2 3 Excel


278206 application of software package in office

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

    Do not import column (skip) Excel General


278206 application of software package in office

8. Import Data

(Existing worksheet) (New

worksheet)


Data validation

Data Validation


278206 application of software package in office

  • Excel Data Validation


278206 application of software package in office


278206 application of software package in office


278206 application of software package in office

  • Allow:

    • Any Value ()

    • Whole number ()

    • Decimal ()

    • List ()

    • Date ()

    • Time ()

    • Text length ()

    • Custom ()


278206 application of software package in office

  • 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 ()


278206 application of software package in office

  • 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 ()


278206 application of software package in office

  • Data ()

  • Whole number ()

  • between

  • (Minimum)

  • (Maximum)


278206 application of software package in office


278206 application of software package in office


278206 application of software package in office


Data validation1

Data Validation


278206 application of software package in office

  • Data > Validation ( > )

  • Settings () Clear All ()


Pivot table

Pivot Table


Pivot table1

Pivot Table

  • Pivot Table

    (Data Base)

  • Worksheet Excel (External Data File)

  • Pivot Table Excel 97

  • Pivot Table Report Generator

  • Excel


Pivot table2

Pivot Table

  • 3


Pivot table3

Pivot Table


Pivot table4

Pivot Table

  • Sheet1

  • Pivot Table

    Cursor Pivot Table


Pivot table5

Pivot Table


Pivot table6

Pivot Table

3. Insert Tables Pivot Table Excel

Pivot Table Table / Range


Pivot table7

Pivot Table

4. Pivot Table Worksheet Worksheet


Pivot table8

Pivot Table

5. Pivot Table

  • Pivot Table

    Field List Pivot

    Table

  • Pivot Table Field List

    Pivot Table Field List

    Pivot Table


Pivot table9

Pivot Table


Pivot table10

Pivot Table

Report Filter

Column Label Column

Row Label Row

Value


Pivot table11

Pivot Table

** Pivot Table

1


Format pivot table

(Format) Pivot Table


Format pivot table1

(Format) Pivot Table


Pivot table12

Pivot Table


Grouping pivot table

(Grouping) Pivot Table


Grouping pivot table1

(Grouping) Pivot Table

Pivot Table


Grouping pivot table2

(Grouping) Pivot Table


Grouping pivot table3

(Grouping) Pivot Table


Grouping pivot table4

(Grouping) Pivot Table


Grouping pivot table5

(Grouping) Pivot Table

Pivot Table


Grouping pivot table6

(Grouping) Pivot Table


Grouping pivot table7

(Grouping) Pivot Table


Pivot table13

Pivot Table


  • Login