Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

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 -  ddalgleish@contextures.com

Highlight Numbers

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:

  • 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."
  • 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.

Excel Announcements

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

Goodbye Snowman!

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

_____________

________________________

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

 

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2015
All rights reserved.