Blog Feed
June is National Safety Month
It was a beautiful Saturday spring day and Stanley decided to do some tree trimming around the house. This was the first weekend he had off for several months and it felt good to be working in the yard. Not only that, he didn’t have his supervisor breathing down his…
Read More
How to Create a Custom Function in Excel
Excel functions are actually shortcuts to more complex calculations. Like a macro is to a series of steps, a function is to a longer equation. While Excel is packed full of functions, you may find that you have proprietary formulas that you use regularly that would be useful as a…
Read More
Using Excel Conditional Formatting Based on Another Column or Cell
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…
Read More
Using Conditional Formatting: If Statements 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…
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…
Read More
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