Overview of Microsoft Office Excel 2007

Welcome to Microsoft® Office Excel® 2007 spreadsheet software, included in the 2007 release of the Microsoft Office system. The Microsoft Office system, an integrated system of programs, servers, and services for information workers, provides an even more accessible and comprehensive set of tools for people who rely on working with information efficiently and productively.

Office Excel 2007 is a powerful tool to create and format spreadsheets and to analyze and share information to make more informed decisions. With the Microsoft Office Fluent™ user interface, it’s easier to create and use rich data visualization, PivotTable® views, and professional-looking charts. When Office Excel 2007 is used with Microsoft Office SharePoint® Server 2007, you can take advantage of Excel Services—a new, server-based version of Excel that is optimized for managing, consuming, and sharing spreadsheets.

Ecma Office Open XML Formats reside at the heart of the new Microsoft Office system. A compact and robust file format, Office XML Formats allow for better data integration between documents and back-end systems. Also, with Excel XML Formats, you can reduce file sizes, improve data recovery, and increase the interoperability of your spreadsheets with other data sources such as line-of-business systems.

Create Better Spreadsheets

The Office Fluent user interface and new and improved capabilities makes it easier and faster to create effective spreadsheets that are ready to be shared or printed.

·         New! The Office Fluent user interface presents the right tools when you need them most.

·         New! Increased spreadsheet row and column capacity of one million rows by 16,000 columns enables you to import and work with massive amounts of data and achieve faster calculation performance with support for dual or multi-core processors.

·         Improved! Support for working with tables of data helps you create and format a table with a rich table styles gallery. Column headings remain in view as you scroll, and auto-fill populates and expands any table automatically.

·         New! Fast formatting with Cell Styles helps you assemble a great-looking report faster, with fewer clicks.

·         Improved! Formulas authoring experience includes a resizable formula bar and context-based Formula AutoComplete—so that you can write the proper formula syntax the first time, every time. You can also refer to named ranges and tables within formulas and functions.

·         New! Chart Formatting tools help you create and format professional-looking charts with greater ease using fewer clicks.

·         New! Use dramatic visual effects in charts such as 3-D, soft shadowing, anti-aliasing, and glow.

·         New! Shared diagramming and charting with Microsoft Office Word 2007 and Microsoft Office PowerPoint® 2007 presentation graphics program help ensure a consistent look across your spreadsheets, documents, and presentations.

·         New! Page Layout View for a better printing experience helps ensure that what you see on the screen is what you’ll get in printed output and that any headers and footers you add or edit are displayed in plain view.

·         Improved! Customization with Microsoft Office art, predefined styles, and integrated graphics help you apply a consistent, professional look to your spreadsheets that can easily be placed in other Microsoft Office system documents.

Improve Spreadsheet Analysis

New data analysis and visualization tools help you analyze information, spot trends, and access your company information more easily.

·         New! Conditional formatting with rich data visualization schemes helps you set conditions more easily to discover trends or patterns in your information.

·         Improved! Sorting and filtering helps you find the information you need, quickly and easily. Office Excel 2007 supports up to 64 levels to sort data, including the ability to sort by color.

·         Improved! Create a PivotTable or PivotChart® more easily by using data fields to reorient data quickly and find the answers you need.

·         New! Full support for Microsoft SQL Server™ 2005 Analysis Services enables you to query your most current business data by using the flexibility of Office Excel 2007.

Share Information with Customers and Partners

With Excel Services, you can share sensitive business information more broadly and securely with coworkers, customers, and business partners.

·         New! Dynamically render a spreadsheet in HTML and then permit others to view only the parts of a spreadsheet you want them to see by using their Web browser.

·         New! High fidelity between the Office Excel 2007 client and spreadsheets that are rendered using Excel Services helps you navigate, sort, filter, and interact with tables or PivotTable views from a Web browser.

·         New! Business dashboards can be easily created from spreadsheets to track key performance indicators (KPIs), and then you can share these broadly through a Web browser.

·         New! Support for PDF and XML Paper Specification (XPS) file formats helps you convert your spreadsheets into a fixed file format for easier sharing.[1]

Manage Information More Effectively

Use Excel Services and XML file format to manage and control important business information more effectively.

·         New! With the Data Connection Library you can import external data into a spreadsheet by using preconfigured external sources of business information.

·         New! Report management features help protect confidential business information while ensuring people can view the data they need.  

·         New! Publish to Office SharePoint Server 2007 to help prevent the spread of multiple copies of business-critical spreadsheets throughout your organization, protect sensitive business information, and ensure people are working with the most current data.

·         New! Excel Services application programming interface (API) enables developers to use the Office Excel 2007 powerful calculation engine in other applications, such as a Web-based mortgage calculator or an options pricing model.

·         New! Office XML Formats reduce file sizes, improve data recovery, and make greater data interoperability possible.

·         New! Permissions-based control helps you manage who can access, view, and make changes to spreadsheets stored on the server.

Office Excel 2007 in Action

Sylvie Narp is the Director of Finance for Fabrikam, Inc., a manufacturing company. With 15 direct reports, each responsible for a different section of the business, she needs comprehensive, real-time visibility into the company’s financial data. Her employees need a robust yet flexible tool for analyzing data to make more informed decisions. Office Excel 2007 offers a comprehensive solution.

[1] You can save as a PDF or XPS file from a 2007 Microsoft Office system program only after you install an add-in. For more information, see Install and use a PDF or XPS add-in.

Related Post :