Search Contextures Sites
Custom Search

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

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 ddalgleish@contextures.com

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!

__________________________

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.

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 ©2016
All rights reserved.