Search Contextures Sites


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

Excel Weekly News from Contextures June 10, 2014

Chart Shortcuts + more Excel tips

In this week's Excel news, you'll see how to use shortcut keys to create a chart, and other tips. Thank you for reading the Excel news!

 -  Debra

Charting Utility Free Upgrade and Giveaway

If you have bought a copy of the awesome Excel Charting Utility from PeltierTech, here is some important news -- an Advanced Excel Charting Utility will be released this Thursday, June 12th. To get a free upgrade to the new version, send an email to Jon, by Friday, June 13th. Use the contact link on the utility page.

If you haven't bought this time-saving tool yet, the Advanced Excel Charting Utility will be on sale Thursday and Friday -- June 12-13 -- for the same price as the Standard utility. After that, the price goes up by $20. Put those dates in your calendar, so you don't forget!

And, if you'd like a chance for a free copy of the charting utility, visit my blog today -- I'm having a giveaway! Read the details on the blog, and the deadline is 5 PM Eastern time on Wednesday, June 11th.

Excel Tips at MVP Canada

Last week, I did a couple of Excel presentations at Microsoft Canada, for MVP Day. My first session featured Excel tips, and the second one looked at Excel Tables and Pivot Tables.

One tip was to filter a list, then click the AutoSum button, and a SUBTOTAL formula is automatically inserted. With that function, the result shows the sum for the visible cells only, instead of all the rows in the table.

You can see a few pictures from the event: MVP Canada Day

Absolute Reference to Pivot Table

If you link to a pivot table cell, you might see a GetPivotData function, instead of a normal link That function acts like an absolute reference, and stays the same, if you copy down a column. You can turn that feature off, to create regular links instead.

Click here to read the details, and watch the video: Absolute Reference to Pivot Table

Chart Shortcuts

After you add data to a worksheet, you can create a chart, to give a visual summary. Use a keyboard shortcut to quickly insert a chart on a new sheet, or add a chart on the same sheet as the data.

Click here to see the details, and watch the video: Create Chart with Shortcuts

More Excel Tips

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

  • Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.

Here are some upcoming events, related to Excel.

  • Using Excel with Chicago City Data -- Ross Loforte (Microsoft Technology Center Architect) and William Stanley (Principal Solution Specialist for Microsoft) discuss how to use Excel against City Data Sets to visualize, analyze, and share those insights. Wed. June 11, 2014, 6:00 PM

Video: List Dates by Week

To create a list of dates by week, use this mouse shortcut. Remember to press the Right mouse button, not the left one.

Rhubarb Harvest

There's a small clump of rhubarb in our garden, and I harvested the crop this week. Most of the 1.5 pounds went into the freezer, and I saved a cup to try a new recipe, for a refreshing rhubarb ginger cooler. Delicious!


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.


Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright ©2014
All rights reserved.