Pivot Table Makeover + more Excel tips

Excel Weekly News from Contextures January 20, 2015

In this week's Excel news, you'll see how to give your pivot table a makeover, 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 -  ddalgleish@contextures.com

Delete Rows Based on Colour

Did you know that you can filter a list based on the conditional formatting colours that you applied? This is one of the newer features in Excel, and in this example, I used it to select highlighted rows, then delete them..

Click here to see the details: Delete Rows With Conditional Formatting Color

Pivot Table Makeover

When you create a new pivot table, it is automatically formatted with the Compact Report Layout. You can change to one of the other layouts, and make a few other simple changes, so your pivot table looks better, and the data is easier to read and understand.

See the details in my blog post, and download the sample file: Give Your Excel Pivot Table a Makeover

More Excel Tips

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

Excel Announcements

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

Video: Quick Drop Down List

To make data entry easier, you can add a drop down list in a cell, then quickly select an item from that list. This video has a few quick tips for creating a named range, then using that name to create the drop down.

Click here to watch the short video that show how it works: Quick Drop Down List Video.

Staying Warm

It is supposed to warm up a bit this week, so perhaps I'll be able to get out to the conservation area, and get some outdoor pictures to share with you. In the meantime, I'm getting lots of work done, while staying inside, and eating healthy and hot food, like this delicious kale and lentil soup. I hope you're staying warm too (or cool if it's summer where you are)!

Featured Excel Product

The start of a new year is a great time to add some new tricks to your Excel repertoire. Stay inside, where it's cozy and warm, and follow an online course at your own pace.

Excel dashboard skills are certainly in demand in many companies, and Mynda Treacy from My Online training Hub is temporarily opening registration for her comprehensive Excel Dashboard Course. I've been through this course, and highly recommend it. You can read my detailed review here.

Mynda's dashboard course is a great investment, and if you sign up by this Thursday, January 22nd, you can get the course for 20% off. Registration closes on January 29th.

The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there's even an option to download the videos.


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.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.