Contextures

Contextures News

Hide Excel Sheets by Colour

July 12, 2016

Hide sheets based on tab colour, quick chart fix, and more, in this week's Excel news. During the summer months I'll send Excel news once every two weeks, so you will get the next news on July 26th. My Excel website is always open though!

Hide Sheets Based on Tab Colour

Recently, I shared a tip on hiding sheets based on their names, and someone asked me how to hide sheets based on their tab colour instead. That sounded like a fun challenge, so I created a macro to do that.

If you go to my website, you can download my sample file. There's a video that shows the steps for setting it up in your own workbook. There are also written instructions, if you prefer those.

show sheets by tab colour

Free Pivot Table Tool

Pivot tables have an annoying "feature" -- they default to using the Count function sometimes, instead of Sum. So, after you build a pivot table, you might have to spend extra time, changing all those Counts to Sums.

To make that job easier, I've just uploaded a free tool that you can use, and it has a few other features too. The tool is called Pivot Power Free (PP Free), and you can go to my site and download it.

NOTE: If you have a copy of my Pivot Power Premium (PPP) tool, you won't need this free version, because PPP has the same tools, and many more!

pivot power free

Excel Articles

Here are a couple of Excel articles I read recently, that you might find useful.

Simple Chart Trick - Ann K. Emery shows a simple trick for making one column in a chart stand out from the rest. You can use a similar trick for creating stacked clustered column charts. (Level - All)

Date Format - On the Ecology Bits blog, Margaret Kosmola is tired of Excel changing the date format when she imports CSV files. She suggests a few ways to adjust your data file, to prevent that from happening. (Level - Intermediate/Advanced)

More Excel Articles -- Visit my Excel website for many more tutorials and videos. And for a bit of fun, read my weekly collection of entertaining Excel tweets.

Also, see all my Excel products on my Contextures website.

Excel Resource of the Week

If you're looking for a job as an Excel Analyst, or any Excel-intensive work, this course could help you -- Hired with Excel: What Every Analyst Needs to Know. The online video course shows you what analysts really do, how Excel can help, and what you can do to impress potential employers. For each topic, there are several short videos, and Excel files for practice.

The instructor, George Mount, gave me access to the course, and I was impressed by its content, and the focus on key Excel skills. George explains the concepts clearly, and there is a Discussion section where you can ask questions about any of the lessons.

If you register for the course by July 25th, you can save 20% with the discount code: Contextures20

Mississauga Towers

Last week, I had an appointment on the far side of Mississauga, and passed these distinctive Absolute towers along the way. They're in the centre of our city, close to City Hall, and I'd like to see inside of them one day. They're nicknamed the "Marilyn Monroe" towers, and I"ll let you figure out why! You can read more about them on Wikipedia.

weekly photo

That's it for this week! If there are topics that you'd like to see covered in future emails, please let me know.,

Debra
ddalgleish @ contextures.com   

P.S. You can choose to get the full Contextures news package (news and occasional special announcements), or the basic news package (news only). Click either link to change your news option.

Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: September 8, 2016 12:20 PM