Microsoft office 2010 Powerpoint Word Excel Access http

Microsoft office 2010 Powerpoint Word Excel Access http: //www. thaiall. com/office ปรบปรง 8 ธ. ค. 2557 1

Microsoft Office • • • Microsoft Word Microsoft Excel Microsoft Powerpoint Microsoft Access Microsoft Outlook Microsoft Publisher Microsoft Onenote Microsoft Sharepoint Microsoft Infopath Microsoft Frontpage 2

meaning Microsoft Word • Microsoft Word is a non-free commercial word processor designed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenix systems. Subsequent versions were later written for several other platforms including IBM PCs running DOS (1983), the Apple Macintosh (1984), the AT&T Unix PC (1985), Atari ST (1986), SCO UNIX, OS/2, and Microsoft Windows (1989). It is a component of the Microsoft Office system; it is also sold as a 3

meaning Microsoft Excel • Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993 (2536). • Microsoft Excel has the basic features of all spreadsheets (กระดาษทำการ ), using a grid of 4

meaning Microsoft Powerpoint • Microsoft Power. Point is a commercial presentation program developed by Microsoft. Power. Point presentations consist of a number of individual pages or "slides". The "slide" analogy (การเปรยบเทยบ ) is a reference to the slide projector, a device that can be seen as obsolete (ลาสมย ), within the context of widespread use of Power. Point and other presentation software. Slides may 5

meaning Microsoft Access • Microsoft Access is a pseudo-relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Access stores data in its own format based on the Access Jet Database 6

meaning Microsoft Outlook • Microsoft Outlook is a personal information manager from Microsoft, available both as a separate application as well as a part of the Microsoft Office suite. Although often used mainly as an e-mail application, it also includes a calendar, task manager, contact manager, note 7

meaning Microsoft Publisher • Microsoft Publisher, is a desktop publishing application from Microsoft. It is an entry-level application, differing from Microsoft Word in that the emphasis is placed on page layout and design rather than text 8

meaning Microsoft Onenote • Microsoft One. Note is a software package for free-form information gathering and multi-user collaboration. While One. Note is most commonly used on laptops or desktop PCs, it has additional features for use on pen-enabled Tablet PCs, in environments where pen, audio or video notes are more appropriate than an intensive use of keyboard. One. Note's interface is an electronic version of the familiar tabbed ring binder which can be used directly for making notes, but also to gather material 9

meaning Microsoft Sharepoint • Microsoft Share. Point is a web-based collaboration and document management platform from Microsoft. It can be used to host web sites that access shared workspaces and documents, as well as specialized applications like wikis and blogs from a browser. Share. Point does not intend to replace an entire file server. Share. Point functionality is exposed (เปดเผย ) as web parts, such as a task list or discussion pane. These web parts are composed into web pages, which are then hosted in the Share. Point portal. Share. Point sites are actually ASP. NET 2. 0 applications, which are 10

meaning Microsoft Infopath • Microsoft Info. Path is an application used for developing XML-based data entry forms, initially released as part of Microsoft Office 2003 Professional. The main feature of Info. Path is its ability to author and view XML documents with oneto-many links among different data groups (schema). Info. Path, a member of Office products, features a different usage scenario from the other applications, such 11

meaning Microsoft Frontpage • Microsoft Front. Page is a WYSIWYG HTML editor and web site administration tool from Microsoft for the Microsoft Windows line of operating systems. It was branded as part of the Microsoft Office suite from 1997 to 2003. Microsoft Front. Page has since been replaced by Microsoft Expression Web and Sharepoint Designer, which were first released in December 2006 (2549). 12

Powerpoint How to. . • Preparation • Slide planning • Slide design • Ribbon menu • Layout • Smartart • Graph & Table • Others • Exercise http: //www. thaiall. com/pdf/textbookpowerpoint 2003. pdf 13

Save as 17

Ribbon menu of Powerpoint 18

Diagram (ไดอะแกรม) • A diagram is a two-dimensional geometric (ทางเรขาคณต ) symbolic representation of information according to some visualization technique. • Sometimes, the technique uses a threedimensional visualization which is then projected onto the two-dimensional surface. 19

Smart. Art (สมารทอารท ) • A smart. Art is a feature first introduced in Microsoft Office 2007. Smart. Art was designed to create simple and effective diagrams, organization charts or flow charts with many more options than in past versions of the Office programs. 20

Smart. Art (สมารทอารท • • ) List Process Circle Relation Organization Chart Matrix Pyramid 21

Organization Chart )ผงองคกร ( • An organizational chart (often called organization chart, organigram, or organogram) is a diagram that shows the structure of an organization and the relationships and relative ranks of its parts and positions/jobs. 22

Chart )ชารท ( • A chart is a graphical representation of data, in which "the data is represented by symbols, such as bars in a bar chart, lines in a line chart, or slices in a pie chart“. • A chart can represent tabular numeric data, functions or some kinds of quantitative (ปรมาณ ) structures. 23

Water mark • Write something in background Such as draft, hurry, secret, private

Chart & Table • • Bar chart Line chart Pie chart Table การเดนทาง 25

Clipart (ภาพตดแปะ ) • Clip art is a collection of pictures or images that can be imported into a document or another program. The images may be either raster graphics (Bitmap picture) or vector graphics. • Clip art galleries many contain anywhere from a few images to hundreds of thousands of images. 26

Wordart )อกษรศลป ( • Word. Art is a text modifying feature in Microsoft Word, a popular word processing program. It includes effects such as shadows, outlines, colors, gradients, and 3 D effects that can be added to a word or phrase. • Word. Art can also bend (โคง ), stretch (ยด หด), skew (เอยง ) , or otherwise modify the shape of the text. 27

Exercise • • Time schedule Logo Flower Seminar advertising Flow of working Organization of company Movie 29

Microsoft word • • Save as Ribbon menu Brochure Webpage 30

Save as 31

Ribbon menu 32

Split section 33

Insert page number 34

Viewing 36

Switch for spelling check 37

Background with character สรางขอความสำหรบเปน background ดวย microsoft paint 38

Microsoft Excel • • Ribbon menu Save as Function Pivot table 39

Save as 40

Ribbon menu 41

Function =AVERAGE(A 1: A 10) =MIN(A 1: A 10) =COUNT(A 1: A 10, B 1: B 10) only number =COUNTA(A 1: A 10) if not blank =COUNTIF(B 1: B 10, A 1>80) 42

if =IF(B 2<50, "F", "A") =IF(B 2<50, "F", IF(B 2<80, "B", "A")) 43

Pivot table : Rows & Value 44

Pivot table : filter 45

Pivot table : column 46

Sheet reference =SUM(Sheet 1!A 1: Sheet 1!A 3) Hide & Unhide 47

Term: Embed • In computing, an embedded system is a specialpurpose system in which the computer is completely encapsulated by the device it controls • In computing, embedding media into a text document, forming a compound document • In computing, font embedding is inclusion of font files inside an electronic document 48

Term: CSV application • • Comma Separated Variable Comma Delimited Database File, Record, Field Table, Row, Column Microsoft Access SPSS 49

Q&A 50