Archive | Productivity

Word Page Formatting: Part 3 (Specific Page Setups for Sections – Controlling Orientation)

Controlling the orientation of specific pages is a frustrating thing to do if you do not know how to do it properly. A common user would only just navigate to the Page Layout tab and just change the orientation, but the result would change the orientation of the whole document, rather than the orientation of […]

Continue Reading 0

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

Powered by WordPress. Designed by WooThemes

Free WordPress Themes