Archive | Productivity

Word Page Formatting: Part 4 (Specific Page Setups for Sections – Controlling Margins)

Controlling the margins of specific pages is not really a major aspect in page formatting. Even though you can set specific margins for different pages, it is not important and sometimes useless because most documents you would want would require a consistent margin size. However, I will still show you how to adjust the margins […]

Continue Reading 0

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

Powered by WordPress. Designed by WooThemes

Free WordPress Themes