Automatically plot multiple pieces of online data in your Excel spreadsheet

AppId is over the quota
AppId is over the quota

This post on exploring Webservice functions is brought to you by Lee Bizek, a Program Manager in the Excel Team. 

If you’ve ever wanted to incorporate data from online resources into Excel spreadsheets, now you can with the new Webservice function. With this new feature, you can add information such as stock quotes, weather, Bing Search results or even Twitter feeds to your spreadsheets—and you can make the information update automatically. In this post, we'll discuss some of the more advanced aspects of the Webservice function.

I’m starting with a spreadsheet I created to organize a group camping trip that includes the latest weather information from the internet. In this example, being aware of online weather updates helped us to prepare for the elements and also predict high and low tides because we wanted to go crabbing as part of the adventure. I’ll show you how to take this spreadsheet a step further to use the =FILTERXML(xml, xpath) to extract multiple records of data from the XML string with an array. This will allow you to automatically plot multiple pieces of data in your spreadsheet.  

Note: Before you start the exercise, be sure to review how to use Webservice functions to automatically update Excel 2013 spreadsheets with online data so that you know how to:

Use a =WEBSERVICE(url) function to get dataUse the =FILTERXML(xml, xpath) function to extract a single piece of data from the XML string

We’re going to set up a Webservice function call to the URL for the 10-day weather forecast and then pull out the details from the XML string. To do this, follow these steps: 

1. Open the example file Kamping 2013 – Start and Complete Sample Files.zip located at the end of this post (click the icon next to Attachment).

2. Go to http://www.wunderground.com/weather/api/d/docs?d=data/forecast10day to get the URL for the 10-day forecast. At the bottom of the page, you’ll see an example URL.

3. Copy the example URL and paste it into your Webservice function in cell B11 of your spreadsheet. (Note: Be sure to replace the API key and location information in the URL to the cell reference we used to incorporate data from an external source so that you can control the API key and zip code for both Webservice functions in the same place.)

4. In your Excel spreadsheet, select cell range B14:B23.

5. Click the Formula Editor Box and then type: 

=DATEVALUE(CONCATENATE(FILTERXML(B11, "//date//month"), "/", FILTERXML(B11, "//date//day")))

In this example, I am pulling out the month and day, CONCATENATING them together and then converting the string to a DATEVALUE.

6. Press CTRL + SHIFT + ENTER to execute the array. This action adds the brackets { } that indicate it is an array. Find more information about array formulas here.

7. Select cell range C14:C23, then type: =FILTERXML(B11, "//high//fahrenheit")

8. Press CTRL + SHIFT + ENTER for the high temperature.

9. Select cell range D14:D23, then type: =FILTERXML(B11, "//low//fahrenheit")

10. Press CTRL + SHIFT + ENTER for the low temperature.

11. Select cell range E14:E23, then type: =FILTERXML(B11, "//conditions")

12. Press CTRL + SHIFT + ENTER for the conditions.

 

Note: To edit the formula, select all of the cells in the array, then click the Formula Editor. Press CTRL + SHIFT + ENTER to execute the new formula.

WEBSERVICE Functions are “non-volatile”, which means they refresh only when:

A referenced cell is edited

The entire workbook is refreshed (CTRL + ALT + F9)

Some text strings include spaces or non-URL-friendly characters instead of URL-friendly characters such as a zip code. You can still use the URL in the WEBSERVICE function, but it’s best to encode the string first. Use the =ENCODEURL(text) function to include text searches into your WEBSERVICE function URL. Learn more about ENCODEURL function here.

 

Now we are better prepared for packing and planning our crabbing activities!

--Lee Bizek, Excel Program Manager

Download the full example file Kamping 2013 – Start and Complete Sample Files.zip attached below. The example file also utilizes the tide data and includes XPATH filters in the WEBSERVICE Functions. Remember you can use this functionality for many different web services to pull in data that you can then analyze using Excel.

To use the web service in this example, go to www.wunderground.com and register for their Weather API to get your own API key. Once you have your API key, add it to the Weather tab. All WSF calls in the file will use this cell reference in the URL.

View the original article here

Data-linked diagrams: Multiple data graphics with a single shape

AppId is over the quota
AppId is over the quota

Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team.

Visio makes it easy to build visually compelling organization charts and enhance them to meet your specific business needs. You can create a data-linked diagram connected to your organization’s key business indicators and then make sure your information is always current by linking it from an external source. Then you can display the information with data graphics. You can bring even more business insight into your diagram by showing multiple data graphics with a single shape.

Shapes can be associated with a single data point—for example, the percent of budget spent by employee—but you can also create diagrams where each shape shows multiple data points, such as the number of employees in each department, sales attainment for employees in revenue-generating roles or other metrics that are important in your organization.

There are a few different ways to do this, but the most simple is to add multiple data elements to a single data graphic. For example, if we wanted to show the number of employees in each department on our organization chart, we could edit our existing data graphic and add a text call out under the main shape.

Visio allows you to specify where you’d like data graphics to show up on shapes--just uncheck the Use default position box and select a position that is better suited to what you are hoping to achieve.  In this case, we chose the Center, Below Shape position.

If you want to change the fill of the data graphic, select that element and change the fill as you would for any other shape.

With our organization chart we can create a diagram that represents multiple dimensions of data in an easy-to-follow format. The first thing to think about is whether the Coin diagram type is the best way of representing data. In situations where I’m showing multiple data graphics per person, I like to use shapes that are open. In this case, I’ll switch to the Bound style. (Go to the Org Chart tab to select the shape style that best fits your needs.)

You may need to use the height and width controls to make the shapes large enough hold the data graphics you’d like. Once you have the shapes looking the way you’d like, you can use the layout controls to adjust spacing between shapes.

Considering the amount and variety of information we want to display on this diagram, and that the data graphics are usually very visual and colorful, we can switch to Simple design for the diagram itself. (Go to the Design tab to select the design style that best fits your needs.) This way we can read our business-intelligent diagram most effectively.

Using Ashima as an example, you can see we added three additional shapes to the organization chart, grouped them, and applied data graphics to them:

Note that not every data graphic needs to be applied to every shape. In the organization chart example, only some employees produce revenue, so they have sales metrics attached to their names, while other employees do not.

Here is our final dynamic data-linked diagram:

Use Visio Services to share your diagram with others and make it available to everyone, from nearly any device.

–Yana Terukhova, Product Marketing Manager

View the original article here

Summary of data on multiple criteria on multiple worksheets

Liam Bastick has modeling financial services and training customers for more than two decades available. A professional mathematician and accountant worked in many countries with many internationally recognized customers, provision and review of the strategic and operational models for various important business obligations. You can check out Liam's previous articles at www.sumproduct.com/thought, where you can subscribe to the monthly tips and tricks newsletter.

Ever to sum of data based on multiple criteria, in different Microsoft Excel worksheets? This article provides a quick tour of indirect references and table functionality during combination properties of the function SUMPRODUCT SUMIFS function provides a solution for the mother of all multiple criteria problems.

The functionality is best to walk through an example explained:

Ivana car sales has four business areas, smart as North, South, East and West. Each quarter the four divisions will submit sales reports detailing of the month sales, salespeople, the Auto color and the price for the car was sold.

The question is: How can you determine how many red cars Charlie in total sold in February in all four divisions?

The answer would be relatively easy if the data on a worksheet.  To cope with a single criterion of SUMIF would admirably well while SUMPRODUCT for multiple criteria can be used to generate the response (for more information see my blog posts to SUMPRODUCT function and approaches to the management of multiple criteria in a worksheet).

Because the reports are furnished, there are a few considerations:

It is important that these reports are from a master template, i.e., each report has the various fields in the corresponding column. This is important for what follows. If this is not the case, you should modify the data sheets. If the four reports do not in the same workbook are saved, the data on separate worksheets within the workbook should be imported, where the expense report to be generated.

If we want to refer to multiple data sheets, we need to know the names of these worksheets. For maximum flexibility, I would suggest, store them in a table (to highlight the data and on the tab of the Ribbon command bar, select Insert , table). Tables, see my blog for a full explanation.

I named this table Division_Table , as the divisions listing for analysis. To show why I used a table, keep in mind that I have recorded Division not the West. So I would give these to the line under East, West would be part of the table. This is a very useful function to refer to the lists.

It is also important to note that named the three divisions (South and East here North,) have identical names on the tab sheet name - otherwise, this solution will not work. Make sure that the text is exactly the same with that in the page tab.

We are now ready. In a separate worksheet, I would create the following table:

The formula in cell I12 here is probably one of the easiest that you have ever met (that is, if you are working in the world of relativistic quantum mechanics accidentally!):

= IFERROR (SUMPRODUCT (SUMIFS (indirect ("'" & Division_Table [relevant departments] & "'!"))))I: I "), indirect ("'"& Division_Table [relevant departments] &"'! ")"("F: F"),$ F12, indirect ("'" & Division_Table [relevant departments] & "'!")("G: G"),$ G12, indirect ("'" & Division_Table [relevant departments] & "'!")"H: H"),$ H12)),)

You know that you have created a monster, if you have three complex Excel functions in a fourth boxes. But have no fear. To work out what's going on, explains from the inside out is (as this is the order in which Excel calculates this formula):

Indirect (detailed here)--this function returns an array of reference such as ' North ' column F, 'South' column F, etc. that can be used by other functions. Note that "'" is the formula, quotation mark, apostrophe (the syntax in General to the sheet names), then quotation marks.SUMIFS-diese function now applies several criteria for the analysis of summation. However, when used alone, this only reports created in the first worksheet (the order of presentation within the workbook is irrelevant). Here comes the next function...SUMPRODUCT-diese function is necessary, as it is often referred to as a "pseudo array"function. What does this mean in practice here is that there will be conducted the SUMIFS function between all three worksheets. IFERROR--diese error trap ensures that if a worksheet in the Division_Table listed does not exist or there is a blank line, the formula will produce an error - #REF!, for example.

This is it. Now you will the workbooks to sum up and reports that Charlie was selling red car capable of, the data about $43 k in the four business units in February.

There are to consider two other possible solutions: pivot tables by using data from multiple worksheets or create a master data sheet as an intermediate step where all data on a worksheet is registered. I produced this response, because it was true to the particular circumstances of the problem.

Final thought is: keep it simple (also known as the KISS-rule). When data on multiple worksheets can complicate the problem and complexity. Before writing a wide range formulas as above described, you should always simplify the model structure first.

-Liam Bastick

View the original article here

Support for international users and multiple languages in the new Office

AppId is over the quota
AppId is over the quota

Julian Parish is the Senior Product Planner in Office International, responsible for coordinating language and market strategy across Office products and services.  He is based at Microsoft's EMEA head office in Paris, France. 

We have made major new investments in the new Office to support international users who work in languages other than English.  Three new languages have been fully localized for the first time and Language Interface Packs added in 13 more.  The range of languages supported in Office 365 and in Office Mobile has also been greatly extended. For the many international users who need to consume or create content in more than one language we are introducing new ways to access Office proofing tools in additional languages.  

We know how important it is for you to feel comfortable using our applications and to be as productive as possible. A key part of that is to use Office in a language you know well or use regularly in your work. We are continuously reviewing the languages we support. As the economies in emerging markets grow further and more people come online around the world, we need to take Office into new languages. In fact, in the past ten years we have increased the number of localized Office languages by over 50%. In the new Office we are therefore investing in two major ways.

 

Word 2013 templates in German

First, we are adding new fully localized versions of Office in three Asian languages: Indonesian, Malay and Vietnamese.  This means that the User Interface (UI) and User Assistance (UA) content will be available in these languages across Office--including Lync--and as a Language Pack for SharePoint Server 2013.   These new language versions will be available to consumers to buy in 2013 and to enterprise customers as part of our Multilingual User Interface or MUI packs.  Alongside the Office Client a dedicated Office.com site in the local language will provide more help and tools for making the most of the new Office.

PowerPoint 2013 in Malay

Secondly, and working closely with our partners in Windows, we are adding thirteen completely new languages as Language Interface Packs to the new Office.  These packs--or LIPs for short--provide a localized User Interface (UI) for the most frequently used Office Client applications: Excel, OneNote, Outlook, PowerPoint and Word.  They run on Windows 7 and Windows 8 and will be available in 2013 as free downloads; they can be quickly installed on top of Office 2013 in a base language such as English.  The same languages can also be used as Office Web Applications in conjunction with Microsoft SkyDrive.  Together, these solutions will make the new Office available to speakers of national languages in markets which are experiencing rapid PC growth (in Africa and Asia, for example) and of additional languages that are preferred by groups of customers in developed markets.  

These are the LIP languages we are adding in the new Office:

 

With these additional investments, the new Office will be available in 106 languages as either a fully localized language or Language Interface Pack.  Taken together, these languages are spoken as the first language of more than 4.5 billion people across the globe.  They cover at least one official language in nearly every country in the world.

PowerPoint 2013 in Japanese

Changes to the international support in the new Office are not limited to these extra languages.   As more and more of our customers move to our new cloud-based service offerings, we have massively increased the range of languages and markets available in Office 365.  Already, Office 365 is available in 88 markets and 32 different languages, with more planned to come online in the next year.   

The perfect partner to Office in the cloud or on your desktop, Office Mobile will be available in many more languages to accompany the release of Windows Phone 8.  Altogether, we will support 51 different languages.

With each new release, we look at the languages we localize each of the Office applications into.  In Project and Visio, for example, we are adding support for Romanian on top of the 27 languages already localized in Office 2010. 

We have also made significant changes to the Extent of Localization for the Lync family of products.  For the Lync Client, Lync Web App and Lync Admin Center 2013 we will provide a consistent end-to-end user experience in 44 languages.  Language switching for the Lync Client will now be possible as part of the central Office language settings.  For Lync Server we are adding a new localized version in Russian.  Finally, we are stepping up our language coverage for the Lync Desktop Phone Edition software, with ten new languages added (Arabic, Czech, Croatian, Hebrew, Hungarian, Polish, Romanian, Slovak, Turkish and Ukrainian), bringing the total to 26.

During the development of the new Office we have worked  with our worldwide partners and MVPs to improve not just the range of languages we support, but also the quality of the experience in the local language.  For this release more than 8,000 localized terms have been changed and a new, modern voice adopted.  This is clearer, less formal and more up to date, whether providing help on a new feature or in error messages. 

Being able to navigate confidently in the new Office, using the UI language you want, is only half the story.  Just as important for many of our customers is to be sure of using the right spelling, finding a synonym or checking a point of grammar, whether it's for a proposal in Word or a presentation in PowerPoint.  In the new Office we have made significant investments in our proofing tools:

A feature much requested by our customers has been to add spell-checking in the subject line of Outlook messages

 

There are new thesauri (or dictionaries of synonyms) in Bulgarian, Latvian, Lithuanian and Serbian. The thesaurus feature--in all available languages--can now be accessed in PowerPoint for the first time

 

The grammar-checking functionality is now available in OneNote

A new definitions feature--available in 22 languages--lets you check the meaning of a word as part of the Proofing Pane. Dictionaries for this feature can be quickly and easily installed--free of charge[1]--from the Office Store

Research carried out by our planning teams has shown that up to 45% of Office users regularly read or create content in a second or further language, often English for people who do not speak English as their first language.  For these users we need to make it as easy as possible to find and use the proofing tools in each language they speak and not just their first language. 

In Office 2010 we already include the proofing tools for two or more "companion" languages with each language version.  The English version of Office, for instance, includes all the proofing tools for French and Spanish.  This feature will continue in the new Office, but we are going beyond it to introduce a completely new approach to proofing in multiple languages.  The range of language combinations users may need is almost limitless: a company in Germany may need Greek to do business with customers or partners, a family in the US with relatives originally from Italy may want to send mail in Italian as well as English.  To help all these users, we are introducing enhanced functionality to our existing Language Auto-Detect feature.

Imagine that you have an English version of the new Office installed on your PC, but want to write a document in Portuguese.  As you start typing your content in Portuguese, Language Auto-Detect will now recognize that you are writing in Portuguese and that you don't currently have the Portuguese proofing tools installed.  A pop-up message appears inviting you to download complimentary proofing tools for that language.  Minutes later, you can continue writing with full support to check your spelling and enrich all your Portuguese documents.

This new approach to proofing was introduced for the Consumer Preview of the new Office in summer 2012 and is available now in 50 languages.  Already, more than 700,000 users have downloaded proofing tools for additional languages; if you are using the Consumer Preview, why not visit the Office Language Options page and try them yourself?

We hope you like the changes we have made in our support for international users and multiple languages in the new Office.  If you have suggestions for further improvements or would like to hear more about language-related topics, please let us know in the comments below!

--Julian Parish

[1] Internet access required, fees may apply.

View the original article here

Using multiple criteria in Excel Lookup formulas

AppId is over the quota
AppId is over the quota

(This post is written by JP Pinto, the winner of the Great White Shark Award given for the best article written about VLOOLUP during VLOOKUP Week. We asked JP to share more of his Excel wisdom with you. JP Pinto blogs at Excel-User.com, where he writes Excel articles for common users to help improve their skills.)

If you want to look up a value in a table using one criteria, it's simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOKUP, MATCH, INDEX, etc. In this blog post, I'll show you a few of those ways.

Let's look at a scenario where you want to use two criteria to return a value. Here's the data you have:

The criteria are "Name" and "Product," and you want them to return a "Qty" value in cell C18. Because the value that you want to return is a number, you can use a simple SUMPRODUCT() formula to look for the Name "James Atkinson" and the Product "Milk Pack" to return the Qty. The SUMPRODUCT formula in cell C18 looks like this:

=SUMPRODUCT((B3:B13=C16)*(C3:C13=C17)*(D3:D13))

What it does is look in the range B3:B13 for the value in cell C16, and in the range C3:C13 for the value in cell C17. When it finds both, it returns the value in column D, from the same row where it met both criteria.  Here's how it will look:

It returns the value 1, which corresponds to the value in cell D4 ("James Atkinson" in row 4 and also "Milk Pack" in the same row), thus returning the value in column D from that row. Let's change the value in cell C5 from "Wine Bottle" to "Milk Pack" to see what happens with the formula in cell C18:

Because our formula found two lines where both criteria were met, it sums the values in column D in both rows, giving us a Qty of 6.

This technique cannot be used if you want to look for two criteria and return a text result. For instance, this, would not work:

You would be looking for the Name "James Atkinson" where the Qty is 1, and you'd like to return the Product name that matches these two criteria. This formula would give us a #VALUE error! Instead, you could use a formula using a combination of SUMPRODUCT, INDEX and ROW functions, such as this one:

=INDEX(C3:C13,SUMPRODUCT((B3:B13=C16)*(D3:D13=C18)*ROW(C3:C13)),0)

You use the SUMPRODUCT function to find out the row where both criteria are met, and return the corresponding row number using the ROW function. Then you use SUMPRODUCT in the INDEX function to return the value in the array C3:C13 that is in the row number provided. The result will be like this:

You could also do this using a different technique, such as this formula in cell C17:

=LOOKUP(2,1/(B3:B13=C16)/(D3:D13=C18),(C3:C13))

The result will be the same as in the previous solution. What this formula does, is divide 1 by an array of True/False values (B3:B13=C16), and then by another array of True/False values (D3:D13=C18). This will return either 1 or a #DIV/0! error. If you use 2 as the lookup value, then the formula will match it with the last numeric value in the range, that is, the last row where both conditions are True. This is the "vector form" of the LOOKUP, so you can use it to get the corresponding value returned from C3:C13. I used 2 as the LOOKUP value, but it can be any number, starting at 1. If the formulas don't find any match, you will, of course, get a #N/A error!

You could also use an array formula, using the MATCH function, like this:

{=INDEX(C3:C13,MATCH(1,(B3:B13=C16)*(D3:D13=C18),0))}

With this technique, you can use the MATCH function to find the row where both conditions are met. This returns a value of 1, which is matched to the 1 that is used as the lookup value of the MATCH function, thus returning us the row where the conditions are met. Using the INDEX value, you can look for the value that is in the range C3:C13, which is in the row that was returned from the MATCH function. In this case, it was row 2, which corresponds to the second row in the range C3:C13.

All of these examples show you how to use two criteria for lookups. It's also easy to use these formulas if you have more than two criteria-you just add them to the formulas. Here how the formulas would look if you add one more criteria:

=SUMPRODUCT((B3:B13=C16)*(C3:C13=C17)*(E3:E13=C18)*(D3:D13))

=INDEX(C3:C13,SUMPRODUCT((B3:B13=C16)*(D3:D13=C18)*(E3:E13=C18)*ROW(C3:C13)),0)

=LOOKUP(2,1/(B3:B13=C16)/(D3:D13=C18)/(E3:E13=C18),(C3:C13))

{=INDEX(C3:C13,MATCH(1,(B3:B13=C16)*(D3:D13=C18)*(E3:E13=C18),0))}

As you can see, depending on what's in your data tables, you can use several different techniques, using different Excel functions, to look up values. Enjoy applying these to your own Excel spreadsheets.

View the original article here

Result! Merging data from multiple worksheets

The Decatur Golden Gators football team is the pitch (a field you uninitiated people) must take in order to perfect their skills and new competitors to beat. The coach is always dizzy, and, to be honest, fiscally concerned. Buy snake, mini-vans, snacks, replace broken merchandise and purchase Beiber ticket is not cheap!

Manage all these issues and they roll up into a spreadsheet is pushing the limits of his knowledge of Excel. He has various worksheets for transport, tasty treats, website-hosting - he cuts and adds numbers of anyone in his household. Cntl + C inevitably leads to errors.

The Excel consolidate feature provides an easy way of the coach his data from different worksheets merge into a main worksheet, a more complete picture of his expenses allowed him (in fact, he can merge up to 256 worksheets!). With the consolidation function, the beleaguered coach get handle to motivate team expenses and focus more on the team.

The steps to merge or consolidate, data are pretty simple. Here is how to do it.

Use our sample workbook or if you learn through their own workbook, you need to do the following:

The workbook contains multiple worksheets the workbook (or else there is not much point using the consolidate function) a home should contain worksheet, for the consolidation of the data, analysis are most important worksheet that you must use for the column and row headers the same name

1. Create a home worksheet worksheet in your workbook that uses the same column and header name as the other worksheets. In this scenario, we call the home total.

(2) Select the cells in which you want to merge data from your other worksheets, on the worksheet effort .

3. Click the tab, click data , and then click the consolidate button in the Data tools .

,

4. Consolidate dialog box, click the highlighted button next to the field reference .

5. Click on the transport - worksheet-tab, to view it.

6. In the worksheet, select the transport all data you in total filename_ want to merge. In this exercise, simply select the data costs .

7. Click on the right side of the field consolidate - reference to return to consolidate dialog box.

8. The consolidate dialog Add , click the button to add the transport data, you just selected. This step ensures that the transport data, you just selected in the total expenses worksheet are merged.

 

9. Repeat steps 4 through 8 described to consolidate the other worksheets in total filename_.

10 Once you have added all the worksheets that you want to merge into the total filename_, click OK in the dialog box for the consolidate button .

The hapless coaches followed the steps above, and now its total expenditure worksheet looks like this:

Better budgeting means more Beiber!

View the original article here

PS – Warping Multiple Layers as One

PS – Warping Multiple Layers as One « Julieanne Kost's Blog function clearSearch() {document.search_form.s.value = "";} Julieanne Kost's Blog / PS – Warping Multiple Layers as OneADDITIONAL INFORMATIONBio, Contact and Artists StatementLightroom Video TutorialsPhotoshop Video TutorialsSchedule of EventsAdditional ResourcesPortfoliowww.jkost.comby Julieanne KostFree Transform (16)Smart Objects and Smart Filters (18)Warp (1)  

View the original article here

Adding Multiple Click-based Animations on a Screen with Adobe Captivate 5

May 24, 2011

You are creating a simulation-based course and you need to demonstrate a couple of related workflows which include just about six to eight steps each. You are not convinced to create separate screens for such small demonstrations. So, what should you do?

Looks like you need a screen where you can include all these simulations which play on-demand, one at a time. Let’s learn how to create such a screen.

Here’s an example for you… There is one common animation area and five different buttons that trigger the animation. Notice that the animation plays from the starting frame every time you click the related button.

And here’s how you can create such a screen:

Let me know if you found this post useful or have any questions by leaving a comment on this post.

Happy Captivating!

View the original article here

e-Seminar tomorrow: Deploying video to multiple screens

e-Seminar tomorrow: Deploying video to multiple screens « Kevin Towes on Online Video at Adobe function clearSearch() {document.search_form.s.value = "";} adobe.com      Kevin Towes on Online Video at Adobe / e-Seminar tomorrow: Deploying video to multiple screensby Kevin Towes  

View the original article here

CS5 panel can update multiple layers' blending modes

Photoshop lets you select more than one layer at once, but unfortunately it doesn’t let you simultaneously change the blending modes of those layers (good JDI suggestion). Scripter Mike Hale has whipped up a panel for Photoshop CS5 (made with the help of Configurator 2) that plugs the gap. (An earlier version remains available for CS4 as well.)

Posted by John Nack at 7:00 AM on April 09, 2011

View the original article here