Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures July 16, 2013

Summarize formulas in a data table+ more Excel tips

In this week's Excel news, you'll see how to use check box results in a formula, summarize formulas in a data table, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Use Check Box Result in Excel Formula

To make it easy for people to enter data on a worksheet, you can add check boxes. Then, instead of typing, just click to enter a response to a question, or select an option.

If you want to use the check box results in a formula, link each check box to a cell. Then, refer to those cells in your formula.

Click here to see the details, and download the sample file: Use Check Box Result in Excel Formula

Create a Pivot Table in Excel 2013

There is a new feature in Excel 2013 -- Recommended PivotTables -- that makes it even easier to get started with pivot tables. Based on your data, you can choose one of the suggested layouts, instead of starting from scratch.

Click here to see the details, and to watch the video: Create a Pivot Table in Excel 2013

See Formula Results in an Excel Data Table

With an Excel Data Table, you can change one or two variables in a formula, and see the results in a compact layout. For example, see what happens to the monthly payment, for different interest rates and loan terms.

Click here to see the details and video, and to download the sample file: See Formula Results in an Excel Data Table

More Excel Tips

Here are a few more Excel articles that I read this week, that you might find useful:

  1. On their E90E50 website, the Frankens Team (Robert, Gábor and Kris), have opened a gallery of Excel charts. If you're looking for new ideas, you'll find something there to inspire you, from birthday candles, to clocks and even the solar system!
  2. Over at the Daily Dose of Excel blog, Tushar Mehta shows how to generate random numbers in Excel. You can use this technique to pick a winner for a door prize, or assign players to teams.
  3. 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.
  4. Microsoft has just announced that new Business Intelligence features for Excel will be available as part of Power BI for Office 365. There will be a preview starting later this summer, but no information yet on pricing or availability.
  5. If you're building a dashboard in Excel, Chandoo has a few tips for displaying numbers that have context and meaning.

Video: Create Excel Hyperlinks With Drag and Drop

This video shows how you can use a quick and easy mouse shortcut in Excel, to create a hyperlink to another cell in the workbook. You can use this Excel hyperlink technique to create a table of contents in an Excel workbook, or link from one worksheet to another.

For more information on hyperlinks, please visit my Contextures website: Excel Hyperlinks and Hyperlink Function

Wet and Wild Weather

We had a wild rainstorm last week, with a month's worth of rain falling in a couple of hours. About 80% of the homes in our city lost power, and there was extensive flooding.

As you can see in this picture, our patio table tumbled over, and the tree lost a couple of branches. Fortunately, we kept our power, and the basement stayed dry.

___________________________

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.