People often ask, “If I could learn just one skill in each of the top MS Office programs (Excel, PowerPoint and Word), what should it be?” Here’s what we suggest:
Pivot Tables. Data by itself isn’t valuable. The value comes from taking the data and extracting it into easy-to-digest analyses that are dynamic and actionable. The analyses must “flex” as the data changes to account for both updating data and new types of data, so the results themselves can drive decisions. The first sounds complicated and the latter sounds risky.
If the data are accurate and come from a reliable source, you can rely on the aggregation done in Pivot Tables. Be sure to start with a well-built data source. That means no rows or columns that are completely blank, descriptive column headers and consistent data types within the columns. To find the Pivot Table button, go to the Insert tab and click in the Tables group.
Styles. Choosing a s...(register to read more)