Contextures News 20150901

Don't use this Excel formula

September 01, 2015

Dashboard tips, navigation shortcuts, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Summer Schedule

During the summer months I'll publish the newsletter once every two weeks, so you will get the next issue on September 15th. After that, we'll be back on our weekly schedule. Where did the summer go?

Pivot Table Survey Results

In the last newsletter, I asked for your opinion in a short pivot table survey, and thank you for all the responses. Here are the results, and you can download the survey results workbook at this link: PT0042 – Results from Pivot Table Survey:

  1. Do you use Excel pivot tables?    Yes - 147   No - 5
  2. If you use pivot tables, what is your skill level? Average - 6.8
  3. How do you feel about pivot tables? Average - 8.7

I'm glad to see that so many people use pivot tables, and love them! If you want to bump up your skills, there are lots of free tutorials on my Contextures website, and on my Pivot Table blog.

Worksheet Navigation Tips

It can take lots of scrolling back and forth, to find a specific worksheet in a large Excel file. To make things easier, AlexJ shared his worksheet navigations tips, and I added a couple of my favourite tips.

There are written instructions and a video, that show how to use the navigation arrows, popup sheet list, coloured tabs, and spacers tabs. If you have any other tips, please let me know.

worksheet navigation tips

Pivot Table Top 10 Filter on Worksheet

A Pivot Table top 10 filter is a great way to focus on the best or worst results. It takes several clicks to run them though, and some people might not know how to use them. To help make filtering easier, I created a bit of code, so you can control the filter with worksheet drop downs. Download the sample file to see how it works.

pivot table filter on worksheet

Excel Podcast Giveaway

John Michaloudis, from the My Excel Online website, is officially launching his new Excel podcast this week. I've listened to one of the episodes so far, and it's an informative and entertaining hour of Excel talk.

To celebrate, John is giving away 21 awesome Excel courses, gift vouchers, and Excel add-ins. To enter the giveaway, just subscribe to John's podcast, and leave an honest review. I've donated 3 copies of my Pivot Power Premium add-in, so you might win one of those.

Click on this link to get the details: MyExcelOnline Podcast - Giveaway Page. Good luck!

Excel Articles

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

Designing a Dashboard --The Science Goddess shows how she designed dashboards to show educational data, over 4 years. See the different versions that she created, and the final results. You'll get good ideas for your own dashboards. (Level - Intermediate)

Formula Warning -- This post has 8 Great Tools to Make You an Excel Expert. Most of the tips are okay, but beware of the FIXED function in tip #7. The result of a FIXED formula is text, not a number. Text is equal to zero, and wouldn't add up correctly. Use ROUND instead, or one of the other rounding functions. (Level - Basic)

More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog. And for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets.

Late Summer Flowers

Do you know what kind of flowers these are? These hardy orange flowers have been blooming for a few weeks, and I love their bright colour. Unfortunately, I threw away the information card that came with them, and don't remember what they're called. Google won't show me anything that looks identical to them, but maybe they're coneflowers or daisies. If you can identify them, please let me know!

Weekly photo

NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser:

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish

Debra Dalgleish

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


Last updated: May 24, 2021 8:29 PM