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
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:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
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. 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 ©2017
All rights reserved.