Excel is arguably the most under-utilized Microsoft Office stock when it comes to industrialized features. Ask population what features they most like in Excel and they commonly quote the spreadsheet and graphing tools. But that is just a very small part of the capabilities built into Excel. From tools for statistical, engineering and financial functions, to pivot tables, to visual Basic for Applications (Vba) programming, you can use Excel for uncomplicated to involved data pathology and display with easy to read graphs and charts.
If you haven't used the industrialized tools in Excel, start by trying the new features to get the most from your software investment. Analyze your data to discover patterns or trends, then display with graphs and charts that illuminate the best course of action. With a little practice, you will enhance your capability to study large data sets and make the most informed decisions.
Metro Wireless Engineering
Make fast, productive comparisons
Sparklines - Use sparklines to graphically display data in a singular cell. You can display data in line, column or win/loss format to highlight trends. On the Insert tab, pick the type of Sparkline and your data range. Customize your sparklines for optimum consequent by selecting the sparkline and selecting the design tab.
Slicer - Slicers are filtering components that allow you to slice-and-dice your data without having to open drop down lists. Slicers make it easier to segment and filter data in PivotTables for high powered firm intelligence.
Step up your analysis
Search Filter - Use the new quest Filter to fast and beyond doubt narrow your quest in tables, PivotTable, and PivotChart views. You can right away sort straight through a million or more items.
PowerPivot (formerly called scheme "Gemini") Add-In - Groundbreaking technology that allows you streamlined integration of data from complicated sources and lightning-fast manipulation of large data sets with up to millions of rows. Easily issue and share pathology straight through Microsoft SharePoint Server 2010 and have other users enjoy the same Slicer and fast-query capabilities when working on their Excel Services report.
Backstage - The Microsoft Office Backstage view replaces the former file menu with an ergonomic advent that uses In and Out features for efficiency. The improved Ribbon lets you passage your popular commands fast and create convention tabs to personalize the way you work.
Jazz up your data presentations
Conditional Formatting - Excel 2010 adds sophistication to conditional formatting. Give your document a professional look by adding eye-catching formats. You have more choices and control over styles and icons, improved data bars, and the capability to highlight exact items in a few clicks. You can also display data bars for negative values and use color for effect.
Work from anywhere
Online - Post your spreadsheets online and work on 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 feel across complicated locations and devices.
Excel Web App - increase your Office feel to the Web, and view and edit your spreadsheets straight through the Excel Web App when you're away.
Excel movable 2010 - Stay up-to-the-minute and quote on-demand by using a movable version of Excel specifically remarkable to your Smartphone.
For other piquant features and functions, try Goal Seek to give you a what-if pathology to test your scenarios, experiment with linear regression to understand relationships in your data or just play with the new formatting tools. But once you find the "hidden" features in Excel, you will be enthusiastically hooked.
Microsoft Office 2010 - The Best New Features in Excel