Helen Holding

Mastering Microsoft Office

Preface Introduction to Windows and Office Microsoft Word: Getting Started Microsoft Word: More Fundamentals and Printing Microsoft Word: Text Enhancement and Document Layout File Management Microsoft Excel: Getting Started Microsoft Excel: Cell Manipulation and Worksheet Layout Microsoft Excel: Functions and Formulae Microsoft Excel: Charts and Multi-Worksheet Workbooks Introduction to Databases Database Tables Relationships Queries Forms and Reports Introduction to Powerpoint Designing a Presentation Excel Functions Introduction to Outlook Index

Introduction to PowerPoint

In this chapter you will learn how to create presentations based on predesigned templates in PowerPoint. You will then perform some very simple manipulations on one of the presentations. You will cover the following features of PowerPoint: Creating a presentation with the AutoContent Wizard. Saving. Changing views. Printing. Closing a presentation. Creating a presentation with a Presentation template. Simple editing. Simple animation.

Introduction to Windows and Office

In this chapter you will learn how to do the following: Understand the relationship between Windows, Office, Word, Excel, Access, PowerPoint and files. Become familiar with the terminology used throughout this book. Switch on the PC and start Windows. Shutdown the PC.

Microsoft Excel — Cell Manipulation and Worksheet Layout

In this chapter you will learn how to carry out the following techniques: Copy your workbook. Edit the contents of a cell. Select a range of cells. Sort a range of cells. Copy, move and clear cell contents. Insert and delete rows and columns. Align and format text. Change column and row width. Use AutoFormat to enhance the worksheet. Define the page layout.

Introduction to databases

In this chapter you will create a small database in Access, and perform some simple manipulation on it. You will cover the following features of Access: Creating a database. Creating a table. Entering data. Sorting. Simple filters. Closing a database.