Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

Excel Weekly News from Contextures Mar 18, 2014

Show Top 10 + more Excel tips

In this week's Excel news, you'll see how to show the Top 10 filtered items, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Show Top 10 After Filtering

Sometimes the Top 10 filter doesn't show the results that you expect. For example, if you filter a list to show only the Sunday sales, then filter for the Top 10 of those sales, only 2 rows are left.

Click here to see why this happens, and how you can get the results that you need: Top Ten Values in Filtered Rows

Report Filter Items Out of Order

If the items in a pivot table Report Filter drop down are out of order, here's how to sort them. This will make it easier to find a date, or other items, in a long list.

Click here to see the details: Sort Items in Excel Pivot Table Report Filter

Dependent Drop Down Lists With Tables

You can create drop down lists on a worksheet, with data validation. Roger Govier shares his technique for building dependent drop down lists -- select a region, then a country, an area, and then a city.

Click here to see the details: Dependent Drop Down Lists With Tables

More Excel Tips

Here are a few of the Excel articles that I read last week, that you might find useful:

  • Jon Acampora recommends the best keyboards if you like to use Excel's keyboard shortcuts. My laptop keys looks like most of the "bad" pictures in the article.
  • Chandoo shows us the 6 best charts to use, when you want to show your progress against a goal. Thereís a sample file to download, so you can experiment on your own.
  • Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.

Video: VLOOKUP From Different Workbook

In a VLOOKUP formula, you can refer to a lookup table that is in a different Excel workbook. It is easier to create the reference if both Excel workbooks are open when you create the formula. After you create the formula, the price list workbook can be open or closed, and the formula will continue to work correctly. This short video shows the steps for setting up the formula.

Spring Blossoms

Maybe spring will arrive after all, despite the harsh winter we've had across most of North America. These pretty pink blossoms, that I saw last week, give me hope that warmer weather is just around the corner.

__________________________

Recommended Excel Tools

In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.

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 ©2014
All rights reserved.