I am trying to group a pivot table by the date rang the 22nd to the 21st example...
Dec 22 – Jan 21 = Jan 2015
Jan 22 – Feb 21 = Feb 2015
Feb 22 – Mar 21 = Mar 2015
Mar 22 – Apr 21 = Apr 2015
Apr 22 – May 21 = May 2015
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as t…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.