Excel Weekly News from Contextures June 17, 2014

Fiscal year totals + more Excel tips

In this week's Excel news, you'll see how to show fiscal year totals, and other tips. Thank you for reading the Excel news!

 -  Debra -  ddalgleish@contextures.com

Smart Art Family Tree in Excel

With this sample file, from Prof. Lee Townsend, you can create your family tree in Excel, using Smart Art. Fill in the list, then click the button, to draw the chart.

Click here to see the details: Smart Art Family Tree

Show Fiscal Year and Month Totals

It's easy to show totals by calendar year and month in a pivot table, but there isn't a built-in way to show totals for fiscal year or month. With this workaround, you can calculate the fiscal year and month in the source data, then use those fields in the pivot table.

Click here to read the details: Show Fiscal Year and Month Totals

Charting Utility Giveaway Winners

Last week, I had a giveaway for a copy of the new Advanced Excel Charting Utility from PeltierTech, and the winners were announced last Thursday:

  1. Grand Prize, JoAnn Paules, comment #4 - Advanced Excel Charting Utility
  2. Runner-up, Trouttrap2, comment # 13 - Any Contextures product
  3. Runner-up, CR, comment # 12 - Any Contextures product
  4. Random Draw, Eric, comment # 17 - Any Contextures product

Congratulations to all the winners! Thanks to everyone who entered -- your comments were thoughtful and creative, and it was very tough to choose the 3 that I liked best.

More Excel Tips

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

Video: Pivot Table Date Filters

If a date field is in the Row or Column area of a pivot table, there are 3 types of date filters that you can apply.

Garden Gloves

It's great to get out in the garden, and dig in the dirt during the spring and summer. I usually wear garden gloves, and perhaps I've bought a few too many pairs over the years! Last week, I washed them all, and put them in the sun to dry, so they'll be ready to use again. Those weeds are growing like crazy!


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.