Search Contextures Sites
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 - firstname.lastname@example.org
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:
- Do you use Excel pivot tables? Yes - 147 No - 5
- If you use pivot tables, what is your skill level? Average - 6.8
- How do you feel about pivot tables? Average - 8.7
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.
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
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.
Contextures Inc., Copyright ©2015
All rights reserved.