| |
| |
| IC3-2009 Unit 2- Using Productivity Software Outline | |
| |
| |
| |
| Starting with Office Applications | |
| |
| |
| |
| Start an Application and Identify Common On-Screen Elements | |
| |
| |
| |
| Open and Save a File, and Close Applications | |
| |
| |
| |
| Navigate a Document and Insert, Select, and Edit Text | |
| |
| |
| |
| Use Buttons and Dialog Boxes | |
| |
| |
| |
| Check Spelling and Grammar | |
| |
| |
| |
| Select and Format Text | |
| |
| |
| |
| Copy, Paste, Cut and Move Text | |
| |
| |
| |
| Use Galleries, Contextual Tabs, and the Quick Access Toolbar | |
| |
| |
| |
| Print Documents | |
| |
| |
| |
| Use Help | |
| |
| |
| |
| Creating a New Word Document and Inserting Graphics and Tables | |
| |
| |
| |
| Create a Document | |
| |
| |
| |
| Create and Modify a Bulleted List | |
| |
| |
| |
| Format, Align and Indent Text | |
| |
| |
| |
| Create a Title with WordArt | |
| |
| |
| |
| Insert and Modify Clip Art | |
| |
| |
| |
| Insert and Modify Pictures | |
| |
| |
| |
| Insert Tables | |
| |
| |
| |
| Format Tables | |
| |
| |
| Lesson 9 Insert a Header or Footer in a Document | |
| |
| |
| |
| Create a Document from a Template | |
| |
| |
| |
| Format and Organize Paragraphs and Documents | |
| |
| |
| |
| Import and Modify Text | |
| |
| |
| |
| Create, Apply, and Modify Styles | |
| |
| |
| |
| Use Language Tools | |
| |
| |
| |
| Create Footnotes | |
| |
| |
| |
| Manage Citations | |
| |
| |
| |
| Prepare Document for Printing | |
| |
| |
| |
| Formatting Informational Documents | |
| |
| |
| |
| Insert Data from Another Document | |
| |
| |
| |
| Format a Multi-Column Document | |
| |
| |
| |
| Save a Document as a Template | |
| |
| |
| |
| Insert Data from Excel | |
| |
| |
| |
| Create a Tabbed List | |
| |
| |
| |
| Use the Format Painter | |
| |
| |
| |
| Save a Document as a PDF Fil | |
| |
| |
| |
| Save a File as a Web Page | |
| |
| |
| |
| Work with Collaborative Tools | |
| |
| |
| |
| Insert Comments into a Document | |
| |
| |
| |
| Track Changes in a Document | |
| |
| |
| |
| Review and Consolidate Changes | |
| |
| |
| |
| Create a Document Template for Merging | |
| |
| |
| |
| Insert Merge Fields into a Document | |
| |
| |
| |
| Merge Document with a Data Source | |
| |
| |
| |
| Transmit Files Electronically | |
| |
| |
| |
| Creating a Formatting a Worksheet | |
| |
| |
| |
| Navigate a Workbook, Select Cells, and Enter Text and Data | |
| |
| |
| |
| Adjust Column Widths | |
| |
| |
| |
| Insert or Delete Rows or Columns | |
| |
| |
| |
| Sum a Column of Numbers | |
| |
| |
| |
| Format Numbers and Dates | |
| |
| |
| |
| Align Text | |
| |
| |
| |
| Add Emphasis, Colors, Shading and Borders | |
| |
| |
| |
| Open, Copy, Insert, and Delete Worksheets | |
| |
| |
| |
| Format, Sort, and Filter Tables | |
| |
| |
| |
| Document and Print Worksheets | |
| |
| |
| |
| Managing Money Using Formulas and Functions | |
| |
| |
| |
| Fill Labels and Use Worksheet Functions | |
| |
| |
| |
| Use the Payment Function | |
| |
| |
| |
| Fill a Sequence of Numbers as Labels and Format Them as Text | |
| |
| |
| |
| Use References to Cells in Other Worksheets and Relative Cell References | |
| |
| |
| |
| Calculate a Percentage Increase and Decrease Using Absolute Cell References | |
| |
| |
| |
| Use a Cash Flow Analysis | |
| |
| |
| |
| Calculate a Simple Payment Using a Hidden Row, the IF Function and Conditional Formatting | |
| |
| |
| |
| Use the Internal Rate of Return Function | |
| |
| |
| |
| Print Large Worksheets | |
| |
| |
| |
| Giving Meaning to Data Using Charts | |
| |
| |
| |
| Create a Column Chart | |
| |
| |
| |
| Edit Chart Elements | |
| |
| |
| |
| Use a Pie Chart | |
| |
| |
| |
| Chart a Trend with a Line Chart | |
| |
| |
| |
| Format Axis Labels and Add a Trendline | |
| |
| |
| |
| Document the Chart and Worksheets | |
| |
| |
| |
| Creating a Presentation | |
| |
| |
| |
| Create a Presentation and Work in Different Views | |
| |
| |
| |
| Add Slides to a Presentation | |
| |
| |
| |
| Add Graphic Elements | |
| |
| |
| |
| Add a Design | |
| |
| |
| |
| Animate a Presentation | |
| |
| |
| |
| Create Handouts | |
| |
| |
| |
| Enhancing a Presentation | |
| |
| |
| |
| Import Slides into a Presentation | |
| |
| |
| |
| Add Data Elements to a Presentation | |
| |
| |
| |
| Control Design Elements | |
| |
| |
| |
| Add Headers and Footers | |
| |
| |
| |
| Add Timings to a Presentation | |
| |
| |
| |
| Create and Print Speaker Notes | |
| |
| |
| |
| Preview and Navigate a Slide Show | |
| |
| |
| |
| Creating a Customized Database | |
| |
| |
| |
| Open and Navigate a Database | |
| |
| |
| |
| Create a Database and Add Tables | |
| |
| |
| |
| Change Table Field Properties | |
| |
| |
| |
| Create Table Relationships | |
| |
| |
| |
| Add and Delete Records | |
| |
| |
| |
| Create a Form Using the Form Wizard | |
| |
| |
| |
| Create a Report Using the Report Wizard | |
| |
| |
| |
| Retrieving Information from Your Database | |
| |
| |
| |
| Find Records | |
| |
| |
| |
| Sort Records | |
| |
| |
| |
| Filter Records | |
| |
| |
| |
| Create Select Queries | |
| |
| |
| |
| Create Compound Queries and Use Comparison Operators | |
| |
| |
| |
| Create a Query Based on Two Tables | |
| |
| |
| |
| Use a Wildcard to Locate Data | |