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[1] 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

References

  1. Wikibooks: OpenOffice.org
Last modified on 22 June 2011, at 13:02