- Image via Wikipedia
There are a lot of great new features available with Microsoft Excel 2010. These features are definitely worth taking a look at. They include:
· Search Filter: This will allow you to quickly and easily narrow down your searches so that you can search a million entries instantaneously.
· Conditional Formatting: You can make your document look professional by adding great formats to it. With Excel 2010 there are more styles, icons, color effects, data bars and highlighting capabilities.
· Power Pivot Add-In, which used to be known as Project “Gemini”: Yu can streamline the integration of data from multiple sources so that you can quickly and easily work with a lot of data (up to as many as a million rows).
· Sparklines: You will be able to graphically display your data within just one cell, whether this is in a line, column or win/loss format.
· Slicer: This is a filtering mechanism that will allow you to maneuver your data without using drop down lists to do so. As such, it will be easier to section off your data to be filtered.
· Backstage: This is what replaces the traditional file menu. It is more ergonomic and efficient.
· An Improved Ribbon: The new ribbon allows you to quickly access your favorite commands. You will also be able to create customized tabs in order to make Excel look the way that you want it to.
· Online Capabilities: Now you can post your spreadsheets online so that you will be able to work on them from anywhere you want. You will also have all of the same capabilities that you would normally have whenever you choose to work in another location.
· Excel Web App: This is the application that you will use whenever you are working online. It is what will allow you to view and edit your spreadsheet from anywhere at any time.
· Excel Mobile: With the mobile version you can always stay up-to-date if you have a Smart Phone.