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
- Excel Tips at MVP Canada
- Absolute Reference to Pivot Table
- Chart Shortcuts
- More Excel Tips
- Video: List Days by Week
- Weekly Photo: Rhubarb Harvest
- Excel Tools
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
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:
- Ron de Bruin and Norman Harker have released an online Excel Function Bible, with examples for all 468 functions.
- Colin Legg answers 3 common questions about changing the number signs in a list of numbers.
- James Longden, at BPM Global, shared his World Cup Monte Carlo Simulator, that you can download, to predict how well your team will do.
- Cole Nussbaumer, on the Storytelling With Data blog, shows four alternatives to pie charts, and you can download his sample file.
- 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
- The European Spreadsheet Risks Interest Group – EuSpRIG –has announced the preliminary program for Eursprig 2014. This event will be held in Delft (Netherlands) on July 3, 2014. Read more about it on Patrick O'Beirne's blog.
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.
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.
- 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 ©2017
All rights reserved.