Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
Are you looking for the “peanut butter and chocolate” of workplace efficiency: how to combine the power of Macros with the convenience of search? As of Office 2013, Excel does not provide an easy way to include a variable search term in the execution of a series of tasks recorded in a macro. By easy,…
Read More
Just as some employees negotiate for more continuing education opportunities through their employer, employees in those industries that require continuing education credit often grumble and complain. Instead of grousing, here are some tips to get the most out of those CPE credits and maybe even make them a little more fun.
In today’s competitive environment, businesses in all industries across the U.S., but especially in Tech and Healthcare, are looking for ways to recruit and retain employee talent. It may be a surprise to you that as many as 95 percent of businesses offer financial support for employee education as an employee benefit. Unfortunately, according to…
Read More
In November of last year, Fortune magazine reported that unfilled job openings at U.S. businesses create an economic cost of roughly $160 billion a year.[1] Yes, that’s with a B. The article attributes a part of this due to decreased production when positions remain unfilled. For example, when an open sales position exists a business…
Read More
Microsoft opened the door additional functionality through apps in Office 2013. If you want to create visual impact for your data in charts and graphics, there are numerous apps or add-ins to meet your need. For more on add-ins, check out our post: Three Excel Chart Add-Ins to Create Unique Charts and Graphics.
Once you’ve harnessed the power of PivotTables, you probably find yourself looking for ways to use them all the time. The same is true of macros – convenient shortcuts that make your life easier! But have you tried to combine the two? Unless you are turning the exact same format and type of data into…
Read More
One of the most powerful advantages of a chart is its ability to show comparisons between data series, but you’ll need to spend a little time thinking about what you want to show and how to organize it for excellent communication. Let’s look at the ways that Excel can display multiple series of data to…
Read More
Professionals who are used to organizing their lives in Excel at some point wish Excel could include a timer to help keep track of common tasks. Tasks like tracking time spent on specific projects or monitoring hourly rate. A quick look, however, reveals that – unless you are an accomplished VBA programmer – Excel does…
Read More
There’s no debating that Excel is a powerful, useful tool for gathering, analyzing and communicating all kinds of data. But even the biggest fan sometimes wishes for just a little bit more, especially when you want to create visual impact for your data in charts and graphics. Microsoft opened the door for developers and third…
Read More
It would be nice if all data was perfect, absolute and complete. But when it isn’t, Excel gives us some useful tools to convey margins of error and standard deviations. If you work in a field that needs to reflect an accurate range of data error, then follow the steps below to add Error Bars…
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 8,500+ 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.
