Excel Weekly News from Contextures June 11, 2013
Interactive Function List + more Excel tips
It's been cool and wet here in Canada this week, and you can see a bird waiting for the rain to start, in my photo this week, at the end of the newsletter.
In this week's Excel news, you'll see how to adjust the pivot table field list, find functions in the interactive functions list, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Interactive Excel Functions List
New functions have been added to Excel, over the past few versions. On my Contextures website, I've created an interactive list of the functions, and you can sort, filter, or download the list. Some functions have hyperlinks, and you can click those to go to a function tutorial on my site.
Click here to see the functions list: Interactive Excel Functions List
How to Adjust the Pivot Table Field List
When you create a pivot table, by default, a pivot table field list should appear, at the right of the Excel window. Instead of leaving the default settings, you can select a different field list layout, move it to a new position, and change the list order.
Click here to see the details, and to watch the video: How to Adjust the Pivot Table Field List
Excel Page Break Preview Tips
Before you print an Excel worksheet, you can check and adjust the page breaks, using the Page Break Preview view. This could save paper, if you discover problems before you start printing.
Click here to see the details, and to watch the video: Excel Page Break Preview Tips
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- On his YourSumBuddy blog, Doug Glancy has code that prompts you to add new items to a combo box, or to a data validation list.
- 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.
- In Excel 2013, each Excel workbook opens in its own window. On Microsoft's Exce blog, Chad Rothschiller explains how this works, and how you can open a second instance of Excel, if you need to.
- On the RAD Excel blog, Colin Legg shows three different ways to calculate the absolute sum in Excel.
Video: Quickly Remove an Excel Pivot Table Field
After you create a pivot table, you might want to remove a field from the layout. You don't need to go to the field list, find that field and remove its check mark. And, you don't need to drag the pivot field out of the Row Labels area in the field list. Watch this short video to see the quickest way to remove a pivot field from the layout.
For more info on pivot fields, please visit my Contextures website: Excel Pivot Fields
Bird on a Wire
Sometimes I see an overhead wire, filled with dozens of birds, watching the world go by. Last week, I snapped this picture of the opposite situation. Here is a single bird, and dozens of wires! Maybe the approaching storm scared away his friends.
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 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.