Search Contextures Sites
Excel Weekly News from Contextures Aug 7, 2012Test interactive Excel data, create MIN IF and MAX IF formulas, and other tips, in this week's Excel news from Contextures.- Debra firstname.lastname@example.org
Interactive Excel Sample Data
On the Sample Data page on my website, I added a new feature from Microsoft -- Excel Interactive 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.
Click here to see the steps and video: Create MIN IF and MAX IF Formulas
Reminder: Excel Dashboards CourseThe 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
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.
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.
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.
Click here to read the details, and see all the charts. 45 Ways to Communicate Two Quantities
Recommended Excel ToolsThey 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.
- Contextures 30 Excel Functions in 30 Days
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
- Excel Pivot Table Intro Course
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.