Search Contextures Sites


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

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 -

New Workbook Based On Old One

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

Scary Pivot Table Training Giveaway

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

More Excel Tips

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

  • 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.

Excel Announcements

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

Video: Count Cells Greater Than Set Amount

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.

November Snowflakes

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.


Featured Excel Product

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.

Peltier Tech Chart Utility

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.


Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright ©2014
All rights reserved.