Blog Feed
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
IRS Issues Proposed Rule Clarifying Laws Regarding Same Sex Marriage
Employers! You no longer need to hold your breath hoping you are “doing it right” regarding same sex marriage equality laws. On October 23, 2015, the question of how employers and other entities must handle the definition of marriage for IRS tax purposes was answered in the IRS proposed rule regarding implementation…
Read More
Is Overtime Pay for Exempt Employees Really Becoming Law?
Well, not actual overtime pay for exempt employees. But, it will feel that way when your overtime exempt workers hear this: “You may be getting a pay raise if you make less than $50,440 a year (before taxes)!” Wait, what? About 15 million salaried overtime exempt employees who have earned about…
Read More
Excel Black Friday Shopping List Template
This template was created so you can have the best game plan when going into Black Friday. It can be used for new or seasoned Black Friday shoppers. Here is how the table works: Column A has your date/time. Be sure to enter AM or PM so that when you…
Read More
How to Use Slicers in Excel 2010 and 2013
Excel's Slicer Filter was added in Excel 2010 and enhanced in Excel 2013. This useful feature is excellent for viewing and comparing varied combinations of your data with a simple click. Something like a cross between a button and a filter, Slicers have become a prized tool for analyzing large…
Read More
Intro to the COUNTIF Function in Excel
Much of spreadsheet data is a collection of individual transactions or instances that don't begin to offer meaning until they are organized and summarized in useful ways. Enter Excel's handy COUNTIF function. When categories of data are mixed together, or if you wish to understand your data based on certain…
Read More
The Pivot Table and Percentage of Total Calculations
Once you learn how to create an Excel PivotTable, you'll discover that organizing your information is only the first step in getting the most out of this useful feature. PivotTables then give you the ability to further manipulate the organized information. Value Field Settings let you perform different types of…
Read More