Blog Feed

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

Excel Formula References: Why Copying Formulas Sometimes Goes Wrong

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? References in Excel work just as you would expect in most situations; but to…
Read More

5 Tips & Tricks for Better Time Management and Multitasking

Go faster! Work harder! Get more done in less time! MULTITASK! Sound familiar? Everyone’s trying to find the secret formula for cramming as much work as possible into every workday. Too often, though, the result of our super-scheduled, overly tight timelines is that we obsess over double-, triple- or quadruple-tasking…
Read More
< >