Search Contextures Sites
Custom Search

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

Don't use this Excel formula

September 1, 2015

Dashboard tips, navigation shortcuts, and much more, in this week's Excel news. And be sure to read my formula warning in the Excel Articles section. You don't want to mess up your worksheets!

 -  Debra -  ddalgleish@contextures.com

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.

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.

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, and it's an informative and entertaining hour of Excel talk.

To celebrate, John is giving away some awesome Excel courses and add-ins. I've donated 3 copies of my Pivot Power Premium add-in, so you might win one of those.

To participate in the fun, just subscribe to John's podcast and leave an honest review. Get all the details here.

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!

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: http://www.contextures.com/newsletter/excelnews2015/20150901ctx.html

_____________

________________________

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 2015
All rights reserved.