Posts Tagged 'Excel tips', page 21

How to group data in an Excel Pivot Table to help further summarize and analyze your data

When you're working with a PivotTable in Excel you may find that you have a lot of data in the table that needs to be summarized even further. This can be done by grouping the data and in this post I'll explain how to do this Continue reading

Interactive elements in Excel with Spin Buttons and Scroll Bars

Whenever your user has a discrete number of choices to make for inputting data into an Excel worksheet you can save time by automating how they enter this data. You can do this in a number of ways and one of them is to use a spin button or a scroll bar to do the work... Continue reading

Conditional formatting in Excel Pivot Tables

With the release of Excel 2007, Microsoft provided some additional conditional formatting options such as data bars and icon sets which makes it easy to apply formats to cells to show visually the relative values in those cells. Microsoft also changed how conditional formatting is applied to PivotTables which gives you a greater flexibility when using conditional formats with data summarized in a PivotTable... Continue reading

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21