Search Contextures Sites
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 - firstname.lastname@example.org
- Excel Family Tree
- Show Fiscal Year and Month Totals
- Giveaway Winners
- More Excel Tips
- Video: Pivot Table Date Filters
- Weekly Photo: Garden Gloves
- Excel Tools
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
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
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:
- Grand Prize, JoAnn Paules, comment #4 - Advanced Excel Charting Utility
- Runner-up, Trouttrap2, comment # 13 - Any Contextures product
- Runner-up, CR, comment # 12 - Any Contextures product
- 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.
Here are a few of the Excel articles that I read last week, that you might find useful:
- Chandoo has posted the 49 entries in his dashboard contest. You’ll get lots of ideas for your dashboard if you look though the list, and download the sample files.
- Dick Kusleika explains how to calculate tiered commissions, and why he uses scientific notation for the large numbers.
- When you’re ready for a break from the World Cup, you can follow golf instead. Erik Svensen shows how to create the leaderboard of the US Open Golf championship in Excel, with Power BI.
- Which door should you choose? Will you win the car or a goat? Keith Rozario tests the Monty Hall problem in Excel.
- Finally, for a humorous peek at what other people are saying about spreadsheets, read this week's collection of Excel tweets, on my Excel Theatre blog.
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.
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!
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.
- Charles Williams has released a new version his add-in, FastExcel V3, and you’ll get 50% off the bundle price, if you use Coupon Code FXLV3Intro (valid until July 31 2014)
- Contextures Excel UserForm Course
- Contextures Excel Tools Add-in
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.