Getting Started with Microsoft Office 2007

1. Getting Startedwith MicrosoftOffice 2007

2. Objectives Explore the programs that comprise Microsoft Office Start programs and switch between them Explore common window elements Minimize, maximize, and restore windows Use the Ribbon, tabs, and buttons New Perspectives on Microsoft Office Excel 2007

3. Objectives Use the contextual tabs, Mini toolbar, and shortcut menus Save, close, and open a file Use the Help system Print a file Exit programs New Perspectives on Microsoft Office Excel 2007

4. Exploring Microsoft Office 2007 • Microsoft Office 2007, or Office, is a collection of Microsoft programs • Microsoft Office Word 2007 (documents) • Microsoft Office Excel 2007 (workbooks) • Microsoft Office Access 2007 (databases) • Microsoft Office PowerPoint 2007 (presentations) • Microsoft Office Outlook 2007 (information management) • A major advantage of Office is integration, the ability to share information between programs New Perspectives on Microsoft Office Excel 2007

5. Starting Office Programs • Make sure your computer is on and the Windows desktop appears on your screen • To start a program • Click the Start button on the taskbar • Click All Programs • Click Microsoft Office • Click the name of the program you want to startor • Click the name of the program you want to start in the most frequently used programs list on the left side of the Start menu New Perspectives on Microsoft Office Excel 2007

6. Switching Between Open Programs and Files Office allows multiple programs to be open at one time Use taskbar buttons to switch between programsor Use Alt+Tab keys to switch between open files New Perspectives on Microsoft Office Excel 2007

7. Exploring Common Window Elements All Office programs have some common elements New Perspectives on Microsoft Office Excel 2007

8. Resizing the Program Window and Workspaces • Office programs have three sizing buttons • Minimize button (hides window, program only visible on taskbar) • Maximize button (expands window to full screen size) • Restore Down button (returns window to predefined size) • Some programs have two sets of sizing controls (like Excel and Word) • Top level controls program window • Lower level controls workspace New Perspectives on Microsoft Office Excel 2007

9. Resizing Windows and Workspaces New Perspectives on Microsoft Office Excel 2007

10. Status Bar and Switching Views • Status Bar • Located at bottom of program window • Provides information about open file and current task • Information provided specific to program • Switching Views • Each Office program has different view options • View changes presentation, but not content New Perspectives on Microsoft Office Excel 2007

11. Zooming the Workspaces • Zooming magnifies or shrinks content displayed in workspace • To change zoom percentage • Use Zoom slider at right of status bar • Click Zoom level button to left of Zoom slider • Use Zoom group in View tab on the Ribbon New Perspectives on Microsoft Office Excel 2007

12. Zooming the Workspaces New Perspectives on Microsoft Office Excel 2007

13. Using the Ribbon The Ribbon at the top of the program window just below the title bar is the main set of commands that you click to execute tasks New Perspectives on Microsoft Office Excel 2007

14. Clicking Button Icons • Each button, or icon, on the tabs provides one-click access to a command • Most are labeled • Clicking the button often displays a menu or performs an action New Perspectives on Microsoft Office Excel 2007

15. Using Galleries and Live Preview A gallery is a grid or menu that shows visual representation of the options available for that command Live Preview shows the results you would achieve in your file if you clicked that option New Perspectives on Microsoft Office Excel 2007

16. Using Galleries and Live Preview Live Preview of bullet style New Perspectives on Microsoft Office Excel 2007

17. Opening Dialog Boxes and Task Panes The Dialog Box Launcher allows you to open a task pane or dialog box that provides more advanced functionality A task pane is a window that helps you navigate through a complex task or feature A dialog box is a window from which you enter or choose settings for how you want to perform a task New Perspectives on Microsoft Office Excel 2007

18. Opening Dialog Boxes and Task Panes Page tab in the Page Setup dialog box New Perspectives on Microsoft Office Excel 2007

19. Using Contextual Tools Some tabs, toolbars, and menus come into view as you work An object is anything that appears on your screen that can be selected and manipulated as a whole A contextual tab is a Ribbon tab that contains commands related to the selected object so you can manipulate, edit, and format that object New Perspectives on Microsoft Office Excel 2007

20. Using Contextual Tools New Perspectives on Microsoft Office Excel 2007

21. Accessing the Mini Toolbar The Mini toolbar is a toolbar that appears next to the pointer whenever you select text and contains buttons for the most commonly used formatting commands New Perspectives on Microsoft Office Excel 2007

22. Opening Shortcut Menus A shortcut menu is a list of commands related to a selection that opens when you click the right mouse button New Perspectives on Microsoft Office Excel 2007

23. Working with Files • The Office Button provides access to document-level features • Creating files • Opening files • Saving files • Printing files • Closing files • Application settings • The Quick Access Toolbar is a collection of buttons that provide one-click access to commonly used commands New Perspectives on Microsoft Office Excel 2007

24. Saving a File • To prevent losing work, save your file to a disk frequently • To save a file the first time or with a new name or location • Click the Office Button, and then click Save As (or for an unnamed file, click the Save button on the Quick Access Toolbar or click the Office Button, and then click Save) • In the Save As dialog box, click the Save in arrow, and then navigate to the location where you want to save the file • Type a descriptive title in the File name box, and then click the Save button • To resave a named file to the same location • Click the Save button on the Quick Access Toolbar (or click the Office Button, and then click Save) New Perspectives on Microsoft Office Excel 2007

25. Saving a File New Perspectives on Microsoft Office Excel 2007

26. Closing a File Close files you are no longer working on Close a file by clicking the Office Button and then clicking the Close command As a standard practice, you should save your file before closing it New Perspectives on Microsoft Office Excel 2007

27. Opening a File When you want to open a blank document, workbook, presentation, or database, you create a new file Click the Office Button, and then click Open Navigate to the storage location of the file you want to open Click the filename of the file you want to open Click the Open button or Click the Office Button, and then click a filename in the Recent Documents list or Click the Office Button, and then click New In the New dialog box, click Blank Document, Blank Workbook, Blank Presentation, or Blank Database (depending on the program) Click the Create button New Perspectives on Microsoft Office Excel 2007

28. Opening a File New Perspectives on Microsoft Office Excel 2007

29. Getting Help Help is like a huge encyclopedia available from your desktop Click the Microsoft Office Help button (the button name depends on the Office program) Type a keyword or phrase in the “Type words to search for” box, and then click the Search button Click a Help topic in the search results list Read the information in the Help window. For more information, click other topics or links Click the Close button on the Help window title bar New Perspectives on Microsoft Office Excel 2007

30. Getting Help New Perspectives on Microsoft Office Excel 2007

31. Printing a File Click the Office Button, and then click Print Verify the print settings in the Print dialog box Click the OK button or Click the Office Button, point to Print, and then click Quick Print New Perspectives on Microsoft Office Excel 2007

32. Printing a File New Perspectives on Microsoft Office Excel 2007

33. Exiting Programs When you finish working with a program, you should exit it You can exit programs with a button or a command New Perspectives on Microsoft Office Excel 2007