Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
While there is no “Excel multiply formula” there are multiple ways to multiply in Excel. For instance, do you use an asterisk (*) to multiply, but hit a brick wall when you apply other arithmetic operators? What about shortcuts for multiplying many numbers in one step? Read on for three powerful ways to perform an…
Read More
Have you ever needed to present a chart that displays component data that roll up to a total? If all of the values are positive, Excel’s stacked column chart works beautifully; but it breaks down when your data includes both positive and negative values. The answer is an Excel waterfall chart! A waterfall chart solves…
Read More
Excel makes it easy to work with data tables, but first you must get that data into tables. Keying data into a spreadsheet and moving the cursor after each entry can be frustrating at best; at worst, it can leave you with mangled data in an unusable format. Fortunately, Excel provides data entry forms to…
Read More
Marketing Your Medical Practice Accessing information on the internet has become a much larger component for people gathering health information and deciding where they want to access healthcare. In a recent Pew research study, 72 percent of internet users have said they looked online for health information in the last year. Of those who had…
Read More
Improve the Patient Experience Whether you need a simple checkup or are having a major procedure, venturing into a doctor’s office, clinic, surgery center or hospital can be an intimidating, worrisome and even frightening. One of the greatest challenges faced by medical and support staff is how to ease patient concerns and make them feel…
Read More
Dealing with Difficult Patients and their Caregivers Dealing with patients and their caregivers is the reason most of us got into healthcare in the first place, but they are also potentially the most challenging aspects of any given work day. A number of factors can contribute to a patient or accompanying loved one becoming difficult.
You’ve created the reports for your management meeting, and, just before you print copies for the executives, you discover that the totals are all showing last month’s values. How do you fix it—fast? 1. Check for Automatic Recalculation On the Formulas ribbon, look to the far right and click Calculation Options. On the dropdown list,…
Read More
The CONCATENATE function joins two or more text strings together into one string. For example, if you have the customer’s first name in Column A and the last name in Column B, you could use “=CONCATENATE(A3,“ ”,B3)” to produce a string containing first name and last name.
Have you ever copied a formula to another tab in your workbook, and the result was not at all what you expected? Moved a formula to a new location and were surprised that it didn’t change?
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 9,000+ 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.
