# Monthly Archives: January 2016

### 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…

#### PRYOR+ 7-DAY FREE TRIAL

Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.