Chapter 8

1. Microsoft Office Applications Chapter 8

2. Describe what Microsoft Office 2010 is. • Describe each component of the Microsoft Office 2010 Suite. • Explain the different versions of Microsoft Office 2010. • Explain the new features in Microsoft Office 2010.

3. What is Microsoft Office 2010? • Microsoft Office 2010 is a productivity suite of software developed by Microsoft Corporation. It is the current successor to Microsoft Office 2007. • The term productivity suite refers to a group of computer applications that are bundled together to increase user productivity. Productivity suites share some of the same functionality between applications and each application may have the same look and feel to the user.

4. What is Microsoft Office 2010? • Microsoft Office 2010, which we will now refer to as Office, is the most popular suite of productivity applications on the market today. Basic versions of Office includes a word processor for creating all kinds of text documents, a spreadsheet application for crunching numbers, a presentation application for creating slideshow presentations and a note gathering application. Other applications like a database management system, a desktop publisher and an email program are added to more expensive versions.

5. Office Applications Included in all retail version of Office 2010: • Microsoft Word –Word processor application • Microsoft Excel – Spreadsheet application • Microsoft PowerPoint – Presentation application • Microsoft OneNote- Information gathering application Higher end and thus more expensive versions of Office • Microsoft Outlook – Email/calendar/contact application • Microsoft Publisher – Desktop publishing application • Microsoft Access – Database application

6. Office Versions

7. Office Versions Office Home and Student • Microsoft Word • Microsoft Excel • Microsoft PowerPoint • Microsoft OneNote • 90 days of technical support

8. Office Versions Office Home and Business • Microsoft Word • Microsoft Excel • Microsoft PowerPoint • Microsoft Outlook • Microsoft OneNote • 90 days of technical support

9. Office Versions Office Professional • Microsoft Word • Microsoft Excel • Microsoft PowerPoint • Microsoft Outlook • Microsoft OneNote • Microsoft Publisher • Microsoft Access

10. New Features New features by program and version • Word 2010 • Edit and apply effects to photos without additional software. • Organize your documents and navigate easily with the new navigation pane. • Add powerful special effects to words with new text effects. • Edit a document with other authors at the same time1 • Excel 2010 • Highlight important data trends in seconds using Sparklines. • Clarify information with color schemes and data bars in Conditional Formatting. • Spend less time shifting through data with new PowerPivot features. • Edit documents with others simultaneously using the new Excel Web Apps. • PowerPoint 2010 • Embed, trim, add bookmarks and special effects to videos right in PowerPoint. • Apply sophisticated effects to pictures, like color saturation and artistic filters. • Broadcast presentation instantly by creating a link for real-time, online viewing. • Share with others and stay on top of changes using the Co-Authoring feature.

11. Word Microsoft Word 2010 is the most popular word-processing application Word-processing can be defined as writing, editing, and production of documents, letters, reports, and books, through the use of a computer program or a complete computer system designed to facilitate rapid and efficient manipulation of text. Word has become the standard word-processor for creating and formatting documents of all types. As the word-processing needs of the consumer have evolved so has Microsoft Word. The days of word-processing software that will only let you type in information and do some simple formatting are gone. Word can handle almost any type of text or graphics you want to work with.

12. Word Microsoft Word 2010 is the most popular word-processing application

13. Word Documents you can create in Word • Letters • Fax cover sheets • Flyers • Legal documents • Manuscripts • Expense reports • Resumes • Shopping lists • Newsletters • Memos • Blogs • Invoices • Awards • Brochures • Calendars • Diagrams • Time sheets • Stationary

14. Excel Microsoft Excel2010 is an electronic spreadsheet program that can be used for storing, organizing and manipulating numbers and data. Many new users to Excel want to know why they would use Excel to type in information or numbers rather than use the more widely known Word software. The answer is easy…Calculations.

15. Excel Excel is a spreadsheet application and we can define spreadsheet as a document that stores data in a grid of horizontal rows and vertical columns. Rows are typically labeled using numbers, Columns are labeled with letters. Individual row/column locations, such as C3 or B12, are referred to as cells. Each cell can each store a unique instance of data.

16. Excel

17. Excel

18. Excel • Data Types, Formulas, and Functions • The types of data that a cell can hold include numbers, text or formulas. Formulas are used for calculations usually involving data contained in other cells. Excel and other electronic spreadsheets include a number of built in formulas used for common tasks known as functions. • Excel and Financial Data • Spreadsheets are often used to store financial data. Formulas and functions that are used on this type of data include: • Performing mathematical operations such as summing columns and rows. • Finding values such as profit or loss. • Calculating repayment plans for loans or mortgages. • Finding the average, maximum, or minimum values in a specified range of data. • Excel's Other Uses • Other common operations that Excel can be used for include: • Graphing or charting data to assist users in identifying data trends. • Sorting and filtering data to find specific information.

19. PowerPoint Microsoft PowerPoint 2010 can be defined as presentation software. The main focus of PowerPoint is to allow the user to create visually exciting presentations. Microsoft PowerPoint allows users to combine text, graphics and multimedia into a ‘slide show’ that can be displayed to an audience one slide at a time. PowerPoint's slide show replaces technology such a chalkboard or an overhead projector to aid someone giving a presentation or leading a discussion.

20. PowerPoint

21. PowerPoint

22. PowerPoint • Support lectures/speeches by highlighting key points • Present tips and outlines • Present examples or diagrams • Provide graphics supporting the material • Increase audience interest by use of clipart cartoons • Display key information • Make important announcements

23. OneNote • Microsoft OneNote 2010 is one of those indispensable programs that many people don’t know much about. OneNote is fairly new to the Office suite but has quickly gained acceptance by those who use it regularly.

24. OneNote

25. OneNote OneNote is a digital notebook that allows you to gather your notes and info in one place, and also includes a search function that lets you quickly find what you want. In business, it's key to organize and arrange important bits of data, so a digital notebook makes it even easier to assemble what you want for ease of access.

26. Access Information in Microsoft OneNote is saved in Pages, which are organized into Sections within Notebooks. OneNote's interface is an electronic version of the familiar tabbed ring binder which can be used directly for making notes, but also to gather material obtained from other applications. OneNote notebooks are designed for collecting, organizing, and sharing possibly unpolished materials, while word processors are usually targeted at publishing in some way

27. Access Microsoft Access 2010 is an information management tool that helps you manage, store, retrieve, and update information. Access is known as a relational database meaning that information stored in the database can be related in some way. Microsoft Access can help you overcome the limitations found when trying to manage large amounts of information in Microsoft Excel or other spreadsheet applications.

28. Access

29. Access Data is stored in Microsoft Access tables (think of them as mini-spreadsheets that store only one type of thing).  A table can have many fields (think of them as columns in your spreadsheet).  Each field in a table contains information

30. Publisher Microsoft Publisher is a desktop publishing application. It is an entry-level application, differing from Microsoft Word in that the emphasis is placed on page layout and design rather than text composition and proofing.

31. Publisher

32. Publisher The line between Word and Publisher is a little blurry because a lot of the same documents you can create in Word…you can create in Publisher. However it is safe to assume you will have more control over your layout and graphic design in Publisher than you do in Word.

33. Outlook Microsoft Outlook is a personal information manager available both as a separate application as well as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note taking, a journal and web browsing.

34. Outlook

35. Outlook Many users of Outlook only use the email portion of the application. That is a shame because Outlook provides a robust set of features to handle personal and business calendars, task list and a contact organizer to name a few

36. Outlook

37. Backstage View One thing you may notice right away when using Office 2010 is the fact that the Office Button in the upper left corner of each application has been removed. The Office button is where the user would go to SAVE, OPEN, and PRINT a current document. With the release of Office 2010, Microsoft has replaced the Office button with a tab called the FILE MENU. It is also now referred to as the BACKSTAGE view because it handles all the tasks in this background tab.

38. End of chapter End of Chapter EIGHT