Excel Weekly News from Contextures Oct 22, 2013
Count items in a date range + more Excel tips
In this week's Excel news, you'll see how to count items in a date range, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
With the COUNTIFS function (Excel 2007 and later), you can get Excel to count how many dates are in a specific date range. For example, how many Pencil shipments went out in September, based on dates in the Ship Date column?
Click here to see the details: Count Items in a Date Range in Excel
You can use the GETPIVOTDATA formula to pull specific data from a pivot table. To make the formula flexible, change items names to cell references, so it's easy to see a different result.
You'll get an error result if you try to use a cell reference for a Value field though, unless you use this little trick.
Click here to see the details: Refer to Value Cells in GetPivotData Formula
When you're working in Excel, sometimes you get data from another department, and some columns have blank cells, so headings are easier to read. If you want to sort or filter the list, you need to fill in the blanks, by copying the value from above.
You can fill the blanks with a few quick steps, and see the steps in the video on my blog.
Click here to see the details: Fill Blank Cells With Value from Above
Here are a few more Excel articles that I read this week, that you might find useful:
With conditional formatting, you can highlight all the rows that have weekend dates, in a list on the worksheet. Watch this short video to see the steps for setting this up.
Registration ends this week, for the Excel Dashboard Course by Mynda Treacy from My Online Training Hub. Sign up by October 31st, so you don't miss out on this excellent course.
I've been through this course, and highly recommend it. The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there's even an option to download the videos.
Bonus: If you sign up for Mynda's course through one of my links, I'll send you a copy of my new Excel add-in -- Contextures Excel Tools -- when it's ready next month. (If you signed up for one of Mynda's earlier courses through my link, send me an email if you'd like a copy of the new add-in.)
The trees don't look quite a lovely these days, but there is a colourful carpet on the forest floor. I took this picture on the weekend, and things were still quite damp, after the rain fell the day before.
In addition to all the free
Excel tips and tutorials, there are other Excel tools that you can
invest in. To learn more about the products listed below, click
on the links to take a look at their features, and decide if they're
right for you.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.