Monthly Archives: March 2017

Insert Subtotals in Excel

Default Image

Subtotals are dynamic in that they adjust instantly based on filters. They are very useful when reviewing a table, as you can make small adjustments to see different perspectives on the information. Create a Subtotal Determine which column you want to subtotal. Sort the selected column (Column A in this example) so that the like…
Read More

Corporate Team-Building Activities

Corporate Team-Building Activities thumbnail

The best team-building exercises have a goal or purpose— one goal may be to provide a shared structured experience that allows team members to get to know each other better. Here are some ideas for team-building exercises that tend to achieve better team camaraderie. While this may take some planning, a shared volunteer experience supports…
Read More

Team-Building Activity: Playing the Cards

Team-Building Activity:  Playing the Cards thumbnail

Here’s a team-building activity for adults that is fun and generates valuable information at the team level.  It works for teams of 6 to 60+ and requires only a stack of index cards (at least 3 cards per person) and pens or markers. First, create small groups of 2 to 6 people, depending on group…
Read More

Use Graphics to Compare Cell Values in Excel

Default Image

Want a quick way to view and interpret data directly in the tables without resorting to graphs or charts? You can add color bars, icons or graphics that reflect the meaning of the data in each cell to get an “at a glance” view of your data. Conditional formatting means that the formatting applied to…
Read More

PRYOR+ 7-DAY FREE TRIAL


Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.

Categories