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!
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.
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!
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)
Also, see all my Excel products on my Contextures website.
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
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.
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.,
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: September 8, 2016 12:20 PM