Search Contextures Sites
Report Cleanup + more Excel tips
Excel Weekly News from Contextures November 4, 2014
In this week's Excel news, you'll see tips for tidying up your reports, 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
- New Workbook Based On Old One
- Scary Pivot Table Course Giveaway
- More Excel Tips
- Excel Announcements
- Video: Count Cells Greater Than Set Amount
- Weekly Photo: November Snowflakes
- Featured Excel Product
You can save time by creating a new workbook that is based on an existing file. Just open the old file, and use the Save As command. But, if you forget to do that, you can accidentally delete or overwrite vital information in that old file.
See the quick ways to create a copy before you start editing, and avoid problems.
Click here to see the details: New Workbook Based On Old One
Even though a pivot table is a beautiful thing, it can be scary if youíre not sure how to handle one. Are you afraid to get started with pivot tables? Have you learned the basics, but arenít sure what to do next? Do the advanced pivot table features make you wake up screaming in the night?
If you are a little (or a lot) afraid of pivot tables, there is good news! You can enter this giveaway for a chance to win an Xtreme Pivot Table Course ($199 value), thanks to John Michaloudis, from My Excel Online Training.
Click here to see the details, and enter the contest: Scary Pivot Table Training Giveaway
Here are a few of the Excel articles that I read recently, that you might find useful:
- Garrett Bugbee offers 6 tips for tidying up your Excel reports.
- Dr. Timothy Mayes has posted a new variance/covariance builder add-in for Excel 2010/2013. You can download this free add-in and examine the code.
- Jon Peltier wrote an epic article that explains everything you need to know about programming charts through events.
- Rick Grantham explains what a Monte Carlo Simulation is, and shows how to run one in Excel. .
- Excel or Google? Oz du Soleil shows 3 Excel features that aren't available in Google spreadsheets.
- Steve gives detailed instructions on how to make an infographic chart in Excel using stacked bar chart, shapes and PowerPoint.
- Finally, 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:
- New Book: Six Sigma Statistics with Excel and Minitab, 2E by Issa Bass.
- Chris Webb is running a one-day Power Query course in London on Nov. 13, 2014.
Use the COUNTIF function to count the cells that contain an amount that is greater than a set minimum, or less than a maximum amount.
There are water drops on the flower in this picture, that I took in my garden, on Saturday (November 1st). But those were not raindrops -- they were melted snowflakes! Yikes, it looks like winter might be coming early this year.
If you make complex charts, you'll save time and reduce frustration, by using the powerful chart utilty from Peltier Tech. There are two versions -- Standard and Advanced -- and each can quickly create a complex chart in seconds.
Go beyond the built-in Excel charts, and create Waterfall, Box Plot, Cluster Stack, and many other amazing charts, with just a few clicks.
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 ©2014
All rights reserved.