Top 10 Benefits of using Excel 2010

[OpenCast Excel Tips]

Top 10 benefits of Excel 2010
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.

2
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.

3
Efficiently model and analyze almost any data.

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.1

4
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 phone.2 With Excel 2010,
you can take advantage of a best-in-class spreadsheet experience
across multiple locations and devices.




5
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.2 See changes from others appear as they are made
and with the number of editors in the workbook shown on the status
bar, you’ll always know who else is editing the workbook with you.

6
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.

7
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.

8
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.

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.



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.