Contextures News 20150203

Save Source Data + more Excel tips

February 03, 2015

In this week's Excel news, you'll see the pros and cons of saving source data with a pivot table, and much more, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Football Fun With Functions

The 49th Superbowl (XLIX) was played on Sunday, and because it was the last one starting with "XL", I looked for some Excel functions that were related to football terms. Can you think of any others?.

Click here to see the details: Football Fun With Functions

Save Source Data With Pivot Table

When you create a pivot table, you have the option to save the source data with the file. There are pros and cons to turning that setting on or off, so pick the option that works best for each file.

See the details in my blog post: Save Source Data With Pivot Table

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

  • For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

  • Amsterdam Excel Summit: Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration is now open, for this year's event.

Video: Create a Waterfall Chart

You can create a waterfall chart in Excel to show the cumulative effect of positive and negative amounts, based on a starting value. For example, show the monthly net cash flow amounts in a waterfall chart, and quickly see which months had positive and negative results.

Click here to watch the short video that show how it works: Create a Waterfall Chart.

Apple Modem 1200

If you've used computers for a long time, you probably had a modem in the early days, to connect to other computers over the phone lines. I found this Apple Modem 1200 in my office storage, and can still remember the noise that it made. Good thing our files were small, and websites were plain text back then, because the data transfer was very slow. And most homes just had one phone, and it could be tied up all night, if someone was downloading files.

According to the InfoWorld article that I found online, this modem cost about $500 in 1984. Yikes! Good thing I was able to deduct it as a business expense.

weekly photo

Featured Excel Product

If you don't have the time or patience to arrange your data and create your own Waterfall chart, Excel charting guru, Jon Peltier, offers a time-saving Excel Chart Utility, which includes a Waterfall chart builder.

Just select your data, click the Waterfall Chart command on the Ribbon, set a few options, and click OK, and your waterfall chart is ready. A few columns with formulas are added in your workbook, to provide the data for the waterfall chart.

Along with the Waterfall chart builder, the chart utility creates other custom charts, and contains chart tools and a data tool. It's a good investment, and the Peltier Tech chart utility will quickly pay for itself, because you won't have to waste your time fussing with data arrangements and chart settings

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.


Last updated: February 17, 2020 4:24 PM