Search Contextures Sites
Custom Search


Newsletter Index



Get weekly Excel tips from Debra





Excel UserForms for Data Entry


30 Excel Functions in 30 Days


Contextures News

Excel Weekly News from Contextures Jan 14, 2014

Highlight upcoming dates + more Excel tips

In this week's Excel news, you'll see how to highlight upcoming dates, and other tips. Thank you for reading the Excel news!

 -  Debra

Highlight Upcoming Employee Service Anniversaries

You might need to keep track of upcoming anniversaries for employee hire dates, or birthdays, or other events. In Excel, you can use formulas to calculate when each date occurs in the current year, then highlight the upcoming dates with Excel conditional formatting.

Click here to see the details: Highlight Upcoming Employee Service Anniversaries

Dynamic Date Range Filters in Pivot Table

Date range filters, such as This Month, Next Week, or Between [date1] And [date2], aren't available in Excel pivot table Report Filters -- you'll only see those in the Row and Column filter drop downs.

However, you can use this workaround show a date range, without the date details.

Click here to see the details, and watch the video: Dynamic Date Range Filters in Pivot Table

More Excel Tips

Here are a few of the Excel articles that I read last week, that you might find useful:

  • On the Data Scopic blog, Oz du Soleil asks a few spreadsheet experts, where are Excel & Google Spreadsheet Headed? You can read Part 1 and Part 2
  • Mike Alexander shares a handy tip for copying just the data from a website into Excel, without all the hyperlinks, icons, and other junk.
  • Microsoft announced its Power BI pricing last week, and Chris Webb comments on the Power BI costs, and compares them with other BI tools.
  • Sign up for free Business Analytics webinars offered in the 24 Hour PASS series, sponsored by Microsoft, Cisco and Dell. Topics inlclude: "Advanced Analytics in Excel 2013", and "Querying in DAX". The online sessions run on Feb 5th and 6th.
  • And finally, for a humorous peek at what other people are saying about Excel, read the weekly collection of Excel tweets, on my Excel Theatre blog.

Video: Quickly Find and Delete Rows

Select several rows that contain similar data, and delete them all at the same time, with Excel's Find All and Delete Sheet Rows commands. This can be a real time saver!

Ruffled Feathers

This lovely green heron was hiding in the bushes near the beach in Hilton Head, South Carolina. I'm sure my hair looks just like that, after a tough day of working with Excel!


Contextures Products

Save time with our "Done For You" Excel products.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright ©2019
All rights reserved.