Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

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 ddalgleish@contextures.com

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.

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.