Blog Feed
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…
Read More
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…
Read More
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…
Read More
Five Principles of Goal Setting Theory
Most westerners believe you can achieve more by setting goals. But why is this such an accepted practice? Psychologist Edwin A. Locke and his colleague, Dr. Gary Latham, are credited with popularizing the modern concept of strategic goal making. Their work, research that spanned 25 years, confirmed the ancient notion…
Read More
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…
Read More
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…
Read More
COUNTIFS – Excel’s COUNTIF for Multiple Criteria
As Excel users, we're never satisfied! We see a powerful function like COUNTIF that gives us the ability to find and tally data based on a huge assortment of specified criteria and we still want more. Namely, the ability to count our data based on multiple criteria specifications. COUNTIF a…
Read More
How to Make a Radar Chart in Excel
Pie charts, bar charts and line charts are familiar friends to Excel users. But there's a less well-known chart out there that can pack a lot of information into a single, visually powerful image. The Radar Chart, also sometimes called a spider or star chart, lets you compare multiple items…
Read More
Export Excel Charts to Word and PowerPoint Using Copy/Paste
Once you have spent the time crunching numbers and creating a beautiful chart in Excel, you'll probably find that you want to use it again and again in reports and presentations. Microsoft makes it easy to share objects between its Office programs, but few methods are easier than Copy/Paste. We…
Read More
Mandatory Paid Sick Leave for Federal Contractors
Federal Contractors awoke to a Labor Day game-changer. President Obama signed an Executive Order on September 7, 2015, mandating paid sick leave for employees working on federal contracts. This new mandate affects all federal contracts beginning in 2017. Adding up the numbers, it seems that a worker will accrue one…
Read More