I need to be able to let users input date ranges on an excel pivot table that I am designing. I have attached a snapshot of the test data. What I want is an excel formula that will for example allow users to input a date range of say December or any month within the period column, if a user inputs a date range,excel should summarize the year to date and month to date for each of the categories.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…