Published on October 24, 2009
ITM Final Project : ITM Final Project Donel Laudon Working Document Did you get the Word? : Did you get the Word? An Introduction to Microsoft Office Word The Logistics - Margins : The Logistics - Margins Select the Page Layout tab and locate the Page Setup group. In this group you will locate: Margins Option Selecting Custom Margins to specify settings. Once you have made your selection, click Ok. From the Margins gallery you have the option of selecting a standard margin set or… Formatting with Purpose : Formatting with Purpose Formatting Text Style Size Color Effects Alignment Left Alignment Center Alignment Right Alignment Justified Alignment Text of a document can be formatted for: You can align each line of a paragraph for: To change the font style, size or color, select the Font group on the Home tab. To change the alignment of a selected paragraph, select the Paragraph group on the Home tab. Visual Aid : Visual Aid From the Insert tab, in the Illustrations group you can select to insert a Picture, Clip Art, Shapes, SmartArt or a Chart. To insert a picture from a file or clip art, click on the Insert tab and then click on the Illustrations group. From here you can select either a picture from your own personal files, Microsoft Clip Art, or photo album. You can also choose to select a chart, SmartArt, or shape from this group. Another quick tip for visual content is to add Word Art to give your text some pop… Visual Aid Spread the Word : Spread the Word On the Mailings tab, in the Start Mail Merge group… And click on Step by Step Mail Merge Wizard. In the Mail Merge task pane, make your selection for the type of document you wish to create. For this example we will select letters. At the bottom of the task pane click on Next: Starting document to continue on. From here click on Next: Select recipients Making a selection from Use an existing List, click on Browse… Select your desired data source! In the Write your letter section you can choose to enter your own merge fields from the data source or… In You can also select to use the Address block or Greeting line by matching your own fields, that will result in both the look and data you select. Select preview results to view your document settings and You can also select Finish & Merge to complete your Mail Merge and Print. Keep It Together : Keep It Together Header Footer Select the Insert tab and locate the Header / Footer group. To insert a Header or Footer click either the Header or Footer button. In the Header or Footer gallery, you may either select from a pre-formatted option and in the placeholder type the text you want. Draw Some Attention : Draw Some Attention To add some visual interest to your word document or even format your own letterhead you can add a page or paragraph border by clicking on the Page Layout tab and selecting the Page Background Group. From here you can select the Page Borders button to format your document. In the Borders and Shading dialog box in the setting area you can either select a preset style or customize with your own selection of color, style, and width. Once you’ve made your selection click okay to accept. Mark the Spot : Mark the Spot To create a standard table of contents, select the References tab, followed by the Table of Contents group. Here you click the Table of Contents button. In the Table of Contents dialog box, click Modify. From here select the style. You can go even further by clicking Modify, to change the font, paragraph, tabs, border and other formatting that suits your needs. Once your finished click OK to see the final product. Network changes : Network changes To turn Track Changes on or off, on the Review tab, in the Tracking group, click on the Track Changes button. You can process the revisions of the document by: Accepting or Rejection the change one at a time. You can process the revisions of the document by: Highlight text containing changes and Accept or Reject all selected changes. Safe Keeping : Safe Keeping To set a password, by accessing the Office button, display the Save As dialog box and specify a location and name for the document. At the bottom of the dialog box, click Tools, followed by General Options. In the General Options dialog box, in the Password to open: or Password to modify:, type in a password. Once this is complete click OK. You will be asked to Confirm Password by reentering it. Once complete, click Save in the Save As dialog box. The password will remain on the document until you remove it. Analyze This! : Analyze This! An Introduction to Microsoft Office Excel Highlights of the Day : Highlights of the Day Applying conditional formatting Conditional formatting simply makes data from a worksheet easier to locate and interpret. Conditions are placed on cell contents. If the condition applies, the cell is formatted as requested by the user and if the condition does not apply the cell remains unchanged. The Conditional Formatting button can be located under the Home tab in the Styles group. Here you can choose to select a preset conditional rule for a cell or to create a new rule. It is here that you can also select to modify or manage your conditional formatting rules. In the New Formatting Rule dialog box select the type of rule you want. In the Edit the Rule Description, specify the condition and click Ok. Filter or Sort Through : Filter or Sort Through Highlight the content you wish to sort or filter. On the Data tab, under the Sort & Filter group, select either the Sort button or Filter button. If you select the Sort button, the Sort dialog box will appear. From here you can elect to sort by one level of data or… you can add a level and go even more in-depth in your search. Look Me Up : Look Me Up To create a PivotTable, select the Insert tab. You will find the PivotTable button under the Tables group. In the PivotTable Field List, you can select data from the Excel worksheet for placement in the Row Labels, Column Lables, and Values. Once you select the PivotTable button, the Create PivotTable dialog box will appear. From here you will select the table or range of data that will be included in the Pivot Table. After you’ve made your data selection, the PivotTable toolbar will appear in the Ribbon. Your end result will be much like the example to the left. You can select to format the PivotTable by… selecting the Design tab under the PivotTable tools. All Comments Aside : All Comments Aside With the designated cell you wish to comment on selected, find the Review tab, go to the Comments group, and select the New Comment button. A comment box will open for you to place any notes or commentary about the data within the cell. IntegrityData Protection : IntegrityData Protection In the Format Cells dialog box, select the Protection Tab. Here make a selection to lock cells to prevent data being changed and/or hide forumulas. Select the Review tab on the Ribbon, and click the Protect Sheet button under the Changes group. In the Protect Sheet dialog box, make your selections on what functions you want to allow users of your worksheet to be able to use. Provide a password if desired and click OK. Charting the Course : Charting the Course Under the Insert tab in the Charts group, make a selection in style of Chart you wish to add to your Excel worksheet and/or workbook. You will be prompted to select the data you want for your chart. You will end up with a result in the style of chart you originally selected. From here you can choose to modify your data points and even add the chart as a separate worksheet to the workbook. Slide 19: All At Once Format Painter With Format Painter you can select an already modified cell, click on the Format Painter and… select another cell you wish to format in the same fashion. It is a quick and easy tool that prevents you from having to repeatedly make your formatting selections. Direct Connect : Direct Connect By selecting the Hyperlink button in the Links group, under the Insert tab, you can designate a cell to reference another worksheet that contains detailed data. Once you’ve selected the Hyperlink button, the Insert Hyperlink dialog box will open and give you the option of linking to an Existing File or Web Page; Place in This Document; Create New Document; or E-mail Address. Formulate : Formulate Select the Forumlas tab and find the Function Library group. Here you will find many quick reference formulas. Select the cell in which you want the product of the formula to appear and then make a selection of a quick reference forumla from the Function Library. Verify that the formula is referencing your desired cells and make any modificaitons necessary. Some example formulas: Gain Access : Gain Access An Introduction to Microsoft Office Access Data Entry : Data Entry Define your data needs and data types Text – upto 255 characters. Memo – upto 65,535 characters Number Date/Time Currency Yes/No Correct database desing involves applying rules that achieve all fields in a record being dependent on a primary key. Primary Key – Designates the field in a table that is used to uniquely identify each record. When a table has a primary key, no two records can have the same value. To set the Primary Key, open the Table in Design View and click the field you want to define as the Primary Key. On the Design tab, in the Tools group, click the Primary Key button. To remove the Primary Key, click the Primary Key Field and in the Tools group, click the Primary Key button. Keep Your Data Straight : Keep Your Data Straight Tables On the Create tab, in the Tables group, click the Table button Save the table with the name you want. From here you can select your desired View Or add new fields to your table. Stay in formationforms : Stay in formationforms To create a form, go to the Create tab, on the Forms Group and select the Forms button. Under the Form Design Tools, Design tab, you will find many tools to format and create the Form to look and function how you desire. Reporting : Reporting On the Create tab, in the Reports group, select the Report button. To insert a picture or logo in a Report, on the Format tab of the Report Layout Tools, in the Controls group, click the Logo button. Make your selection from stored pictures. Building Relationships : Building Relationships Three types of Relationships can be created: One-to-One – Each record is unique in the Primary Table and can have one and only one related record in another table. One-to-Many – Each record is unique in the Primary Table and can have many corresponding records in the other table. Many-to-Many – Each record is unique in the Primary Table and can have many corresponding records in the other table and vice versa. On the Database Tools tab, in the Show/Hide Group, click the Relationships button to display the Relationship window. On the Design tab, in the Relationships group, click the Show Table button. Then in the Show Table dialog box, select one or more tables or queries, click Add and then click Close. Drag a Primary Key Field from one table to the Foreign Key Field of another table. In the Edit Relationships dialog box, click Create. Slide 28: Queries Under the Create tab, in the Other group, select the Query Wizard button. When the New Query dialog box opens select the style of Query you wish to use. Find the right style of query for your use: Simple query – Locates records and displays information from fields you select. Crosstab query – Locates records and displays information from the fields you specify in a worksheet format. Find duplicates – locates records that have the same information in one or more fields in a single table. Find unmatched query – Locates records in one table that have no matched records in another table. Import From Other Sources : Import From Other Sources To export/import data from Access or other sources, select the External Data tab. Here you will find the Import group which allows you to import data from Access, Excel, SharePoint List, Text File, XML File, and more. In the Export group you will find functional buttons to export Access data to Excel, SharePoint, Word and/or a Text file. Power of Persuasion : Power of Persuasion An Introduction to Microsoft Office PowerPoint Give It Some Visual : Give It Some Visual Under the Design tab, select a pre-formatted Theme from the Theme group. You can customize a pre-formatted Theme to suit your needs by changing the color, size and style of the Font, and/or the background. To change the background select the Background Styles button on the Background group. Customize in the Format Background dialog box. Charts : Charts Select the Chart button off the Illustrations group from the Insert tab. Select the type and style of chart that you want to add from the Insert Chart dialog box. Enter the data for plotting in the linked Excel worksheet. The chart in the PowerPoint presentation will automatically update. tables : tables On the Insert tab, go to the Tables group and select the Tables button. From there select the number of rows and columns that you would like in the table. Once you’ve created your table you can easily format it for visual appeal by selecting the Format Tab, under Table Tools. WordArt : WordArt Select the WordArt button, under the Insert tab, in the Text group. Under the Drawing Tools, in the Format Tab, on the WordArt Styles group, from the drop down you can select a preformatted style. Your final product will give any presntation a little pop and capture your audience’s attention. Animation : Animation Select Custom Animation button on the Animations group, on the Animations tab. A Custom Animation dialog box will appear on the right of your presentation workspace. From here you can add the effect to your selected text or graphic. You have a choice between the Entrance, Emphasis, and Exit of the selected item. Once you’ve selected the effect, you can customize it even further by coordinating when the effect starts, the direction, and the speed. Transitioning : Transitioning On the Animation tab, in the Transition to This Slide group, display the Transitions gallery, and click on the transition you want. To change the speed of a transition click the Transition Speed List in the Transition to This Slide group. To apply the same transition to all slides, in the Transtions to This Slide group, select the Apply to All button. You can incorporate sound into a transition by selecting in the Transition to This Slide group, the Transition Sound list. Slide 37: Straight To The Show To set up and view your slide show, select the Slide Show tab. From here you can set up your slide show from making selections under the Set Up group. You can also preview your slide show by making selections from the Start Slide Show group. Of course for a quick preview of your slide show you can select the shortcut key of F5 without any use of your mouse. Quick and efficient. To get back into the PowerPoint workspace, simply hit the ESC (Escape) key. Notes : Notes On every slide workspace a user can add presentation or slide notes to the designated Notes area. These notes are available to print on handouts as we will discuss later. Printing : Printing When Printing your presentation you have many different options. Available in both Print and Print Preview you will find options to print Handouts with 1, 2, 3, 4, 6, or 9 slides per page. You will also find an option for Slides, Notes Pages, and Outline View. I prefer making this selection in the Print Preview option, as I am able to see my final product first hand and avoid wasting office supplies. As previously stated, you can add notes to your slides that pertain to the presentation or material contained with in the slide, speaking points. One of the many options for printing is to print your Notes Pages. As shown in the example both your slide and notes print, allowing you to use them later while giving your presentation or as handouts to your audience for later reference. I hope you enjoyed today’s lesson. : I hope you enjoyed today’s lesson. Thank you for your time!