Monthly Archives: April 2016

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

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 that cater to young buyers….
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 media competitive analysis. Use a…
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. Fortunately, there is a social…
Read More

Save Time With Our 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 As you continue working in…
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

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 has several built in conditions…
Read More

Categories

Monthly Archives