Final PP Project

Download
Share  Add to  Flag Embed
Views:
 
Category: Entertainment
     
 
License:   All Rights Reserved

Presentation Description

No description available.

Comments

Presentation Transcript

Welcome to Kenin Professional Distribution Center : 

For internal use only - training material 1 Welcome to Kenin Professional Distribution Center Korean blankets distributor Founded in 2007 Insu Kim, CEO

MS Office at Kenin Professional : 

For internal use only - training material 2 MS Office at Kenin Professional Create memorandum using MS Word Create invoices using MS Excel Keep customer database using MS Access Create presentations using MS PowerPoint

Word: Preview and Print documents : 

For internal use only - training material 3 Word: Preview and Print documents Print preview Page option Number of copies Select printer

Word: Create and Modify Tables : 

For internal use only - training material 4 Word: Create and Modify Tables Insert rows Insert columns Delete rows Delete columns

Word: Inserting Images and Graphics : 

For internal use only - training material 5 Word: Inserting Images and Graphics Insert Chart Insert ClipArt Insert File Insert Pictures

Word: Insert, view, and edit comments : 

For internal use only - training material 6 Word: Insert, view, and edit comments Inserting comments Editing comments Reviewing Pane Hiding comment or viewing comment

Word: Saving New document : 

For internal use only - training material 7 Word: Saving New document Save Save as Save as web page

Word: Creating a table of contents : 

For internal use only - training material 8 Word: Creating a table of contents Creating a table of contents using custom heading styles Use hyperlinks or page number

Word: Choosing font & font size : 

For internal use only - training material 9 Word: Choosing font & font size Decide which font is best. Select font size Use BOLD, italic, Underline, Shadow

Word: Spelling and Grammar check : 

For internal use only - training material 10 Word: Spelling and Grammar check Check Spelling Check Grammar

Tools in Excel : 

For internal use only - training material 11 Tools in Excel Create new invoices Predefined formulas Create tables and charts

Excel: Importing text file to excel : 

For internal use only - training material 12 Excel: Importing text file to excel Select Text file Text import wizard

Excel: Create workbook for shared use : 

For internal use only - training material 13 Excel: Create workbook for shared use Open the document Go to tools, click Share Workbook

Excel: Define and apply filters : 

For internal use only - training material 14 Excel: Define and apply filters Click Data from the menu bar Point to Filter, then AutoFilter Select the column or entire row of header

Excel: Create Pivot table : 

For internal use only - training material 15 Excel: Create Pivot table Pivot table and pivot chart report List range New worksheet

Excel: Modify worksheet name and position : 

For internal use only - training material 16 Excel: Modify worksheet name and position Name worksheet Moving position of the worksheet

Excel: Save workbook using different names : 

For internal use only - training material 17 Excel: Save workbook using different names Save As Enter a different name

Excel: Insert, Delete, and Move Cells : 

For internal use only - training material 18 Excel: Insert, Delete, and Move Cells Need to add and delete information Insert or delete cells, block of cells or entire rows or columns Check the alignment of your data

Excel: Merge or Split cells : 

For internal use only - training material 19 Excel: Merge or Split cells Create a title that spans few columns Merge few cells into one large cell Split cells into their original cell

Tools in Access : 

For internal use only - training material 20 Tools in Access Keep customer information Combine several database

Access: Creating a database : 

For internal use only - training material 21 Access: Creating a database In Design view Using wizard Entering data

Access: Enter, Edit, and Delete Records : 

For internal use only - training material 22 Access: Enter, Edit, and Delete Records Using the Datasheet view, enter, edit, or delete data Form usually displays one record at a time Use the toolbar to move between records

Access: Add subtotals for groups of records : 

For internal use only - training material 23 Access: Add subtotals for groups of records Create a calculated control Contains built-in formulas Add it to the Group Footer section of report

Access: Import excel file to Access : 

For internal use only - training material 24 Access: Import excel file to Access From File menu bar, get external data, then click Import Select the excel file and click Import Check the ‘First row contains column headings Choose own primary key option button

Access: Create queries : 

For internal use only - training material 25 Access: Create queries Queries button Create query by using wizard Choose the fields you want Enter the title for the query

Access: Create lookup field : 

For internal use only - training material 26 Access: Create lookup field Data entry easier, faser, and more accurate Lookup properties Lookup wizard

Access: Filter records : 

For internal use only - training material 27 Access: Filter records Filter by selection Selection tool in datasheet view and form view

Tools of PowerPoint : 

For internal use only - training material 28 Tools of PowerPoint Visual aid for our customers Added special effects Customers can follow along

PPT: Creating slide show : 

For internal use only - training material 29 PPT: Creating slide show Create presentations for our customers Advertise our product lines Training materials

PPT: Open and close a presentation : 

For internal use only - training material 30 PPT: Open and close a presentation Depends on personal working style Start with blank presentation Open an existing presentation to edit or modify

PPT: Format Text on slides : 

For internal use only - training material 31 PPT: Format Text on slides Many formatting features Use bold formatting to emphase certain words Bright colors to add cheers Format wisely and consider your audience

PPT: Change views : 

For internal use only - training material 32 PPT: Change views Normal view Slide Sorter View Slide show

PPT: Review presentation comments : 

For internal use only - training material 33 PPT: Review presentation comments Review all comments Reviewer’s comments appear in different color Merge with original file Accept or reject changes

PPT: Add text box to slides : 

For internal use only - training material 34 PPT: Add text box to slides Add text anywhere in the slide Text box button Place the text box

PPT: Customize slide backgrounds : 

For internal use only - training material 35 PPT: Customize slide backgrounds Add fill effects Add bitmap graphics Add freeform objects Add autoshapes

PPT: Set up review cycle : 

For internal use only - training material 36 PPT: Set up review cycle Send file using e-mail Send to routing recipient Choose the addresses of recipient

Welcome Aboard! : 

For internal use only - training material 37 Welcome Aboard! Thank you! Questions and answers