# Blog Feed

## How to Use the IF Formula in Excel, Part 1

Sometimes you need your data to tell you more. The IF formula as a function gives your data a voice and turns 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.…

## Excel PivotTable Percentage: Which Customers Are Costing You A Fortune?

Let's suppose you have sales by state, and each state belongs to a sales region. What percentage of your sales come from each region? First, Set Up Your PivotTable 1. Align your data in a table format, as shown here. Type "State," "Region," and "Sales" in row A. 2. Drag…

## Quick Tips for Calculating Percentages In Excel

Here are some techniques for calculating percentages. For these examples, we have a simple sheet of travel expenses and you are after the percentage results of prices going up or down for the total and for the individual months. Percent increase Let’s say you anticipate more travel the following year…

Ongoing training results in engaged, flexible, and high-performing employees. The most successful organizations keep up-to-date on the latest software trends with robust education and development initiatives. The Disengaged Employee: Disengaged employees negatively impact the bottom line by generating less work and therefore less revenue than their engaged counterparts. Employee disengagement…

## Computer Safety Awareness: 5 Issues You Don’t Think About

Organizations take many precautions to keep their data and systems safe and secure. Unfortunately, no number of firewalls protects your data from this potentially disastrous threat. Increase your staff's awareness and turn security leaks into additional protection. Security Concerns Metadata. As you may or may not be aware, your documents store…

## Computers in the Workplace: Mandatory Business Skills

If you are a business professional today, you are working with computers to be as efficient as possible. Businesses benefit from efficient use of technology. You and your fellow employees must be well-versed and well-trained on pertinent hardware and software to be efficient, solve problems and generate ROI. Computers =…

## How to Calculate Percentage of Total in Excel

The Ins and Outs of Excel Percentage Formula

## Create a Gantt Chart in Excel

If you do any project management, you’ll eventually need to (or be asked to) create a Gantt chart

## The Power of Excel Array Formulas Part II

Use an array formula to attach an IF to a function that doesn’t have one