Excel Weekly News from Contextures August 12, 2014
Top 5 for Date Range + more Excel tips
During the summer, I am sending you the newsletter twice each month, instead of weekly. You will get the next newsletter on August 26th. In this week's Excel news, you'll see how to see the top or bottom records in a pivot table, and other tips. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.
- Debra - firstname.lastname@example.org
Use an Advanced Filter to find the top 5 orders, for products sold after a specific date. Just enter a few formulas at the top of the worksheet, then run the filter. One advantage of using an Advanced Filter is that you can show the results in place, or send the list to a different worksheet.
Click here to see the details, and download the sample file: Top 5 Items in Advanced Filter List
Use a pivot table's Top 10 filter to show best-selling products. Then, change the filter, to see how many of the low selling products it takes to equal the sales of the top 3 products.
Click here to read the details: Compare Top and Bottom Products
Here are a few of the Excel articles that I read last week, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
If you create an Excel chart, then hide rows or columns in your worksheet, the hidden data might also disappear from your chart. By default, Excel charts do not display the data in hidden rows and columns. This video shows how to change an Excel chart's settings, so the hidden data will appear in the chart.
The weather was perfect last Thursday, so I took the day off, and went to a local farm, for some fun in the sun. They grow and sell crops on this farm, and there is also a play area, for the children. Just inside the gates, there was a row of sunflowers, and I snapped a photo of one plant, just as a bee was flying in. I'm glad that bee was working hard, while I was playing!
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.