Author Archives: Tepring Crocker

Five of the Best Online Project Management Tools

While it’s possible to guide projects with nothing more than whiteboards and email, most complex projects require software to track all the moving parts. In a dynamic work environment, online and cloud-based tools offer the most flexibility for the cost. There are hundreds of applications to choose from, but these five are among the most…
Read More

Conditional Formatting Across Multiple Cells in Excel

Steps in this article will apply to Excel 2007-2016. Images were taken using Excel 2016. Conditional formatting is a useful Excel feature that can help you quickly scan your data without resorting to complicated filtering or fussy charts. Often, you will use conditional formatting to call attention to cells that represent an outlying condition –…
Read More

Using If/Then in Conditional Formatting in Excel

*Steps in this article will apply to Excel 2007-2016. Images were taken using Excel 2016. If you are a fan of Excel’s conditional formatting feature, you probably find looking for even more and more ways to highlight useful information in your data. A question that often comes up among these “conditional formatting addicts” is Can…
Read More

Nesting Functions in Excel – A Tutorial for Beginners

Most of us begin using Excel by creating simple worksheets that organize data and perform simple calculations. Then, we might dabble with some of Excel’s many pre-set functions for more complex calculations. You know you’re a real Excel addict, however, when you start thinking How can I crunch my data even more efficiently? This means…
Read More

Excel Conditional Formatting: Date Data

Turning your cluttered spreadsheet of data into living, actionable information can be as simple as adding visual cues. Unless you are really good at doing date calculations in your head, conditional formatting is especially helpful when determining ages or anticipating birthdays and anniversaries. The following steps show how to perform a common Human Resources task:…
Read More

Get the Most Out of Excel’s Conditional Formatting

As a continuation of our post last week, we decided to expand on some great uses from conditional formatting. Highlighting negative values in red and using several built-in conditions is great when you are starting out, but you are not getting nearly enough bang for your buck! Here are three ways to get more out…
Read More

Categories

Monthly Archives