Exploring Microsoft Office 2007

Office Fundamentals Robert Grauer, Linda Ericksen, Keith Mulbery Committed to Shaping the Next Generation of IT Experts.

Copyright © 2008 Pearson Prentice Hall. All rights reserved.

1

Objectives  Identify common interface components   Use Office 2007 help Open a file   Save a file Print a document   Select text to edit Edit text in the insert and overtype modes Copyright © 2008 Pearson Prentice Hall. All rights reserved.

2

Objectives (continued)  Move and copy text  Find, replace, and go to text  Undo and Redo  Use language tools  Apply font attributes  Copy formats with Format Painter Copyright © 2008 Pearson Prentice Hall. All rights reserved.

3

Office 2007 Applications

Word

Document processing

Excel

Spreadsheet

PowerPoint

Presentation

Access

Database Copyright © 2008 Pearson Prentice Hall. All rights reserved.

4

Common Interface Components   Office Button  Office Menu Quick Access Toolbar   Title Bar Ribbon  Tabs   Groups Commands  Status Bar Copyright © 2008 Pearson Prentice Hall. All rights reserved.

5

Common Interface Components Office Button Quick Access toolbar Title bar Office menu Copyright © 2008 Pearson Prentice Hall. All rights reserved.

6

The Ribbon Active tab Tabs Ribbon Groups Copyright © 2008 Pearson Prentice Hall. All rights reserved.

Commands 7

The Ribbon (continued) Copyright © 2008 Pearson Prentice Hall. All rights reserved.

8

The Ribbon (continued) Gallery Contextual tab Dialog box launcher Live preview Copyright © 2008 Pearson Prentice Hall. All rights reserved.

9

Keyboard Shortcuts Key tip Copyright © 2008 Pearson Prentice Hall. All rights reserved.

10

The Status Bar Status bar View commands Zoom slider Copyright © 2008 Pearson Prentice Hall. All rights reserved.

11

Office 2007 Help Print topic Table of contents Help button Search box Help topics Copyright © 2008 Pearson Prentice Hall. All rights reserved.

Dialog box 12

Super ToolTip Help Command name Command description Additional help Copyright © 2008 Pearson Prentice Hall. All rights reserved.

13

Dialog Box Help Open dialog box Copyright © 2008 Pearson Prentice Hall. All rights reserved.

14

Universal Tasks  Manipulating files  Creating new files  Opening files  Saving files  Printing files  Manipulating documents  Editing documents  Formatting documents Copyright © 2008 Pearson Prentice Hall. All rights reserved.

15

Creating New Files Software Word Default Filename Document1 PowerPoint Presentation1 Excel Access Book1 Database1 Copyright © 2008 Pearson Prentice Hall. All rights reserved.

16

Saving a File Folder selected Up one level Create a new folder 1. Views My Places bar Files in the My Documents folder 2. 3. Copyright © 2008 Pearson Prentice Hall. All rights reserved.

4. 17

My Places Bar Folder to add Shortcut menu Point here and right-click Copyright © 2008 Pearson Prentice Hall. All rights reserved.

18

Opening a File Storage location My Places bar Down arrow View of folders and files in My Documents Look in toolbar buttons Copyright © 2008 Pearson Prentice Hall. All rights reserved.

19

Open Dialog Box Copyright © 2008 Pearson Prentice Hall. All rights reserved.

Open arrow Open options 20

Recent Documents List Push pin Recently used documents Copyright © 2008 Pearson Prentice Hall. All rights reserved.

21

Previewing a Document Close print preview Document Copyright © 2008 Pearson Prentice Hall. All rights reserved.

22

Print Dialog Box Printer Pages to print What to print Copyright © 2008 Pearson Prentice Hall. All rights reserved.

Manual duplex Number of copies 23

Quick Printing Dialog box launcher Move up on list Copyright © 2008 Pearson Prentice Hall. All rights reserved.

24

Basic Tasks Editing Documents  Selecting  Go to        Inserting Overtype Moving Copying Clipboard Finding Replacing       Undo Repeat Spelling Grammar Thesaurus Research Formatting Documents  Font  Format Painter Copyright © 2008 Pearson Prentice Hall. All rights reserved.

25

Selecting Text Mini toolbar Selected text Copyright © 2008 Pearson Prentice Hall. All rights reserved.

26

Selecting Text (continued) Single word Whole line Whole sentence Whole paragraph Copyright © 2008 Pearson Prentice Hall. All rights reserved.

27

Insert or Overtype Set the insert key Use overtype mode Copyright © 2008 Pearson Prentice Hall. All rights reserved.

28

Moving and Copying Clipboard commands Cut Copy Formatting options Copyright © 2008 Pearson Prentice Hall. All rights reserved.

29

The Clipboard Dialog box launcher Clipboard pane Text clips Text to paste Paste option Option button Copyright © 2008 Pearson Prentice Hall. All rights reserved.

30

Find Command Find Next button Copyright © 2008 Pearson Prentice Hall. All rights reserved.

31

Find and Replace Command Replace Replace All Copyright © 2008 Pearson Prentice Hall. All rights reserved.

32

Go To Command Page number Copyright © 2008 Pearson Prentice Hall. All rights reserved.

33

Undo and Repeat Undo Repeat Action list Copyright © 2008 Pearson Prentice Hall. All rights reserved.

34

Language Tools Proofing group Shortcut menu with possible spellings Spelling error Options Copyright © 2008 Pearson Prentice Hall. All rights reserved.

Grammar error 35

Research Keyword or search term Go button Results Copyright © 2008 Pearson Prentice Hall. All rights reserved.

36

Font Attributes Font dialog box launcher Selected attribute Live preview Copyright © 2008 Pearson Prentice Hall. All rights reserved.

Preview in dialog box 37

The Format Painter Attributes of font in Format Painter Format Painter Font loaded in Format Painter Copyright © 2008 Pearson Prentice Hall. All rights reserved.

38

Questions?

Copyright © 2008 Pearson Prentice Hall. All rights reserved.

39