Blog Feed

Using Excel Conditional Formatting Based on Date

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…
Read More

No-Hype Social Media for Business: LinkedIn™

As a small business or B2B owner when you look at a typical social media rah-rah article you probably come away wondering what all the hype is about. Most of it doesn’t seem to apply to you. This happens because the early drivers of social media marketing were B2C companies…
Read More

Social Media Competitive Analysis

There are several reasons you might be looking at your competitor’s social media performance: To evaluate whether to begin a social media campaign of your own, to keep tabs on them, to research ideas and so on. Below are some of our favorite tools and tips for performing a social…
Read More

No-Hype Social Media for B2Bs: Content Marketing

The explosion of social media marketing was initially driven when direct-to-consumer businesses saw new, rich platforms for reaching highly segmented audiences. Business-to-business companies have been far more skeptical and slower to adapt to social media as a way to reach customers. While avoiding hype is prudent, getting left behind isn’t.…
Read More

Time-Saving Excel Formulas Cheat Sheet

Syntax, Operators and Functions…Oh My! Do you speak Excel? Are you just starting out and trying to remember the go-to lingo? Well, today’s blog post is a snapshot of helpful cheat sheet material to help you build your Excel skills. Advanced Filter Criteria Popular Excel Functions and Descriptions Next Steps…
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…
Read More

Highlight Valuable Data With Excel Conditional Formulas

You can conditionally format your data in order to draw attention to outliers and quickly assess how significant your data points are. Conditional formatting can be used to highlight interesting cells, emphasize unusual values, and visualize data using data bars, color scales, and icon sets based on specific criteria. Excel…
Read More