"Excel 2010 - Top 10 New Ways You Get A Cutting-Edge Spreadsheet Experience"


Microsoft Excel 2010 makes it possible to analyze, manage and share information in more ways than ever before, helping you make better, smarter decisions.

New data analysis and visualization tools help you track and highlight important data trends. Easily upload your files to the Web and work simultaneously with multiple individuals online. Access your important data on the go with Microsoft Excel Mobile 2010 (1) or Microsoft Excel Web App. (2)

Whether you're producing financial reports or managing personal expenses, Excel 2010 gives you more efficiency and flexibility to accomplish your goals.


1. Visualize data within 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.

Excel 2010 sparklines


2. Zero in on the right data points quickly

Excel 2010 delivers new and exciting slice-and-dice capabilities. The Slicer feature provides you with a rich visualization of your PivotTable view so you can dynamically segment and filter the data to display just what you need. With the search filter, you can spend less time sifting through large data sets in your tables and PivotTable views, and more time analyzing.

Excel 2010 slice and dice


3. Access your spreadsheets from virtually anywhere

Post your spreadsheets online and then access, view and edit them from virtually anywhere from the Web 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.

  • Excel Web App. Extend your Office experience to the Web, and view and edit your spreadsheets through the Excel Web App when you're away from your office, home or school.(2)
  • Excel Mobile 2010. Stay up-to-the-minute and take immediate action when necessary by using a mobile version of Excel specifically suited to your Smartphone.(1)


4. Connect, share and accomplish more when working together

Co-authoring through the Excel Web App makes it possible for you to edit the same spreadsheet with others simultaneously from different locations.2 You can see who's working on a spreadsheet with you at the same time. All modifications are instantly tracked and flagged so you can stay on top of where and when edits are made.


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 can also display data bars for negative values to more accurately illustrate your data visuals.


6. Take advantage of a more interactive and dynamic PivotChart

Quickly gather more insights within your PivotChart. Display different data views directly in a PivotChart, independent of PivotTable views, to analyze and capture the most compelling view for your numbers.

Excel 2010 pivotchart


7. Get things done 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 a few clicks. With an improved Ribbon you can access your favorite commands quickly and create custom tabs to personalize the experience to your work style.

Excel 2010 backstage view


8. Efficiently model and analyze almost any data

"Project Gemini" add-in for Excel 2010 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 and fast-query capabilities when working on their Excel Services report.3

Excel 2010 project gemini


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 co-workers, customers and business partners in a security-enhanced environment.


References:
(1)- Excel Mobile 2010 is not in the Office 2010 applications or suites.
(2)- Requires SharePoint 2010 or Windows Live. Office Web Apps will be available through Windows Live at a later date during Technical Preview and will have limited functionality at this milestone.
(3)- "Project Gemini" add-in requires a separate, free download.



Can't find what you're looking for? Try Google Search!

Custom Search


Related Links:

Back to Top

You're viewing the Microsoft Excel 2010 info page, click here to go back to the Home Page


Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Resources:

Click on the image to view the details of the training/book.
Excel 2010 Video Training DVD
Microsoft Excel 2010 Video Training DVD



Excel 2010 formulas ebook
Microsoft Excel 2010 Formulas



Word 2010 Video Training DVD
Microsoft Word 2010 Video Training DVD



PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007



Excel 2007 ebook
The Ultimate Guide to
Excel 2007!




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.