The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defining projects for readers in a way that’s easy to understand.\ Creating Documents with Microsoft Word 2007; Formatting and Organizing Text; Using Graphics and Tables; Special Document Formats, Columns, and Mail Merge; Creating a Worksheet and Charting Data; Managing Workbooks and Analyzing Data; Using Functions and Tables; Getting Started with Access...
The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation. This approach is based on clearly defining projects for readers in a way that’s easy to understand.Creating Documents with Microsoft Word 2007; Formatting and Organizing Text; Using Graphics and Tables; Special Document Formats, Columns, and Mail Merge; Creating a Worksheet and Charting Data; Managing Workbooks and Analyzing Data; Using Functions and Tables; Getting Started with Access Databases and Tables; Sort and Query a Database; Forms, Filters, and Reports; Getting Started with Microsoft PowerPoint 2007; Designing a PowerPoint Presentation; Enhancing a Presentation with Animation, Tables, and Charts; Using Access Data with Other Office Programs; Using Tables in Word and Excel; Using Excel as a Data Source in a Mail Merge; Linking Data in Office Documents; Creating Presentation Content from Office DocumentsMARKET: For professionals seeking to learn and understand Microsoft Office 2007.
Word 2007Word Chapter 5: Creating Documents with Microsoft Word 2007Objective 1 Create and Save a New DocumentObjective 2 Edit TextObjective 3 Select, Delete, and Format TextObjective 4 Print a DocumentObjective 5 Navigate the Word WindowObjective 6 Add a Graphic to a DocumentObjective 7 Use the Spelling and Grammar CheckerObjective 8 Preview and Print Documents, Close a Document, and CloseWordObjective 9 Use the Microsoft Help SystemWord Chapter 6 Formatting and Organizing TextObjective 1 Change Document and Paragraph LayoutObjective 2 Change and Reorganize TextObjective 3 Create and Modify ListsObjective 4 Insert and Format Headers and FootersObjective 5 Insert Frequently Used TextObjective 6 Insert and Format ReferencesWord Chapter 7 Using Graphics and TablesObjective 1 Insert and Format GraphicsObjective 2 Set Tab StopsObjective 3 Insert and Modify Text Boxes and ShapesObjective 4 Create a TableObjective 5 Format a TableWord Chapter 8 Special Document Formats, Columns, and Mail MergeObjective 1 Collect and Paste Text and GraphicsObjective 2 Create and Format ColumnsObjective 3 Use Special Character and Paragraph FormattingObjective 4 Create Mailing Labels Using Mail MergeObjective 5 Insert HyperlinksObjective 6 Insert a SmartArt GraphicObjective 7 Preview and Save a Document as a Web PageExcel 2007Excel Chapter 9 Creating a Worksheet and Charting DataObjective 1 Create, Save, and Navigate an Excel WorkbookObjective 2 Enter and Edit Data in a WorksheetObjective 3 Construct and Copy Formulas, Use the Sum Function, and Edit CellsObjective 4 Format Data, Cells, and WorksheetsObjective 5 Close and Reopen a WorkbookObjective 6 Chart DataObjective 7 Use Page Layout View, Prepare a Worksheet for Printing,and Close ExcelObjective 8 Design a WorksheetObjective 9 Construct Formulas for Mathematical OperationsObjective 10 Format Percentages and Move FormulasObjective 11 Create a Pie Chart and a Chart SheetObjective 12 Use the Excel Help SystemExcel Chapter 10 Managing Workbooks and Analyzing DataObjective 1 Create and Save a Workbook from an Existing WorkbookObjective 2 Navigate a Workbook and Rename WorksheetsObjective 3 Enter Dates, Clear Contents, and Clear FormatsObjective 4 Move, Copy, and Paste Cell ContentsObjective 5 Edit and Format Multiple Worksheets at the Same TimeObjective 6 Create a Summary SheetObjective 7 Format and Print Multiple Worksheets in a WorkbookObjective 8 Design a Worksheet for What-If AnalysisObjective 9 Perform What-If AnalysisObjective 10 Compare Data with a Line ChartExcel Chapter 11 Using Functions and TablesObjective 1 Use SUM, AVERAGE, MEDIAN, MIN, and MAX FunctionsObjective 2 Use COUNTIF and IF Functions, and Apply ConditionalFormattingObjective 3 Use a Date FunctionObjective 4 Freeze Panes and Create an Excel TableObjective 5 Format and Print a Large WorksheetObjective 6 Use Financial FunctionsObjective 7 Use Goal SeekObjective 8 Create a Data TableAccess 2007Access Chapter 12 Getting Started with Access Databases and TablesObjective 1 Start Access and Create a New Blank DatabaseObjective 2 Add Records to a TableObjective 3 Rename Table Fields in Datasheet ViewObjective 4 Modify the Design of a TableObjective 5 Add a Second Table to a DatabaseObjective 6 Print a TableObjective 7 Create and Use a QueryObjective 8 Create and Use a FormObjective 9 Create and Print a ReportObjective 10 Close and Save a DatabaseObjective 11 Create a Database Using a TemplateObjective 12 Organize Database Objects in the Navigation PaneObjective 13 Create a New Table in a Database Created with a TemplateObjective 14 View a Report and Print a Table in a Database Createdwith a TemplateObjective 15 Use the Access Help SystemAccess Chapter 13 Sort and Query a DatabaseObjective 1 Open an Existing DatabaseObjective 2 Create Table RelationshipsObjective 3 Sort Records in a TableObjective 4 Create a Query in Design ViewObjective 5 Create a New Query from an Existing QueryObjective 6 Sort Query ResultsObjective 7 Specify Criteria in a QueryObjective 8 Create a New Table by Importing an Excel SpreadsheetObjective 9 Specify Numeric Criteria in a QueryObjective 10 Use Compound CriteriaObjective 11 Create a Query Based on More Than One TableObjective 12 Use Wildcards in a QueryObjective 13 Use Calculated Fields in a QueryObjective 14 Group Data and Calculate Statistics in a QueryAccess Chapter 14 Forms, Filters, and ReportsObjective 1 Create a FormObjective 2 Use a Form to Add and Delete RecordsObjective 3 Create a Form by Using the Form WizardObjective 4 Modify a Form in Design View and in Layout ViewObjective 5 Filter RecordsObjective 6 Create a Report by Using the Report ToolObjective 7 Create a Report by Using the Blank Report ToolObjective 8 Create a Report by Using the Report WizardObjective 9 Modify the Design of a ReportObjective 10 Print a Report and Keep Data TogetherPowerPoint 2007PowerPoint Chapter 15 Getting Started with Microsoft PowerPoint 2007Objective 1 Open, View, and Save a PresentationObjective 2 Edit a PresentationObjective 3 Format a PresentationObjective 4 Create Headers and Footers and Print a PresentationObjective 5 Create a New PresentationObjective 6 Use Slide Sorter ViewObjective 7 Add Pictures to a PresentationObjective 8 Use the Microsoft Help SystemPowerPoint Chapter 16 Designing a PowerPoint PresentationObjective 1 Format Slide ElementsObjective 2 Insert and Format Pictures and ShapesObjective 3 Apply Slide TransitionsObjective 4 Reorganize Presentation Text and Clear FormatsObjective 5 Create and Format a SmartArt GraphicPowerPoint Chapter 17 Enhancing a Presentation with Animation, Tables,and ChartsObjective 1 Customize Slide Backgrounds and ThemesObjective 2 Animate a Slide ShowObjective 3 Create and Modify TablesObjective 4 Create and Modify ChartsIntegrated ProjectsChapter 18 Using Access Data with Other Office ProgramsObjective 1 Export Access Data to ExcelObjective 2 Create a Formula in ExcelObjective 3 Create a Chart in ExcelObjective 4 Copy Access Data into a Word DocumentObjective 5 Copy Excel Data into a Word DocumentObjective 6 Insert an Excel Chart into a PowerPoint PresentationChapter 19 Using Tables in Word and ExcelObjective 1 Plan a Table in WordObjective 2 Enter Data and Format a Table in WordObjective 3 Create a Table in Word from Excel DataObjective 4 Create an Excel Worksheet from a Word TableChapter 20 Using Excel as a Data Source in a Mail MergeObjective 1 Prepare a Mail Merge Document for Mailing LabelsObjective 2 Choose an Excel Worksheet as a Data SourceObjective 3 Produce and Save Merged Mailing LabelsObjective 4 Open a Saved Main Document for Mail MergeChapter 21 Linking Data in Office DocumentsObjective 1 Insert and Link an Excel Object in WordObjective 2 Revise a Linked Excel Worksheet and Update Links in WordObjective 3 Open a Word Document That Includes a Linked Object andUpdate LinksChapter 22 Creating Presentation Content from Office DocumentsObjective 1 Insert a Word Outline into PowerPointObjective 2 Import Excel Data into a PowerPoint ChartObjective 3 Insert a Hyperlink into a PowerPoint Slide