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 firstname.lastname@example.org
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
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
- 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
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!
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.