Application-specific changes Microsoft Office 2007

1 application-specific changes

1.1 word
1.2 outlook
1.3 excel
1.4 powerpoint
1.5 onenote
1.6 access
1.7 publisher
1.8 infopath
1.9 visio
1.10 project
1.11 sharepoint designer

application-specific changes
word


new style sheets (quick styles) , ability switch among them.
default font calibri instead of times new roman , featured in previous versions of microsoft office.
word count listed default in status bar. word count dynamically updates type.
new contextual spell checker, signified wavy blue underline traditional wavy red underline misspellings , wavy green underline grammar errors, catches incorrect usage of correctly spelled words, such in think loose battle .
translation tool tip option available english (u.s.), french (france), , spanish (international sort). when selected, hovering mouse cursor on word displays translation in particular language. non-english versions have different sets of languages. other languages can added using separate multilingual pack.
automated generation of citations , bibliographies according defined style rules, including apa, chicago, , mla. changing style updates references automatically. connect web services access online reference databases.
redesigned native mathematical equation support tex-like linear input/edit language or gui. supports unicode plain text encoding of mathematics.
preset gallery of cover pages fields author, title, date, abstract, etc. cover pages follow theme of document (found under page layout tab).
document comparison engine updated support moves, differences in tables, , easy follow tri-pane view of original document, new document, , differences.
full screen reading layout shows 2 pages @ time maximal screen usage, plus few critical tools reviewing.
building blocks, lets 1 save used content, accessible further use. building blocks can have data mapped controls in them allow form building or structured document authoring.
the ability save multiple versions of document (which had existed since word 97) has been removed.
blog entries can authored in word , uploaded directly blog. supported blogging sites include windows live spaces, wordpress, sharepoint, blogger, telligent community etc.
drops function insert/picture/from scanner or camera. can added manually.
drops bullets , numbering dialog boxes , rich, controlled range of options formatting outline numbered lists

outlook


as major change in outlook 2007, exchange 5.5 support has been dropped. evolution, outlook express , entourage, outlook works exchange 2000 , above.
outlook indexes (using windows search apis) e-mails, contacts, tasks, calendar entries, rss feeds , other items, speed searches. such, features word-wheeled search, displays results characters typed.
search folders, saved searches, have been updated include rss feeds well. search folders can created specific search criteria, specifying subject, type , other attributes of information being searched. when search folder opened, matching items search automatically retrieved , grouped up.
outlook supports text-messages , smss, when used in conjunction exchange server 2007 unified messaging.
outlook includes reader rss feeds, use windows common feeds store. rss subscription urls can shared via e-mails; updates can pushed mobile device.
outlook can support multiple calendars being worked simultaneously. includes side-by-side view calendars, each calendar displayed in different tab, , allows easy comparison of them. outlook supports web calendars. calendars can shared other users, , exported html file viewing others not have outlook installed.
calendar view shows tasks due.
flagged e-mails , notes can converted task items.
outlook includes bar, consolidates appointment, calendar, , task items in single view.
outlook includes windows sideshow calendar gadget
online or offline editing of microsoft office 2007 documents via sharepoint site. edits automatically synchronized.
contacts can shared among users, via e-mail, exchange server or sharepoint site.
attachment preview allows users view office e-mail attachments in reading pane rather having open program.
html in e-mails rendered using microsoft word rendering engine disallows several html tags object, script, iframe etc. along several css properties.

microsoft office outlook can include optional business contact manager (included on separate installation disc in office 2007 small business , above) allows management of business contacts , sales , marketing activities. phone calls, e-mails, appointments, notes , other business metrics can managed each contact. can keep track of billable time each contact on outlook calendar. based on these data, consolidated report view can generated microsoft office outlook business contact manager. data can further analyzed using microsoft office excel. data can shared using sharepoint services.

excel


support 1,048,576 rows , 16,384 columns (xfd) in single worksheet, 32,767 characters in single cell (17,179,869,184 cells in worksheet, 562,932,773,552,128 characters in worksheet)
conditional formatting introduces support 3 new features — color scales, icon sets , data bars

color scales, automatically color background of group of cells different colors according values.
icon sets, precede text in cell icon represent aspect of value of cell respect other values in group of cells, can applied. icons can conditionally applied show when criteria met, such cross showing on invalid value, condition invalidity can specified user.
data bars show gradient bar in background of cell contribution of cell value in group.


column titles can optionally show options control layout of column.
multithreaded calculation of formulae, speed large calculations, on multi-core/multi-processor systems.
user defined functions (udf), custom functions written supplement excel s set of built-in functions, supports increased number of cells , columns. udfs can multithreaded. server side udfs based on .net managed code.
importing data external sources, such database, has been upgraded. data can imported formatted tables , reports, not have regular grid structure
formula autocomplete, automatically suggests function names, arguments , named ranges, , automatically completing them if desired, based on characters entered. formulae can refer table well
cube functions allow importing data, including set aggregated data, data analysis services, such sql server analysis services
page layout view, author spreadsheets in way mirrors formatting of printed document
pivottables, used create analysis reports out of sets of data, can support hierarchical data displaying row in table + icon, which, when clicked, shows more rows regarding it, can hierarchical. pivottables can sorted , filtered independently, , conditional formatting used highlight trends in data.
filters, includes quick filter option allowing selection of multiple items drop down list of items in column. option filter based on color has been added choices available.
excel features new charting engine, supports advanced formatting, including 3d rendering, transparencies , shadows. chart layouts can customized highlight various trends in data.

powerpoint


improvements text rendering support text based graphics.
rendering of 3d graphics.
support many more sound file formats such .mp3 , .wma.
support tables , enhanced support table pasting excel.
slide library, lets reuse slide or presentation template. presentation or slide can published slide library.
any custom-designed slide library can saved.
presentations can digitally signed.
improved presenter view.
added support widescreen slides.
allows addition of custom placeholders.
drops function insert/picture/from scanner or camera.
allows duplication of slide through right-clicking without having go through copy , paste

onenote


onenote supports multiple notebooks.
notebooks can shared across multiple computers. can edit while not connected , changes merged automatically across machines when connection made. changes labeled author , change time/date.
notebook templates.
word-wheeled search present in onenote, indexes notes.
synchronization of tasks outlook 2007. outlook can send mails onenote, or open pages in onenote linked tasks, contacts, appointments/meetings.
support tables. using tabs create tabular structure automatically converts table.
optical character recognition performed on images (e.g., brochures, photos, prints, scans, screen clips) text appears in them searchable. handwritten text on tablet pc searchable.
words included in audio , video recordings tagged , indexed, can searched.
notes can have hyperlinks among themselves, or outside onenote specific point on page.
embedding documents in notes.
extensibility support add-ins.
drawing tools creating diagrams in onenote.
typing arithmetic expression, followed = results in result of calculation being displayed.
onenote import printer driver, application can print virtual printer onenote , printed document imported notebook; ocr performed on text appears in printed document facilitate searches.
onenote mobile included smartphones , pocketpc devices. syncs notes two-way onenote. takes text, voice, , photo notes.

access


access includes support broader range of data types, including documents , images.
whenever table updated, reports referencing table updated.
dropdown lists table can modified in place.
lookup fields, values looking value in table, have been updated support multi valued lookups.
many new preset schemata included.
access can synchronize windows sharepoint services 3.0 , office sharepoint server 2007. feature enables user use access reports while using server-based, backed-up, managed version of data.

publisher


templates automatically fill out information such company name, logo etc., wherever applicable.
frequently used content can stored in content store quick access.
a document can automatically converted 1 publication type, such newsletter, publication type, web page.
save pdf supports commercial printing quality pdf.
catalog merge can create publication content automatically retrieving data, including text, images , other supported types, external data source.
design checker, used find design inconsistencies, has been updated.

infopath


infopath designed forms can used browser, provided server running infopath forms services in sharepoint 2007 or office forms server.
a form can sent out people via e-mail. such forms can filled out outlook 2007 itself.
automatic conversion of forms in word , excel infopath forms. forms can exported excel.
forms can published network share or sharepoint server.
adding data validation, using validation formulae, , conditional formatting features without manually writing code.
print layout view designing forms in view mirror printed layout. such forms can opened using word well.
ability use microsoft sql server, microsoft office access, or other databases back-end data repository.
multiple views same forms, expose different features different class of users.
template parts, used group office infopath controls use later. template parts retain xml schema.

visio


pivotdiagrams, used visualize data, show data groups , hierarchical relationships.

visual modification of pivotdiagrams dragging data around levels, restructure data relationships.
pivotdiagrams can show aggregate statistical summaries data , show them.


shapes can linked external data sources. doing so, shapes formatted according data. data, , hence shapes, updated periodically. such shapes can formatted manually using data graphics feature.
autoconnect : link 2 shapes.
data link : link data shapes.
data graphics : dynamic objects (text , images) linked external data.
new theme behaviour , new shapes.

project


ability create custom templates.
any change in project plan or schedule highlights else affected.
analyze changes without committing them. changes can done , undone programmatically, automate analysis of different changes.
improved cost resource management , analysis projects.
project data can used automatically create charts , diagrams in microsoft office excel , microsoft office visio, respectively.
the project schedule can managed 3d gantt chart
sharing project data of sharepoint services.

sharepoint designer

microsoft office sharepoint designer 2007 new addition office suite, replacing discontinued frontpage users of sharepoint. people don t use sharepoint can use microsoft expression web

supports features , constructs expose sharepoint functionality
supports asp.net 2.0 , windows workflow foundation
support creating workflows , data reports, external data sources
can optionally render xml using xslt




^ see unicode plain-text encoding of mathematics (pdf). unicode, inc. april 4, 2006. retrieved 2006-12-19. 
^ happened versioning? . microsoft. retrieved 2007-10-02. 
^ blogging word 2007 . 2006-05-12. retrieved 2006-05-25. 
^ bryntze, john (2009-09-27). insert - picture - scanner or camera... in word 2007 . office-kb4. john bryntze s knowledge base. retrieved 2010-01-10. 
^ kennedy, william (december 16, 2005). search in outlook 12 - changes way work . msdn. microsoft. retrieved november 11, 2016. 
^ lowe, scott (november 2, 2006). @ new , different in outlook 2007 . techrepublic. cbs interactive. retrieved november 11, 2016. 
^ thurrott, paul (october 6, 2010). windows vista review, part 5: windows vista features: mobility features . supersite windows. penton. retrieved september 17, 2016. 
^ frie, curtis (2006-05-22). preview enhanced microsoft office excel 2007 business intelligence capabilities . microsoft.com. retrieved 2006-07-15. 
^ introducing: new powerpoint tables! . retrieved 2006-07-26. 
^ re-presenting powerpoint s presenter view . retrieved 2006-07-26. 
^ take walk on wide slide . retrieved 2006-07-26. 
^ s new in microsoft office onenote 2007 . office support. microsoft. retrieved november 11, 2016. 
^ pratley, chris (june 8, 2006). syncing onenote 2007 notes across many pcs . msdn. microsoft. retrieved november 11, 2016. 
^ pratley, chris (september 27, 2005). onenote 12 – working team shared notebooks . msdn. microsoft. retrieved november 11, 2016. 
^ pratley, chris (may 24, 2006). onenote 2007 , outlook: best buddies . msdn. microsoft. retrieved november 14, 2016. 
^ pratley, chris (september 15, 2005). unifying analog , digital onenote . msdn. microsoft. retrieved november 11, 2016. 
^ create pivotdiagram . office.com. microsoft. retrieved 4 december 2013. 
^ brief detour data: autoconnect . retrieved 2006-07-27. 
^ data link: getting data shapes . retrieved 2006-07-27. 
^ data graphics: visualizing data on diagram . retrieved 2006-07-27. 
^ themes: great results in few clicks . retrieved 2006-07-27.