Monthly Archives: November 2014

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 process is operating within its…
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 resolutions being get a promotion/new…
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 while you search. Fortunately, this…
Read More