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
Save time with our "Done For You" Excel products.
- Pivot Power Premium Add-in - Time-saving tools for pivot table users
- Data Entry Popup Kit - Quick and easy data entry with a popup list
- Data Entry Search Popup - Enhanced data entry popup, with Search box
- Excel Tools Add-in - Make instant backups, sheet list with links, much more
- More Excel products from Contextures
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.