# Monthly Archives: July 2014

### Ease the Pain of Data Entry with an Excel Forms Template

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…

### Avoid the Five Big Mistakes that Medical Practices Make When Marketing

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…

### Improve the Patient Experience through Technology

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…

### Healing with HEARTS

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.

### Excel Formulas Not Calculating? How to Fix it Fast

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

### How it works – Meet the Excel Concatenate Function

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.

#### PRYOR+ 7-DAY FREE TRIAL

Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.