Microsoft Excel 2010

Microsoft Excel 2010
 Microsoft Excel icons are pictorial representations of objects and are shorthand for completing tasks in Microsoft Excel. Microsoft Excel icons allow you to quickly open or close a file, access and modify your data and even email or fax your spreadsheet. Popular Microsoft Excel icons are displayed at the top of your spreadsheet, but you may choose to add icons you use frequently
Microsoft Excel is a spreadsheet program that allows users to insert and   manipulate data.  This tutorial covers many basic functions for Microsoft Excel such as   inserting cells, mathematical functions, and sorting lists.

Microsoft Excel 2010: New Features

 RIBBON

First introduced in Excel 2007, the ribbon makes it easy for you to find commands and features that were previously buried in complex menus and toolbars. Although you could customize the Quick Access Toolbar in Excel 2007, it wasn’t possible to add your own tabs or groups to the ribbon. In Excel 2010, however, you can create custom tabs and groups and rename or change the order of the built-in tabs and groups.

SPARKLINES

You can use sparklines—tiny charts that fit in a cell—to visually summarize trends alongside data. Because sparklines show trends in a small amount of space, they are especially useful for dashboards or other places where you need to show a snapshot of your business in an easy-to-understand visual format. In the following image, the sparklines that appear in the Trend column let you see at a glance how each department performed in May.

SLICERS

Slicers are visual controls that let you quickly filter data in a PivotTable in an interactive, intuitive way. If you insert a slicer, you can use buttons to quickly segment and filter the data to display just what you need. In addition, when you apply more than one filter to your PivotTable, you no longer have to open a list to see which filters are applied to the data. Instead, it is shown there on the screen in the slicer. You can make slicers match your workbook formatting and easily reuse them in other PivotTables, PivotCharts, and cube functions.

POWERPIVOT FOR EXCEL ADD-IN

If you need to analyze large quantities of data, you can download the Microsoft SQL Server PowerPivot for Excel add-in, which adds a PowerPivot tab to the Excel ribbon.

MORE THEMES

In Excel 2010, there are more themes and styles than ever before. These elements can help you apply professional designs consistently across your workbooks and other Microsoft Office documents. Once you select a theme, Excel 2010 does the design work. Text, charts, graphics, tables, and drawing objects all change to reflect the theme you have selected, so that all elements in your workbook visually complement one another.

Microsoft Excel 2010: Improved Features

IMPROVED FILTER CAPABILITIES

In addition to slicers, which are described earlier in this article, Excel 2010 comes with new features that make it easier to sort and filter data.

• New search filter    When you filter data in Excel tables, PivotTables, and PivotCharts, you can use a new search box, which helps you to find what you need in long lists. For example, to find a specific product in a catalog that stocks over 100,000 items, start by typing your search term, and relevant items instantly appear in the list. You can narrow the results further by deselecting the items you don't want to see.

IMPROVED PICTURE-EDITING TOOLS

Communicating ideas in Excel 2010 isn't always about showing numbers or charts. If you want to use photos, drawings, or SmartArt to communicate visually, you can take advantage of the following features:

• Screenshots    Quickly take a screenshot and add it to your workbook, and then use the tools on the Picture Tools tab to edit and improve the screenshot. 

IMPROVED CHARTING

It's easier to work with charts in Excel 2010. Specific improvements include:

• New charting limits    In Excel 2010, the limitation on the number of data points that can be created on a chart has been removed. The number of data points is limited only by available memory. This enables people—particularly those of you in the scientific community—to more effectively visualize and analyze large sets of data.
• Quick access to formatting options    In Excel 2010, you can instantly access formatting options by double-clicking a chart element.
• Macro recording for chart elements    In Office Excel 2007, recording a macro while formatting a chart or other object did not produce any macro code. In Excel 2010, however, you can use the macro recorder to record formatting changes to charts and other objects.

IMPROVED EXCEL SERVICES

If your organization previously used Excel Services to share Excel workbooks on SharePoint Server sites, take note of the following improvements:

• Improved user experience    Some of the more visible changes include the ability to refresh elements of a page, instead of having every change require a page refresh, and the addition of scroll bars, which let you easily scroll throughout the worksheet.
• Better integration with SharePoint 2010 features    In this version of Excel Services, you get better integration with important SharePoint 2010 features, including security, content management, version control, data connection management, and service administration features. In addition, Excel Services better integrates with the built-in business intelligence capabilities in SharePoint.
• Improved support for workbook features    Previously, if a workbook contained unsupported features, it couldn't be opened at all in the browser. Now, if a workbook contains an Excel feature that isn't supported, that workbook will, in most cases, open in the browser. In addition, more Excel features are supported in Excel Services, including new Excel 2010 features such as sparklines and slicers.
• More support for developing applications    Developers and non-developers alike can take advantage of new tools, such as a REST application programming interface, for building business applications.

IMPROVED PROGRAMMABILITY FEATURES

Improvements for developers include:

• Changes to the XLL SDK     The XLL Software Development Kit (SDK) now supports calling new worksheet functions, developing asynchronous user-defined functions, developing cluster-safe user-defined functions that can be offloaded to a compute cluster, and building 64-bit XLL add-ins.
• VBA improvements    Excel 2010 has a number of features that will enable you to migrate any remaining Excel 4.0 macros you may have to VBA. Improvements include better performance for print-related methods and chart properties not previously accessible with VBA.
• Better user-interface extensibility    If you develop custom workbook solutions, you have more options for programmatically customizing both the ribbon and the new Backstage view. For example, you can programmatically activate tabs on the ribbon, and make custom tabs behave similarly to built-in contextual tabs, where tabs only appear when specific events occur. In addition, you can make custom ribbon groups grow and shrink as the ribbon is resized and customize context menus with rich controls. You can also add custom UI and other elements to the Backstage view .
• Changes to the Open XML SDK    The Open XML SDK 2.0 now supports schema-level objects, in addition to the part-level support introduced in the Open XML SDK 1.0. This makes it easier to programmatically manipulate workbooks and other documents outside the Office 2010 desktop applications—for example, as part of a server-based solution.

Microsoft Excel 2007 versus 2010

There are many differences between excel 2007 and 2010.  There are far fewer differences between Excel 2007 and Excel 2010.  Should you upgrade?  Very tough call.   We thought we would list the differences that we see that are important to most users:

• Chart macro recording has been fixed in 2010.  Not something to be proud of since it should not have been broken when Excel 2007 was released, and should have been fixed in an SP release.  If you need to record chart macros, which is a need if writing such macros, then you need 2010.

• The calculation speed is a little faster.  For 99% of users, no one will notice the difference. 

• Sparklines are nice.  Maybe worth the upgrade.  They are little mini-charts.

• Excel 2010 can be run as a 64 bit application.  But one can not install it as part of the automatic install.  One has to dig on the disk to find it.  And you need to have at least 5-10 gig of memory on your PC to significantly benefit from it.  Most PCs have at most 3 gig, which is far to little.  And few users need 64 bit Excel.  But it does sound impressive to say you are using it!

• Microsoft improved statistical, financial, and math functions and the wizard interface in 2010. We're glad the functions are better, but upgrade only if you are aware of a problem with functions in your older copy of Excel or if you need a function that is not in your copy of Excel. 

• Fill patterns which were removed in 2007 are back.  Howeve do not upgrade just to get fill patterns back.  A quick search on the internet will find several free fill pattern add-ins for Excel 2007. 

• If you are a heavy user of conditional formatting, then upgrading to 2010 should benefit you.  In 2007, a lot of conditional formatting would bring Excel to its knees. 

If you were pushing the envelope of what you needed Excel to do, then upgrading is probably a good idea, especially if you have Excel 2007.  If you are on 2003, upgrading to 2010 will most likely cut your productivity 20% at least.  See our page above on 2003 versus 2007.   If you are the average user, developing typical workbooks and your version of Excel is working fine, stay with it and don't upgrade.

Issues ;

• Corrupted shortcut to the Excel program
• Problematic file in Excel startup folder or alternate startup file location
• Conflict with another program
• Incorrect version of a core Microsoft Office file
• Corrupted Excel toolbar file (*.xlb) or Excel .pip file
• Corrupted add-ins under the Tools menu
• Corruption in the registry keys
• Other problems when opening Excel files
• 
  

Reflection:

The Microsoft Excel 2010 is now very convenient it will analyze, manage, and share information in more ways than ever before.  Excel 2010 gives you more efficiency and flexibility to accomplish your goals.

Microsoft Office 2010

Microsoft Office 2010 Description

Microsoft Office 2010 gives you powerful new tools to express your ideas, solve problems, and connect with people. Office 2010 lets you work how, when, and where you want, letting you get things from a PC, the Web, and even a smart phone.

Use Office 2010 virtually anywhere: PC, phone, browser
With Microsoft Office 2010, you can review and do minor editing on Word, Excel, PowerPoint, and OneNote 2010 documents, virtually anywhere, by using Office Web Apps from more locations on more devices. 

Keep your people productive on the go. Office 2010 lets you access and edit documents stored on a server while you’re offline with SharePoint Workspace 2010, and then automatically syncs these changes when you’re back online. So you stay productive while on the go. 

Support your employees, regardless of location or device. Office 2010 saves you time and money by helping you deploy and manage Office on the PC, the smart phone, and the Web, all from within familiar Microsoft System Center tools. 


Product Features

·         Microsoft Word 2010 offers enhanced features to create professional-quality documents.

·         Easier ways to work together with people, and almost-anywhere access to your files

·         Better illustrate your ideas with diagrams by turning bullet-point lists into compelling SmartArt graphics

·         Apply new formatting effects to your text such as shadow, bevel, glow and reflection

·         Add impact to your document with new picture-editing tools

·         Capture and insert screenshots directly into your document