MS Word 2013: Document Basics & Formatting

• The MS Office 2013 Syllabus includes 24 hours of training.
• The MS Word 2013 course has 8 hours of classes.

Basics of a Document

• Start with opening a new document.
• Navigate the Home Tab to use tools like cut, copy, paste, format painter, find, replace, formatting options, and fill colours.
• Improve the document by applying styles, and inserting pictures or SmartArt.

Editing/Formatting the Document

• Text boxes can be added for emphasis or layout purposes.
• "My App and store" can be useful for productivity.
• Use headers and footers to add consistent information across pages.
• Electronic signatures can be added for verification.
• Add shapes and other Objects.
• Objects can be manipulated by grouping several objects together.
• Wrapping can modify the way objects interact with text.

Setting up the Page

• Alter the page size to fit the output requirements.
• Columns are helpful to format text like in a newspaper.
• Initiate a page break to start a new page.
• Modify the indent spacing to change paragraph spacing.
• Use hyphenation to improve the flow of text by splitting words over lines.

Viewing/Finalizing the Document

• Add References to give credit to sources.
• Include a Citation and Bibliography that make the document scholarly.
• Mail merge allows documents to be personalized.
• Review the document to ensure quality.
• Add comments for collaborative editing.
• Viewing helps review.

Printing/Closing the Document

• Print the document when it is finalized.
• Save the document to preserve the work.
• Close the document to exit the file.
• The MS Excel 2013 course has 8 hours of classes.

Basics of Creating a New Workbook

• Introduction includes navigating MS Office.
• Data in cells can be entered for calculations and storage.
• Rows and columns can be inserted to increase space.
• Entire worksheets can be inserted and deleted as necessary.
• Modify the number format to change the way data is displayed.

Editing/Formatting a Workbook

• Use the Insert Tab to add various objects.
• Insert tables for organized data presentation.
• Insert pictures to communicate information.
• Slicers are helpful for visual filtering.
• Hyperlinks can link to references.
• Use headers and footers to add context to output.

Charts

• Column charts are helpful to show comparisons using 2D and 3D models.
• Bar charts are effective when the column labels are too long.
• Pie charts compare proportions of categories in a sample.
• Scatter charts are useful to see correlations between many samples.
• Combo charts show both bars and lines, enabling comparison in two different ways.
• Line charts are used to see variation over a continuous range.
• The Data Tab allows you to work with sets.
• Sort and filter helps organize information.
• Flash files 2013 can create quick files.
• Data validation ensures accuracy.
• Remove Duplicates to ensure you are not skewing statistics.
• Change the page layout to fit output.

Functions

• Formulas perform calculations on given inputs.
• Review uses tools such as spelling and theasaurus to check.
• Comments can be added for collaborative editing.
• View Options allows changes to be made to the way the file is worked with.
• Freeze panes keeps the first line in view.

Printing/Saving a Workbook

• Save the Workbook often to prevent data loss.
• Recover unsaved workbooks to restore data.
• Close the Workbook when work is complete.
• The MS PowerPoint 2013 Course has 8 hours of classes.

Create a Basic Presentation

• An introduction to PowerPoint 2013 is included.
• The Quick Access Toolbar allows quick manipulation.
• Existing Presentations already created by the user can be edited.
• PowerPoint uses slides for different screens.
• Formatting the text will make it more visually appealing.

Editing

• Insert tables for organized data presentation.
• Insert text as the primary information communication method.
• Adding Rows and Columns will expand the amount of presentable information.
• Designing the table will improve appearance.
• Slides can embed media such as pictures.
• SmartArt and Word Art can improve overall presentation.
• Hyperlinks allow direct access to outside webpages.
• Actions are helpful for animations.
• Using videos and audios are helpful for keeping presentations captivating.

Formatting/Designing

• Formatting will refine the overall appearance.
• Designing presentations keeps the content consistent.
• Transitions can be added between slides.
• Slide transitions can be removed.
• Show created content using slide show function.
• Animations can be used to make the presentation captivating.

Setting up/Saving the Presentations.

• Show slides can be adjusted.
• Advance slides move the show forward.
• Multiple monitors can be used for presenting and monitoring.
• Slides can be reviewed.
• Use Master View to keep things looking consistent.
• Handout Master lets slides work as handouts.
• Note master allows the presenter to add personal notes.
• Presentations should be saved.
• Presentations can be shared.
• Presentations can be printed.
• Close the presentation when edits are done.