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
March 29, 2017
Categories: Business Training Center, HR Corner, HR Training
Tags: volunteers
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 could take different shifts.” “Maybe…
Read More
March 29, 2017
Categories: Business Training Center, HR Corner, HR Training
Tags: employee termination
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 to help make sure you…
Read More
March 29, 2017
Categories: Business Training Center, HR Corner, HR Training
Tags: paid leave
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 of FMLA pay. That’s a…
Read More
March 28, 2017
Categories: Professional Development
Tags: team building, team building games, teambuilding, teambuilding games
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. There are many team-building activities…
Read More
March 28, 2017
Categories: Professional Development
Tags: corporate team-building activities, corporate teambuilding activities, team building, team-building excercises, teambuilding, teambuilding exercises
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
March 28, 2017
Categories: Professional Development
Tags: team building, team-building activities, team-building activity, team-building activity for adults, teambuilding, teambuilding activities, teambuilding activity, teambuilding activity for adults
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
March 23, 2017
Categories: Excel®
Tags: data validation
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 entered does not match your…
Read More
March 16, 2017
Categories: Conditional Formatting, Excel®
Tags: apply conditional formatting, data bars, graphics
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
March 9, 2017
Categories: Excel®, Sparklines
Tags: 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 you have saved. Change Value…
Read More
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 11+ million learners and 300,000+ businesses achieve meaningful and lasting success. Pryor Learning delivers 17,000+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access 12,000+ live seminars across the U.S. and Canada and more than 5,000 online courses within our mobile-friendly learning platform, or purchase eLibrary content to import into an existing LMS. With Pryor, gain access to more than 40 years of curated and professionally accredited content in a cloud-based learning environment that doesn’t obligate special IT requirements, pricey budgets or complicated timelines. You’re fully operational in as little as three days and only three clicks away from unlimited learning options for you and your team.
Enter Express Code
Enter Express Code