Search Contextures Sites


Newsletter Index


Get weekly Excel tips from Debra




30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures Aug 7, 2012

Test interactive Excel data, create MIN IF and MAX IF formulas, and other tips, in this week's Excel news from Contextures.

 -  Debra

Interactive Excel Sample Data

On the Sample Data page on my website, I added a new feature from Microsoft -- Excel Interactive View

interactive Excel view

When you click the button, a new window opens. You can sort, filter, and chart the data from a website table. You can also download the results, and work this the data in your desktop version of Excel.

This feature works nicely in Firefox, and Chrome, but I don't see the button in Internet Explorer.

I also added Excel Interactive View on my Excel books list, so you can sort and filter, to find the book you're looking for.

Click here to read the details: Excel Interactive View

Excel Dashboard With High and Low Values

On my Contextures blog, I shared a technique for creating MIN IF and MAX IF formulas. You'll see how to find the highest and lowest values for specific products, in a long sales list, with multiple products.

MAX IF formula

Click here to see the steps and video: Create MIN IF and MAX IF Formulas

Reminder: Excel Dashboards Course

The early bird discount for the Excel Dashboards Course ends today, August 7th, so sign up now, to save 20%.  Registration is open until August 14th, and you can see the course details and a sample video here: Excel Dashboards Course
dashboard example

Dashboards are the new buzzword in Excel reporting, and employers are specifically asking for these skills. If you need to take your Excel skills to the next level to get your dream job, then knowing Excel Dashboards will help you stand out from the competition.

I highly recommend this training, to improve your dashboard skills. Go at your own pace, because you'll have 12 months of access to the videos and sample files. Or, select one of the options that includes downloadable videos, so you can watch them offline, at any time.

Excel Dashboards Course

Improving the Default Percent Formatting

On the Bacon Bits blog, Mike Alexander shows how to add custom formatting for percentages. The built in formatting is very limited, and you can add brackets, colours, and even symbols to the results.

custom format percent

Click here to see the steps for creating your own format: Improving the Default Percent Formatting

45 Ways to Communicate Two Quantities

On the Blog, Santiago Ortiz shows an amazing array of ways to visualize a small data set -- only 2 numbers.

The options range from writing, to pie charts and divided shapes, and beyond.

divided shapes 

Click here to read the details, and see all the charts. 45 Ways to Communicate Two Quantities

Contextures Products

Save time with our "Done For You" Excel products.


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




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.