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