Contextures

Contextures News

Excel Popup Slicer Trick #2

August 8, 2017

Messy charts, converting measurements, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos. We're on our summer schedule now, so the next newsletter will arrive on August 22nd.

Note: For some products mentioned below, I earn a commission on sales. That supports the free info on my site!

On Demand Slicers

Last time, you saw AlexJ's pop up Slicer trick #1 - click a small button on the worksheet to open the Slicer. It's a great way to use a large Slicer, without taking room on the worksheet.

If you have multiple Slicers, try AlexJ's "on demand" Slicers technique instead. Click on a cell at the top of the worksheet, and the Slicer for that cell appears. In the screen shot below, I clicked on the Category cell, and the Category Slicer appeared in column C. If I click OrderYr, its Slicer will show up in the same spot, and the Category Slicer is hidden.

You can get all the details on my blog, and there is a workbook to download too.

On Demand Slicers

CONVERT Function

The CONVERT function lets you change a value from one type of measurement to another. For example, change a temperature from Celsius to Fahrenheit, or change distance from miles to kilometres.

I use CONVERT in the Recipe Calculator sheet of my Calorie Counter workbook. If your favourite recipes list the ingredients in cups and ounces, Excel will calculate the amounts in litres and grams.

To see how the function works, download my CONVERT workbook that shows all the measurement categories and codes. You can add prefixes too, like "k" (kilo) and "M" (mega).

=CONVERT(10,"kg","Mg")

CONVERT function

Excel Articles

Here are a couple of recent Excel articles that you might find useful or interesting.

Charts - There are no swear words in this story, but apparently some were used when the Science Goddess built this messy chart. She usually works in Excel, so this chart is certainly different! (Level - All)

Quick Tip - Chandoo shows how to quickly unprotect multiple worksheets -- all in one place. You'll have to enter the password for each sheet, but it's nice to see everything at once. NOTE: If you have my Excel Tools add-in, you can use that quickly unprotect all the sheets, and enter the password once. (Level - All)

Also see: My Excel Products || Excel Events || Previous Issues || Excel Humour

Our New Pet

Everyone online posts pictures of their cute cats and dogs. So, for the first time in my life, we've got a pet too. It's a FurReal Friends Bootsie cat, and it has a variety of sounds, moods, and movements -- just like a real cat. But, it's perfect for people who have allergies, and you don't need to clean up after it!

If anyone asks, we bought it for our grandkids to play with. Nobody has to know that I keep it in my office.

weekly photo

That's it for this week! Watch for the next newsletter in 2 weeks.

NOTE: If you have trouble with the images or links in this email, paste this URL into your web browser, to see the online version: http://www.contextures.com/newsletter/excelnews2017/20170808ctx.html

Debra Dalgleish
ddalgleish @ contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: August 4, 2017 11:23 AM