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.
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
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
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
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.
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.
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.
Last updated: February 17, 2020 4:24 PM