Search Contextures Sites
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 - firstname.lastname@example.org
- Football Fun With Functions
- Save Source Data
- More Excel Tips
- Excel Announcements
- Video: Create a Waterfall Chart
- Weekly Photo: Apple Modem 1200
- Featured Excel Product
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:
- Gašper Kamenšek shows how you can set specific days as the weekend, with the WORKDAY.INTL function.
- Chandoo has a light bulb moment, while setting up a cost benefit analysis.
- Fowmy built a pop-up calendar add-in for Excel. Right-click to insert a date, and select a date format.
- Jordan Goldmeier uses the Color Brewer tools to create new color palettes for his workbooks.
- Ken Puls created a VLOOKUP function in Power Query, to find approximate matches.
- Mike Alexander describes how Microsoft's free Fuzzy Lookup add-in works.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
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.
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
See more recommended Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2015
All rights reserved.