- Whats New In Microsoft Excel 2010 Software Download
- Whats New In Microsoft Excel 2010 software, free download
- Microsoft Excel 2010 Pdf
- Whats New In Microsoft Excel 2010 Software Key
When a new version of Microsoft Office is released, sometimes Excel gets lots of new features. And sometimes it gets very few new features. In the case of Office 2010, Excel got very few new features. Here’s a quick summary of what’s new in Excel 2010, relative to Excel 2007:
- 64-bit version: If your hardware (and Windows version) supports it, you can install the 64-bit version, which lets you create larger workbooks. Most people do not require the 64-bit version, and using it might cause some add-ins to not function.
- Conditional formatting enhancements: Data bar conditional formatting can display in a solid color, and the bars provide a more accurate display.
- Screen capture tool: You can easily capture a window from a different program and then insert the image on a worksheet.
- New security features: Workbooks downloaded from the Internet or from e-mail attachments are opened in Protected View mode. Workbooks can be designated as “trusted,” and don’t need to reside in special trusted folders.
- New pivot table formatting options: You have more control over the appearance of pivot table reports.
- Office button changes: The big round Office button in Excel 2007 has been replaced by a File button/tab, displayed to the left of the tabs. Clicking it displays a screen that lets you perform various operations on your workbook. This view essentially replaces the traditional File and Print menus — plus quite a bit more.
- Solver: Excel 2010 includes a new version of the Solver add-in, which is useful for solving some complex problems.
- Slicers: A new way to filter and display data in pivot tables, by clicking buttons.
- Function enhancements: Some Excel worksheet financial and statistical functions have been improved in terms of numerical accuracy.
- Image editing enhancements: You have much more control over graphic images inserted into a workbook, including the ability to remove nonessential parts from the background of an image.
- Equation editor: Create and display (noncalculating) mathematical equations and embed them on a worksheet.
- Paste preview: When you copy a range, the Paste command displays various options with a live preview so you can see how the paste operation will look.
- Ribbon customization: You can customize the Ribbon by adding new tabs and groups.
- Enhancements to VBA: Operations that used to require old XLM macros can now be performed directly using VBA macro commands. In addition, macro recording now works for operations such as chart shape formatting.
- Sparkline charts: Create small in-cell charts to summarize a range of data graphically.
- Faster: Microsoft made some improvements to the calculation engine, and files load a bit faster.
You now can add data to Excel directly from a photo. Using the Excel app, just take a picture of a printed data table on your Android or iPhone device and automatically convert the picture into a fully editable table in Excel. This new image recognition functionality. To learn more from Excel 2010 itself, press F1 and type What’s New in the Search box of the Excel 2010 Help window to find details on all the new features in Excel 2010. The Excel 2010 user interface, like Excel 2007, scraps its reliance on a series of pull-down menus, task panes, and multitudinous toolbars.
Microsoft Office Excel 2010 comes with many new features and improvements that both casual users and number crunchers will enjoy. Microsoft has rewritten almost all old functions to improve performance and accuracy in Excel.
I have been using Excel for the past few weeks, taking a look at the new features, and the more I use it the more I like it. Excel 2010 is definitely improved in performance and has reduced graphics clutter when compared to Excel 2007. In addition to performance improvements, the following new features and enhancements make Excel 2010 a joy to use.
For a look at what’s new in Word 2010, check out our Word 2010 New Features Roundup.
Improved Ribbon: Microsoft introduced ribbon in Office 2007 but it is included in the list of new features because it has come a long way. The ribbon in Office 2010 is an enhanced, cleaner and more customizable tool. It is easier to change the behavior of the ribbon including adding your own shortcuts and hiding it if you don’t need to use the ribbon.
Paste option: Microsoft has also introduced a new paste option. This option will show up when you right click to paste. The paste option will change depending on what you are doing, so you might see different options when you past a picture than you would if pasting text.
Sparklines: Sparklines is one of most exciting features of Excel 2010. Sparklines are tiny charts that appear within a single spreadsheet cell. Basically Sparklines are a visual way to display numbers. Sparklines help bring meaning and context to numbers being reported and, unlike a chart, are meant to be embedded into what they are describing. The advantage of Sparklines is that you can represent more chart in same amount of excel compare to actual chart.
Excel 2010 has added three kind of Sparklines Line , column and win loss .
Whats New In Microsoft Excel 2010 Software Download
Sparklines are available under the Insert file menu. See below screen shot.
Sparklines can be given custom colors also. Select the color palette under the Sparkline tools. See below screen shot.
Below are some screenshots of Sparklines usage:
Sparklines feature video:
Slicer: Slicer is another new feature on Excel 2010 which helps to filter the data in pivot tables. Pivot tables are used to summarize the data and with the introduction of Slicers, you can visually filter the data on pivot table and quickly find the data you are looking for.
This helps you dig deeper in your data with less hassle. Slicers can be moved and resized like charts. A Slicer will get updated automatically when there is any change in pivot tables. You can place Slicers anywhere you want in the excel sheet and you don’t need to move the pivot tables to do that.
Like the Sparklines, the Slicer feature is available under the Insert menu.
Excel 2010 Slicer feature video:
Protected view: like Word 2010, Excel 2010 features protected view. If you open any downloaded file from the internet or an old version of Office, you won’t be able to edit the file right away.
This is because Excel 2010 opens such files in protected mode, and by default editing is disabled to prevent a virus or malicious code from running. If you know where the file came from and trust it then you can enable editing with one click.
Whats New In Microsoft Excel 2010 software, free download
You can also open any file in protected view by using the Open button.
Co-author: One of most notable feature in Excel 2010 is co-author. With excel 2010 you can use the Excel web app to edit a workbook with your colleagues at the same time, even if they are at different location. When someone else opens and edits the workbook in the Excel web app while you have it open you’ll see the number of editors in the workbook on the status bar, at the bottom-right corner of the screen.
If you open an Excel file from a network share for editing and someone else tries to open the same file they will also be able to co-author the file with you. This is a very useful feature, and one which should make collaboration easier, even with remote workers.
PowerPivot for excel add-in: PowerPivot for Excel 2010 is a free Microsoft tool to enhance your Excel capabilities such as fast manipulation of large data sets and is designed with business users in mind. Business users can publish and share analysis through Microsoft SharePoint. In short, PowerPivot for excel is a data analysis tool that delivers power directly within the Excel by providing user friendly methods of performing data analysis.
Please visit PowerPivot.com to learn more about PowerPivot for Excel.
64 bit support: Unlike the Windows operating system, Office 2010 is not coming in 32 bit and 64 bit versions separately. Instead, Microsoft is allowing users to choose between 32 bit and 64 bit during the installation. So, if you have a 64 bit operating system then you can choose the 64 bit office suite to take full advantage of 64 bit performance.
To find out the overview of Excel 2010 please see below video from Microsoft.
<object width=”480″ height=”385″><param name=”movie” value=”https://www.youtube.com/v/ZIBj1v4P7yg&hl=en_US&fs=1&”></param><param name=”allowFullScreen” value=”true”></param><param name=”allowscriptaccess” value=”always”></param><embed src=”https://www.youtube.com/v/ZIBj1v4P7yg&hl=en_US&fs=1&” type=”application/x-shockwave-flash” allowscriptaccess=”always” allowfullscreen=”true” width=”480″ height=”385″></embed></object>
Microsoft Excel 2010 Pdf
Related Posts
Whats New In Microsoft Excel 2010 Software Key
- The Microsoft Surface Pro 4 balances perfectly the needs of most laptop users who need…
- Even though Windows 10 has made upgrading Windows easier than ever, sometimes you still need…
- On August 2, 2016 the Windows 10 Anniversary Update came out with some cool new features…