Blog Feed

Create an Excel Control Chart to Analyze Data

In this article, we'll show you how to construct an Excel control chart to analyze data and improve efficiency. Control charts are useful for monitoring any process that has a level of variation - for example, filling containers with a certain number of items. They can easily illustrate whether your…
Read More

What’s Holding You Back?

The popularity of Raphael Cushnir’s book, The One Thing Holding You Back[1] is built on an interesting premise: fix this “one thing” about you and the rest of your life will fall into place. It’s an appealing notion. In Cushnir’s book, that “one thing” is Emotional Connection. Whether you agree…
Read More

Don’t Make Goals, Make Resolutions

Every New Year’s Day, nearly half of Americans participate in the tradition of promising to better themselves in the upcoming year. Most of these improvements will be personal: lose weight, spend less and get organized were the top three resolutions of 2014.[1] Career-related ambitions follow a similar pattern with popular…
Read More

How Did I Get Here?

Once in a Lifetime – Talking Heads [1] “And you may find yourself living in a shotgun shack And you may find yourself in another part of the world And you may find yourself behind the wheel of a large automobile And you may find yourself in a beautiful house,…
Read More

Present Value of Annuity Formulas in Excel

For anyone working in finance or banking, the time value of money is one topic that you should be fluent in. Knowing exactly what it means to discount something or to get the future value of a particular investment vehicle is necessary to do the job. Excel can be an…
Read More

How to Link with Excel Hyperlink Formula

When using Excel, do you ever need to quickly access information stored elsewhere-- the internet or your company's intranet, for example? Taking the time to find these files outside of Excel can waste valuable time, especially if you get lost navigating away from your spreadsheet and forget the information’s context…
Read More