Blog Feed

Help, I’m Stuck in a Rut: Planning for Change

You feel stuck. Every day feels the same and you have a distinct impression that you’re not supposed to be here. You’re not quite sure how you got here and you’re worried that you’ll never break free from the dull routine that your life has become. Does this sound familiar?…
Read More

No Excel Multiplication Formula? 3 Ways to Multiply in Excel

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…
Read More

How to Hide Formulas in Excel and Protect Your Spreadsheet

Excel makes it easy to decipher why a formula produces its result. When you click on the cell, the formula is displayed in the formula bar. If that’s not enough, you can select the Formulas ribbon and click Evaluate Formulas for a step-by-step walkthrough. But what happens when you don’t…
Read More

Visually Display Composite Data — How to Create an Excel Waterfall Chart

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…
Read More

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…
Read More

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…
Read More

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…
Read More

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…
Read More

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…
Read More

What is the Excel Concatenate Function and How Does It Work?

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. Be aware that…
Read More
< >