Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

Save Source Data + more Excel tips

Excel Weekly News from Contextures February 3, 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. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.

 -  Debra -  ddalgleish@contextures.com

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.

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

_____________

________________________

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 ©2015
All rights reserved.