Don't use this Excel formula
September 01, 2015
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
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?
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:
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.
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.
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!
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.
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: https://www.contextures.com/newsletter/excelnews2015/20150901ctx.html
That's it for this week! If you have any comments or questions, send me an email.
Last updated: December 27, 2019 11:39 AM