p. 1

microsoft excel 2010 product guide

[close]

p. 2

table of contents microsoft excel 2010 an overview 1 excel 2010 at-a-glance 2 get easier access to the right tools at the right time 2 analyze your data quickly and effectively 2 obtain powerful analysis from your desktop 3 save time and simplify your work 3 collaborate on workbooks in new ways 4 access your workbooks virtually anytime anywhere 5 excel 2010 a closer look 6 ribbon improved 6 microsoft office backstage view new 7 sparklines new 9 pivottable views improved 10 pivotchart interactivity improved 10 slicer new 11 conditional formatting improved 12 powerpivot for excel 2010 new 13 function accuracy improved 15 filter capabilities improved 16 solver add-in improved 17 64-bit version new 18 recover unsaved versions new 19 charting performance improved 20 equations new 20 office themes improved 21 paste with live preview new 22 picture editing tools improved 23

[close]

p. 3

excel services improved 25 protected view new 25 trusted documents new 26 accessibility checker new 27 streamlined communications new 28 share through communicator 14 new 30 language tools improved 30 microsoft excel web app new 32 microsoft excel mobile 2010 improved 35 power user tips 37 more on show values as calculations 37 explore recover unsaved workbooks and autosave versions 41 customize the ribbon 42 customize workbooks and save time using office open xml 44 conclusion 46 where to find it 47 version comparison 54 excel 2010 faq 63 feature availability disclosure 72 office mobile 2010 72 office web apps 72 powerpivot for excel 2010 72 microsoft communicator 14 72 links provided in this product guide 72

[close]

p. 4

microsoft excel 2010 an overview microsoft® excel® 2010 delivers rich new and enhanced features to the world s most popular productivity suite excel 2010 makes it possible to analyze manage and share information in more ways than ever before helping you make better smarter decisions with new data analysis and visualization tools along with managed self-service business intelligence technologies you can create effective business or information insights that track and highlight important data trends and communicate your results through high-quality charts and graphs you can also easily share your insights with others through microsoft sharepoint® 2010 or your windows livetm account work better together by working simultaneously with others online and accomplish your most important tasks faster your information is never far away as you can access your files from almost anywhere from your pc a web browser or smartphone.1 with excel 2010 you can work when and where you want whether you re producing financial reports managing personal expenses collaborating with a team on school or work projects even if your workbooks exceed a million rows excel 2010 makes it easier to get what you need done more quickly with more flexibility and with better results welcome to excel 2010 our most powerful and intuitive version yet 1 web and smartphone access require an appropriate device and some functionality requires an internet connection web functionality uses office web apps which require a supported internet explorer ® firefox or safari browser and either sharepoint foundation 2010 or a windows live id some mobile functionality requires office mobile 2010 which is not included in office 2010 applications suites or office web apps there are some differences between the features of the office web apps office mobi le 2010 and the office 2010 applications 1

[close]

p. 5

excel 2010 at-a-glance take a glance at how excel 2010 is designed to give you the best productivity experience across pc phone and browser get a closer look at the new and improved features in the sections that follow today a spreadsheet application is used for a variety of tasks such as statistical analysis forecasting revenue managing business and personal finances and maintaining address lists or student records your needs may be increasing but there s no need to outsource and hire a consultant to meet them with excel 2010 you can quickly create polished and professional work new data analysis and visualization capabilities have been added and long-time favorites have been enhanced to help increase your productivity and help you gain insights resulting in better decisions get easier access to the right tools at the right time new and improved features can help you be more productive but only if you can find them when you need them fortunately the enhanced customizable ribbon in excel 2010 makes it easy to uncover more commands so you can focus on the end result not how to get there want an easier time making sure the file you re working on is finished and ready for public consumption wishing for a faster more direct route to print something or perhaps you need an easier way to share your workbooks the new microsoft office backstagetm view can help you achieve all of this and more you can now more easily print share and manage your workbooks and customize your excel 2010 experience all from one convenient location analyze your data quickly and effectively excel 2010 delivers powerful new features to help you discover patterns or trends at-a-glance that can lead to more-informed decisions improve your ability to analyze large data sets by using new analysis visualization features and dynamic formatting to call out the highs and lows of your data turn complexity into clarity get a quick visual summary of data using tiny charts that fit within a cell near its corresponding values with new sparklines 2

[close]

p. 6

more intuitive filtering quickly filter large amounts of data in fewer steps using new slicer functionality and enhance your pivottable® view and pivotchart® view visual analysis enhanced data analysis and visualization communicate your analysis more clearly through improved conditional formatting using new icons and enhanced data bars obtain powerful analysis from your desktop whether at work or home you need to be able to manipulate and analyze your information in a way that gives you new insight to make better decisions and the faster you can finish your task the better many refinements and performance improvements in excel 2010 make it easier and faster for you to accomplish your work get more power from excel for those who need additional power for your analysis powerpivot for excel 2010 a free add-in was designed for you experience lightning-fast manipulations of enormous quantities of data.2 quickly narrow your search find relevant items among thousands or even millions of table or pivottable rows using new search filter capabilities power users this is for you work with massive datasetsmore than 2 gigabytesand maximize new and existing hardware investments by using the 64-bit version of excel 2010.3 save time and simplify your work no matter what type of workbooks you create you want to focus on your content not the tasks associated with creating and managing them excel 2010 delivers new and improved tools that simplify your tasks and save you time at every step recover unsaved versions of files that you closed without saving that s right recover your workbooks even if they were never previously saved enjoy a wide range of additional office themes coordinate colors fonts and graphic formatting effects throughout your workbook in just a couple clicks 2 requires a free separate download for more information visit www.powerpivot.com powerpivot for sharepoint requires microsoft sql® server 2008 r2 enterprise edition or higher and sharepoint 2010 3 this option can only be installed on 64-bit systems for installation instructions and more information visit http www.office.com/office64setup 3

[close]

p. 7

pasting is now simplified effortlessly reuse content by previewing how information will look before actually pasting using paste with live preview add polished and professional images to your workbooks with new and improved picture editing tools you don t have to be a graphic designer or use additional photo-editing programs sometimes you want to share your workbooks with friends or co-workers at other times you need to work together with a team on school or work projects in either instance you want to focus on what needs to be done as opposed to the processes that make sharing and communicating easy and convenient excel 2010 provides new and enhanced features to help you work on team projects or show your work to other people collaborate on workbooks in new ways excel 2010 offers easy ways to bring people together and help increase work quality new technologies help break down barriers so you can share and work together on workbooks and dashboards making you and/or your team more efficient and productive share your analysis and results across your organization use sharepoint excel services and share your easy-to-read workbooks in a web browser with your team while maintaining a single version view workbooks created by others more safely and securely workbooks received in e-mail or downloaded from the web automatically open in protected view so that you can make a more informed decision before exposing your computer to potential vulnerabilities eliminate multiple security prompts trusted documents simplify your excel 2010 experience by enabling you to eliminate security prompts for workbooks you have already trusted 4

[close]

p. 8

if your ideas deadlines and work emergencies don t always conveniently occur when you are at your desk you are certainly not alone fortunately excel 2010 gives you the power to get things done when and where you want access your workbooks virtually anytime anywhere get the information you need when and how you want it now you can easily access your workbooks by taking the excel experience with you and stay on top of your needs while you re on the go microsoft excel web app edit virtually anywhere view and edit your workbooks in a web browser when you re away from home school or your office.4 you can even simultaneously work with other people on the same workbook even if they don t have excel installed microsoft excel mobile 2010 bring big power to your small devices stay up to the minute by using a mobile version of excel specifically suited to your windows® phone.5 whether you are creating a simple list or a complex mission-critical financial model or getting work completed on the run excel 2010 makes it easier to get what you need done more quickly with more flexibility and with better results 4 office web apps require an appropriate device internet connection supported internet explorer firefox or safari browser and either sharepoint foundation 2010 for business or a free windows live id for personal use there are some differences bet ween the features of office web apps and the office 2010 applications 5 an appropriate device is required excel mobile 2010 is not included in office 2010 applications suites or web apps office mobile 2010 will be released on windows phones windows mobile ® 6.5 or above by the general availability of microsoft office 2010 there are some differences between the features of office mobile 2010 and the office 2010 applications 5

[close]

p. 9

excel 2010 a closer look explore new ways excel 2010 can help you get things done whether you re working on your ideas on your own together or on the go get easier access to the right tools at the right time ribbon improved locate the commands you need when you want them and where you want them the improved ribbon available across the office 2010 applications makes it easy to uncover more commands so you can focus on the end product rather than how to get there the ribbon replaces the traditional menus and toolbars to give you a more customized work experience it s designed to help you more easily find and use the full range of features that excel provides so that you can get more done in less time figure 1 the enhanced ribbon helps you quickly find the commands that you need to complete a task customize or create your own tabs on the ribbon to personalize the excel 2010 experience to your work style the standard tabs that you see on the ribbon are organized to display commands relevant to a given task so that you can find what you need more quickly the ribbon also provides contextual tabs to give you exactly the tools you need when you need them for example when you click a chart contextual tabs appear on the ribbon with a broad range of chart options as shown in figure 2 6

[close]

p. 10

figure 2 contextual tools automatically display when you need them microsoft office backstage view new on the left edge of the ribbon you see the file tab just click that tab for an all-access pass that makes it easier than ever to manage your files and customize your excel experience the new backstage view replaces the traditional file menu to provide a single location for all of your file management tasks for example when you first open backstage view you re on the info tab from this one location you can manage workbook protection options view and edit file properties inspect the workbook for proprietary information you may not want to share and even recover files that you accidentally closed without saving 7

[close]

p. 11

from the save send tab in backstage view you can share your workbook as an excel email attachment or as pdf or xps you can also save your workbook to microsoft sharepoint or to the web such as to your windows live skydrivetm the print tab shown in figure 3 provides a new print experience with a full page print preview right alongside your print options figure 3 ­change your print settings and preview your workbook in a single intuitive view the ribbon helps you create your content backstage view helps you manage it quick tip check out the recent tab in backstage view for lists of both recently accessed files and recently accessed locations pin files or locations to that tab to move them to the top and keep them readily accessible in addition you can remove a recently used file or location by right-clicking the list item and then clicking remove from list 8

[close]

p. 12

analyze your data quickly and effectively sparklines new sometimes numbers speak for themselves at other times charts or graphs can significantly clarify your information with excel 2010 you can take advantages of numbers and charts within the same cell sparklines are small charts in a worksheet cell that provide a clear and compact visual representation of your data for quick and easy reference figure 4 ­ add sparklines to chart data near your values use sparklines to show trends in a series of values such as seasonal increases the price of your home or your monthly expenditures highlight maximum or minimum values and increase impact by positioning a sparkline next to its corresponding data quick tips quickly create sparklines select the location for your sparkline on the insert tab in the sparklines group choose the type of chart you want line column or win/loss and select the values for the data range to format a sparkline independently of a sparkline group select the sparkline and on the sparkline tools design tab click ungroup 9

[close]

p. 13

pivottable views improved pivottable views are easier and faster to use in excel 2010 along with improved performance that helps speed up data retrieval sorting and filtering you ll find these additional enhancements and more repeating labels in previous versions of excel when you use more than one field as a row label in your pivottable only the first occurrence of the row label will display in excel 2010 you can now use repeat all item labels found on the pivottable tools design tab in the report layout options in to repeat the row label for each corresponding value this enhanced ability enables you to utilize pivottable data in functions such as vlookup index and match new show values as calculations excel 2010 has added six new calculations for analyzing your pivottable data now display of parent row total of parent column total of parent total of running total in rank smallest to largest or rank largest to smallest quick tip now it s even easier to try out different calculations in your pivottable right-click a value field in your pivottable and point to show values as to display a list of calculations that were only previously available in the value field settings dialog box you can also find show values as on the pivottable tools options tab in the calculations group pivotchart interactivity improved excel 2010 takes the popular pivotchart used for visual analysis and reporting one step further you can now filter directly on your pivotchart using new interactive buttons figure 5 quickly filter your pivotchart with new interactive buttons 10

[close]

p. 14

stay in control of what you see on your screen and make filtering more accessible hide all interactive buttons for printing purposes or hide individual buttons that may not apply to your filtering needs quick tip after you filter your pivotchart the interactive buttons will display a filter icon just as the pivottable does today slicer new collecting useful and detailed data is only half of the equation for data analysis the other half is having the right tools in place to help you better understand your data enhanced pivottable and pivotchart filtering in excel 2010 lets you intuitively filter large amounts of data through the new slicer feature quickly find the relevant information you need and clearly see which items you are filtering in your report filter on the fly your slicer will dynamically change and update as data in underlying pivottable or pivotchart changes figure 6 ­ connect a slicer to any number of pivottable and pivotchart views and filter multiple objects simultaneously place your slicers where you want them a slicer can be moved around and resized like a chart or a graph so you can control the look of your report 11

[close]

p. 15

filter on multiple fields connect multiple slicers to a pivottable or pivotchart and increase your filtering capabilities quick tips display slicer list items in multiple columns select the slicer and on the slicer tools options tab in the buttons group modify the columns count find a variety of additional formatting options for your selected slicer on the slicer tools options tab choose from a gallery of slicer styles that match your office theme or when working with multiple slicers use the options in the arrange group to quickly align and group your slicers conditional formatting improved conditional formatting comes with even greater flexibility in excel 2010 to help you more easily discover and illustrate important trends and highlight data exceptions find more styles data bar options and new icon sets figure 7 use conditional formatting with gradient fills and borders data bars and icon sets to better analyze your data more icon set flexibility now you can mix and match icons from different sets or hide an icon for cells that meet a specified condition it s easy to customize your icon arrangements 12

[close]