Highlight Specific Numbers + more Excel tips
Excel Weekly News from Contextures March 17, 2015
Make it easy to spot numbers that are in another list -- use conditional formatting. See how it works, and find many more tips, in this week's Excel news.
- Debra - firstname.lastname@example.org
- Highlight Numbers
- More Excel Tips
- Excel Announcements
- Video: Move Pivot Table Values
- Weekly Photo: Goodbye Snowman!
- Featured Excel Product
Highlight numbers that are found in another list, with Excel's conditional formatting This example uses lottery numbers, and you could use the same technique for other types of lists, such as names, or dates.
Read the details on my blog, and watch the video, to see how it works: Highlight Winning Lottery Numbers
More Excel Tips
Here are a few of the Excel articles that I read recently, that you might find useful:
- Matthew Eaton uses a simple table, and a Pareto chart, to track his personal habits, and calculate his success rate.
- Good news -- In a follow up to the ActiveX control problems caused by a Microsoft Security update in December, Jan Karel Pieterse announced that Microsoft's March 10th update should automatically fix the problem.
- Aaron Souppouris takes a look at the new Office 2016 for Mac preview. He suggests that you try it, and warns you to "keep Office 2011 around for the important stuff."
- Which would you choose to have in your workbook – an Excel Table, or Custom Views? Gašper Kamenšek would like to have both!
- In a short video on YouTube, Sara Silverstein shows how to analyze several years of NCAA revenue data, by using a pivot table. NOTE: The video starts playing automatically on YouTube.
- Jeff Weir wants to know which features you'd like to see improved in Excel? Or do you thinks it's perfect, just the way it is? Read the comments, and add your suggestion to the discussion.
- Chris Webb adds the AGGREGATE function to his table, so he can use Slicers to filter his Power Query results. You can download the sample file, to see how it works.
- Richard Harker shows how to create a dynamic 12 month rolling column chart, from horizontal data.
- Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
- Amsterdam Excel Summit: Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration is now open, for this year's event.
Video: Move Pivot Table Values
Last week, someone emailed me to ask about the "Values" button that shows up in the field list, when you have more than one value. You can see an example in the screen shot below.
That button represents the group of Value fields, and you can move it to the Row area, for a different layout.
Click here to watch the short video that shows how the Values button works: Show Pivot Table Values Vertically
It's finally getting a bit warmer, and the big piles of snow are melting. While we walked through the park last week, we saw this fallen snowman. That is a pretty good sign that spring is just around the corner. Sorry snowman, but I hope we don't see you again until next winter!
Featured Excel Product
This week, I'm pleased to recommend Excel University -- an online Excel training course designed specifically for accountants. I went through several of the modules, and was very impressed by the content, delivery, and course structure.
As an exclusive offer to Contextures Newsletter subscribers, you can save 20% with this discount code: contextures2015 (code expires March 31, 2015)
The course focuses specifically on the Excel features, functions, and techniques that are most useful to accounting professionals. The training is practical and the concepts are easily applied to your workbooks. You'll learn how to get your Excel tasks done more quickly, how to save time, and how to automate your recurring-use workbooks.
Click the link to learn more about Excel University. And remember, until March 31, 2015, you can save 20% with this discount code: contextures2015
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 ©2016
All rights reserved.