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 firstname.lastname@example.org
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.
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
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
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
Here are a few of the Excel articles that I read last week, that you might find useful:
Here are some upcoming events, related to Excel.
To create a list of dates by week, use this mouse shortcut. Remember to press the Right mouse button, not the left one.
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!
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.
Contextures Inc., Copyright ©2017
All rights reserved.