Blog Feed

Calculate Range in Excel: 3 Easy Formulas

An essential skill any Excel user should know is how to determine the range of values in Excel. Most businesses don't have time to waste sorting through rows and rows in Excel in order to find the highest and lowest values of revenue, sales, or other information. The difference between…
Read More

Compound Annual Growth Rate: Comparing Investments with the Excel CAGR Formula

Does your company offer several types of IRA accounts? Are you unsure of your current IRA strategy? How do you know if the choices you make for your future are the best available to you? Say you review your IRA returns and consider changing your mix of investments. Five years…
Read More

Simple and Foolproof Customer Service Employee Engagement Analysis

Employee engagement is a big-time buzzword right now.  Statistics show how important it is for employees to be engaged. They also show how much productivity, profitability and customer satisfaction boom when engagement is high and bust when it’s low. Experts, surveys, calculators and apps in hand, are ready to tell…
Read More

Six Steps to Pumping Up Your Customer Service Team

Customers. Depending on the kind of day you’re having, that word can either bring a smile to your face and a song to your lips or send you scuttling under your desk to whimper and rock back and forth muttering incoherently about someone named “Angry Edith” and her profane cockatoo,…
Read More

Three Ways Technology Boosts Customer Satisfaction

There’s a tendency to think of customer service as a people-centric service – and rightly so. Our customers are people, and customers like human interaction. Customers even often prefer in-person or over-the phone conversations with a real person to resolve customer service issues1. That does not mean, though, that technology…
Read More

Excel Lookup Formula to Create Combined Tables

Lookup functions (VLOOKUP and HLOOKUP) are among the most useful Excel functions to pull data from multiple column-/row-sorted lists into a unified table. Think of it this way, these functions ask a simple question and return the answer. Question: is the data from a specific cell reference in this column…
Read More

Excel Formula Not Calculating?

As committed Excel users, we often go on and on about it as a productivity solution and essential program powerhouse. But catch us on a bad day and we are cursing that little green arrow and #VALUE! error like nobody’s business! Have you ever poured time into a worksheet, only…
Read More

How to Make a Pareto Chart in Excel

The Pareto Principle, named for Italian economist Vilfredo Pareto, suggests that 80% of problems can be traced to as few as 20% of root causes.  This can be valuable, even vital information when you are trying to figure out which of many problems to tackle first, or in a complicated…
Read More

Feed Your Brain, Increase Your Opportunities

There’s an old myth that seems impossible to kill – that we only use ten percent of our brains. Popular culture perpetuates this misunderstanding. The new film, Lucy, featuring Scarlett Johansson as a woman who, through scientific accident, harnesses her brain’s full capacity, is the latest portrayal of the mind’s…
Read More

The Forgotten (or Missing) Element to Achieving Goals

Is it just me or does it seem like everyone talks about setting goals, yet only a handful seem to accomplish their goals?  I've learned about setting goals since elementary school, so I’m pretty good at writing my goals, but only after employing techniques that helped me accomplish my goals…
Read More
< >