Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

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

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 Visual.ly 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

Recommended Excel Tools

They aren't free, but these Excel tools are a worthwhile investment, so please 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 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.