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 firstname.lastname@example.org
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:
- 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!
- 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.
- 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.
- 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.
- 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.
- 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.