Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
*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
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
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
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
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
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
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
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
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
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 incorporate, spreadsheets into your Word…
Read More
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 13+ million learners and 3+ million businesses achieve meaningful and lasting success. Pryor Learning delivers 9,000+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access live seminars and more than 5,000 online courses within our mobile-friendly learning platform, or purchase eLibrary content to import into an existing LMS. With Pryor, gain access to more than 50 years of curated and professionally accredited content in a cloud-based learning environment that doesn’t obligate special IT requirements, pricey budgets or complicated timelines. You’re fully operational in as little as three days and only three clicks away from unlimited learning options for you and your team.
