Microsoft Office

This book does not assume any prerequisites other than general computer use. It has been written for student and adults who want to learn better techniques within Microsoft Office. Much of what is covered here can be applied in a general sense to OpenOffice.org or other office packages.

This book is about the topic of Microsoft Office. It is designed for today's student who needs to learn the information quickly. It is also designed to help students better teach themselves. It will point out the help features in Microsoft Office periodically so you will be able to use this feature fully. It is also intended to focus on their future by making them investigate different careers that fit their interest profile through this course.

Assessments

There are vocabulary quizzes and tests available on http://www.yacapaca.com under the PC Applications authoring group and course. This is a free online resource for giving tests and quizzes for teachers and students. I have organized the quizzes and tests according to the chapters in this book and will be updating my questions as this book is being developed.

Table of Contents

Word

Create and Edit a Document

Spacing and Special Characters

Create and Edit a Flier

Create and Edit a Research Paper in MLA format

Create and Edit a Research Paper in APA format

Create and Edit a Cover Letter

Create and Edit a Resume

Opening a Word File as Read Only

Create a Proposal with collaboration

Edit your Cover Letter into a form letter with mailing labels

Create a Newsletter

Excel

Excel Terminology

Navigating Cells

Working with Data

Working with Formulas

Making Beautiful Charts

Printing in Excel

Create a Workbook to Analyze your Field of Interest with Embedded Chart

Create a Personal Budget with functions

Create a College Expense Analysis Workbook

Troubleshooting Excel Errors

Loan Payment Amortization Schedule

Create a Pivot Table

Create a spreadsheet with lists

Create a spreadsheet with multiple worksheets

Excel Basic Exam

Access

Create a basic two table database with reports

Create queries for a database

Using and updating a database

Creating Forms and Reports from multiple tables

Creating Sub-forms

Creating a data access point for the internet

Reports

Access Basic Exam

PowerPoint

PowerPoint Terminology

Strategies for College Success

Creating and Editing a Presentation

Formatting Text Slides

Using Graphics and Animations

Creating a Custom Design Template

Preparing to Deliver a Presentation

Publisher

Create a Greeting Card

Create a Business Card

Create a Poster

Create a Banner