Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
Spreadsheets are great for managing large amounts of information and deriving new insights from data, but they can be difficult to comprehend at a glance. When you need to share information with non-technical colleagues or want to visualize your data, an excel color formula can be your best friend. Your excel color formula will use…
Read More
If you’re looking for a modern way to visualize your data, check out the Excel dial chart. Dial charts are a natural fit for dashboard-style interfaces and are also referred to as speedometer charts because of the visual similarity to a car’s speedometer. Dial charts work well for indicating performance or completion thresholds.
There are several Excel functions that will help you round numbers to the appropriate format. You can create formulas using these functions to get your data looking the way you want it. An Excel rounding formula allows for rounding to a specific number of decimal places, the nearest even or odd number, or the nearest…
Read More
There might be times when you do not want Excel to adjust all or part of your formula automatically. For example, you may have a table of standard multipliers that you use in the formula and want the same cell to always be used to multiply. The answer: an absolute reference. You can create an…
Read More
While you can’t praise too often, you can praise badly. This is the premise of a recent white paper titled, “The Manager’s Field Guide to Recognition”[1]. For some managers, employee recognition comes naturally. For others – perhaps even most – creating a system for effective feedback can seem time-consuming and uncomfortable. Understanding best practices of…
Read More
The benefits of a happy workforce are compelling: improved retention, increased productivity, reduced absenteeism. A survey by the employee recognition consulting company, Globoforce®, indicates that happy employees are 85% more efficient and 10 times less likely to take sick leave. Globoforce also discovered that peer recognition is a powerful motivator with employees 107% more likely…
Read More
When you manage employees you may find yourself using words like “Employee Engagement” and “Company Culture”. Employee Recognition Programs may be on your radar as an effective tool for impacting both engagement and employee satisfaction. A survey published by the Society for Human Resource Management (SHRM) and Globoforce®[1], suggests that praise alone is not nearly…
Read More
Problem: You have a standard salary multiplier for overtime hours that you want to calculate the same way every time. The formula you generate needs to appear along an entire row of data, and across several worksheets, but you don’t want to type it out each time. Solution: Copy your formula to multiple cells instead…
Read More
Problem: You have data with thousands of donors and their annual gifts listed. The PivotTable you are using still doesn’t help you see which donors gave the most or how many donors gave you donations at various giving tiers.
The end of the first quarter traditionally shows high hiring rates. Whether you are starting a new job this month, or just looking to “March Forth on March Fourth” in your current position, here are some tips from business leaders and coaches to help you put your best foot forward.
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.
