1 / 69

Pearson Prentice Hall DDC

Office 2007 is the most significant update to the Microsoft Office user interface in more than a decade.

makenna
Download Presentation

Pearson Prentice Hall DDC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. Pearson Prentice Hall | DDC

    2. Office 2007 is the most significant update to the Microsoft Office user interface in more than a decade.   Microsoft customers were generally very satisfied with Office. So why change? Why this new user experience? Extreme Makeover

    3. Why a New User Experience? Microsoft listened to their customers Users losing their “sense of mastery” The Office feature set stretched old menu & toolbar UI to the limit Let’s take a trip down Office Memory Lane…

    4. Microsoft Word 1.0 for Windows shipped in 1989 after a long development cycle and was designed to run on Windows 386.  There's not much more to the program than what you see here, but it gives you an idea of how far Word's come.  The Berlin Wall was still up but if you squint your eyes, you can see the core of today's Word UI already present.  There's an application-level menu bar, which Windows evolved from the Mac's top-level menu bar and the bottom-of-the-screen menu display of Microsoft's DOS programs.  Word 1.0 also includes something not seen often in user interfaces since Palo Alto Research Center: the toolbar.  First used by Microsoft in Excel, it might look like there are two toolbars in Word 1.0, but in reality only the top bar is called a toolbar.  Interestingly, the bottom row of buttons is called the "Ribbon"--something we didn't discover until I went back and made these screenshots some number of months ago.  It's a small world. Microsoft Word 1.0 for Windows shipped in 1989 after a long development cycle and was designed to run on Windows 386.  There's not much more to the program than what you see here, but it gives you an idea of how far Word's come.  The Berlin Wall was still up but if you squint your eyes, you can see the core of today's Word UI already present.  There's an application-level menu bar, which Windows evolved from the Mac's top-level menu bar and the bottom-of-the-screen menu display of Microsoft's DOS programs.  Word 1.0 also includes something not seen often in user interfaces since Palo Alto Research Center: the toolbar.  First used by Microsoft in Excel, it might look like there are two toolbars in Word 1.0, but in reality only the top bar is called a toolbar.  Interestingly, the bottom row of buttons is called the "Ribbon"--something we didn't discover until I went back and made these screenshots some number of months ago.  It's a small world.

    9. Number of Menu Items

    10. Toolbars and Task Panes

    11. Looking Under Rocks Office began as a simple program -- but has become intensely feature rich Word 1.0 had 150 commands Word 2003 has 1500 commands Users ended up “looking under rocks” With Office 2007, Microsoft wants to make it easier to find and use features and commands to get results In excel for example – want to insert a header or footer? Don’t use the insert menu for goodness sake…use the View menu. Huh? And that launches the Page Setup dialog box…? That’s looking under rocks – and with the new UI, that goes way. You want to Insert something, you go to the Insert tab.In excel for example – want to insert a header or footer? Don’t use the insert menu for goodness sake…use the View menu. Huh? And that launches the Page Setup dialog box…? That’s looking under rocks – and with the new UI, that goes way. You want to Insert something, you go to the Insert tab.

    12. Regaining a “Sense of Mastery” What? Top design goals for Office 2007 Make it easy to discover functionality Make users efficient Help users make great-looking documents How? A new user interface Provide a single space to search for functionality Focus on contextualization: simplifies the number of choices available at one time Time for a new user interface Provide a single finite space to search for functionality – instead of having menus, toolbars, dialog boxes, task panes, etc – put it all in one place. Focused on contextualization: simplifies the number of choices available at any one time Time for a new user interface Provide a single finite space to search for functionality – instead of having menus, toolbars, dialog boxes, task panes, etc – put it all in one place. Focused on contextualization: simplifies thenumber of choices available at any one time

    14. Components of the New UI The Ribbon Contextual Tools Quick Access Toolbar Galleries Live Preview New Status Bar Mini Toolbar (aka Floatie or Mini Bar) ScreenTips Office Button Zoom Slider

    15. New User Interface The Ribbon

    16. The Ribbon Goodbye, Old Menu Bar… Ribbon consists of ‘tabs’ organized around specific scenarios or objects Brings most used commands to front What are the most used commands?

    17. Most-Used Word 2003 Commands Paste Save Copy Undo Bold Soon after you install Office 2003 on your computer, a balloon pops up asking if you would like to "Help Make Office Better."  If you click on it, you are given the opportunity to enroll in something called the Microsoft Office Customer Experience Improvement Program.  If you opt-in, anonymous data about how you use Office are uploaded to Microsoft occasionally in the background. If you're the curious type, you might have wondered where your data goes.  Well, today I'm here to answer the question: it goes into an Excel spreadsheet I have sitting on my desktop. How much data have we collected? About 1.3 billion sessions since we shipped Office 2003 (each session contains all the data points over a certain fixed time period.)   Over 352 million command bar clicks in Word over the last 90 days. So, one of the biggest reasons that we decided to do the new user interface for Office 12 is simply that, for the first time, we have the data we need to make intelligent decisions -- about knowing which commands people use often and which they don't.  And knowing which commands are used in sequence with which other commands.  And which commands are used 7x more with the keyboard than with the mouse.  And how big people's screens are... and how much of the time they use Excel maximized... and how many documents they use at once... and which commands literally are never used... and which are used much more frequently by East Asian users... and on and on... Knowledge is power.  And having that knowledge makes this the right time to reinvent the user interface of Office. Want to guess what is the most-used command in Microsoft Word?  The top 5 commands used?  Top 5 Most-Used Commands in Microsoft Word 2003 Paste Save Copy Undo Bold Together, these five commands account for around 32% of the total command use in Word 2003.  Paste itself accounts for more than 11% of all commands used, and has more than twice as much usage as the #2 entry on the list, Save. Paste is also far-and-away the number one command in Excel and PowerPoint, accounting for 15% and 12% of total command use, respectively. Beyond the top 10 commands or so, however, the curve flattens out considerably.  The percentage difference in usage between the #100 command ("Accept Change") and the #400 command ("Reset Picture") is about the same in difference between #1 and #11 ("Change Font Size")  This is what makes creating the new UI challenging--people really do use a lot of the breadth of Office and beyond the top 10 commands there are a lot of different ways of using the product. Here's an example of where we used this very data to help make a decision in Office 12.  Early on, we were toying with the idea of not having buttons for Cut/Copy/Paste in the Ribbon.  Everyone "knew" that people mostly used CTRL+X/C/V to do most clipboard actions (which was true.)  And that mouse users used the context menu to access these clipboard commands (which was also true.) What we didn't know until we analyzed the data was that even though so many people do use CTRL+V and do use "Paste" on the context menu, the toolbar button for Paste still gets clicked more than any other button.  The command is so incredibly popular that even though there are more efficient ways of using it, many people do prefer to click the toolbar button. The data kept us from making a crucial, stupid mistake.  One which we might not have caught during the beta due to the high expertise level of our beta users.  Once we recognized the importance of the Paste toolbar button, it was promoted to the first big button on the left side of Word's first tab.Soon after you install Office 2003 on your computer, a balloon pops up asking if you would like to "Help Make Office Better."  If you click on it, you are given the opportunity to enroll in something called the Microsoft Office Customer Experience Improvement Program.  If you opt-in, anonymous data about how you use Office are uploaded to Microsoft occasionally in the background. If you're the curious type, you might have wondered where your data goes.  Well, today I'm here to answer the question: it goes into an Excel spreadsheet I have sitting on my desktop. How much data have we collected? About 1.3 billion sessions since we shipped Office 2003 (each session contains all the data points over a certain fixed time period.)  Over 352 million command bar clicks in Word over the last 90 days. So, one of the biggest reasons that we decided to do the new user interface for Office 12 is simply that, for the first time, we have the data we need to make intelligent decisions -- about knowing which commands people use often and which they don't.  And knowing which commands are used in sequence with which other commands.  And which commands are used 7x more with the keyboard than with the mouse.  And how big people's screens are... and how much of the time they use Excel maximized... and how many documents they use at once... and which commands literally are never used... and which are used much more frequently by East Asian users... and on and on... Knowledge is power.  And having that knowledge makes this the right time to reinvent the user interface of Office. Want to guess what is the most-used command in Microsoft Word?  The top 5 commands used?  Top 5 Most-Used Commands in Microsoft Word 2003 Paste Save Copy Undo Bold Together, these five commands account for around 32% of the total command use in Word 2003.  Paste itself accounts for more than 11% of all commands used, and has more than twice as much usage as the #2 entry on the list, Save. Paste is also far-and-away the number one command in Excel and PowerPoint, accounting for 15% and 12% of total command use, respectively. Beyond the top 10 commands or so, however, the curve flattens out considerably.  The percentage difference in usage between the #100 command ("Accept Change") and the #400 command ("Reset Picture") is about the same in difference between #1 and #11 ("Change Font Size")  This is what makes creating the new UI challenging--people really do use a lot of the breadth of Office and beyond the top 10 commands there are a lot of different ways of using the product. Here's an example of where we used this very data to help make a decision in Office 12.  Early on, we were toying with the idea of not having buttons for Cut/Copy/Paste in the Ribbon.  Everyone "knew" that people mostly used CTRL+X/C/V to do most clipboard actions (which was true.)  And that mouse users used the context menu to access these clipboard commands (which was also true.) What we didn't know until we analyzed the data was that even though so many people do use CTRL+V and do use "Paste" on the context menu, the toolbar button for Paste still gets clicked more than any other button.  The command is so incredibly popular that even though there are more efficient ways of using it, many people do prefer to click the toolbar button. The data kept us from making a crucial, stupid mistake.  One which we might not have caught during the beta due to the high expertise level of our beta users.  Once we recognized the importance of the Paste toolbar button, it was promoted to the first big button on the left side of Word's first tab.

    18. And The Point is…? The result? Paste is the first button on the first toolbar in Word. See? They did listen!

    19. The Ribbon Each tab is organized into chunks No more looking under rocks! All commands start in the Ribbon Everything gets a specific label Every command has a place and that place doesn’t change The Ribbon is the starting point for all functionality.  Unlike the old system, in which you had to look under short menus, long menus, toolbars, hidden toolbars, the Task Pane stack, all commands in Office 12 start in the Ribbon.   Everything gets a label, especially dropdowns.  If you can keep someone from turning over a rock by giving that rock a good name, then that's a huge win.  You don't ever have to open up a can of Sprite to know what's inside it.   Use specific labels.  Engineers love to name things "Tools" or "Options" or "More" or "Advanced."  This is just like putting a "Turn Me Over" sticker on the rock--the name is so ambiguous and yet so promising that people are going to turn it over every time.  A label for a menu like "Import Data From" is never going to take a click from someone looking for Word Count. Contains most often used features Commands can look like a toolbar, a menu, a dialog box, or even a web page Primary & secondary actions -- key functionality can have large buttons, while supporting functions have smaller, grouped controls. Every command is labeled “because most people don't click on an unlabeled 16x16 icon”. Designed to be predictable –“every command has a place, and that place doesn't change”.The Ribbon is the starting point for all functionality.  Unlike the old system, in which you had to look under short menus, long menus, toolbars, hidden toolbars, the Task Pane stack, all commands in Office 12 start in the Ribbon.  Everything gets a label, especially dropdowns.  If you can keep someone from turning over a rock by giving that rock a good name, then that's a huge win.  You don't ever have to open up a can of Sprite to know what's inside it.  Use specific labels.  Engineers love to name things "Tools" or "Options" or "More" or "Advanced."  This is just like putting a "Turn Me Over" sticker on the rock--the name is so ambiguous and yet so promising that people are going to turn it over every time.  A label for a menu like "Import Data From" is never going to take a click from someone looking for Word Count. Contains most often used features Commands can look like a toolbar, a menu, a dialog box, or even a web page Primary & secondary actions -- key functionality can have large buttons, while supporting functions have smaller, grouped controls. Every command is labeled “because most people don't click on an unlabeled 16x16 icon”. Designed to be predictable –“every command has a place, and that place doesn't change”.

    20. Word, Excel, PowerPoint Ribbons One home for functionality Not more looking in hierarchical menus, toolbars, Task Panes, etc… Better organization of commands within each application Has room to label most commands Rich command layouts help people find more important functionality Allows user to view galleries A strip across the top of the window that exposes what the program can do. Billed as “the one and only place to look for functionality”. The ribbon’s default contents are based on customer data outlining what features are used most frequently and how often they’re used. Commands can look like a toolbar, a menu, a dialog box, or even a web page. Primary & Secondary actions- key functionality can have large buttons, while supporting functions have smaller, grouped controls. Every command is labeled “because most people don't click on an unlabeled 16x16 icon”. The Ribbon is designed to be predictable –“every command has a place, and that place doesn't change”. One home for functionality Not more looking in hierarchical menus, toolbars, Task Panes, etc… Better organization of commands within each application Has room to label most commands Rich command layouts help people find more important functionality Allows user to view galleries A strip across the top of the window that exposes what the program can do. Billed as “the one and only place to look for functionality”. The ribbon’s default contents are based on customer data outlining what features are used most frequently and how often they’re used. Commands can look like a toolbar, a menu, a dialog box, or even a web page. Primary & Secondary actions- key functionality can have large buttons, while supporting functions have smaller, grouped controls. Every command is labeled “because most people don't click on an unlabeled 16x16 icon”. The Ribbon is designed to be predictable –“every command has a place, and that place doesn't change”.

    21. The Ribbon: Contextual Tools When you select or insert an object, Contextual Tools for that object appear in the ribbon

    22. New User Interface Quick Access Toolbar (QAT)

    23. Quick Access Toolbar Allows one-click access to commands Starts with Save, Undo, Redo You can customize it to include anything in the Ribbon – including groups of commands Put your most used features right where you need ‘em! Quick Access ToolbarQuick Access Toolbar

    24. New User Interface Galleries

    25. Galleries Work with the ribbon Provide visual way to browse functionality Show the results of the commands, not the commands themselves Help users get great results without being an expert or knowing ‘behind the scenes’ details of formatting Galleries are at the heart of the redesigned applications. Galleries provide users with a set of clear results to choose from when working on their document, spreadsheet, presentation, or Access database. By presenting a simple set of potential results, rather than a complex dialog box with numerous options, the Galleries simplify the process of producing professional looking work. The traditional dialog box interfaces are still available for those wishing a greater degree of control over the result of the operation. Galleries are at the heart of the redesigned applications. Galleries provide users with a set of clear results to choose from when working on their document, spreadsheet, presentation, or Access database. By presenting a simple set of potential results, rather than a complex dialog box with numerous options, the Galleries simplify the process of producing professional looking work. The traditional dialog box interfaces are still available for those wishing a greater degree of control over the result of the operation.

    26. Types of Galleries In-Ribbon In-ribbon galleries work with Live Preview Don't cover up any part of document as you mouse over styles in gallery

    27. Types of Galleries Dropdown grid layout Dropdown list

    28. Dialog Launchers Chunks with related dialog boxes have dialog launcher Galleries with related dialog boxes have links at bottom of gallery

    29. What About Task Panes? News of the Task Pane’s death has been greatly exaggerated Task panes still exist in Office 2007 Most task pane functionality integrated into the Ribbon Task panes never come up automatically No task pane shows at startup When we designed the Ribbon, we knew we had to reconcile it with the role of Task Panes. We considered removing all of them from the product entirely, but there were a few which did seem to make sense within the new design. So we struck a set of design principles to govern when and how would allow the use of Task Panes: All Task Panes which had content consistent with the Ribbon were removed and integrated into the Ribbon. Slide Design in PowerPoint is an example of this, where it became its own Ribbon tab. This accounts for most of the Task Panes in the product. Task Panes never come up automatically. They are always turned on or off by the user, and always from the Ribbon. This is how we've stayed true to "everything starts with the Ribbon." If you want a Task Pane as part of your document workspace, you can turn it on and we'll never mess with it. Allow people to have multiple Task Panes up at once. To put people in better control of their screen real-estate, we've turned all of the Task Panes into lighter-weight panes that you can arrange as you like. If you want to include both Styles and Formatting and the Research pane as part of your workspace, go for it. No Task Pane will show up at startup. This includes the Getting Started pane, which has been removed from the product. No inter-Task Pane navigation. There's no dropdown list of Task Panes; the UI is organized into one place--the Ribbon. You can open the Clipboard pane from the Clipboard group on the Ribbon but not from some one-off list of panes hanging from Mail Merge. When we designed the Ribbon, we knew we had to reconcile it with the role of Task Panes. We considered removing all of them from the product entirely, but there were a few which did seem to make sense within the new design. So we struck a set of design principles to govern when and how would allow the use of Task Panes: All Task Panes which had content consistent with the Ribbon were removed and integrated into the Ribbon. Slide Design in PowerPoint is an example of this, where it became its own Ribbon tab. This accounts for most of the Task Panes in the product.

    30. Live Preview Live Preview shows what effect a feature would have before you apply it As you hover over a choice in a gallery, the document previews the change Stops the frustrating, repetitive cycle of clicks trying to get the right format Live Preview is a new technology that shows the results of applying an editing or formatting change as the user moves the pointer over the results presented in a Gallery. This new, dynamic capability streamlines the process of laying out, editing, and formatting so users can create excellent results with less time and effort. Be sure and look at the Preview to see it in action.Live Preview is a new technology that shows the results of applying an editing or formatting change as the user moves the pointer over the results presented in a Gallery. This new, dynamic capability streamlines the process of laying out, editing, and formatting so users can create excellent results with less time and effort. Be sure and look at the Preview to see it in action.

    31. New Status Bar Contains 3 parts Document information View/Window Switching Zoom

    32. New Status Bar

    33. New User Interface More Enhancements

    34. Mini Toolbar Mini Toolbar is a unique form of on-object UI designed to improve efficiency For example, if you have text selected, Mini Toolbar includes commands like bold, italic, underline etc. Helps prevent tab switches in ribbon Efficient access to commands for mouse-oriented people Floatie: Floatie comes out of the obvious problems that you will face while working with Ribbon. Say you are making a table and need to edit the text or use another command that is not by default in the table tab. You will have to keep switching back and forth between the tabs, which will get extremely irritating if you work for long hours or have to do it repeatedly. Example: you’re working on a table in a Word document, so the Tables tab is shown on the Ribbon.  If you want to change a cell font style to bold, you don’t want switch to the Write tab just to do that, then switch back to the Tables tab again.  So, up pops Floatie – a mini toolbar that appears alongside the right-click menu we all know, with common commands you might want to apply to selected item. A Floatie is like a mini toolbar (more like an amalgamation of the right-click menu and the smart tags of Office 11) that appears near the right click menu with contextual commands. If you have the text selected, it will give you command options like bold, underline in addition to others for selection. Floatie: Floatie comes out of the obvious problems that you will face while working with Ribbon. Say you are making a table and need to edit the text or use another command that is not by default in the table tab. You will have to keep switching back and forth between the tabs, which will get extremely irritating if you work for long hours or have to do it repeatedly. Example: you’re working on a table in a Word document, so the Tables tab is shown on the Ribbon.  If you want to change a cell font style to bold, you don’t want switch to the Write tab just to do that, then switch back to the Tables tab again.  So, up pops Floatie – a mini toolbar that appears alongside the right-click menu we all know, with common commands you might want to apply to selected item. A Floatie is like a mini toolbar (more like an amalgamation of the right-click menu and the smart tags of Office 11) that appears near the right click menu with contextual commands. If you have the text selected, it will give you command options like bold, underline in addition to others for selection.

    35. Super Tooltips So…you need help. How do you know what search term to use? Super Tooltips bridge the gap between functionality and documentation Provides info about a command directly in the Ribbon Pressing F1 to get more info about selected feature Stays out of your way (later, Clippit!) Main problem with Help today is that users don’t know the terms used to describe features A feature code-named “Super Tooltips” integrates Help topics into the product in a new way. One of the main problems that people have with Help topics today is that they don’t know the terms used to describe features. Super Tooltips are integrated Help tips that provide quick access to information about a command directly from the command’s location in the ribbon. The tooltip itself will usually give you enough information about what that feature does so that you can use it. Main problem with Help today is that users don’t know the terms used to describe features A feature code-named “Super Tooltips” integrates Help topics into the product in a new way. One of the main problems that people have with Help topics today is that they don’t know the terms used to describe features. Super Tooltips are integrated Help tips that provide quick access to information about a command directly from the command’s location in the ribbon. The tooltip itself will usually give you enough information about what that feature does so that you can use it.

    36. Keyboard Navigation In Office 2003, most commands are performed using the mouse… Power users love the keyboard Office 2007 has old keyboard shortcuts and new KeyTips

    37. Office 2007 and the Keyboard Keyboard shortcuts (e.g. CTRL+X, CTRL+B) will continue to work exactly as in Office 2003 KeyTips: Press ALT key to view KeyTips; use keyboard to navigate UI

    38. Office Button: Start Here, Finish Here Where you go to start doing things with your document – opening, saving as PDF, sharing, and more Also use to set application options and exit The Office Button provides access to all of the document and system-level functionality in the program. This is where you go to start doing things with your document in Office--from simply opening a file to saving as a PDF to starting a workflow or publishing the document on a server. This is where you start a document, and this is where you finish a document The Office Button provides access to all of the document and system-level functionality in the program. This is where you go to start doing things with your document in Office--from simply opening a file to saving as a PDF to starting a workflow or publishing the document on a server. This is where you start a document, and this is where you finish a document

    39. New User Interface Q: What programs get the new UI? A: In Office 2007 Word Excel PowerPoint Access Not Outlook (except in the Word window where Outlook users compose or read mail)

    40. New File Formats Open XML The new formats improve file and data management, data recovery, and interoperability with line-of-business systems. They extend what is possible with the binary files of earlier versions. Any application that supports XML can access and work with data in the new file format. The application does not need to be part of the Microsoft Office system or even a Microsoft product. Users can also use standard transformations to extract or repurpose the data. In addition, security concerns are drastically reduced because the information is stored in XML, which is essentially plain text. Thus, the data can pass through corporate firewalls without hindranceThe new formats improve file and data management, data recovery, and interoperability with line-of-business systems. They extend what is possible with the binary files of earlier versions. Any application that supports XML can access and work with data in the new file format. The application does not need to be part of the Microsoft Office system or even a Microsoft product. Users can also use standard transformations to extract or repurpose the data. In addition, security concerns are drastically reduced because the information is stored in XML, which is essentially plain text. Thus, the data can pass through corporate firewalls without hindrance

    41. Open XML Office 2007 introduces a new file format based on Open XML Word, Excel, & PowerPoint (not Access) Documents created in Open XML formats include additional x in the file extension Microsoft will release updates to Office 2000, XP, 2003 to read/write the Open XML format New File Formats With Office 12, Microsoft introduces a new file format based on Open XML. Word, Excel, and PowerPoint will ship with the new default format – and documents created in the Open XML formats will include additional "x" in the file extension. So .doc becomes .docx in Word 12; .xls becomes .xlsx, and .ppt becomes .pptx. Access also uses a new file extension, .accdb.While older versions of Office won’t be able to read Open XML files, Microsoft will release updates to Office 2000, XP, and 2003 to allow those versions to read/write the Open XML format. New File Formats With Office 12, Microsoft introduces a new file format based on Open XML. Word, Excel, and PowerPoint will ship with the new default format – and documents created in the Open XML formats will include additional "x" in the file extension. So .doc becomes .docx in Word 12; .xls becomes .xlsx, and .ppt becomes .pptx. Access also uses a new file extension, .accdb.While older versions of Office won’t be able to read Open XML files, Microsoft will release updates to Office 2000, XP, and 2003 to allow those versions to read/write the Open XML format.

    42. Word 2007

    43. Word 2007: Other Cool Stuff Symbol Gallery Equation Gallery Citations and Bibliography

    44. Excel 2007

    45. Excel 2007: Bigger is Better Excel grid will be 1,048,576 rows by 16,384 columns 1500% more rows and 6300% more columns Columns end at XFD instead of IV Expanded formula bar Formulas up to 800 characters long Up to three lines In Excel 2007, bigger is better. First, you get a bigger worksheet – with a grid of 1,048,576 rows by 16,384 columns (that’s 1,500% more rows and 6,300% more columns than in Excel 2003!) Columns now end at XFD instead of IV. And, remember how, if you had long text in a cell and clicked it, the formula bar dropped down and covered your worksheet? No more. Excel 12 also has a bigger formula bar –- it allows you to enter formulas up to 800 characters long and can show up to three lines. In Excel 2007, bigger is better. First, you get a bigger worksheet – with a grid of 1,048,576 rows by 16,384 columns (that’s 1,500% more rows and 6,300% more columns than in Excel 2003!) Columns now end at XFD instead of IV. And, remember how, if you had long text in a cell and clicked it, the formula bar dropped down and covered your worksheet? No more. Excel 12 also has a bigger formula bar –- it allows you to enter formulas up to 800 characters long and can show up to three lines.

    46. Excel 2007: Improved Charts All of Office 2007 apps have better, more polished graphics Excel 2007 charts have a wide range of new graphic effects Formatting is a snap using QuickFormat galleries All of the applications in Office 2007 provide better, more polished graphics. Excel 2007 charts benefit from this, with a wide range of new graphic effects. Creating a chart is a snap –- and updating the look of your chart is as simple as selecting a new look from the Quick Format gallery or selecting a new chart type. Other options include setting transparency, lighting effects, shadows, reflections, and more. All of the applications in Office 2007 provide better, more polished graphics. Excel 2007 charts benefit from this, with a wide range of new graphic effects. Creating a chart is a snap –- and updating the look of your chart is as simple as selecting a new look from the Quick Format gallery or selecting a new chart type. Other options include setting transparency, lighting effects, shadows, reflections, and more.

    47. Excel 2007: Improved Charts All of the applications in Office 2007 provide better, more polished graphics. Excel 2007 charts benefit from this, with a wide range of new graphic effects. Creating a chart is a snap –- and updating the look of your chart is as simple as selecting a new look from the Quick Format gallery or selecting a new chart type. Other options include setting transparency, lighting effects, shadows, reflections, and more. All of the applications in Office 2007 provide better, more polished graphics. Excel 2007 charts benefit from this, with a wide range of new graphic effects. Creating a chart is a snap –- and updating the look of your chart is as simple as selecting a new look from the Quick Format gallery or selecting a new chart type. Other options include setting transparency, lighting effects, shadows, reflections, and more.

    48. Excel 2007: Improved Charts All of the applications in Office 2007 provide better, more polished graphics. Excel 2007 charts benefit from this, with a wide range of new graphic effects. Creating a chart is a snap –- and updating the look of your chart is as simple as selecting a new look from the Quick Format gallery or selecting a new chart type. Other options include setting transparency, lighting effects, shadows, reflections, and more. All of the applications in Office 2007 provide better, more polished graphics. Excel 2007 charts benefit from this, with a wide range of new graphic effects. Creating a chart is a snap –- and updating the look of your chart is as simple as selecting a new look from the Quick Format gallery or selecting a new chart type. Other options include setting transparency, lighting effects, shadows, reflections, and more.

    49. Excel 2007: Structured Referencing New Structured Referencing feature Use the AutoFilters to sort and filter the data – by top ten, highest, lowest, even by color!* New Structured Referencing feature Right-click on any cell inside a table of data Select Create Table from the shortcut menu Generate a fully formatted table Use the AutoFilters to sort and filter the data – by top ten, highest, lowest, even by color!* *Officially my favorite new Excel featureNew Structured Referencing feature Right-click on any cell inside a table of data Select Create Table from the shortcut menu Generate a fully formatted table Use the AutoFilters to sort and filter the data – by top ten, highest, lowest, even by color!* *Officially my favorite new Excel feature

    50. Excel 2007: Conditional Formatting A bunch of new options Apply a color spectrum to table data to show high/low numbers Apply data bars to reflect cell value* All of the applications in Office 2007 provide better, more polished graphics. Excel 2007 charts benefit from this, with a wide range of new graphic effects. Creating a chart is a snap –- and updating the look of your chart is as simple as selecting a new look from the Quick Format gallery or selecting a new chart type. Other options include setting transparency, lighting effects, shadows, reflections, and more. All of the applications in Office 2007 provide better, more polished graphics. Excel 2007 charts benefit from this, with a wide range of new graphic effects. Creating a chart is a snap –- and updating the look of your chart is as simple as selecting a new look from the Quick Format gallery or selecting a new chart type. Other options include setting transparency, lighting effects, shadows, reflections, and more.

    51. PowerPoint 2007

    52. PowerPoint: Revved Up Graphics Aims to turn up the 'wow' factor in your documents Office 2007 includes a new graphics engine, code- named IGX

    53. PowerPoint: Revved Up Graphics Change presentation's look in one click by applying a new Theme Complementary Fonts, Colors, & Effects designed to make slick documents Themes go across all apps Use one theme -- your Word flyer matches your PowerPoint presentation Change presentation's look in one click by applying a new Theme Complementary Fonts, Colors, & Effects designed to make slick documents Themes go across all apps Use one theme -- your Word flyer matches your PowerPoint presentation Change presentation's look in one click by applying a new Theme Complementary Fonts, Colors, & Effects designed to make slick documents Themes go across all apps Use one theme -- your Word flyer matches your PowerPoint presentation

    54. PowerPoint: Revved Up Graphics

    55. PowerPoint: Revved Up Graphics

    56. PowerPoint: Revved Up Graphics

    57. PowerPoint: Revved Up Graphics

    58. Access 2007

    59. Access 2007: Tracking Apps Access 2007 will ship with a host of templates, or what Microsoft calls tracking applications Create a new database in a few clicks

    60. Access 2007: Tracking Apps Steps: Select a tracking application Access automatically creates the database tables, forms, and more. Customize the database to your needs. Need more options? Additional tracking applications will be available via Office Online

    61. Access 2007: New Navigation An entirely new set of navigation tools New Navigation pane Open elements are organized in a tab-based interface View switching with a tab right-click

    62. FAQs

    63. Frequently Asked Questions Q: What are the system requirements? A: OS: Windows XP SP2 or later Hardware: similar to recommended requirement for Office 2003* Requirements for servers (e.g. Sharepoint): Windows Server 2003, SQL 2000 or later System Requirements Overview We have not set final system requirements or completed performance optimization for the 2007 Microsoft Office release. When upgrading from Microsoft Office 2003 to the 2007 release you should not need to upgrade your hardware, although you may need to upgrade to a supported operating system. When upgrading from Microsoft Office 2000 or Office XP to the 2007 release you will need to ensure that your hardware and operating system meet the minimum 2007 Microsoft Office system requirements. Note  Microsoft Office 2007 Beta 2 programs are supported on Windows Vista Beta 2 (when available), and not earlier versions of Windows Vista. The Microsoft Office 2007 Beta 2 programs client is a 32-bit application and runs on a Windows 64-bit platform (Windows XP and Windows Server 2003) via WOW64. 2007 Microsoft Office Programs and Suites For 2007 Microsoft Office system programs including Access, Excel, Groove, InfoPath, OneNote, Outlook, Outlook with Business Contact Manager, PowerPoint, Project, Publisher, SharePoint Designer, Visio, and Word, you will need: Component Requirements tOperating system Microsoft Windows XP Service Pack (SP) 2 or later or Microsoft Windows Server 2003 (or higher) required Computer and processor 500 megahertz (MHz) processor or higher; 256 megabyte (MB) RAM or higher; DVD drive; 1 gigahertz (GHz) and 512 MB of RAM or higher is required to run Microsoft Office Outlook 2007 with Business Contact Manager Hard disk 2 gigabyte (GB) necessary for install; a portion of this disk space will be freed after installation if the original download package is removed from the hard drive Monitor resolutionMinimum 800x600; 1024x768 or higher recommended Internet connectionBroadband connection, 128 kilobits per second (Kbps) or greater, for download and activation of products Additional componentsMicrosoft Internet Explorer 6.0 with service packs, Microsoft Exchange Server 2000 or later required for Outlook 2007 usersSystem Requirements Overview We have not set final system requirements or completed performance optimization for the 2007 Microsoft Office release.

    64. Frequently Asked Questions Q: What versions are available? How much will they cost? A: Seven Office suites, with a ton of different application combos. Costs vary, depending on distribution and whether retail or upgrade.

    66. Learning Microsoft Office 2007 New edition from DDC and Pearson Prentice Hall. DDC Learning series means less “Hands-Up” Time – more Teaching and Learning time. Abundance of Exercises – your students never run out of things to do. Motivate students with “why would I do this?” info. Less reading – more doing: Technical concepts/skills presented in brief sound bytes. Avoid the “Voila syndrome.” Procedures sections in every Exercise provide easy-to-use quick reference. Designed to make managing your class easier –wraparound teacher’s edition and other supps work together well.

    67. DDC Learning Office 2007 4-color design brings step-by-step exercises to life. Cross-curriculum exercises throughout from Math, Language Arts, Social Studies, Science. Curriculum Connections help you bring tech skills into students’ core curriculum work. Key Terms defined at start of each exercise.

    68. Learning Microsoft Office 2007 Learning Microsoft Office 2007 available now! Stop by the booth to order your sample copy. Deluxe and Standard Editions Learning Microsoft Word 2007 and Learning Microsoft Excel 2007 coming this fall. Go to www.phschool.com to purchase.

    69. Summary The new user experience helps people be more productive in Office Find the right feature Discover new functionality Be more efficient Easily create powerful, beautiful documents

More Related