### How to Calculate Median in an Excel PivotTable – Almost!

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…

### Thoughts about Finding Work-Life Balance

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.”

### Strategies for Balancing Work and Life

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 Benefits of Work-Life Balance

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.

### How to Use an Excel IF Function

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…

### How to Create PivotTables Using the Quick Analysis Tool in Excel

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…

### The Right Way to Create an Excel Rolling Chart

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…

### Five Principles of Goal Setting Theory

Most westerners believe you can achieve more by setting goals. But why is this such an accepted practice?

### Goal Setting Quotes Throughout History

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…

### The Importance of Writing Down Goals

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…

#### PRYOR+ 7-DAYS OF FREE TRAINING

Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.