Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.
A frequent question that comes up when working with Excel PivotTables is how to calculate median using the table’s filters and analysis. The short answer is “Excel doesn’t do that”. Meaning, there isn’t a simple way to change the Value Field Settings to calculate “Median”. The closest you can get is “Average”. However, averages aren’t…
Read More
The idea of work-life balance can be controversial. Some successful people say that it’s nearly impossible to achieve a real balance between one’s career and one’s personal life. Others use some variation of the tired phrase, “Work to live, don’t live to work.”
At the beginning of a new year, you’ve probably been hearing a lot about work-life balance. You may find yourself asking: How am I supposed to achieve this balance? There are so many suggestions out there that it can be difficult to decide what advice to follow.
The modern office can be hectic. New projects, deadlines and new crises can result in long hours at work. Worse, smartphones enable our jobs to spill over into our homes, allowing emails and messages to demand our attention at all hours.
Sometimes you need your data to tell you more about itself. The versatile IF function is how you can turn raw numbers into useful information. For example: Your wholesale company charges different rates depending on the size of bulk orders – customers who order more receive volume discounts. You want a way to quickly calculate…
Read More
Storing information is only part of the useful things Excel spreadsheets can do. Once you have collected a set of data, Excel can help you organize it and analyze it. One of the most powerful tools for analysis is the PivotTable. PivotTables do more than generate graphs out of one or two data points. When…
Read More
Creating reports on a regular schedule is a common task for the business Excel user. When you need to create a Rolling chart that reflects data in a specific timeframe – such as the previous 12 months – you can quickly find yourself in a maintenance nightmare, updating your charts manually to include the new…
Read More
Most westerners believe you can achieve more by setting goals. But why is this such an accepted practice?
January is a time when many of us take a breath and collectively endure the ritual of setting goals for the coming year. The custom is commonly regarded as a positive tradition and either taken for granted or at least in good humor. But where does the idea of setting goals come from in the…
Read More
If you have spent any time in corporate life you are probably familiar with the concepts of goal setting, S.M.A.R.T. goals and so on. While you may know that those who engage in a deliberate process of identifying and setting goals are more successful overall than those who don’t, you may not know is that…
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.
