Blog Feed

External Reference Links: Link Excel Worksheets Together

Worksheets can be linked so that information shared between the two is always identical. This reduces errors and ensures consistency as information only needs to be entered in one place to be available in multiple locations. In our example today, data is gathered and duplicated between employees and departments. One…
Read More

Trace Precedents in Excel: Find Formulas, Functions and Cells Connected to a Cell

Have you ever inherited a worksheet that someone else set up or you created and haven’t played in for some time? If you need to update the formulas and functions, but do not know what other calculations will be affected you could quickly make a lot of work for yourself!…
Read More

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
< >