270 likes | 379 Views
What’s New! Office 2007. Stacy L. Gee St. Louis Community College 3-30-07. Stacy L. Gee. A.A. St. Louis Community College B.A. St. Louis University M.B.A. Fontbonne University Pursuing Doctorate at UM-St. Louis Teach at St. Louis Community College
E N D
What’s New!Office 2007 Stacy L. Gee St. Louis Community College 3-30-07
Stacy L. Gee A.A. St. Louis Community College B.A. St. Louis University M.B.A. Fontbonne University Pursuing Doctorate at UM-St. Louis Teach at St. Louis Community College Information Systems - Meramec & Flo
How & Why??? • Feedback from the box that “Send or Don’t Send” box • Tools were “hidden” • “Catch an option” • Mo’ money! Mo’ money! Mo’ money! • No matter the reason, you can only call in “sick” for so long…..
User Interface Components • Office button • Pdf’s & blogs • Quick access toolbar • Mini toolbar • Status bar
Ribbon, Tabs, Groups and Galleries • Ribbon • Contains basic and commonly used commands • Ribbon contains tabs • Home, Insert, Design, Animations, etc. • Tabs contain groups • Clipboard, Slides, Font, Paragraph, etc. • Dialog box launcher • Opens dialog box related to the group
Ribbons and Tabs - Word Home insert Page layout
Ribbons and Tabs References mailings review view
Contextual Tabs: Tables • Table Tools Design Tab • Table Tools Layout Tab
Contextual Tabs: Graphics • Picture Tools Format Tab • Drawing Tools Format Tab
Gallery – Oh, so cool! • Set of options that display as thumbnails • Live Preview • Displays the change instantly – no trial and error
New File Formats • Word - .docx • Excel - .xlsx • PowerPoint - .pptx • Access - .accdb .docx .xlsx .pptx .accdb
Just Spend Quality Time……. • New Terminology • New Interface • New Additions • New File Formats • New Learning • New Teaching • Just spend some time with it, just as you would a loved one…..
New Features - Excel • 16,384 columns • 1,048,576 rows • 100 undo levels • 4.3 billion unique colors allowed in a single workbook • 64 sort references in a single sort • 255 Data series in a chart • 10,000 filter (previously known as AutoFilter) conditions • Formulas: 255 arguments and 64 levels of nesting • Lists are now tables • Themes • Galleries
Headers are visible when scrolling Table Styles Total Row New functions in Total Row
Conditional formatting options Icon sets Data bars Color scales
Excel, check this out!! • The formula bar doesn’t fill up your screen anymore!!!
Access - Wow! • New Interface • Pre-built categorized templates • The Navigation Pane shows you what's in the database you're using (tables, forms, reports, queries ) at the same time • More secure • More compact • Recovery is easier • Pictures in fields and as attachments
Quick Steps • Select Template-Download – Done! • Select Create Tab – Table Template – Select – Done! • Save Table – Click Form – Done! • Select Report – Done!
Cool things in PowerPoint We’re in it! Let’s check it out!
Other Products from Microsoft • Groove – Virtual Office Space http://office.microsoft.com/en-us/groove/FX100487641033.aspx • Sharepoint-Dreamweaver equivalent/replaces FrontPage http://office.microsoft.com/en-us/sharepointserver/FX100492001033.aspx • Expression-Similar to Macromedia products http://www.microsoft.com/products/expression/en/default.mspx • One Note – Great for students & part of Office 2007 purchase http://office.microsoft.com/en-us/onenote/default.aspx
What I’ve learned so far… • It’s all there! It’s easier to find once you get used to the new interface • Use the groups to help guide you • Save the file correctly for the recipient • The new software makes me look SMART • I’ve learned the most from actually using it • Download a free trial
Resources Additional Resources http://blogs.msdn.com/jensenh/archive/tags/All+Office+2007+UI+Posts/default.aspx http://blogs.msdn.com/excel/ http://blogs.msdn.com/brian_jones/archive/tags/Office+2007/default.aspx Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en 60 Days for FREE! http://us1.trymicrosoftoffice.com/ Stacy L. Gee St. Louis Community College sgee@stlcc.edu Presentation posted: www.stlcc.edu/presentations