Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
If you have two data series that are related, but not comparable, it might be tough to chart it. For example, let’s say you have data representing the sales of products. You also have the production costs. When you subtract the production cost from the sales data, you get the gross profit. Divide this remainder…
Read More
You might think you need some fancy add-ins to create charts that look like a speedometer. In this tutorial, you’ll learn how to create this snazzy image from a pie chart and a doughnut chart. Download CreatingGaugeChart.xlsx to follow along. The Steps Create the data for the speedometer. If a circle is 360 degrees, then…
Read More
Does your organization currently have a written FMLA policy? In the short video below, Lisa Smith discusses the Department of Labor’s new FMLA requirement. Transcript Well, it looks like the DOL is at it again. In June of 2016 the Department of Labor released a 76 page guide regarding the FMLA– Family and Medical Leave…
Read More
The best team building activities allow people to have fun, while also creating something that will be useful to the team in the future. In this post, we share some small group activities to share with your customer service teams. First, form small groups of people that provide similar types of customer service: 4-5 people in…
Read More
In this post, we offer an idea for a customer service call center exercise with groups of 10-60 people — you need a large space, chart paper and markers. The goal is to allow people to share their customer service experiences — and fears — in a safe supportive forum. First, tape chart paper on…
Read More
Everyone likes to feel noticed and appreciated — and for staff working on the front lines with customers, a small reward or gift for the work they do can be particularly meaningful. I once worked with an employee-centered customer service manager who has a great set of small symbolic gifts and rewards — each embossed…
Read More
Whether for personal or business application, it’s a good idea to know how to calculate compound interest for loans and investments. There are two methods you can use, the long form and the FV (future value) function. Download ExcelCompoundInterest.xlsx to see the examples. Long Form In this first example, we’ll assume a one and a…
Read More
Accounting is more than just debits and credits. It is the calculation and analysis of those debits and credits that generate accounting information an organization can act upon. Let’s take a look at two types of reports a professional in the Accounting Department might be asked to generate. Then, we’ll see how that information can…
Read More
With the most recent versions of Excel, you have gained more and more functionality with Pivot Tables. It is now much easier to work with dates. There are two features that you can put to work right away: data filtering (2007) and timeline slicer (2013). There’s also a change to the way dates are displayed…
Read More
Given the number crunching power of Excel, you might surmise that when it comes to calculating money matters, it really shines. And, so it does. In order to understand how the various financial functions, work, there are a few components to understand. Most of the fifty-five functions that are classified as financial functions in Excel…
Read More
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 13+ million learners and 3+ million businesses achieve meaningful and lasting success. Pryor Learning delivers 8,500+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access live seminars 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 50 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.
