Archive | Productivity

Mastering PivotTables: Part 13 (Timelines)

Timelines are similar to Slicers, except that it is only limited to showing data related to Dates. Timelines allows easier visualization of data in a set amount of time, and allows easier analysis of data. Open this document (same document as Slicer) or open any Excel document that has data related with Dates. Navigate to the […]

Continue Reading 0

Mastering PivotTables: Part 12 (Slicers)

One prominent problem with PivotTable report filters is the need to constantly open the drop-down list to see which multiple items are activated. A slicer can easily show you which items are active and inactive, making it easier to understand the data. Slicers can also allow you to easily filter the data in a PivotTable, […]

Continue Reading 0

Mastering PivotTables/Charts: Part 10 (Using Tables as Data Sources)

By turning a range of cells into an Excel table, you can make managing and analyzing a group of related data easier. A table typically contains related data in a series of rows and columns in a worksheet that have been formatted as a table. By using the table features, you can then manage the […]

Continue Reading 0

Mastering PivotTables/Charts: Part 9 (Dynamic Data Ranges)

In Excel, you may have a named range that must be extended to include new information. The only way to do this is to create a dynamic defined name for the data range. When defining the data range for a PivotTable without dynamic ranges, if the range expand or contracts, then the definition of the […]

Continue Reading 0

Mastering PivotTables/Charts: Part 8 (PivotCharts)

PivotCharts can be created from the PivotTable data, allowing you to create charts to visually represent your data. Using any documents, or the document attached, follow these steps. Ensure the data is collapsed to yearly data (this can be done by grouping the dates in years). Right-click in the grand total figures, and sort the […]

Continue Reading 0

Mastering PivotTables/Charts: Part 7 (Grouping)

Grouping in a PivotTable can help combine data in a more meaningful way, especially with dates. Sometimes, companies will have data for individual days which makes the data visually unappealing, and with grouping, you can group the date in Weeks, Months, Year, and so on. First of all, please use this document to make the […]

Continue Reading 0

Powered by WordPress. Designed by WooThemes

Free WordPress Themes