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
Count Items in a Date Range in Excel
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
Refer to Value Cells in GetPivotData Formula
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
Fill Blank Cells With Value from Above
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
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- Occasionally, a few of the old Excel functions are superseded by new version of those functions. On his Excel User blog, Charley Kyd takes a look at these deprecated functions, and what has replaced them.
- On the Microsoft Excel team blog, Kevin Donovan shows how to create a pivot chart from external data in Excel 2013, without also creating a pivot table.
- For a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- If you create histograms, Jon Peltier shares his technique for creating a value-type horizontal axis.
Video: Highlight Weekend Dates
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.
Excel Dashboard Course Deadline
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.)
Carpet of Leaves
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.
Recommended Excel Tools
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.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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.