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