Sep 21, 2015
Being able to analyse all the data in your worksheet can help you make better business decisions. But sometimes it is hard to know where to start, especially when you have a lot of data. Excel can help you by recommending and then automatically creating PivotTables, which are a great way to summarise, analyse, explore, and present your data. Pivot Tables will allow the user to insert several fields in the Filters area. You can filter the Pivot Table by clicking on the arrow next to Company Name (All), ticking the Select Multiple Item options and selecting the companies you want to display in the filter. Once you filter the Pivot Table, the (All) option next to Company Name label changes to (Multiple Items). Unless you display the drop down list of all Company names, the user of the report does not know which company names are displayed in the report filter. You can insert a slicer for a quick and effective way to show the filtered data or to add/remove filter items quickly. To insert a slicer:- Go to PivotTable Tools Analyse tab
- Go to Filter group
- Click the Insert Slicer button
- Tick the Company Name option
- Click OK and the slicer displays.
- Right click on the slicer
- Click Size and Properties
- Expand Position and Layout option
- Under Layout heading, increase the Number of columns to 5
- Resize the slicer
How do your Excel skills stack up?
Test NowNext up:
- The best features in Office 2016!
- “If you can’t measure it…”
- No need for meeting notes anymore!
- Setting up your models in MVC
- Create a Chart Template in Excel
- Cascaded Dropdowns in Nintex Forms
- The Aussie Meat Pie of Managing Teams
- Introduction to Office 365 Video
- Entity Framework Code-First
- The awesomeness that is AngularJS – Part 1
Previously
- What’s a JavaScript Closure?
- Put that marker down and Redact in Acrobat please!
- Understanding your customers with 6 questions
- New security features in Windows 10
- All About VLOOKUP() in Excel
- Creating a layout for Word and Excel
- Implementing paging easily
- Leadership, Management and Feedback
- Do the Quick Step in Outlook
- OneDrive for Business Gets Some Major Enterprise Updates