Excel 2010 Top Benefits
Explain Benefit #1: Create data charts in a single cell?
With Sparklines, a new feature in Excel 2010, you can create small charts in a single cell to quickly discover patterns in your data. It’s a quick and easy way to highlight important data
trends such as seasonal increases or decreases, saving you time.
Explain Benefit #2: Create data charts in a single cell?
Zero in on the right data points quickly.Excel 2010 delivers a new and exciting filter enhancement for your PivotTables. The Slicer feature provides you with a rich visualization of your PivotTable view so you can dynamically segment and filter the data to display precisely what you need. With the new search filter, you can spend less time sifting through large data sets in your tables and PivotTable views, and more time analyzing
Explain Benefit #3: Access your spreadsheets from virtually anywhere?
Post your spreadsheets online and then access, view, and edit wherever from just about any computer or your Windows Mobile-based smartphone. With Excel 2010, you can take advantage of a
best-in-class spreadsheet experience across multiple locations and devices.
Microsoft Excel Web App
Edit documents in a Web browser when you’re away from your office, home, or school without compromising the quality of your viewing experience.
Microsoft Excel Mobile 2010
Stay current and take immediate action when necessary using the mobile version of Excel specifically suited to your smartphone.
Explain Benefit #4: Connect, share, and accomplish more when working together?
Co-authoring through the Microsoft Excel Web App makes it possible for you to edit the same spreadsheet with others simultaneously from different locations. You can see who’s working on a
spreadsheet with you at the same time. All modifications are instantly shown and flagged so you can see where others are editing and who those editors are.
Explain Benefit #5: Add more sophistication to your data presentations?
Conditional Formatting in Excel 2010 gives you more control over styles and icons, improved data bars, and the ability to highlight specific items in a few clicks. You also can display data bars
for negative values to more accurately illustrate your data visuals.
Explain Benefit #6: Take advantage of more interactive and dynamic PivotCharts?
Quickly gather more insights with the ability to display different data views directly in a PivotChart, independent of PivotTable views, to analyze and capture the most compelling picture of
your numbers.
Explain Benefit #7: Do things easier and faster?
Excel 2010 simplifies how you access features. The new Microsoft Office Backstage view replaces the traditional File menu to let you save, share, print, and publish your spreadsheets with
just a few clicks. And, with the improved Ribbon, you can access your favorite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.
Explain Benefit #8: PowerPivot for Excel add-in?
Efficiently model and analyze almost any data with the PowerPivot for Excel add-in, a free download, provides groundbreaking technology such as streamlined integration of data from multiple
sources and lightning-fast manipulation of large data sets with up to millions of rows. Business users can effortlessly publish and share analysis through Microsoft SharePoint Server 2010,
and have other users enjoy the same Slicer, PivotTable, and fast-query capabilities when working on their Excel Services report.
Explain Benefit #9: Harness more power for building bigger, more complex spreadsheets?
Power users and analysts rejoice! With the new 64-bit version of Excel 2010, massive amounts of information are easier to analyze than ever before. Analyze large, complex datasets greater
than the 2-gigabyte file size of previous Excel versions.
Explain Benefit #10: Publish and share through Excel Services?
SharePoint Server 2010 and Excel Services integration lets business users share analysis and results across their organization by publishing spreadsheets to the Web. Build a business intelligence
dashboard and share sensitive business information more broadly with coworkers, customers, and business partners in a security-enhanced environment.