Blog Feed
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
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
How to Transfer Data from Excel to Word Automatically
Excel lives up to its name when crunching numbers or organizing data. However, when you want to convey ideas beyond the table or graph, you will almost certainly turn to Word or PowerPoint. In the examples below, we are going to look at several different ways you can export, or…
Read More
Financial Processes for Success
Would you drive your car on the interstate without a speedometer, gas gauge or a clear windshield? Reviewing your monthly financial statements to understand your organization’s financial health is like watching the gauges to ensure you are staying on track. So, how do you do it? Keeping a financial grip…
Read More