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
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
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
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
Here are a few more Excel articles that I read this week, that you might find useful:
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
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.
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.