Blog Feed

Insert Subtotals in Excel

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…
Read More

Is the Use of Volunteers Legal or Not Under FLSA? (Video)

Transcript Have you ever had a fundraiser or a special event? Maybe you're going to set up a table at the county fair and exhibit your business and answer questions and collect leads. And you think, "If I just had a few employees kind of come in and help, they…
Read More

Employee Termination: 3 Tips for Success (Video)

Transcript Terminating employees is never an easy chore. It can be a land mine field full of little errors and mistakes and missteps just waiting to blow up. So what is a manager to do? When it comes time to terminate, there are three pretty solid things you can do…
Read More

Do You Provide Paid Leave? (Video)

Transcript Are you providing paid sick leave to your workers? Well, if you're not, it might be something to consider-- at least on a small level. Many studies have shown that more and more employers are offering paid sick leave. Very often, this is in the format of 12 weeks…
Read More

Finding the Meaning Behind Team-Building

Much is said about the benefits of team-building, but how do we do it in a way that doesn’t just feel like adult games at work? First, it is important to have a “why” behind the games—a larger learning point or goal that adults can get behind. Here’s an example.…
Read More

Corporate Team-Building Activities

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,…
Read More

Team-Building Activity: Playing the Cards

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…
Read More

Excel Data Validation: Check Formatting of Entered Data

Excel allows you to set certain cells to accept only a certain data format that you specify. You can prompt the user with guidelines about the proper way to enter their data. You can even specify that data must fall in a certain data range if you wish. When data…
Read More

Use Graphics to Compare Cell Values in Excel

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…
Read More

3 Easy Ways to Customize Excel Sparklines

After your sparklines have been created, Excel offers several tools for you to control which value points are shown, set options on the vertical axis, and define how empty values are displayed. You can also change colors, apply styles from Office’s pre-loaded style gallery or apply a custom style that…
Read More