Untitled Document

Microsoft Office for Beginners

Description

This class will give students an overview of the Microsoft Office applications and how they work together. Students will be able to create and edit Word documents that include outlines, tables, styles and sections. Students will be able to create and edit Excel spreadsheets that include charts and "what-if" analysis. Students will be able to create and edit PowerPoint presentations. Students will be able to create Access databases that include tables, forms, queries and reports. Students will need a basic understanding Windows to complete this class. Students will need a copy of Office. A 30-day trial version is available.

Objectives

Students will create and edit Word documents.
Students will format their documents and add tables and column formatting to their documents.
Students will create and edit Excel worksheets.
Students will add formulas, function and formatting to their Excel workbooks.
Students will create data tables and forms in Access.
Students will create queries and filters and set up their tables to ensure data accuracy.
Students will create and edit presentations in PowerPoint.
Students will format their PowerPoint presentations and prepare them to be displayed electronically.
Students will manage email and their in-box using Outlook.
Students will manage appointments and schedules using the calendar feature of Outlook.
Students will create a final project using what they learned in the class.

Book

Choose the book to go with your version of Office:

The 2007 Microsoft Office System Step by Step

Author: Online Training Solutions Inc.
Publisher: Microsoft Press
ISBN: 0735622787

Microsoft Office System Step by Step -- 2003 Edition

Author: Online Training Solutions Inc.
Publisher: Microsoft Press
ISBN: 0735615209

Lesson 1: Microsoft Word

Read the Introductory chapters and chapters 1 and 2 of the book. Read the online content in the classroom.

Lesson 2: Microsoft Word

Read chapters 3 and 4. Read the online content in the classroom.

Lesson 3: Microsoft Excel

Read Chapters 5 and 6 in the bok and review the online content.

Lesson 4: Microsoft Excel

Read Chapters 7 and 8 in the book and review the online content.

Lesson 5: Microsoft Access

Read Chapters 9 and 10 in the book and review the online content.

Lesson 6: Microsoft Access

Read Chapters 11 and 12 in the book and review the online content.

Lesson 7: Microsoft PowerPoint

Read Chapters 13 and 14 in the book and review the online content.

Lesson 8: Microsoft PowerPoint

Read Chapters 15 and 16 in the book and review the online content.

Lesson 9: Microsoft Outlook

Read Chapters 17, 18 and 19 in the book and review the online content.

Lesson 10: Microsoft Outlook

Read Chapters 20 and 21 in the book and review the online content.

Lesson 11: Putting It All Together

Review the chapters covered in the book.