Tính năng Slicer cung cấp cho bạn một hình dung phong phú của ® PivotTable của bạn xem để bạn có thể tự động phân đoạn và lọc dữ liệu để hiển thị chỉ là những gì bạn cần. Với bộ lọc tìm kiếm, bạn có thể chi tiêu ít thời gian hơn việc chọn lọc thông qua các bộ dữ liệu lớn trong các bảng của bạn và xem PivotTable, và thêm thời gian phân tích. | Excel 2010 Tips Tricks Contents Zero in on the right data points Share and Analyze Data Get to the right information quickly in Excel Zero in on the right data points faster. Excel 2010 delivers new and exciting slice-and-dice capabilities. The Slicer feature provides you with a rich visualization of your PivotTable view so you can dynamically segment and filter the data to display just what you need. With the search filter you can spend less time sifting through large data sets in your tables and PivotTable views and more time analyzing. Step by Step Note Slicers require that you have already created a PivotTable from your data. 1. Select a PivotTable and on the Insert tab in the Filter group click Slicer. 2. In the Insert Slicer dialog box select what you want to filter your PivotTable by and then click OK. In this example two Slicers will be available one to filter the PivotTable based on Genre and the other based on Store. 3. From the Slicer select the filter you want to apply. In this example you are filtering the PivotTable so that only the Family category is shown. Share and Analyze Data Faster Use Excel 2010 as your Business Intelligence tool. New features like Sparklines and Data Bars help you present and compare trends in seconds. Whether sorting through sales revenue results or your favorite team s last few seasons these new tools in Excel 2010 help you make your data relevant. Step by Step Sparklines Step by Step Data Bars 1. On the Insert tab in the Ribbon in the Sparklines group click the type of Sparkline you want to insert such as Line Column or Win Loss. 2. In the Create Sparklines dialog box define your Data Range and Location Range and then click OK. 1. Select the cells you want to format. 2. On the Home tab in the Styles Group click Conditional Formatting click Data Bars and then click More Rules. 3. Set your rule and formatting options using the dialogue. To create Data Bars for negative values as well proceed as above
