Microsoft Office 2007

Microsoft Office 2007 Intro

Office 2007 Intro to Office: The Basics What, Where, and Why?
What is Office?
Where on earth is everything located?
Word, PowerPoint, OneNote, Excel, Access, and Outlook have incorporated the RIBBON .
The RIBBON provides easy (sometimes iconic) access to options that were harder to find in previous Office versions.
Rule #1- Listen to your own questions!
The biggest question about using Office 2007 is “How do I…?”
For example: How do I insert a picture?
Read your question:
The Ribbon and Live Previews
You can point to some formatting options on the RIBBON (such as font, size, color) and see what it would look like without selecting it and having to make the change.
Formatting options also appear when you highlight an object to change.
The Office Button
By clicking on the Office Button, you find important options such as Save, Save As, Open, Print, etc.
The Quick Access Toolbar
The Quick Access Toolbar gives you quick access (thus the name) to items found under the Office Button and other commonly used commands.
You can customize the Quick Access Toolbar by clicking on the and selecting the commands you want to add.
Shortcut Keys
You can use keys to do most of the functions you need.
Saves you from having to hunt through all of the tabs in the RIBBON for one simple action.
Most shortcuts work in different Office programs.
When you scroll over an action in the RIBBON or in the menu, it will show you a ScreenTip with the shortcut keys. If you want to find more shortcut keys, search the help for “Shortcut Keys”.
Shortcut Keys
When all else fails, ask for help…
The help menu has tons of instructions, videos, PowerPoint presentations, and more to help you when you’re stuck!
Why the change?
Microsoft has been using the same format for Office products since Office 97, (doc, ppt, xls, etc). The new format has changed the files to docx, xlsx, pptx, etc.
The new files incorporate XML- a standardized programming language that will make documents, presentations, etc be more easily translatable from machine to machine.
To see an Office 2007 file with an older version of Office, you will need to download a patch for your older version of Office (available in Tech Resources). For documents sent to parents, save as a PDF or as a ‘97-’03 format.

Microsoft Office Keyboard Shortcuts In The 2007 System

 

1: Microsoft ® Office Training Keyboard shortcuts in the 2007 Office system Jim Taliaferro Community Mental Health Center

2: Course contents
1: Overview: New ways to use the keyboard
1: Lesson 1: Introducing the Ribbon
1: Lesson 2: Navigate the Ribbon with access keys
1: Lesson 3: Carry out commands by using key combinations

Keyboard shortcuts in the 2007 Office system Two of the lessons include a list of suggested tasks, and each lesson includes a set of test questions.

3: Overview: New ways to use the keyboard Keyboard shortcuts in the 2007 Office system People use keyboard shortcuts for a lot of reasons: to save time, because they find it easier, or because keyboard shortcuts are an essential physical alternative to the mouse. The 2007 Microsoft Office system has a new look, and with it comes new and improved ways to use the keyboard. No matter what your level of keyboard experience, this course will help you learn how to use keyboard shortcuts for all your Office tasks.

4: Course goals
1: Learn how to accomplish tasks by using sequential shortcut keys, known as access keys, shown on the Ribbon.
1: See how to navigate around the Ribbon using the TAB keys and arrow keys.
1: Find out how you can accomplish tasks by using key combinations—keys you press at the same time—exactly as you’ve done in previous versions of Office.

Keyboard shortcuts in the 2007 Office system

5: Lesson 1 Introducing the Ribbon

6: Introducing the Ribbon Keyboard shortcuts in the 2007 Office system Based on extensive research into how people use Microsoft Office and how they wish it would work, the design of the 2007 Office release helps you work with greater ease and efficiency. An important feature of the new design is the Ribbon , which runs across the top of the program window and replaces menus and toolbars. With the demise of menus and toolbars come new, easier ways to carry out tasks—including new keyboard shortcuts.

7: What’s on the Ribbon? Keyboard shortcuts in the 2007 Office system Each 2007 Office system program has a different Ribbon, but the elements on it are the same. Tabs sit across the top of the Ribbon. Each one represents an activity area. Groups are sets of related commands displayed together on tabs. Groups pull together all the commands you’re likely to need for a type of task. Here are the Ribbon’s three main parts:

8: What’s on the Ribbon? Keyboard shortcuts in the 2007 Office system Each 2007 Office system program has a different Ribbon, but the elements on it are the same. Commands are arranged in groups. A command can be a button, a menu, or a box where you enter information. Here are the Ribbon’s three main parts:

9: What’s on the Ribbon? Keyboard shortcuts in the 2007 Office system The Ribbon will adapt depending on what you’re working on, to show you the commands you’re likely to need for that task. For example, if you’re working with a chart in Microsoft Office Excel ® 2007, the Ribbon will show the commands you need for working with charts. Otherwise, those commands aren’t visible.

10: More new features in the Ribbon programs Keyboard shortcuts in the 2007 Office system The new Ribbon programs include two additional features that will help you get your work done quickly and easily. The Microsoft Office Button has replaced the File menu, and it’s where you’ll find the same basic commands as before to open , save , and print your documents—as well as for setting program options, editing file properties, and more.

11: More new features in the Ribbon programs Keyboard shortcuts in the 2007 Office system The new Ribbon programs include two additional features that will help you get your work done quickly and easily. The Quick Access Toolbar sits above the Ribbon and contains the commands that you want to keep near at hand. By default, the Quick Access Toolbar contains the Save , Undo , and Repeat (or Redo ) commands. But you can customize it with whatever commands you want.

12: Types of keyboard shortcuts Keyboard shortcuts in the 2007 Office system Many people think of a “keyboard shortcut” as any keystroke sequence or combination that carries out an action. And generally, that’s a fine definition. But for this course, let’s be a bit more precise in defining a keyboard shortcut. There are two basic types of keyboard shortcuts, and this course covers both of them. Defining the difference is important because the different types work in different ways.

13: Types of keyboard shortcuts Keyboard shortcuts in the 2007 Office system Access keys You use access keys by pressing the ALT key followed by another key or a sequence of other keys. Every single command on the Ribbon, on the Quick Access Toolbar, and on the menu that opens from the Microsoft Office Button has an access key, and every access key is assigned a KeyTip . Access keys give you access to the Ribbon. They relate directly to the tabs, commands, and other things that you see on the screen.

14: Types of keyboard shortcuts Keyboard shortcuts in the 2007 Office system Key combinations In key combinations, the keys need to be pressed together to trigger the action and most, but not all, involve pressing CTRL plus other keys (for example, CTRL+C to copy). Key combinations haven’t changed much in the 2007 Office release and will work the same way as previously. Key combinations perform specific commands. They are unrelated to the Ribbon or other things that you see on the screen.

15: Types of keyboard shortcuts Keyboard shortcuts in the 2007 Office system The picture illustrates how you can make text bold by using either of the two different keyboard methods. Keys to access the tabs and commands on the screen. A direct key combination unrelated to the Ribbon.

16: Test 1, question 1
1: What are the three main parts of the Ribbon? (Pick one answer.)

Keyboard shortcuts in the 2007 Office system
1: Tabs, groups, and commands.
1: The Microsoft Office Button , tabs, and access keys.
1: Menus, toolbars, and commands.

17: Test 1, question 1: Answer
1: Tabs, groups, and commands.

Keyboard shortcuts in the 2007 Office system Tabs contain groups of commands that you are most likely to need for a particular task.

18: Test 1, question 2
1: Where should you look for items that used to be on the File menu? (Pick one answer.)

Keyboard shortcuts in the 2007 Office system

1: On the Home tab.
1: On the menu that opens when you click the Microsoft Office Button .
1: There’s no equivalent; they’re spread all over the Ribbon.

19: Test 1, question 2: Answer

1: On the menu that opens when you click the Microsoft Office Button .

Keyboard shortcuts in the 2007 Office system This is where you’ll find the basic commands for opening, saving, and printing your documents—as well as for setting program options, file properties, and more.

20; Test 1, question 3
1: Which of these are the two basic types of keyboard shortcut? (Pick one answer.)

Keyboard shortcuts in the 2007 Office system
1: Navigation keys and KeyTips.
1: Shortcuts and KeyTips.
1: Combination keys that initiate a command and access keys that navigate the items on the screen.
1: Combination keys that initiate a command and KeyTips.

21: Test 1, question 3: Answer
1: Combination keys that initiate a command and access keys that navigate the items on the screen.

Keyboard shortcuts in the 2007 Office system And in addition to access keys, there are other ways of moving through on-screen items, such as ALT followed by the TAB key or arrow keys, and F6 to move around the program window.

22: Lesson 2 Navigate the Ribbon with access keys

23: Navigate the Ribbon with access keys Keyboard shortcuts in the 2007 Office system When you use access keys rather than a pointing device like a mouse to control the Ribbon and other things on the screen, you must first “switch on” keyboard control of the Ribbon. In other words, you need to get out of text entry mode and into command mode. You do this by pressing the ALT key. After you do that, you have a lot of choices for moving around the Ribbon. This lesson shows you how to use a variety of keys to move around the screen and choose commands.

24: KeyTips and badges Keyboard shortcuts in the 2007 Office system As soon as you press ALT, little labels, or badges , pop up showing the KeyTips for all the tabs. KeyTips offer an on-screen reminder of which keys to press. After you press a key to activate a particular tab, the badges showing the KeyTips for the commands on that tab appear. Play the animation to see how you can use the badges and KeyTips on the Home tab to display the Clipboard. Animation: Right-click, and click Play .

25: KeyTips and badges Keyboard shortcuts in the 2007 Office system As soon as you press ALT, little labels, or badges , pop up showing the KeyTips for all the tabs. KeyTips offer an on-screen reminder of which keys to press. After you press a key to activate a particular tab, the badges showing the KeyTips for the commands on that tab appear. The picture, for example, shows the badges and KeyTips for the commands that are available on the Home tab.

26: More about KeyTips Keyboard shortcuts in the 2007 Office system The layered approach to KeyTips means that each command in a program has a unique sequence of KeyTips. It also means, however, that there are many duplicates when comparing the KeyTips across tabs. For example, in Microsoft Office Word 2007, M does one thing on one tab and something else on a different tab.

27: More about KeyTips Keyboard shortcuts in the 2007 Office system Remember, you only ever see the KeyTip badges for the active tab—the tab you are on. If you end up with the KeyTips for the wrong tab showing, just press ESC to see the tab KeyTip badges again, and select the tab you want. Although you can do things on the Ribbon by using other keys to move around it, access keys are a much quicker way to access and execute commands. You have to move to another tab to see its KeyTips.

28: Getting around with the arrow keys Keyboard shortcuts in the 2007 Office system In addition to access keys, there’s another way of using sequential keystrokes to move around the Ribbon: by using the arrow keys. First, as with access keys, you must press the ALT key to move the focus from the document to the Ribbon. Then you can use the arrow keys to move around.

29: Getting around with the arrow keys Keyboard shortcuts in the 2007 Office system In addition to access keys, there’s another way of using sequential keystrokes to move around the Ribbon: by using the arrow keys. Here are specifics:
1: The LEFT ARROW and RIGHT ARROW keys move you to the adjacent tabs.
1:The UP ARROW key moves the focus to the Quick Access Toolbar. (From there, use the LEFT ARROW key to move to the Microsoft Office Button.)

30: Getting around with the arrow keys Keyboard shortcuts in the 2007 Office system In addition to access keys, there’s another way of using sequential keystrokes to move around the Ribbon: by using the arrow keys. Here are specifics:
1: The DOWN ARROW key moves you into the active tab, where you can move further by using the other arrow keys.

31: Getting around with the arrow keys Keyboard shortcuts in the 2007 Office system In addition to access keys, there’s another way of using sequential keystrokes to move around the Ribbon: by using the arrow keys. The major improvement over previous versions of Microsoft Office in moving around the screen with the arrow keys is that you can use them to move up and down as well as side to side. Generally speaking, navigating around like this is a great way to get to know the Ribbon.

32: The TAB key and the Ribbon Keyboard shortcuts in the 2007 Office system You can also navigate the Ribbon by using the TAB key. After you press ALT to move the focus to the Ribbon, pressing the TAB key cycles through all the commands on the active tab, group by group.

33: The TAB key and the Ribbon Keyboard shortcuts in the 2007 Office system You can also navigate the Ribbon by using the TAB key. After cycling through the last group of commands on the tab, the TAB key moves the focus to the Help button, the Microsoft Office Button, and the Quick Access Toolbar, and then back to the first group on the tab.

34: The TAB key and the Ribbon Keyboard shortcuts in the 2007 Office system You can also navigate the Ribbon by using the TAB key. Press SHIFT+TAB to cycle through the commands in the opposite direction. When the focus is on the command that you want, press ENTER to select it.

35: Cycling with F6 Keyboard shortcuts in the 2007 Office system You can get to different areas of the program window by pressing F6. For example, the figure on the left shows F6 movement around the Microsoft Office Outlook ® 2007 window. In Mail view, the focus moves between the folder list, the open folder, the preview pane, and the To-Do Bar .

36: Cycling with F6 Keyboard shortcuts in the 2007 Office system In the programs with the Ribbon, F6 cycles between all the areas of the window. On the right, for example, you see how pressing F6 in Word 2007 cycles between the open document, any open task panes, the status bar at the bottom of the window where you’ll find the View controls, and the Ribbon.

37: Cycling with F6 Keyboard shortcuts in the 2007 Office system So, let’s say you want to zoom in on your document. Here’s what you do:
1: Press F6 until the focus is in the status bar.
1: Press the TAB or RIGHT ARROW key to move to the + (plus) command.
1: Press ENTER.

38: Navigating beyond the Ribbon Keyboard shortcuts in the 2007 Office system You learned a little about the Microsoft Office Button in the first lesson. You can get there by using access keys, the TAB key, or arrow keys. There are KeyTip badges (and also underscored letters) in the menu to show you which letters to press to use a command, just as there were on menus in previous versions of Office. This new button is at the upper left of the window, just where the File menu was.

39:
1: The TAB key and arrow keys let you navigate a dialog box.
1: You activate a command by pressing ENTER. In some cases, this opens a gallery or menu so you can choose what you want and then activate your choice by pressing ENTER again. For some options, like the Font box, pressing ENTER puts the focus in the box so you can start typing or use the arrow keys to scroll through lists. After you’ve got what you want, press ENTER again.

1: CTRL+TAB cycles through the tabs in a dialog box.
1: SPACEBAR selects and clears check boxes.
1: SHIFT+F10 opens the shortcut menu, which opens when you right-click an item.

Navigating beyond the Ribbon Keyboard shortcuts in the 2007 Office system Here’s a brief list of other keystrokes you need for moving around:
40:
1: ESC closes an open dialog box or shortcut menu. If nothing is open, it takes the focus away from the Ribbon and back to the main document.
Navigating beyond the Ribbon Keyboard shortcuts in the 2007 Office system Here’s a brief list of other keystrokes you need for moving around.
1: To close a task pane, first press CTRL+SPACEBAR to open the task pane menu. Then press C to select Close on the menu.
1: ALT+F4 (pressed simultaneously) closes the active window.
1: F1 opens the Help window.

41: But I know all the old menu shortcuts… Keyboard shortcuts in the 2007 Office system If you’re a keyboard shortcut expert who’s used ALT menu shortcuts for years and knows them all by heart, you may be alarmed that the menus and the old shortcuts have gone. Take heart! The new Ribbon and shortcuts may take a little time to learn, but once you know them you’ll appreciate the new features.

42: But I know all the old menu shortcuts… Keyboard shortcuts in the 2007 Office system Here’s how it works. In the 2007 Office system Ribbon programs, when you press ALT and then one of the old menu keys, you won’t open a menu. Instead, you’ll see a message telling you that you’re using an Office 2003 access key and to press ESC to cancel. In the previous version of Office, you pressed ALT, E to open the Edit menu. Then you pressed the underlined letter in a menu command.

43: But I know all the old menu shortcuts… Keyboard shortcuts in the 2007 Office system Here’s how it works. If you know the key sequence you want, you can just carry on and initiate the command. Otherwise, do as the box says and press ESC to see the KeyTip badges. In the previous version of Office, you pressed ALT, E to open the Edit menu. Then you pressed the underlined letter in a menu command.

44: Suggestions for practice
1: Look at KeyTips.
1: Use KeyTips.
1: Move around the Ribbon.
1: Use the Ribbon.
Keyboard shortcuts in the 2007 Office system Online practice (requires Microsoft Office Word 2007)

45: Test 2, question 1
1: You can move to the Ribbon and initiate commands by using the ALT, TAB, and ENTER keys. (Pick one answer.)
Keyboard shortcuts in the 2007 Office system
1: True.
1: False.

46: Test 2, question 1: Answer
1: True.
Keyboard shortcuts in the 2007 Office system You can use the Ribbon by using only ALT, TAB, and ENTER—though it’s not the quickest way of achieving results.

47: Test 2, question 2
1: Which function key do you use to move among different areas of a program? (Pick one answer.)

Keyboard shortcuts in the 2007 Office system
1: F4.
1: F5.
1:F6.

48: Test 2, question 2: Answer
1: F6.
Keyboard shortcuts in the 2007 Office system F6 cycles among the various areas in the window, including task panes and the View commands.

49: Test 2, question 3
1: What do you press to display the badges showing KeyTip letters? (Pick one answer.)

Keyboard shortcuts in the 2007 Office system
1: CTRL+S.
1: The ALT key.
1: The CTRL key.
1:ALT, then S.

50: Test 2, question 3: Answer
1: The ALT key.

Keyboard shortcuts in the 2007 Office system As soon as you press ALT, the KeyTips will appear.

51: Lesson 3 Carry out commands by using key combinations

52: Carry out commands by using key combinations Keyboard shortcuts in the 2007 Office system A key combination is a set of keystrokes that, when pressed together, initiate an action. This is the quickest way to use the keyboard. A major advantage of key combination shortcuts is that most of the common ones are the same across the Office programs, whether they have the Ribbon or not, and they’re the same as in previous versions of Office. While using key combinations is slightly faster than using access keys, you do have to memorize the keys.

53:Your friend: the CTRL key Keyboard shortcuts in the 2007 Office system Key combination shortcuts are fast, and you don’t need to use the Ribbon to make things happen. Most key combination shortcuts in most Office programs (for example, Word, Excel, and PowerPoint) use the CTRL key. There are a few exceptions to the CTRL rule. One of the most notable is ALT+S for sending an e-mail message in Outlook.

54: Your friend: the CTRL key Keyboard shortcuts in the 2007 Office system You can see the shortcuts when you’re using a mouse: If a shortcut is available, it is displayed in a ScreenTip when you rest the mouse pointer over a command. You’ll find that the more frequently you use the shortcuts, the less you have to look them up. You’ll soon become very familiar with shortcuts that you use every day.

55: Your friend: the CTRL key Keyboard shortcuts in the 2007 Office system You can see the shortcuts when you’re using a mouse: If a shortcut is available, it is displayed in a ScreenTip when you rest the mouse pointer over a command. Even if you’re usually a mouse user, once you know some shortcuts you’ll discover the speed and efficiency of using keystrokes instead of the mouse. Rather than moving your hand off the keyboard continually to use the mouse, use a few keystrokes and you’ll quickly finish the task.

56: Shortcuts that no longer work Keyboard shortcuts in the 2007 Office system Most keyboard shortcuts in the 2007 Office system work exactly the way they did in Office 2003. However, there are a few seldom-used shortcuts that either work differently or no longer work at all. The table shows these shortcuts. Shortcut 2003 action Ribbon program action CTRL+SHIFT+F in Word Moves the focus to the Font drop-down list Opens the Font dialog box (if you want the Font drop-down list, use KeyTips instead: ALT, O, F) CTRL+SHIFT+S in Word Moves the focus to the Styles drop-down list Moves the focus to the Apply Styles task pane

57: Suggestions for practice
1: Use key combinations to cut and paste.
1: Use key combinations to apply direct formatting.

Keyboard shortcuts in the 2007 Office system Online practice (requires Microsoft Office PowerPoint 2007)

58: Test 3, question 1
1: Which of these statements is true about using a key combination keyboard shortcut? (Pick one answer.)
Keyboard shortcuts in the 2007 Office system
1: It takes longer.
1: The menu must be open.
1: You have to know the exact keystrokes.
1: The Help window must be open.

59: Test 3, question 1: Answer
1: You have to know the exact keystrokes.a

Keyboard shortcuts in the 2007 Office system You do have to memorize the keystrokes, although you can find prompts on the screen if you use a mouse and rest it over the command on the Ribbon.

60: Test 3, question 2
1: The majority of key combination keyboard shortcuts use the SHIFT key. (Pick one answer.)

Keyboard shortcuts in the 2007 Office system
1: True.
1: False.

61: Test 3, question 2: Answer
1: False.

Keyboard shortcuts in the 2007 Office system Most key combination keyboard shortcuts use the CTRL key, not the SHIFT key.

62: Test 3, question 3
1: All the common CTRL+ shortcuts work in which of the following programs? (Pick one answer.)

Keyboard shortcuts in the 2007 Office system
1: Word.
1: Excel.
1: PowerPoint.
1:All of the above.
1: None of the above.

63: Test 3, question 3: Answer
1: All of the above.Keyboard shortcuts in the 2007 Office system The common CTRL+ shortcuts work in most Microsoft Office programs.